Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
What could be the reason between a binary file in a package being different from the file that is published to the Bin folder?I had done a MD5 hash comparison and the file in the Bin folder (after publishing) differs from the file in the Package. The only fix was to download the file from the Custom Package Files grid and copy it to the Bin folder.Has anyone experienced this before? What could cause it?
I can no longer override the ConfirmPackage method when pressing the Confirm Package Action on the Pick, Pack, and Ship page (SO302020). What method is being called now when that action is being selected?error
Via a customization I have a Webhook that is trying to create a lead, but prior it try to find an existing contact or account with a matching phone number.In the UI when I assign an existing contact or Business Account to a lead a series of dialogs popup asking how best to associate the records.How do I deal with the dialogs? Some of them are multi step.
I wanted to embed an External Images on the Report Designer, Is there a way to do it?
Hi,I have created a Database Script to increase the length of the PayItemCD field from 10 to 20, but I can't seem to find where to do this for the on-screen field shown below.I can type as many characters as I like into the Pay Item field, but once I click into another field, it cuts it down to 10 characters.I have updated the MaxLength property of the field, but that hasn't seemed to help.Is there another way to increase the length of this field?Kind regards,Andrew Enter as many characters as I want After clicking out of the field, text is shortened to 10 characters Max Length property set to 20
View & DAC public PXFilter<TestViewDAC> TestView; [Serializable] public class TestViewDAC : PXBqlTable, IBqlTable { #region [PXDBDecimal(2)] [PXDefault(TypeCode.Decimal, "0.00", PersistingCheck = PXPersistingCheck.Nothing)] [PXUIField(DisplayName = "Test Total", Required = false)] public decimal? UsrTestTotal { get; set; } public abstract class usrTestTotal : PX.Data.BQL.BqlDecimal.Field<usrTestTotal> { } #endregion #region [PXDBDecimal(2)] [PXDefault(TypeCode.Decimal, "0.00", PersistingCheck = PXPersistingCheck.Nothing)] [PXUIField(DisplayName = "Test Amount", Required = false)] public decimal? UsrTestAmount { get; set; } public abstract class usrTestAmount : PX.Data.BQL.BqlDecimal.Field<usrTestAmount> { } #endregion } TS Codes: Html Codes: The compiled UI is not displayed, but the UI settings are gray.
We are hosted on Acumatica’s platform, but we have two servers. I’m assuming (for lack of information) that this is a load balancing situation. We have two urls ourname and ourname-process. We are told it shares the same database. We were told we only need to install on the main server, so we install on that server. However, randomly, when we install, it causes issue. After install:Main server functions as normal. Process server:All pages are white when loaded. It loads the menus, etc. API connections to the server break with a 500 error. We can still login to the process server.I’m attaching a screenshot and the package that broke the process server. Again, it works fine on our dev server (same version), and it works fine on our live main - just breaks the production.
Hi,I’m working on my first customization adding a new table / DAC with a foreign key linking to Customers.The need is to restrict the selection of the customer to only customers belonging to a specific class.This is what I currently have in my DAC definition for this field: #region CustomerID [PXRestrictor(typeof(Where<Customer.customerClassID, Equal<Customer.customerClassID.Contains<"SPECIAL">>>), "Not a Special Customer")] [Customer] [PXDefault] public virtual int? CustomerID{ get; set; } public abstract class customerID : PX.Data.BQL.BqlInt.Field<customerID> { } #endregionI’m getting a “CS1031: Type expected” error on “SPECIAL”. I can’t find an example of creating a PXRestrictor condition that isn’t based around a boolean, null check or comparison to a value from a matching field on this DAC. Is there a way I can create this sort of hard-coded filter?Appreciate any guidance here.
Hello,Has anyone encountered the following - If I copy the Item Class name from different places it gives me different values and I’m wondering why, and which one is the appropriate one to use if I’m trying to use the Item Class name as a FILTER for my Ecommerce Export Filter.I have a class ID defined as such:: Now...if I copy the value from different places, I get the following ‘versions’: “PURCHASED -MISC” (If I copy from the Stock Item Summary Screen)“PURCHASED_-MISC______ “ (if I copy from the Item Class)“PURCHASED MISC” (If I copy from the Stock Item General Tab of the item).why does this happen?
Hi everybody.I’m trying to modify a GI but i cannot get it to work the way i want.what I want is for this column to be displayed as the "mold" column (with dashes)
Most screens with grids have an option to import from an excel file. Specifically I am talking about the SO entry screen below I have a customization where I customized and added an event handler on this screen and it fires fine when users are entering data in the grid. But when they load records form file, it doesn’t handle. Never fires the event from what I can tell. I stripped it bare to see if the code was having an issue, but even the simplist code never fires as below: protected void SOLine_RowUpdating(PXCache cache, PXRowUpdatingEventArgs e){ var row = (SOLine)e.NewRow;}But the same event fires when modifying the data in the screen. Any thoughts?
Adding a Text box in a UDF on Invoices and receiving the error “Index was outside the bounds of the array”.I have many UDFs throughout Acumatica and not understanding why this can not be added.
Upgrading a customization project from 23R1 to 24R1 I’m getting the following error:PrimaryKeyOf<MyDAC> does not contain a definition for BaseByHere’s the line of code.PrimaryKeyOf<MyDAC>.BaseBy<MyDAC.field1, Config>.FindBy(graph, field1);Is there a different namespace needed or has the BaseBy been removed. ThanksScott
I have create Process screen I want to insert records in PXFilterProcessing view. But not able to insert records
Hi I need to populate the value of the shipping terms field in the Customers screen into the sales order header in a custom field. How can I achieve this? This is my code so far.[PXDBString(100)][PXDefault(typeof(Search<Location.cShipTermsID, Where<Location.bAccountID, Equal<Current<SOOrder.bAccountID>>, And<Location.locationID, Equal<Current<SOOrder.shipToLocationID>>>>), PersistingCheck = PXPersistingCheck.Nothing)][PXUIField(DisplayName="INCOTERMS")]Please let me know if I’m implementing the right way, thank you!
Hello-I have a custom field that I am trying to transfer from GLTran (Journal Transaction) to PMTran (Project Transaction) when the native conditions are met to create a project transaction on release of Journal Transaction. The issue I’m running into is that that I can’t find a viable method to attach my logic to- I have tried FieldUpdated and RowPersisting on the RegisterEntryGraph to no avail- releasing the Journal Transaction does not trigger any of the events. Anybody have any suggestions on where to tie my logic to transfer this custom field from the GL to the PM? I’m thinking I might have to override the ‘Release’ of the journal entry.. which I would rather avoid if all possible because that adds more complication if the Journal Transaction was created from a separate module first.Thanks in advance!
The way I was thinking of doing it was to insert the key field FAAccrualTran.TranID into a new field I created in FATran.usrTranid, which would serve to link this with the GLTran or APTran table. The problem is that I would have to edit two processes, one located in FA303000 and another in FA504500. These are processes I have not been able to modify to add this logic. These processes are responsible for allowing a posted AP record to create a Fixed Asset with a transaction that is saved in FATran.The requirement is: To be able to have the amount in different currencies (Fixed Assets). The problem with the requirement is: The client's configuration leaves the FATran.GLTranID fields (a field native to Acumatica) as 'NULL,' and this configuration is non-negotiable, so I have to create this link myself, and therefore, the solution I came up with was that.
Hello, I am creating a processing screen that pulls in shipment records of the receipt type and running into a small issue when creating the BQL statement to do so. You’ll notice below I am trying to join an enclosed condition with the condition to check if the shipment is of the type receipt. I’m not entirely sure what to add inbetween the commas after the “Where<SOShipment.Operation,” as I can’t simply type “R” (value stored in SQL). Is there a way to go about this? public PXProcessing<SOShipment, Where<SOShipment.operation,, And<Where<SOShipmentExt.usrToTransfer, IsNull, Or<SOShipmentExt.usrToTransfer.IsEqual<False>>>>>> shipments;SQL:select * from SOShipmentwhere Operation = 'R' and (UsrToTransfer is null or UsrToTransfer = 0)Thanks,Adam
Hi. When the user inserts a line level record in the applications tab of the Invoices form I need to update one of my custom fields. I’m trying to update my custom field which is the UsrTotalCreditDue with a calculation of the values that i get from the two data views. In the code i am also printing the values to the trance. The values get updated in the trance but doesn’t update the field. How can i fix this ?Trace Values Customization Code
Hi All,I want to track the time spent on support cases made by our clients in support portal. (According to service level agreement-SLA)PS-Currently we record the time manually. But we want to track time automatically through a running clock according to the status change.It should work as below,Once the case is taken (take case) by one of our team members and the case is open, an internal clock, should run until we close the case. If we put the case to pending customer status, clock have to be stop from our end and once the client is responding to case once again, and status change to updated clock have to run again till we close the case.Furthermore, when we change the status of case to pending customer and if they(client) do not reply in two days (48 hours), an automatic email has to be sent to the client reminding them to reply to the case. This may be done using a business event, but I have no idea, how to map the time to Business Event.If anyone know the solution to this or use s
Hi, how can I schedule a report to be automatically generated and emailed to my customers whenever a new report is available based on specific dates? Additionally, the system currently only allows exporting the report in PDF or Excel format, but I need it in a text file. Is there a way to automate this entire process in acumatica Like using buisness events or any other thing? Or If I try using Python for this, will it cause any issues with Acumatica? Please guide me.
In T220 When Created Screen RS301000 when we publish it and then preview changes its showing Parameter Cannot be Null for VirtualPath but that Virtualpath is there.
I have customized purchase orders screen, add an extension to POLine DAC and add two fields. public class POLineExt : PXCacheExtension<PX.Objects.PO.POLine>{ #region UsrInventoryItemClassID [PXInt] [PXUIField(DisplayName="ItemClass")] [PXDBScalar(typeof( Search<InventoryItem.itemClassID, Where<InventoryItem.inventoryID, Equal<POLine.inventoryID>>>))] public virtual int? UsrInventoryItemClassID { get; set; } public abstract class usrInventoryItemClassID : PX.Data.BQL.BqlInt.Field<usrInventoryItemClassID> { } #endregion #region UsrInventoryItemClassCD [PXString(32)] [PXUIField(DisplayName="Item Class Description")] [PXDBScalar(typeof( Search2<INItemClass.itemClassCD, InnerJoin<InventoryItem, On<InventoryItem.itemClassID, Equal<INItemClass.itemClassID>>>, Where<InventoryItem.inventoryID, Equal<POLine.inventoryID>>>))] public virtual string UsrInventoryItemClassCD { g
Hi,I have a question. I have multiple tabs in my screen, also all the tabs have different table. ( multi-DAC Scenario) and when I have use PXOrderedSelect on the multiple tabs so that I can perform drag and drop on tabs., but still it works for single tab only.As you mentioned in above solution that PXOrderedSelect can be use for multi-DAC scenario, but in my case it is not working.Any suggestion or solution for PXOrderedSelect to be worked for multiple tabs. Thanks,Dhruv
Hey all trying to modify the ScanMove Screen in two ways;Combine the Production Order ID and the Operation ID in a single scan. Currently you are prompted first for the production order id then for the operation id. So the change would be to maybe add a new scan item that parses to the two fields and then skips the two fields after populated, or anything that would combine the two. Don’t care just need it to work Add the Scap quantity into the grid on scan move. Its not there. Its there on the move screen but we forgot that one for some reason. Both of these tasks sound very simple but access to everything in the Automated Warehouse Operation Engine it is not. Everything seems to be in a sealed class or so far abstracted down the line that I can’t get to it. Examples are skimpy to say the least and none Add a new barcode scan item (there is one that you add a cancel button scan but thats not what I am looking for). Injection is used to modify code and I can change the order of
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.