Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
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.
Hi everyone, Does anyone know where the key comes from or is inserted when adding a new file? I am trying to include a new file to a new installed instance(I have no customizations), but still the error is shown. Also I checked the profiler and it is not trying to insert anything, just querying a few tables. Thanks
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)
I’m using PXReportRequiredException to open up a report from a button on a screen. I would like to open the report to the where the user can enter the parameters instead of the preview. I don’t want to pass the parameters to the report because it doesn’t make sense in this context.Is there a way to do that?
Hi i’m trying to add address details in report , in english version the details are as expected but when i try to print it in french verson the format is changing.This is in english This is in french here is the code i used for it. =IIf([RemitContact.FullName]<>null,[RemitContact.FullName], iif([Vendor.AcctName]<>null,[Vendor.AcctName] , '')) +'{br}'+IIf([VendorAddress.AddressLine1]<>null,[VendorAddress.AddressLine1] + '{br}','')+IIf([VendorAddress.AddressLine2]<>null,[VendorAddress.AddressLine2] +'{br}','')+IIf([VendorAddress.AddressLine3]<>null,[VendorAddress.AddressLine3]+'{br}','')+IIf([VendorAddress.City]<>null, [VendorAddress.City]+' ', '')+IIf([VendorAddress.State]<>null, [VendorAddress.State]+' ','')+IIf([VendorAddress.PostalCode]<>null, [VendorAddress.PostalCode],'')+IIf([VendorAddress.City]<>null OR [VendorAddress.State]<>null OR [VendorAddress.PostalCode]<>null,'{br}','') +IIf([VendorAddress.CountryID]<
Is there any possibility to add Nuget packages to Acumatica Customization project?
Hi!I need to track the receipt number of an item that was selected for a sale. This means, track the receipt number related to an item that was submitted in a sales order/invoice.In this post, the logic for table The logic behind Table INReceiptStatus and INCostStatus | Community (acumatica.com) was explained. So, Im thinking that this could help me to track it but Im guessing that there is another table intermediary between the purchase and the sales.Does someone know which table could be? Thanks.
Hello Community,I’m trying to update the Unit Price field when I update the Quantity but it is not working but the same code is working in the Sales Orders screen. Not sure why it is not working in the Sales Quotes screen. Below is the simple code I’m using but still not working, can anyone review and help on this? public class QuoteMaintExt : PXGraphExtension<QuoteMaint> { public static bool IsActive() => true; protected virtual void CROpportunityProducts_Quantity_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseMethod) { InvokeBaseMethod?.Invoke(cache, e); CROpportunityProducts row = e.Row as CROpportunityProducts; if (row != null) { cache.SetValueExt<CROpportunityProducts.curyUnitPrice>(row, 10m); } } }
Hello Guys, i have a view that requires an inventoryid to be passedi need to pass the id in the rowselected then show the new records returned from the view in the screenso, i need to show the currentInventorySalesHistory variable in the screenanyhelp?
Hi, I need to add a smart panel when clicked on my Add Purchase button. The smart panel should include all the Purchase Orders inside a grid which are currently available in the database. So I created a graph extension of my parent Graph APProformaEntry and also a DAC extension of px.objects.po.POOrder standard DAC called POOrderExtension to define new fields if I need to add. But for now I didn’t add any new fields to the DAC Extension except the main key .below screenshots show the code for the reference.Graph ExtensionDAC ExtensionIn the customization project editor, inside the dialogs, I added a pop-up panel and passed POrdersView which is previously defined view in the graph extension , as the Key. Now the issue is when I preview my changes before publish, it shows me the following error.I have no idea about this error, even I have not defined any new fields or changed the data type of the main key OrderNbr, in my DAC extension, this error is happening continuously. Have I done s
hello,i was upgrading my website from version 6 to version 20 R1i faced an error when preparing invoice from the job orderwhen i try to skip it this error appears in the insert method
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.