Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
We want to change the default order of some columns on the Selector for Ref Number on the Payments tab of the Sales Order. I finally tracked down which field this is on but no matter what I do it fails to take any effect.The field and the changes I’m making are below. AlI did was edit the columns to move the date to the top but it doesn’t affect anything. Is there somewhere else I need to edit this? Thanks for any advice, Phil
Hello Everyone, We have to add extra notes action in the top of the screen besides acumatica notes action. Is there a way to do it this customizaiton? This requires only in one screen.
[PXInt()][PXUIField(DisplayName = "Picker", Required = false, Enabled = true, Visibility = PXUIVisibility.SelectorVisible)][PXDefault][PXSelector(typeof(Search<EPEmployee.bAccountID>), typeof(EPEmployee.bAccountID), typeof(EPEmployee.acctName))]public int? Picker { get; set; }public abstract class picker : PX.Data.BQL.BqlInt.Field<picker> { }[PXString()][PXUIField(DisplayName = "Picker Name", Required = false, Enabled = false)]public string PickerName { get; set; }public abstract class pickerName : PX.Data.BQL.BqlString.Field<pickerName> { }EPEmployee class contains the acctName field which I want to populate in pickerName when the Picker is selected by the selector.How can I do that ??
How can we achieve something like this ? I have added the field for code but need to add another field for the emp. name and both are read-only fields.Custom field should auto-populate with Employee code (3-digit for the Warehouse team) of the person logged-in and cannot be changed manually. Name should be displayed next to the code field.
I have been asked if here is a way to customize the drop down filters to add an entry for Yesterday or Last Month: I suspect they are not customizable but thought I would ask just in case. Thanks, Phil
We are new to Acumatica, we still have not gone live yet and in the processes of learning the processes before we go live. Question is, we have multiple salesmen that will be creating sales orders and will be marking for po several line items at times. When a vendor has minimums or if we can get quantity breaks, common practice is to compile a few separate sales orders into one purchase order. When a few sales orders are marked for po, can those line items be added to one purchase order to one vendor instead of sending several purchase orders, which will not give us the minimums or price breaks needed?
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?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.