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 all I overrode the button UpdateIN in SOShipmentEntry to add additional logic related to transfers. When I execute the action opening a single confirmed shipment (Screen SO302000), it works as expected. But when invoked from the Process Shipments screen SO503000 (action Update IN), the long operation in the base graph never returns and the execution enters in an eternal wait. This is an excerpt of the overridden code:[PXOverride]public IEnumerable updateIN(PXAdapter adapter, List<SOShipment> shipmentList, updateINDelegate baseMethod){ List<SOShipment> shipments = shipmentList ?? adapter.Get<SOShipment>().ToList(); try { bool isTransfer = shipments.Any(a => a.ShipmentType == SOShipmentType.Transfer); ... if (isTransfer) { ... } var retVal = baseMethod?.Invoke(adapter, shipmentList); if (isTransfer) { // CODE GET STUCK HERE PXLongOperation.WaitCompletion(Base.UID); ... } } catch (PXException ex) { PXTrace.WriteError(ex); } return ad
I’m pulling my hair out a bit. I was helped along on this project by another user and I think I'm missing something here: I need each row to show a warning containing the various vendor prices. When I use the RowSelected event the top row value gets cleared out and when I change vendors it no longer updates the price. See images for expected behavior and current result.(originally I was using RowUpdated (which worked) but then I would have to update the row before the warning would occur)Any help would be greatly appreciatedusing PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Objects.AP;using PX.Objects.PO;using System;using System.Text;namespace PX.Objects.SO{ public class POCreate_ExtensionAI : PXGraphExtension<POCreate> { public static bool IsActive() => true; #region Event Handlers protected void _(Events.RowSelected<POFixedDemand> e) { var row = (POFixedDemand)e.Row; if (row == null || row.Inventor
Hi all,I’m trying to apply, or not apply, a Discount to a SO Invoice and update the Balance on creation. The discount is in a user defined field on the Invoice and Sales Order. I can update the Balance, and other totals, in code and things look good until the invoice is processed which causes the totals to be wrong.When the Actions > Recalculate Prices button in pressed the Balance is updated correctly and processing the Invoice works as expected.Is there a way to call the that action from GraphExtension code?Thanks for your feedback!
Hi Experts,I have a process screen as below, and I’d like to show the records of different objects (like Sales Order and Shipments) in the same Grid when I select different transaction types.I defined a common BQLTable as below, and here is my code to return the records to the grid. But when I select the records and click the Process button, I find there is no records stored in the PXCache. So the value of “Selected” is always null and I can not get the selected records in the backend. I changed the common BQLTable into SOOrder or SOShipment, and it worked. Does anyone have any idea about this issue? Thanks,
I wanted to set the default button in the Messagebox to be NO but apparently can’t do that. As a workaround I need to override the following:protected virtual void Customer_CustomerClassID_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e) { Customer row = (Customer)e.Row; CustomerClass cc = (CustomerClass)PXSelectorAttribute.Select<Customer.customerClassID>(cache, row, e.NewValue); this.doCopyClassSettings = false; if (cc != null) { this.doCopyClassSettings = true; if (cache.GetStatus(row) != PXEntryStatus.Inserted) { if (BAccount.Ask(Messages.Warning, Messages.CustomerClassChangeWarning, MessageButtons.YesNo) == WebDialogResult.No) { this.doCopyClassSettings = false; } } } }I have changed the warning message by adding a translation for the warning message as by default we want YES to only change the class ID and nothing else. How do I go about overriding the code to match? I only want to change the if statement to action on W
I have a custom field on the inventory item called usrBuyerPlanner. I want to show that data in my MRP Display (AM400000) I have created a custom filed here Called usrBPCode and modified the attributes like so. [PXDBString][PXUIField(DisplayName="Buyer Planner")][PXFormula(typeof(Selector<AMRPDetailExt.usrBPCode, InventoryItemExt.usrBuyerPlanner>))]However it does not appear to be pulling in the BPcode from the item. Any thoughts?
Hi Experts,I have some custom fields in Sales Order screen as below. I know we can’t update this Sales Order when the sales order status is shipping or closed. But I want to set a new value to these fields. I know I can update the confirmed shipment by the action “Correct Shipment”. Does Sales Order screen have any way to modify the fields when the status is shipping or closed?
When I tried to import an XML file with the Generic Inquiry page, I get the following error:
Hi All,Please advise if you have some ideas for my issueMy customize project is usually unpublished and I don't know why, for sure that no one has touched on this.Thanks for your advise,Yên Chi
I have a request to add file attachments to the My Cart details grid and have those carry over to sales order lines. Is there a trick to this? If I try to add NoteID it changes to UsrNoteID and I also don’t think this field works on a DAC extension with PXNote attribute.
Acumatica version: 22R1 Build 22.107.0022 I am using a no-code approach to adding an action menu items.On the Contacts screen, I have created two new action menu items:Create Customer Create Vendor Here are the settings I am using for "Create Customer" (The settings for "Create Vendor" are similar). I have the same challenge for both action menu items.I need to return the "Business Account" ID/Name to the "Business Account" field on the "Contacts" screen (when the dialog closes).I have tried using a few different field combinations on the “FIELD UPDATE”but have not had any success. Maybe I am misunderstanding how some of these settings are interpreted by Acumatica.Can you tell me what I am missing or point me in the right direction?Thank you in advance. :)Ken Severud
I have a processing screen to get data from an Acumatica table and do gyrations and put data into a custom table. I don’t need to select any records from a filter results. I just want to use the filters on the screen to “do the work” on all records returned by the filter.I originally had a button under the End Date that would fire a custom action. In order to make this a schedulable process, I THINK I needed to do it as a processing screen.So...I tried to re-do the screen.Since I am pulling data from the AuditHistory table, there is no “Select checkbox” to select on the processing screen. Is my delegate not firing because there is no Select checkbox available in the filter results?Is there a way to use a PXFilterProcessing without a list of records with a Select checkbox?This is what my screen looks like after removing the Get Report Data button and making it a processall button on the top of the screen.This is the constructor that sets up the processing button.public QTCAuditRepo
I have a processing screen that pulls records based on a date range. public PXFilteredProcessing<AuditHistory, QTCAuditHistoryReportFilter, Where<AuditHistory.screenID.IsEqual<QTCAuditHistoryReportFilter.screenID.FromCurrent>. And<AuditHistory.changeDate.IsBetween<QTCAuditHistoryReportFilter.startDate.FromCurrent, QTCAuditHistoryReportFilter.endDate.FromCurrent>>>> RecordsToProcess; The filter screen looks like this. The problem is that if there is a record in the AuditHistory table with a change date of2022-07-06 21:44:08.583 it won’t get selected. I need my selector to just look for the DATE portion and ignore the time portion. Is there something I can do in my selector to just use the Date portion?
Hi, I have a requirement where some validations are to occur once the inventory ID field is updated in the Requisitions screen. The logic is based on values taken from custom fields in a custom form and synced with user defined field in Summary area of requisition form and line item’s inventory ID. The logic is attached but the warning and error messages are not executed. Please let me know how to solve this issue.Custom Form Record Validated By Referencing these 2 Fields protected virtual void RQRequisitionLine_InventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler) { InvokeBaseHandler?.Invoke(cache, e); RQRequisitionLine rowLine = (RQRequisitionLine)e.Row; if (rowLine == null) return; // Get current Requisition RQRequisition row = Base.Document.Current; // Find my custom field from Extension var ext = PXCache<RQRequisition>.GetExtension<RQRequisiti
Hi All , I’m unable to insert the ScheduleID in Child table Column ,because it is integer type storing the integer Default value(-2147483647).Not storing actual value. How to insert FSContractSchedule.scheduleIDfield into Child table (SSPFSScheduleInsp.scheduleID).can you plz help me in this..!this is my DAC#region ScheduleID [PXDBInt(IsKey = true, MinValue = 1, MaxValue = 999999)] [PXUIField(DisplayName = "Schedule ID")] [PXDefault(typeof(FSContractSchedule.scheduleID.FromCurrent))] public virtual int? ScheduleID { get; set; } public abstract class scheduleID : PX.Data.BQL.BqlInt.Field<scheduleID> { } #endregion.but it is storing like this in my table Thanks…!
We’re looking for the best way to prevent the Error: Another process has updated the 'SOOrder' record. Your changes will be lost when our integration writes back an external ID. When a users saves the first SO line it creates a push notification and creates a record in our external app. The ID generated in that App is then written back to the External Ref number on the SO which will be used to stay in sync with the external App. However if a user continues to add lines they have to refresh the SO.The current thought is to create a customization that creates a table that will store the SO GUID or Order Type and Number and our external ID. Then have the GI for the push notification relate to this new table.Any other ideas on how to prevent this issue?
Hello Gang, I was wondering is there any way to freeze a few columns of the DATA ENTRY grids on the left to always have them visible to the user when scrolling to right/left and we have many columns? I tried through Css but couldnlt find “Frozen” or similar property for it.Something like as Excel freez pane I’m looking to simulate in Acumatica
We would like the warning dialog when changing the customer class to default to No rather than Yes. I have looked at the code and found where it is defined:protected virtual void Customer_CustomerClassID_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e) { Customer row = (Customer)e.Row; CustomerClass cc = (CustomerClass)PXSelectorAttribute.Select<Customer.customerClassID>(cache, row, e.NewValue); this.doCopyClassSettings = false; if (cc != null) { this.doCopyClassSettings = true; if (cache.GetStatus(row) != PXEntryStatus.Inserted) { if (BAccount.Ask(Messages.Warning, Messages.CustomerClassChangeWarning, MessageButtons.YesNo) == WebDialogResult.No) { this.doCopyClassSettings = false; } } } }Is there a way to specify which button (Yes/No) should be the default? Thanks,Phil
Hi EveryoneI have created ServiceContractInqExt graph like below: public class SSPServiceContractInqExt : PXGraphExtension<ServiceContractInq> {… //How can I call base functionality of process or processALL // Need to execute custom logic here..}
I have been building some customization around the Add Items (Inventory Lookup) functionality of the Sales Order Entry screen. The query that populates the Add Items grid is located in the SOOrderEntry.cs class, and is a PXProjection (see code below). I’m adding it here because it took me a long time to find where it was located, so maybe this will shortcut it for someone else in the future. What I want to do now is to use the PXSubstitute functionality to override this query, so that i can populate that grid with my own data coming from a different source. However, I can’t find any mention of the PXSubstitute functionality in the Acumatica Framework Development Guide anywhere. The first link I reference below even gives a page number (95) in the Framework Development Guide, but I don’t see PXSubstitute anywhere in the development guide, including page 95. Can anyone point me to a reference for PXSubstitute? Latest customization guide...https://acumatica-builds.s3.amazonaws.com/builds/
Hello Everyone, We have a requirement to load the SHIP-TO Address from the employee by default instead of Shipping destination type details. We have used fielddefaulting event, but it is not assigning the employee address on page load.We have tried fieldupdating event and we are able to override the address when we update creator, but we are getting a weire issue, i.e., When we complete removehold process and once we reload the page then again the address is reverting back to the default ship to address instead of employee address. protected virtual void RQRequisition_EmployeeID_FieldUpdated(PXCache sender, PXFieldUpdatedEventArgs e, PXFieldUpdated baseEvent) { baseEvent?.Invoke(sender, e); RQRequisition row = e.Row as RQRequisition; if (row == null) return; if (Base.Document.Current != null) { BAccount BaccDetail = PXSelect<BAccount, Where<BAccount.bAccountID, Equal<Required<BAccount.bAccountID&g
Can I customize the following print action in this screen ? If yes then how can I do it. Please help. I cannot find any view or DAC in this page.
I am trying to fetch value from DB in FieldDefaulting event but the value is not reflected in the UI.This my code in graph extension.protected void SOShipment_UsrPickListPrintNumber_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e) { var row = (SOShipment)e.Row; SOPickingWorksheetReview tempGraph = PXGraph.CreateInstance<SOPickingWorksheetReview>(); SOPickingWorksheet txsetup = PXSetup<SOPickingWorksheet>.Select(tempGraph); SOPickingWorksheetExt rowExt = PXCache<SOPickingWorksheet>.GetExtension<SOPickingWorksheetExt>(txsetup); e.NewValue = 100; }DACExtension#region Virtual fields [PXInt()] [PXUIField(DisplayName = "# of times Pick list printed", Required = false, Enabled = false)] public int? UsrPickListPrintNumber { get; set; } public abstract class usrPickListPrintNumber : PX.Data.BQL.BqlInt.Field<usrPickListPrintNumber> { } #endregion
Hello,I have a SOLine custom field with PXSelector, how can I rename the column Customer Price Class to Price Code inside the selector? In Sales Price screen (not customized), its name was Price Code. I already tried using ARSalesPrice.priceCode in the code, but it shows empty value. Here’s my code,
I am fetchig data from the DB. And I to show a read-only field in a shipment screen.var worksheet = from p in graph.Select<SOPickingWorksheet>() join q in graph.Select<SOPickingWorksheetShipment>() on p.WorksheetNbr equals q.WorksheetNbr where q.ShipmentNbr == row.ShipmentNbr select p; SOPickingWorksheet tempWrksheet = worksheet.FirstOrDefault(); SOPickingWorksheetExt worksheetExt = tempWrksheet.GetExtension<SOPickingWorksheetExt>();I am getting correct worksheet from the query but my worksheetExt variable does not have the value stored in DB table. Can anyone help me here. I am writing all of this code in SOShipmentEntry GraphExtension.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.