Develop Customizations

Hello, Not entirely sure why Acumatica did this, but I was curious about whether or not the identifier field for states could be expanded to two characters. 1 character gives you 26 alpha (less pre-defined) and then 10 int. I know you can use symbols as well but these don’t work well with API/middleware. Just wanted to gauge if this would be feasible or if anyone has done it in the past. 

Hello Gang, I am trying to hide 3 buttons of Acumatica as I have added 5 custom buttons to either replace or add more functonality. Out of these 3 Acumatica buttons 1 (releaseFromHold)  is created by acumatica in Base Graph and the other 2 (approve and reject) in one of Acumatica’s own graph extensions. Using RowSelected event I’m trying to hide these 3 buttons. My code hides the one from the base graph (releaseFromHold) but the other two (approve & reject) remain visible. Why? Here is my little event code: protected virtual void APInvoice_RowSelected(PXCache cache, PXRowSelectedEventArgs e){ var row = e.Row as APInvoice; if (row == null) return; APInvoiceEntry_ApprovalWorkflow BaseAM = Base.GetExtension<APInvoiceEntry_ApprovalWorkflow>(); Base.releaseFromHold.SetVisible(false); BaseAM.approve.SetVisible(false); BaseAM.reject.SetVisible(false);} 

I am new to Acumatica ERP Development have started T190 Quick Start in Customization 2022 R1 , In this process downloaded sample source code from Acumatica GitHub, but when as per instruction trying to Build the application getting bellow error. Can anyone help how to fix this? Error        D:\Acumatica ERP\PhoneRepairShop\licenses.licx: Could not transform licenses file into a binary resource.  Object reference not set to an instance of an object.

Hello,I need to know if it is possible to insert/update data from a Tenant(Develop) to another Tenant(Production) by code. I have not found any information about that.Thanks.  

Hello, I am trying to override the CopyOrderQT function to inject some code after this method runs, however, I can’t seem to figure out what I am doing wrong. Any help would be greatly appreciated.Original Action: public virtual IEnumerable CopyOrderQT(PXAdapter adapter) { return CopyOrder(adapter); }Overridden Action (giving errors): public delegate void CopyOrderQTDelegate(PXAdapter adapter); [PXOverride] public virtual IEnumerable CopyOrderQT(PXAdapter adapter, CopyOrderQTDelegate baseMethod) { SOOrder order = Base.DocumentProperties.Current; SOOrderExt orderExt = order.GetExtension<SOOrderExt>(); orderExt.UsrBlyRecalcUnitPrice = true; cache.Update(order); //I understand that cache doesn't exist but need to update the order. I need to make a view and then execute based on that. return adapter.Get(); //I keep getting a wrong return type }I am still trying to understand how the

Please can anyone help me with this issue?I have this customization project, but I’m facing this problem when clicking on Workflows. How can I check if this error is code or database related and then fix it? The issue just happens to this specific screenID, I can open normally the Workflows for the other ScreensThanks

New to customizing acumatica, Trying to add a Rate Table Maintenance Screen to Accounts Receivable. Want there to be two tables RateTable with just an ID RateTableDetail with that ID and a begin amount (double) and end amount (double) and a percentage. Want the custom form to only have one tab that opens with a blank screen.  You select the Rate Table ID from a lookup in the header section and the grid populates with all RateTableDetail Lines for that ID allowing the user to edit lines and add lines. User can add new Rate IDs in the header also Any help would be appreciated. 

Hi, I would like to create an MRP Exception Inquiry that is exactly the same as the standard Acumatica MRP Exception screen. As on my mrp exception inquiry I would like to include additional fields like the inventory item attributes. Anyone can advise? Thanks alot!

Hello Gang,As you may have noticed there is a logcal issue in Acumatica’s Approval Map Workflow injection to the Document workflow. In document worflow if an action is not allowed, its buttom is hidden but in Approval Map WF, the “Approve” & “Reject” buttons are always visible whether or not that user is an authorized approver. When user clicks on Approve/Reject then if not an authorized user, receives an error that “You are not an authorized approver!” What I want to do is to hide the Approve/Reject if the user is not an authorized approver. Here is my code. I do not get any error but the buttons are always visible. What I’m doing wrong?  protected virtual void APInvoice_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { APInvoiceEntry_ApprovalWorkflow graphExt = Base.GetExtension<APInvoiceEntry_ApprovalWorkflow>(); APInvoice document = Base.Document.Current; EPApproval approval = PXSelect<EPApproval,

Acumatica forms delete buttons displays a delete confirmation when click on the recycle bin but in the data entry grids when user clicks on “-” or presses the “Delete” key the line is deleted without any prompt. I was wondering:is there any way to enable "Delete" prompt in Acumatica Data Enty grids without overriding the codes? orIs it possible to disable the “Delete” key press that doesn’t delete the row?The problem is it happens often users do not double click into a grid cell to highlight the test and then hit the delete button. They just click on the cell and press the delete buttom that results in deleting the whole row.

Hi All, Hope you are doing well.How can I find out the Screen ID or Screen Name based on the DAC name? Thanks,Moulali Shaik.

I want to calculate commissions with some calculations.For one line item I want to deduct 20 from the base price and then calculate commission based on percentage. Can I limit a line item to be added only for one time in a Sales Order ? I need help on how can I implement this ?

Specifically we are trying to customize the Attributes screen to add an Attribute Type/Category field (combobox).  Then we can categorise attributes by Customer, Item, Other etc.I have created the custom field (usrAttributeType) as a PXDBString with PXStringList for the combo values.I have modified the PXSelector for the Attribute ID field.  We want to have the Selector for the AttributeID use the value from the custom field to limit the attributes to ones with the category selected instead of the constant it uses currently. The field is called usrAttributeType and I have added the following so far:namespace PX.Objects.CS{ public class CSAttributeMaint_Extension : PXGraphExtension<CSAttributeMaint> { #region Event Handlers public class attribType: PX.Data.Constant<string> { public attribType() : base("I") { } } [PXDBString(10, IsUnicode = true, IsKey = true, InputMask = ">aaaaaaaaaa")] [PXDefault()] [PXUIField(DisplayName = "Attribute ID", Visibi

Hello,How can I get applications for payment object with REST Api? When I try to run such a queryhttps://companyname.acumatica.com/entity/Sites/20.200.001.0/Payment?$filter=PaymentRef+eq+'035530'&$expand=ApplicationHistoryI got such error:Optimization cannot be performed.The following fields cause the error:\r\nApplicationHistory.AdjustedDocType etc

I have created a custom table which was created using the following SQL:IF Not Exists(select * from sys.tables where name = 'CustAIEverestData') CREATE TABLE [dbo].[CustAIEverestData]( [CompanyID] [int] NOT NULL, [EverestDataID] [int] IDENTITY(1,1) NOT NULL, [CustCode] [char] (20) NOT NULL, [CustName] [char] (50), [EverestOrderDate] [datetime] NOT NULL, [EverestOrderNo] [char] (20) UNIQUE, [EverestSalesRep] [char] (10) NOT NULL, [EverestTerms] [char] (20) NOT NULL, [EverestTaxable] [decimal] (18,6) NOT NULL, [EverestTaxAmount] [decimal] (18,6) NOT NULL, [EverestInvoiceAmount] [decimal] (18,6) NOT NULL, [EverestFOB] [char] (20), [EverestDeliveryMethod] [char] (20), [EverestWeight] [decimal] (18,6) NOT NULL, [EverestTracking] [char] (50), [CreatedDateTime] [datetime] NOT NULL, [CreatedByID] [uniqueidentifier] NOT NULL, [CreatedByScreenID] [char](8) NOT NULL, [LastModifiedDateTime] [datetime] NOT NULL, [LastModifiedByID] [uniquei

Hi,On top of Release AR Documents screen, I want to show the total  of a grid column . How do I do that? Can I do this by using PXFormula() or using RowSelected event?Can anyone help me? Thanks.

We want to create a pop-up note for a customer on the SO screen if ever today is > { a custom date/time field value tracking a tax expiration date}. Is this possible? If not, it would even be beneficial to add the field value to the Pop-Up note itself.Could we have the pop-up note display the value of the custom date/time field, for example? That would be acceptable. Is this a matter of determining the correct bQL when creating the pop-up note? Here are the properties: Here’s a version of the note showing where I’d like to see the field value.  Open to ideas!Thank you.

I’m not sure if this needs a customization or is possible without.  We have carrier labels generated as PDF files and at the moment the user has to click confirm shipment and then print label from the action menu at the top to download the file and then print it.  Alternatively they have to go to packages and click the attachment icon there and then the link in the files to download and print the label.We would very much like to streamline this process, ideally having it automatically bring up the generated pdf file so the user can just click print.Is this possible via built in means or does it require a customization? Thanks, Phil

Hi,I got question on building GI for sales invoice. I need it for push notifications. The idea is to track LastModifiedDateTime property like we did for SalesOrder but SalesInvoice doesn’t have it. Can you suggest how to do it?

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?