Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
what is the formula for counting the RefNbr based on Tran.Typefor example i choose CRM the count will be two=Count([ARTran.RefNbr ]) it is not working
Dear Experts,I need to insert “Upload Excel file button” on Requisition’s detail screen, It’s always showing all requisition detail at details tab, when create a new Requisition doc. Below is the Code, In Aspx:AllowUpload=true for details gridIn Graph Extension:namespace PX.Objects.RQ{ public class RQRequisitionEntry_Extension : PXGraphExtension<PX.Objects.RQ.RQRequisitionEntry> { [PXImport(typeof(RQRequisitionLine))] [PXViewName(Messages.RQRequisitionLine)] [PXCopyPasteHiddenView] public PXSelect<RQRequisitionLine, Where<RQRequisitionLine.reqNbr, Equal<Current<RQRequisition.reqNbr>>>, OrderBy<Asc<RQRequisitionLine.reqNbr, Asc<RQRequisitionLine.lineNbr>>>> Lines; }} Can anyone suggest on this to import / update all lines in detail grid. Thanks in advance. Cheers,Iko
I've encountered a couple situations recently where I needed to extend an action where a PXLongOperation was running and do something after it was completed. I can use PXLongOperation.WaitCompletion(Base.UID) to wait for it to finish, but it seems to break the operation (the processing indicator doesn’t appear until the operation is complete). I think this makes sense, since it's blocking the UI thread until the background thread is complete.What is the proper way to execute additional code after a PXLongOperation is “finished” without blocking the UI thread?
There is a requirement to dynamically enable and disable an action button in the grid toolbar based on a column value in the grid. If there are multiple lines in the grid, the action button should be enabled for some lines and disabled for others.How can I implement this?Any detailed instructions, tips, or code snippets would be greatly appreciated. Thank you!
Hi fellow developers. I’ve been doing Acumatica dev since 2019. I am a “lone ranger”, which means I don’t have fellow associates to run things by when I don’t know the best way (or any way) to do a particular “thing”. Thank God for this forum. I’d have quit a long time ago without it. However, I just finished a project that involved working with Attributes on the Projects screen. I have custom fields on the screen that are Key Performance Indicators and they are calculations based on 3 sources: one of my own custom fields on the PMProject DAC, a field in the Summary tab (PMProjectRevenueTotal DAC), and Attributes in the Attributes tab.For this one, I have to wait until ALL data has been loaded into the Views. Due to the really unusual way that Attributes are loaded, I cannot use the “appropriate” events to trigger my calculations. Based on my skill set, I can find only one way to do it and it is primarily done in the RowSelected handler, not for the primary DAC on the extension
@Dmitrii Naumov - can you send this to whomever needs to see it?I was looking at the SOAddress table and noticed the field length on the PostalCode field. Might be excessive. Edit: There’s probably a good reason for this. SOAddress’ fields are all 2500 nvarchars.
Hi all , How can we add Branch ID column to the Grid on Approve Bills for Payment ?
On the Projects screen, I want to do some work when the Contract Total changes.In the project editor, I generated the extension for the FieldUpdated event on this field. This is the signature that was created. protected void PMProject_ProjectRevenueTotals.CuryAmount_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) I moved this code from the project editor to my VS project. I got compiler errors. I changed the signature to: protected void PMProject_ProjectRevenueTotals_CuryAmount_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) It compiles and I get no errors on the screen.However, when click Include CO, the value in the field changes to 12,500. I was hoping my extension would fire but it does not.I set CommitChanges to true for the field but it still does not fire.Any ideas on how I can trigger an event to fire when the value in the field changes?
Hi,In shipments screen Details Grid, I added Upload button and trying to update Existing data through Excel, It updating for only first line. Not updating for remaining lines.Below is the Code I gaveIn Aspx: AllowUpload=true for details gridIn Graph Extension:[PXImport(typeof(SOShipLine))] [PXViewName(Messages.SOShipLine)] public PXSelect<SOShipLine, Where<SOShipLine.shipmentNbr, Equal<Current<SOShipment.shipmentNbr>>>, OrderBy<Asc<SOShipLine.shipmentNbr, Asc<SOShipLine.sortOrder>>>> Transactions;Can anyone suggest on this to update all lines in grid.
I want to add a 'Project' filter to the Calendar Board screen (FS300300), as shown in the image. I’ve searched and only found information on modifying the Service Orders bar, but I haven’t found anything related to the Dashboard in my case.
Hey guys, this is my first time playing around with views for a generic inquiry we will be requiring for a new legislation coming in.I have used the view in a GI and it has given me the error: ‘Error: An error occurred during processing of the field Base Item Weight: Specified cast is not valid.’.This is my view:CREATE VIEW CBAMCalculator ASSELECT Inv.CompanyID, TranLine.DocType, TranLine.BatNbr, Inv.InventoryID, Orders.OrderNbr, Line.LineNbr, Inv. BaseItemWeight FROM [InventoryItem] AS InvINNER JOIN [AMMTran] AS TranLine ON Inv.[InventoryID] = TranLine.[InventoryID]INNER JOIN [AMBatch] AS Batch ON TranLine.[DocType] = Batch.[DocType] AND TranLine.[BatNbr] = Batch.[BatNbr]INNER JOIN [SOLine] AS Line ON TranLine.[OrderType] = Line.[AMOrderType] AND TranLine.[ProdOrdID] = Line.[AMProdOrdID]INNER JOIN [SOOrder] AS Orders ON Line.[OrderType] = Orders.[OrderType] AND Line.[OrderNbr] = Orders.[OrderNbr]WHERE Batch.[DocType] = 'M'GOThis is my DAC:#region DocType [PXDBString(1, IsFixed = t
I want to conditionally hide a tab in the Production Order Maintenance form. To achieve this, I followed Option 1 in the following Acumatica Community Portal article.https://community.acumatica.com/customization-tools-and-framework-245/how-to-conditionally-hide-a-tab-on-the-entry-form-4310First, I created an unbound DAC in the AMProdItemExt DAC as follows. #region UsrCustomField01 [PXBool()] [PXUIField(DisplayName="Custom Field", Visible = false)] [PXDefault(false)] public virtual bool? UsrCustomField01 { get; set; } public abstract class usrCustomField01 : PX.Data.BQL.BqlString.Field<usrCustomField01> { }Now, I want to change the value of the UsrcustomField01 based on a field in the Stock Items screen. This field is also custom field in the InventoryItemExt DAC.I tried using event handlers, PXFormula, and PXDefault, but it didn't work.We can create a connection between the AMProdItem and InventoryItem DACs using the InventoryID fields of both DACs.
Hello Community, I have added a custom unbound field to APInvoice DAC. I see the field in the “Result Grid” of the Generic Inquiry I want to design and it shows the result as I expect. My problem is I do not see this field in the "Condition" and "Grouping" tabs of Generic Inquiry Design. I have other custom bound fields which are shown in these two tabs. Am I missing something or Acumatica doesn’t show the unbound fields in these two tabs and if ths is the case any idea why? Im testing on 2023R2 23.206.0006
Hello, I need to present data received from a REST call from an external source. Most probably using PXGrid. My understanding is that I need an unbound DAC class to provide the data to the grid.But I can’t find any documentation how to define the unbound DAC class and how to fill it with the data.Thank you for any hint.
Hello All, I have a custom screen that is built with a grid and allows deleting the row of the grid when a condition is met. I have had this code (sample below) for a while which worked fine but when the same code was upgraded to 24 R1 it stopped displaying the delete button on the row entirely. Can you please point out what could have changed with 24 R1? This code is both in the RowSelected of the header DAC and grid DAC:if (true) {this.Caches[typeof(DAC)].AllowInsert =this.Caches[typeof(DAC)].AllowUpdate =this.Caches[typeof(DAC)].AllowDelete = false;View.AllowDelete = false;View.AllowInsert = false;View.AllowUpdate = false;}else {this.Caches[typeof(DAC)].AllowInsert =this.Caches[typeof(DAC)].AllowUpdate =this.Caches[typeof(DAC)].AllowDelete = true;View.AllowDelete = true;View.AllowInsert = true;View.AllowUpdate = true;}
We wants to hide Create Payment button on sales order base on Finance TermsIn sales order we have Create Payment toolbar button This should be hide if Financial terms = PP (Pre Payment) I cannot able to access button in graph. So I try to add condition but I don’t know how to access in action. But this is not working.Can anyone suggest changes?
Hi,I wanted to localize acumatica into another language. I followed steps in the below blog post and attempted to accomplish it in my local instance.https://asiablog.acumatica.com/2018/01/how-to-translate-acumatica.htmlHowever, in translation dictionaries, the operation is already completed but the string file is not downloaded to translate.I tried again by clicking collect strings but the string file wasn’t downloaded. I tested this in my local instance. Was that the issue or will there be another reason for that? Can someone help me with this?Thank you.
How would I go about updating user defined fields programmatically?I can’t find any examples or any documentation on how to do this. Found a post showing the below, but I need to update UDF fields on IN Issue, IN transfer and IN Receipts, and none of them has Answers view. // iterate attributes on case to set valuesvar answers = caseGraph.Answers.Select();using (var ts = new PXTransactionScope()){ foreach (CSAnswers att in answers) { if (att.AttributeID == "MYATTRIB") { att.Value = "My attribute value"; } } caseGraph.Answers.Cache.Update(answers); caseGraph.Task.Cache.Update(caseGraph.Case); caseGraph.Actions.PressSave(); ts.Complete();}
When I add a field to the ts PXView I get the following error. Sequence contains more than one matching elementAll other fields work as expected except the Template field. I am assuming it has something to do with the PXSelector but am not sure. Below is the PXView def@gridConfig({ preset: GridPreset.Details, syncPosition: true})export class Inspections extends PXView { CreateInspection: PXActionState; DocDate: PXFieldState; ProjectTask: PXFieldState; InspectionCD: PXFieldState; Template: PXFieldState;} snippet from DAC defining template #region Template [PXDBInt] [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)] [PXForeignReference(typeof(FK.Template))] [PXUIField(DisplayName = "Type", Visibility = PXUIVisibility.SelectorVisible, Required = true)] [PXSelector( typeof(Search2<GPProjectInspectionTemplate.templateID, LeftJoin<GPProjectInspectionTemplateAssociations, On<GPProject
So one of our customers has a customization where we added a field for them. They will need to upgrade to the newest version of Acumatica soon. All this customization did was add a field to an AP window. How is that customization field data stored in the database? Could it be lost during an upgrade? Just want to make sure I have a good understanding of this before giving them the go ahead.
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");
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.