Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Hey all,I was assigned a new project to make an inquiry to find all orders with any given SKU in it. As a developer my instinct was to jump to making an inquiry form from scratch. However, while I was in the middle of the project it dawned on me that this could probably of just been a generic inquiry. So I set out do see if there was any standard as to when to make a new Inquiry form vs a generic inquiry, but I couldn't find anything concrete and the university write ups don’t say when one is preferable to the other. So, my question is what is your guys' opinion on when to make an inquiry form vs a generic inquiry and is there any performance benefit to picking one over the other? (assuming both are well written / bug tested) My assumptions are that a well written Inquiry form might eke out the performance of the same generic inquiry and that you might be able to create a more complex inquiry form if you needed to. However I have no real basis for these thoughts and I would like to kno
I need to add JavaScript code to run when a button is clicked on a screen I’m including through a Customization Project. (I’m using Acumatica 2022 R1)I am able to do it by including a function using the JavaScript control, and then calling it from the Click or MouseDown inside the ClientEvents menu on the button’s properties.I can also do it by entering the JavaScript code directly into the Click or MouseDown events.I can confirm the JavaScript code runs, but the problem is that it runs when the screen is loaded, instead of when the button is clicked. Also, the code runs twice for some reason.I was wondering if this may be caused by not following a right way to include JavaScript. I’d like to know what steps need to be followed if this is the case, or to learn from any suggestions any of you may have tried already to make JavaScript code work correctly on a button click.
I want to load a file in Acumatica into Nuget package object(It expects file location). If we consider a file such as attachment in SOLine, how can I get actual location of that file?
I want to align added buttons(see the attachment 1) to bottom right and the align the search bar to top right. I tried several ways but I could not accomplished it. I'm new to acumatica environment. So i kindly request an advice/guide from you guys to align these button and search bar as i want in this customized screen.
Hello Everyone,I am working on enhancing some of my older projects and simultaneously I am updating my codes from BQL to FBQL for better readability and using some new functions of FBQL. I have come across a piece that I have used IsNull<,>. I am wondering how can I use IsNull in FBQL.Below is the piece of code I have converted to FBQL (the BQL version was working fine) I tried using “Use<>” before “IsNull<>” to mix use BQL with FBQL but didn’t work either. HCLPMCostProjectionView costProjection = SelectFrom<HCLPMCostProjectionView> .Where<Brackets<HCLPMCostProjectionView.projectID.IsEqual<@P.AsInt>> .And<Brackets<HCLPMCostProjectionView.taskID.IsNull.Or<HCLPMCostProjectionView.taskID.IsEqual<IsNull<@P.AsInt, HCLPMCostProjectionView.taskID>>>> .And<Brackets<HCLPMCostProjectionView.costCodeID.IsNull.Or<HCLPMCostProjectionView.costCodeID.IsEqu
We are looking for a way to have the address start to auto populate once our users start typing. Place Autocomplete by Google or something similar to that.Is this possible to integrate into Acumatica?
Hi,I added a smart panel for my customized screen. After the customer select, all the purchase order show in smart panel like below.After I clicked the checkbox and clicked ADD button clicked line need to be add to the grid view Below like that.But,My issue is when I clicked the add button data is not added to grid.This is my Action method. public PXAction<APProforma> addNewOrder; [PXButton(CommitChanges = true, DisplayOnMainToolbar = false)] [PXUIField(DisplayName = "", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Visible = false)] protected virtual IEnumerable AddNewOrder(PXAdapter adapter) { APProformaView.AllowInsert = true; PXSelectBase<POOrder> orders = new PXSelect<POOrder, Where<POOrder.orderNbr, Equal<Current<APProformaItemList.ponbr>>>>(Base); foreach (POOrder item in orders.Select()) {
Hi,I added a allow filter into my custom smart panel.Then,I need to align its into top right corner in my smart panel.Can you please help me. Thanks you
Hi experts,I want bring custom field Invoice Number (UsrPSInvoice) on screen Bill and Adjustment (AP301000)to grid on screen Vendor Details (AP402000)by selecting this field in Screen EditorHowever, the value of this field is always empty although it contains value on Bill and Adjustment Do you know how to get over this issue?
I had a issue getting the values to stay visible using the multi select field ( PXMultiSelector ) into the location grid. I describe the problem in the text below.I add a multiselector into a Location Grid in Warehouses in this way: In the picture before the UOM field is declared in this way: Aspx <px:PXGridLevel DataMember="location" DataKeyNames="SiteID,LocationCD"> <RowTemplate> <px:PXMultiSelector runat="server" ValuesSeparator="," AllowCustomItems="True" DataField="UsrFRUOM" AutoRefresh="True" CommitChanges="True" DataSourceID="ds" ID="CstPXSelectorFRUOMId" /> </RowTemplate><Columns> <px:PXGridColumn DataField="UsrFRUOM" Width="72" CommitChanges="True" AllowFocus="True" AllowResize="True"></Columns> DAC #region UsrFRUOM [PXUIField(DisplayName = "UOM")] [PXSelector(typeof(INLocation.primaryItemID), ValidateValue = false )] public virtual string UsrFRUOM { get; set; } public abstract cla
Hello experts,I created a Multi Selector on Prepare Replenishment and I want to filter item in Grid ReplenishmentItem by this fieldHere is the field schema: public class INReplenishmentFilterExt : PXCacheExtension<PX.Objects.IN.INReplenishmentFilter> { #region UsrWarehouse [PXSelector(typeof(INSite.siteCD), typeof(INSite.siteCD), typeof(INSite.descr), ValidateValue = false, DescriptionField = typeof(INSite.siteCD))] [PXUIField(DisplayName = "Warehouse")] public virtual string UsrWarehouse { get; set; } public abstract class usrWarehouse : PX.Data.BQL.BqlString.Field<usrWarehouse> { } #endregion }I update Aspx add following code: <px:PXMultiSelector runat="server" ID="CstPXSelector2" DataField="UsrWarehouse" CommitChanges="True" />Then I modified graph INReplenishmentCreate, change the filter condition as following:[PXFilterable] public Processing<INReplenishmentItem> Records; //If update Acmatica
Hi guys,I’m getting this error when I try to select and add values from my smart window to the grid which is customized by me. APProformaItemList is the DAC for my grid and poNbr is the foreign reference for the DAC POOrder which is used to load data into the smart panel.following code snippet is the reference.SelectFrom<POOrder>. Where<APProformaItemList.ponbr.IsEqual<POOrder.orderNbr.FromCurrent>>.View.Select(this);how can I fix this error? As I’m new to acumatica , I don’t know what I have done wrong in my code. So If someone could help me in this and needs the full code let me know please.Thank you in advance.
Have added a custom field on the Grid(Volume) to display the volumes of the Inventory Items during transfer.Have also created another field(Total volume) to calculate the total volume.see below; Kindly assist on code to calculate the sum of the volumes and be displayed on Total volume Field.And also please assist on- Created the Volume field as decimal(19,6). But the output is rounded off. Please share some insights on this too.Thank you all.Any kind of response will be appreciated.
Hello I was create an instance of form, and I want call an acction of the principal
Hi All, I want to display the appointment nbr in SO detail TAB so I have added and I want to display the list the appointment nbr. what should I add in the code to pull the respective appointment nbr?
Does anybody can me help with project attributes? I am triyng to sync it throw the API, but I always get errors with it. It seems I do something wrong…And on this screenshots my json and response with error from API, it is just one of examples, I tried use only one required attribute field, result is the same.List of my attribute values: There are Attributes in the API swagger definition for Project. I also tryed extend endpoint and populate attribute fields - but it seems this is another fields because according the screenshot above I can use only one item, not collection with itWhat I missed in my json request to the server? Or it can’t work with API?
Hello, Does anyone know how to meke it so thath when I click on a Shipment on the Sales Order Screen, it redirects to the Shipment Screen? Sales Order Screen My Shipment to redirect My Custom Shipment Screen This is the code fro the Sales Order Screenadd screen SO301000 { add container "OrderSummary" { formActionsToExpand = 1 add layout "OrderHeader" { displayName = "OrderHeader" layout = "HeaderSimple" add layout "OrderHeaderNbrRow" { displayName = "OrderHeaderNbrRow" layout = "Inline" add field "OrderNbr" add field "OrderTotal" } add layout "OrderHeaderTaxTotalRow" { displayName = "OrderHeaderTaxTotalRow" layout = "Inline" add field "Status" add field "DiscountTotal" } add layout "OrderHeaderTotalRow" { displayName = "OrderHeaderTotalRow" layout = "Inline" add field "OrderedQty" add field "TaxTotal" } } add layout "OrderTypeRow" { displayNam
Hi guys good morning/noon/eveningI have 2 screens, Screen1 & Screen 2 When I change/update data in Screen 1 I need to updated screen2 (saved data in DB should be updated ) that have the same SectionID value.find below screen shot Thanks in advance
hello everyone,kindly assist, would like to add filter settings on the form below in the specified area.this will enable me to save my filters and also share the filters. filter settings: kindly assist please
Hi,How I can add a custom action in an automation schedule?Thanks,EV
What do I need to do to get a UDF field to behave like a masked field?I am adding a UDF to the SO Types screenThe field is supposed to be the same field type as the Combine Sales Sub. From field. It will be used to override the sub account field on the SO Entry screen if there is a value in the UDFThe custom field does not “act” like a masked field. It behaves like a regular text field.This is my UDF DAC field. #region UsrSalesSubMaskOverride public abstract class usrSalesSubMaskOverride : PX.Data.BQL.BqlString.Field<usrSalesSubMaskOverride> { } protected String _UsrSalesSubMaskOverride; //[PXDefault] //[PXUIRequired(typeof(Where<active, Equal<True>>))] [SOSalesSubAccountMask(DisplayName = "Channel/Modality Override")] public String UsrSalesSubMaskOverride { get { return this._UsrSalesSubMaskOverride; } set { this._UsrSalesSubMaskOverride = value; } } #endregionIt is a copy
Hi,I need to add button ‘Add Order’ in the details tab like below screen shot.When the clicking button I need to load purchase order details( popup window) Relevant with selected customer.Like the below one. Can you help to how i do it.Thanks & Regards
Hello Everyone,I created a customization on the service order as shown below. When Mark for SO is active, CREATE SALES ORDER button appears. The button enable creation of a service management sales order.The service management sales order is as follows; Opening the sales order;How do I get the STATUS and ORDERNBR of service management sales order created to be displayed on Servce order screen on the Details Line on my custom fields i.e SOStatus(UsrSOStatus). also have another custom field as SONumber(UsrSONumber).Kindly Assist.ALL RESPONSES WILL BE HIGHLY APPRECIATED.
I am going through some of these mobile app workflows, and to be honest they really don’t make much sense. If you go to the “Scan and Receive” workflow, the first thing it asks you is to scan the warehouse you’re in. Then it asks you to scan the Location. Then it asks you to scan the item number.I’m having a really hard time thinking of any use case where this is the correct order of things. If you receive a shipment from another warehouse, or from a supplier, would the first action you take on a handheld device be to scan the current warehouse you’re in, and the current location you’re standing at? No! You scan the thing you’re receiving (probably a po or transfer order number… in some cases perhaps an item number or a vendor order number). And then the workflow proceeds from there. Maybe someone could already decide where to put that thing...and the system can then proceed to just tell you where it goes. And maybe that thing was shipped to a very specific warehouse, so the system can
Hello, We recently implemented acumatica.We now need a way to extract invoice and sales data to send once a day to different integrators.The files need to be in different formats such as csv, pipe delimited and/or tab delimeted.The files need to be sent the files via FTP or SFTPThe extraction needs to be scheduled to run automaticallyThe extraction needs some logic to send only incremental data (new invoices or sales orders since last execution)
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.