Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
When I select a line in my process screen, the selected line is updated but its values get replaced with data from the first RQRequisitionLine.I know this happens because RQRequisition only has ReqNbr as a key, but not LineNbr. Unfortunately, I cannot add LineNbr as a key in my projection.How can I make the grid work so that when I check Selected, only the Selected field changes, and the rest of the data for that row does not get overwritten from the first line RQRequisitionLine?[Serializable] [PXCacheName(Messages.RQRequisitionLineOwned)] [PX.TM.OwnedEscalatedFilter.Projection(typeof(RQRequisitionLineSelection), typeof(RQRequisition), typeof(LeftJoin<RQRequisitionLine, On<RQRequisitionLine.reqNbr, Equal<RQRequisition.reqNbr>>>), null, typeof(RQRequisition.workgroupID), typeof(RQRequisition.ownerID), typeof(RQRequisition.orderDate))] public class RQRequisitionLineOwned : RQRequisitionmy virtual Dac is Projection.I can’t set k
public delegate IEnumerable CompleteDelegate(PXAdapter adapter); public PXAction<DailyFieldReport> complete; [PXButton(CommitChanges = true), PXUIField(DisplayName = "Complete")] protected virtual IEnumerable Complete(PXAdapter adapter) { OnDailyFieldReportCompleting(); return adapter.Get(); } // DailyFieldReportEntryEmployeeActivityExtension.OnDailyFieldReportCompleting protected virtual void OnDailyFieldReportCompleting() {}I need override this button. But I need save base functional. In DailyFieldReportEntryEmployeeActivityExtension this button was already override: [PXOverride] public virtual void OnDailyFieldReportCompleting(Action baseHandler) { baseHandler(); CompleteAllActivities(); } protected virtual void CompleteAllActivities() { foreach (EPActivityApprove activity in EmployeeActivities.Select().FirstTableItems.Where(x => x.Appro
i have grid:<px:PXGridLevel DataMember="LaborHours"> <Columns> <px:PXGridColumn DataField="Selected" Width="30" AllowCheckAll="True" Type="CheckBox" /> <px:PXGridColumn DataField="EmployeeID" Width="140" /> <px:PXGridColumn DataField="EmployeeID_description" Width="220" /> <px:PXGridColumn DataField="EarningTypeCD" Width="140" /> <px:PXGridColumn DataField="ProjectTaskID" Width="70" /> <px:PXGridColumn DataField="CostCodeID" Width="70" /> <px:PXGridColumn DataField="Date_Date" Width="90" /> <px:PXGridColumn DataField="Time_Time" Width="90" /> <px:PXGridColumn DataField="EndDate_Date" Width="90" /> <px:PXGridColumn DataField="EndTime_Time" Width="90" /> <px:PXGridColumn DataField="LaborItemID" Width="70" /> <px:PXGridColumn DataField="IsBillab
<px:PXTabItem Text="Scope"> <AutoCallBack Enabled="True" Target="tab" Command="Save"> <Behavior CommitChanges="True" /></AutoCallBack> <Template> <px:PXRichTextEdit runat="server" AllowLoadTemplate="false" AllowAttached="true" AllowSearch="true" AllowMacros="true" AllowSourceMode="true" DataField="usrDescription" ID="edUsrDescription" Style='width:100%;height:120px;'> <AutoSize Enabled="True" MinHeight="120" /> <LoadTemplate TypeName="PX.SM.SMNotificationMaint" ViewName="NotificationTemplate" Size="M" DataMember="Notifications" ValueField="notificationID" TextField="Name" DataSourceID="ds" /></px:PXRichTextEdit></Template></px:PXTabItem> when i edit edUsrDescription my graph is not dirty. and how to set Disable PXRichTextEdit?
Hi everyone, I am having a problem in a field when I press the Data Field button, the system will take the entire view name as the parent node and the data field as the child node in the view name of the screen that I have selected to display to allow the user to select in the list. However, currently the view name and data field are on the same level without hierarchy, for example PIDetail is the view name, but warehouse is the data field. The result is returning a flat list of child nodes in the repeated parent nodes. Here I attach the capture of my problem, I really appreciate you responds and help.Code for logic: public PXSelect<EntityItem> EntityItems; //public PXSelect<EntityItem> PreviousEntityItems; public IEnumerable entityItems() { var result = new List<EntityItem>(); var current = Templates.Current; if (current == null || string.IsNullOrEmpty(current.Screen)) return result; va
Acumatica version 25R2. I’ve successfully deployed and consumed generic inquiries with parameters via OData. For a specific generic inquiry, I would like to return the result in Excel format for direct opening or download, rather than returning the data in json format. I do not want the calling application to have to convert the data. I’ve been going round and round with Claude AI on a low-code customization solution, but it can’t figure out how to do it in one shot. It wants to trigger an export and file save to the file system then return a reference to the file which requires another API call to download the file. Has anyone been able to perform this type of action with a generic inquiry in one API call? It’s hard to believe that this is so difficult when I can do it with very little code in a web service method in a very old SAP system. Thanks.
Hello, this should be simple but I’m struggling. This code will create an invoice, and work perfectly.private ARInvoice CreatePrepaymentInvoice1(SOOrder order, decimal amount){ ARInvoiceEntry graph = PXGraph.CreateInstance<ARInvoiceEntry>(); ARInvoice invoice = graph.Document.Insert(new ARInvoice { DocType = ARDocType.Invoice, CustomerID = order.CustomerID, DocDate = Base.Accessinfo.BusinessDate, }); graph.Save.Press(); return graph.Document.Current;}Switch the DocType to Prepayment and now it doesn’t work. private ARInvoice CreatePrepaymentInvoice1(SOOrder order, decimal amount){ ARInvoiceEntry graph = PXGraph.CreateInstance<ARInvoiceEntry>(); ARInvoice invoice = graph.Document.Insert(new ARInvoice { DocType = ARDocType.Prepayment, CustomerID = order.CustomerID, DocDate = Base.Accessinfo.BusinessDate, }); graph.Save.Press(); return graph.Document.Current;}The error is:“CS Error: Cannot generate the next number for the sequence.”In the UI, I can open the invoic
I have a customisation that adds a field to AP301000 - it’s part of a project that we’re deploying to pretty much all our customers.I’ve another customisation that adds a very different set of fields to the same screen, and that will be deployed to a subset of our customers. (So it wouldn’t make sense to combine the projects at all.)When I come to publish the second project, it fails with the error message:The [published project] and customization projects cannot be merged because they contain the duplicate AP301000 object. The published typescript file has:import { PXFieldState} from "client-controls";import { AP301000, APInvoice_CurrentDocument} from "src/screens/AP/AP301000/AP301000";export interface AP301000_PinnacleA_generated extends AP301000 {}export class AP301000_PinnacleA_generated {}export interface APInvoice_CurrentDocument_PinnacleA_generated extends APInvoice_CurrentDocument {}export class APInvoice_CurrentDocument_PinnacleA_generated { UsrQueryReason: PXFieldState;
How to hide column note and file on the grid?
#region UsrProjectTaskFilterLabor public abstract class usrProjectTaskFilterLabor : PX.Data.BQL.BqlString.Field<usrProjectTaskFilterLabor> { } [PXDBString] [PXUIField(DisplayName = Messages.ProjectTask)] [PXSelector( typeof(Search<PMTask.taskCD, Where<PMTask.projectID, Equal<Current<DailyFieldReport.projectId>>, And<PMTask.status, NotEqual<ProjectTaskStatus.planned>, And<Where<Current<DailyFieldReportExt.usrBranchIDFilterLabor>, Equal<Null>, Or<PMTask.defaultBranchID, Equal<Current<DailyFieldReportExt.usrBranchIDFilterLabor>>>>>>>>), typeof(PMTask.taskCD), typeof(PMTask.description), ValidateValue = false)] public virtual string UsrProjectTaskFilterLabor { get; set; } #endregionAnd<Where<Current<DailyFieldReportExt.usrBranchIDFilterLab
I created a new screen and i am trying make a GI the entry point for the screen. The screen is working fine with no issues. When i add the screen to the it has a warning that says “This form cannot be automated.” when i view the gi afterward,i get an error that says “Object reference not set to an instance of an object”. The new screen is added to the sitemap and works fine. I published the GI to the same workspace that the screen is in. I tried restarting the application and that didnt fix it. I also added the dll to the customization project and published it again. Nothing i have done so far has made it work. I went back and looked at the last video of T210 where they show how to do it and followed it but i am still getting the error. Does anyone know what this error means?
Hi Everyone, When I’m trying to add the existing screen (Sales Order Preferences), I’m receiving below error. Can you please help fix this issue.
Hello everyone, I want to make a dropdown label like phone type in contact, but the default value doesn't appear, even though I've used PXDefault, and previously I had created a dropdown field with default values and there was no problem.[PXDBString(10)][PXUIField(DisplayName="Virtual Account Bank 1")][PXDefault("BCA;VA BCA")][PXStringList("BCA;VA BCA,HSBC;VA HSBC")]
We have a business requirement to have unit cost be visible and editable on the Details tab for Sales Orders. I made it visible but I can’t find a way to make it editable. Here are the attributes:[PXDBCurrency(typeof(Search<CommonSetup.decPlPrcCst>), typeof(SOLine.curyInfoID), typeof(SOLine.unitCost))][PXUIField(DisplayName = "Unit Cost", Visibility = PXUIVisibility.Dynamic)][PXDefault(TypeCode.Decimal, "0.0")]These seem to match Unit Price except for the Visibility. If there is a way to enable this please let me know.
Selecting GI Data from Database Reading DAC Fields from GenericResult DAC Incorrect Method with Direct Access to Values Property Correct Method with Reading DAC Fields via PXCache API This post is inspired by the old Dmitrii Naumov's blog post:https://asiablog.acumatica.com/index.php/2019/03/working-with-generic-inquiries-from-code/This post attempts to explain how to correctly get Generic Inquiry results from code and also attempts to address some inaccuracies of the original post. Selecting GI Data from DatabaseSometimes, you may wish to obtain Generic Inquiry results from code. The first step to do that is to create an instance of the PXGenericInqGrph graph which is a special graph type used by all Generic Inquiries. To do that, use the PXGenericInqGrph.CreateInstance factory method. The parameters of this method are Generic Inquiry ID or Name, or Screen ID, or previously prepared GI description, or DAC type for auto-generated GI. You can also pass GI parameters to this method. The
I have encountered an issue where some words revert back to the base language (English) instead of the localized language (China). I followed the same steps described in the below link. Sometimes, when I re-upload the same excel to Translation Dictionaries, it works but not always.Is this a cache issue or something else?Version: 24.208.0020https://www.greytrix.com/blogs/acumatica/2022/12/27/translation-and-localization-into-different-languages-in-acumatica/
Hi All, Can you let me know if we can extend the logic in the Calendar Board screen to add an action which creates a service order? If so what are the steps required? Any help is appreciated.Thank you!
Hi I am trying to add numbering sequence logic to the below custom screen, but get Container ID cannot be empty error when trying to save the record. #region ContainerCD [PXDBString(25, IsUnicode = true, IsKey = true, InputMask = ">CCCCCCCCCCCCCCCCCCCCCCCCC")] [PXDefault] [PXSelector(typeof(MAINContainer.containerCD))] [AutoNumber(typeof(Search<PX.Objects.CS.Numbering.numberingID, Where<PX.Objects.CS.Numbering.numberingID, Equal<StringConstant_CONTAINERN>>>), typeof(AccessInfo.businessDate))] [PXUIField(DisplayName = "Container ID")] public virtual string ContainerCD { get; set; } public abstract class containerCD : PX.Data.BQL.BqlString.Field<containerCD> { } #endregionnamespace CFInnova11112025{ public class StringConstant_CONTAINERN : PX.Data.BQL.BqlString.Constant<StringConstant_CONTAINERN> { public StringConstant_CONTAINERN() : base("CONTAINERN") { } }}Trace: Container ID cannot be emptyCan I
Hi. I need to add new tab to Daily Field Report document. At this tab must be grid and filter for this grid.Grid must contain “Selector” column, allow Select all (this should trigger the ability to Save the DFR if changed on a record in this grid).There will be no +/- on this grid, it is just showing existing results matching our filters.When we select some lines at this tab, at next tab(new tab) must be fill associated rows from some table. How i can do this?
I met a problem while upgrading package from 25r1 to 25r2. WSDL changed my viewNames, and control names. So on mobile it brokes up... old UI should be ProgressProject now it named Progress_I solved issue for mobile containers by addimg this to .ts and name restored, but im not sure that it`s a correct solution of this issue.Correct(expected) ViewName: CrewSummaryMobileEmployee @viewInfo({containerName: "Crew Summary Mobile Employee"})Also i have few fields wich is get changed. From ProjectTaskID to ProjectTask and so many others, like on image below.How we can store all names? Maybe describe me how it generate names for schema.If you need details, code or something else. Feel free to ask.
I’m trying to prepare some customisation projects for 2025R2; because I’ll need a load of real data to test it afterwards my starting point was a new instance created using 24.208.0020 that I upgraded to 25.200.0248.Once I’d established that all my projects with only Classic UI forms published successfully, I started to replicate the form changes in Modern UI.So using Powershell I ran: npm run getmodules npm run build-devBut my problem is now that the build fails with errors like:ERROR in ./src/screens/AP/AP301100/documentRecognition/pdfViewer/pdf-viewer.ts 10:0-62Module not found: Error: Can't resolve 'pdfjs-dist' in 'C:\AcumaticaTenants\AcuQBRE2\FrontendSources\screen\src\screens\AP\AP301100\documentRecognition\pdfViewer' That module does appear to be present within the node_modules folder at:C:\[instance]\FrontendSources\screen\node_modules\pdfjs-dist What else might be wrong?
I have RQRequisitionEntry_Workflow.I need override this handlers.Add(handler => handler .WithTargetOf<POOrder>() .OfEntityEvent<POOrder.Events>(e => e.OrderDeleted) .Is(g => g.OnPurchaseOrderDeleted) .UsesPrimaryEntityGetter< SelectFrom<RQRequisition>. InnerJoin<RQRequisitionOrder>. On<RQRequisitionOrder.FK.Requisition>. Where<RQRequisitionOrder.FK.POOrder.SameAsCurrent> >());I need allow select multiple record:handlers.Add(handler => handler .WithTargetOf<POOrder>() .OfEntityEvent<POOrder.Events>(e => e.OrderDeleted) .Is(g => g.OnPurchaseOrderDeleted) .UsesPrimaryEntityGetter<
I just spent several hours trying to figure out why the ‘Appointments’ screen is broken in 25 R2, only to discover that it’s “not”. I just wasn’t using a user that was connected to an employee and I got zero errors about it until I tried the same screen in the Classic UI.Here’s what it looks like:Opening an appointment from the ‘Appointments’ GIOpening the ‘Appointments’ screen
When printing AR Invoice with a project link to it, the system routes me to ProInvoice/Memo (pm641000) form. How do I change the setting to be able to print the regular AR Invoice form (Invoice/Memo - AR641000) for invoices with projects link to it? I have tried going into Mailing & Printing settings of Project Preferences, but the AR Invoice is not available to select. Any ideas how to change this please? Printed form: I want the below to be printed:
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.