Develop Customizations

Is there a way to clear all translations of an PXDBLocalizableString field in a DAC row?I see no suitable function in PXDBLocalizableStringAttribute.

Hello. I’ve googled quite a bit and could for the life of me not figure out how to pass values fromCROpportunity → CR Quote         I                           I Sales Order         Sales OrderI found this code https://stackoverflow.com/questions/36156112/how-to-pass-custom-field-vales-from-opportunity-to-sales-order to copy fields from CR Opportunity to Sales Order but if i try this i get a error message.'CROpportunity' is an ambiguous reference between 'PX.Objects.CR.CROpportunity' and 'PX.Objects.CR.Standalone.CROpportunity'I'm not sure if this code is functional for my needs. We added several fields on a new Tab in the Opportunity screen that we would need to transfer.Although I've successfully created a method to transfer fields from Sales Order to Shipment and Invoice, I haven't been able to locate any code examples for the task at hand.

Hi,In the Opportunities Screen, after the Create Quote button is clicked, the pop-up below appears with the option to create a Sales Quote displaying by default. The client would prefer for this to show Project Quote by default since the majority of their quotes are project ones, and some of their staff have mistakenly created Sales Quotes instead of Project Quotes as they forgot to change the dropdown value in the image below.Is it possible to change the default value that appears in this pop-up screen? Or should they just double-check this value before proceeding with the quote creation?Kind regards,Andrew 

hello all,I am learning development basics in Acumatica and I am looking steps/guide on how & what to install for Acumatica apart from the configuration wizard.Any help would be grateful. Regards.

Hi I have a question I’m trying to change the labels display names in Easy Post but I’m not sure on how that works. I copied someone’s code from over 5 years and but I tried using it and it’s not working on my end can does someone know how to change the display name from Acumatica. Shipment shipment = new Shipment() { to_address = toAddress, from_address = fromAddress, parcel = parcel};//DO THIS BEFORE CREATING!shipment.options = new Dictionary<string, object>();shipment.options.Add("print_custom_1", "this is some sample text");shipment.options.Add("print_custom_2", "abc");shipment.options.Add("print_custom_3", "xyz");shipment.Create();var lowestRate = shipment.LowestRate(includeServices: new List<string>() { "First" }, includeCarriers: new List<string>() { "USPS" });shipment.Buy(lowestRate);shipment.GenerateLabel("pdf");

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