Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Hi I have done a customization where I set the required qty to 1.00 in the material wizard 2 screen which works, I now need to make sure the release qty field also reflects this change where release qty needs to be the 1.00*the BOM, it still seems to be the original qty * the BOM with the logic I have written below.using System;using PX.Data;using System.Collections.Generic;using System.Collections;using PX.Objects.Common.Extensions;using PX.Objects;using PX.Objects.AM;namespace PX.Objects.AM{ public class MatlWizard2_Extension : PXGraphExtension<PX.Objects.AM.MatlWizard2> { #region Event Handlers // Use RowSelected to update QtyReq when the row is selected or edited protected void AMWrkMatl_RowSelected(PXCache sender, PXRowSelectedEventArgs e) { var row = (AMWrkMatl)e.Row; if (row == null) return; // Force QtyReq to 1.00 whenever a row is selected or edited row.QtyReq = 1.00m; sender.SetValue<AMWrkMatl.
I am just new on customization and I need to insert total row to the bottom of the Cost Projection (PM305000) DETAIL grid, any suggestion or code I can use?
I am migrating version 22.122.0019 -> 24.100.0139 and I am getting the following errorwhat solution we could apply?
I created three DAC fields in a custom DAC as follows. When the user is redirected to the screen, those values are automatically filled. However, when I press save, the LotSerialNbr and Quantity fields are reset to empty and save as null in the database. Meanwhile, the ProductionNbr field, which is PXSelectors, are working fine. #region ProductionNbr [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Production Nbr")] [PXSelector(typeof(AMProdItem.prodOrdID))] public virtual string ProductionNbr { get; set; } public abstract class productionNbr : PX.Data.BQL.BqlString.Field<productionNbr> { } #endregion #region LotSerialNbr [PXDBString(100, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Lot Serial Nbr")] public virtual string LotSerialNbr { get; set; } public abstract class lotSerialNbr : PX.Data.BQL.BqlString.Field<lotSerialNbr> { } #endregion #region Quantity [PXDBDecimal(
I wants to create settings screen which should contains only one record per tenant.Database structure done and save also work.But I don’t want next previous button or selection.My layout is In graph only three linespublic PXSave<UsrCustomTable> Save;public PXCancel<UsrCustomTable> Cancel;public SelectFrom<UsrCustomTable>.View MasterView;How can I select default 1st entry ?
I have created one processing screen where I want to create a text file when I select the records and click export. And I want that file to be attached in the top right corner just like many other screens. Is this possible ? I checked and it looks like you can attach the file to a particular DAC but I don’t want to do that.
A line of code like this will crash the code page in the Customization Editor in 22R2, after it is saved and reloaded:ApplyDocuments.SetCaption($"Apply Prepayment of ${amountOfPrepayments}");I believe the issue is the ${} within the interpolated string.
Hello,Is it possible to have unit test cases in Acumatica for a hosted form? If so, how can we input data into the hosted form from the unit tests? I do have the hosted form tests using the Acumatica test sdk but I am hoping to work with unit cases. Thanks
I am trying to add Order Nbr.(ARTran-SOOrderNbr) to Prepayment and Application-Documents to Apply, the title shows up, but it did not bring the related Order Nbr to its invoice.What kind of update do I need to write for this attribute (ARtran_SOOrderNbr)
I am developing a customization and would like to check if a user has access to a specific screen (or a Graph for that matter) in my code, I need to perform certain actions if they do not. How would I do that in my graph, which is not the same graph/screen?
Hello everyone!I’m trying to add a column from the BAccount table to the AR.52.10.00 Prepare Dunning Letter screen in order to provide more information.I wrote the following code, which publishes without errors. However, when I check the screen, the data doesn’t appear, and I can’t figure out where I might have gone wrong or if I’m approaching this incorrectly: using System;using System.Collections;using System.Collections.Generic;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Objects.CM;using PX.Objects.Common.Extensions;using PX.Objects.GL.FinPeriods;using PX.Objects;using PX.Objects.AR;using PX.Objects.CR;using PX.Objects.CS;namespace PX.Objects.AR{ public class ARDunningLetterMaint_Extension : PXGraphExtension<PX.Objects.AR.ARDunningLetterMaint> { protected void ARDunningLetterList_RowPersisting(PXCache cache, PXRowPersistingEventArgs e) { var row = (ARDunningLetterProcess.ARDunningLetterList)e.Row; if (row == null || row.BAccountID ==
Hi Experts,I have a requirement from a client regarding custom fields on the Customer Details (AR402000) screen. Specifically, the client wants the ability to filter and sort unbound custom fields directly in the grid.Here is the scenario:I added two unbound custom fields, Location ID and Location Name (both string data types), to the grid. The client wants to: Filter records in the grid by typing a value in these custom fields. Sort the records in ascending or descending order based on these fields. What I've Tried So Far:Added the custom fields (UsrLocationID and UsrLocationName) to the FastFilterFields property (along with fields like RefNbr, ExtRefNbr, and DocDesc). Set the AllowFilter and AllowSort properties to true for these fields in the customization editor.However, the filtering and sorting functionality is still not working for these unbound fields.Question:Is it possible to enable filtering and sorting for unbound custom fields using Acumatica's built-in attributes or cust
Hi,I’m having an issue with a customisation. Not sure if this is relevant, but this is the first customisation I have done in build 2022. All previous have been in 2021 builds and I haven’t seen this issue before: I have a processing form. When I Update all, after approx. 4 seconds the dialog below pops up The processing form keeps running until it gets to 18 seconds, and then freezes. Any further interaction with screen results in a request to reload the page I think that the screen expirying is probably due to the debug message. I have tried, click “yes, debug wp3.exe” with the following result:Clicking “New instance of Visual Studio Community 2019” results in the below: Also, when debugging in Visual Studio, after approx 4 seconds I’m getting:Everything appears to be behaving normally up until this point eg. I can set break points, and execution stops on these as per normal. Thanks in advance for any help on this.JOhn.
I need to populate all the “S - Service items” which are in inventoryitem table (related Sql is below). How can I customize it?select *from inventoryitemwhere ItemType = 's';-------------------------------------------Used Acumatica version - 22.111Used data set - I100No customizations published
I create a customization project to add few fields to several screens including sales order screen, then I need keep these fields as any time editable (in every state). So, I customized the SO301000 (Sales Order) workflow. I do that inhering the existing workflow. Then custom fields become editable,but the default fields turn uneditable in every states. Then I Remove the newly added workflows and enable the default workflows. but the fields still uneditable. Then I delete the whole SO301000 screen from the customization project. Even now default fields are uneditable. SO301000 screens returns back to the default behavior when only the whole customization is unpublished. I Tried with “Publish with cleanup”. It also not works for me.
I am wondering if it is possible to display a Google Maps map generated from the Maps JavaScript API in an ASPX page.Does anyone have experience with this or something similar?
How can you limit the visibility of User-Defined Fields so that it doesn't appear on other companies?I have companies XYZ and OMP but I don’t want to show in XYZ to OMP
Hi I have a requirement where I need to default the qty to produce to 1.00 in material wizard 1 screen which I have implemented as follows: namespace PX.Objects.AM{ public class MatlWizard1_Extension : PXGraphExtension<PX.Objects.AM.MatlWizard1> { #region Event Handlers protected void AMProdItem_Selected_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated baseHandler) {baseHandler?.Invoke(cache, e); var row = (AMProdItem)e.Row; if (row.Selected == true) // Only if the item is selected { row.QtytoProd = 1.0000m; } }This works but when I select a record to be sent to Material Wizard 2 screen this grabs the value based on original logic. How can I make sure the value is set to 1.00 across both screens? As a side note I have also tried implementing field defaulting event handler but this universally updates AMProdItem.QtytoProduce which is not required because only these 2 screens need to be updated.Thank
Use CaseThis article demonstrates how to update fields in a Sales Order upon confirmation on its shipment. In this example, we will add the "Expected Delivery Date" field to a Sales Order header,and will calculate it as adding some constant days number (7 here) to the shipment confirmation date.PrerequisitesThe attached customization adds the "Expected Delivery Date" field to Sales Order header (SOOrder database table, DAC, and aspx). It should be used as a starting point for implementing the logic described in the Use Case section.SolutionThe described solution uses the structure of the Confirm Shipment action delegate:protected virtual IEnumerable ConfirmShipmentAction(PXAdapter adapter){ PXLongOperation.StartOperation(this, delegate () { SOShipmentEntry docgraph = PXGraph.CreateInstance<SOShipmentEntry>(); SOOrderEntry orderentry = PXGraph.CreateInstance<SOOrderEntry>(); foreach (SOShipment shipment in list) { docgraph
Hello Everyone,I have a custom field on the sales order header where users can enter a value. This same custom field is also available on all activity screens (Task, Email, Chat, Note, etc.). If a user creates an activity from the sales order, I need to pass the value of this custom field from the sales order to the activity screen.Additionally, this logic should also work for the shipment and invoice screens.In Acumatica, the activity screens are handled by the ActivityDetailsExt generic graph, which contains several virtual methods used for creating activities. I tried overriding these methods in the SOOrderEntry extension, but while there are no errors, the overridden methods are not being executed.Can anyone suggest how to pass the custom value from transaction screens (sales order, shipment, invoice) to the corresponding activity screens?Acumatica base code for activity logic is in below class. public class SOOrderEntry_ActivityDetailsExt : ActivityDetailsExt<SOOrderEntry, SOOr
@Dmitrii Naumov - I wasn’t sure where to report this to. 24.204.0004Using the built in customization interface I asked it to create an override of the SOInvoiceEntry.InvoiceOrder method and it produced this:public delegate void InvoiceOrderDelegate(InvoiceOrderDelegateArgs args);[PXOverride]public void InvoiceOrder(InvoiceOrderArgs args, InvoiceOrderDelegate baseMethod){ baseMethod(args);}But should have produced this:public delegate void InvoiceOrderDelegate(InvoiceOrderArgs args);[PXOverride]public void InvoiceOrder(InvoiceOrderArgs args, InvoiceOrderDelegate baseMethod){ baseMethod(args);}It inserted the word “Delegate” into the name of the data type of the delegate’s parameter declaration.
I created a custom processing screen. At the end of the processing, I want to create a results report. public static void DoIt(List<UploadFileRevision> lineList, RecordsToProcessFilter currentFilter, bool isMassProcess = false) {DO ALL MY PROCESSING HEREAt the very end: if (results.GetRowCount() > 0) { throw new PXReportRequiredException(results, "IC604010", PXBaseRedirectException.WindowMode.NewWindow); }}If I have the PXReportRequiredException, the processing screen does not show the processing popup. It also does not refresh the grid of items that are available to be processed (remove the items that were processed). The report opens in a new window and it looks great.If I comment out the report redirect, the screen works perfectly. Is there a way to create my results report and not break the standard processing screen? I don’t absolutely have to have the report, but it is a nice feature.I am wondering if I can
We have a custom field that we’ve added to a page and the client wants to make it required, but only require it based on the company they are in. So it would not be required if they are in Company A, Company B, or Company C but it would be required if they are in Company D. Is there an easy way to accomplish something like this?
I’m looking for the ability to create a bunch of DACs that all have the same fields without retyping the fields each time. So, for example I might have 3 different DACs that I want to bind to 3 different database tables. But the actual fields should be identical. Is there any easy way of doing this? My thought was to use DAC inheritance, where I’d have an abstract base class DAC A and then all my children DACs would automatically get the fields from DAC A added but still actually reference the different database tables behind the scenes. To be clear there wouldn’t actually be a database table for DAC A.If this isn’t possible not a big deal, it just means more copying and pasting for me.
Hi I want to create same screen as Scan and Count Base screen.I will ScanPI Ref Nbr. Lot serial NbrI will not scan Warehouse and Location.I am trying to customize existing base screen. But After scanning PI ref nbr. i am not able to bring Lot serial Nbr. I have attached the Code of Maint and aspx code file.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.