Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
I have added a view (ContractDetails) in a BusinessAccountMaint extension. One of the columns contains a Vendor Number and I would like to add a hyperlink on that column to make the related vendor number appear in a popup window. The Vendor Number column is defined as follows, it is just a lookup field. #region UsrVendor [PXString(15)] [PXUIField(DisplayName="Vendor", Enabled=false)] [PXDBScalar(typeof(Search2<BAccount.acctCD ,InnerJoin<POVendorInventory, On<POVendorInventory.vendorID, Equal<BAccount.bAccountID>> ,InnerJoin<ContractItem, On<ContractItem.recurringItemID, Equal<POVendorInventory.inventoryID>>>> ,Where<ContractItem.contractItemID, Equal<ContractDetail.contractItemID>> >) )] public virtual string UsrVendor { get; set; } public abstract class usrVendor : PX.Data.BQL.BqlString.Field<usrVendor> { } #endregionHere is my code for the hyperlink and popup window. I’ve added ViewV
I have some specific questions about about how Acumatica developers manage customization projects, in particular those that involve custom C# classes and are developed using Visual Studio: How do you manage your code repository and versioning for Acumatica customizations? Would you recommend using the built-in Azure DevOps tools in Visual Studio to manage Acumatica customization code? Do you have any advice for maintaining multiple different versions of a customization project that correspond to different Acumatica builds? What’s the best way to manage multiple development sandbox instances for multiple clients? Is this usually done on a virtual machine? Do you have any general advice for QA / testing specifically in Acumatica? How would you set this up for a small team without a dedicated testing engineer?Any insight or advice on these questions would be greatly appreciated!
Hi all I am not able to publish the project thrown out this exception could you please have a look.TIAshahidavali
Hi,I have created a sales order data table widget on dashboard. Now i want to add a print link as one of the column in the widget. how can i do that?
Hi there, I am trying to override the Ship-to-Address and Ship-to-Contact details by making them automatically filled when I select Customer from a custom field in Shipments screen. Further digging into this shown that the details is referencing from ShipAddressID and ShipContactID which is being referenced from CustomerID on the header. However for Transfer, the Customer selector on the header will be hidden and from SQL, it shows that the Customer is pointing to itself. How do I get the ShipAddressID and ShipContactID to be referenced from the custom Customer field instead?
I am posting this in case anyone ever has the same issue, they will know how to fix it.I have a customized version of AP301000 in R2020R2 Build 20.207.0012. The page publishes and works fine.In the project editor, on my custom field, I entered a LabelWidth with a value of “M”. This caused the page to error. I unticked the checkbox on the LabelWidth propery. The value [RESET] was automatically filled into the value field. I saved the change and tried to preview and I got this error Steps to try to get rid of the error:unpublished all deleted the screen from the customization published the project restarted the application cleared cookies from the browser added the screen back into the project with no changes. clicked preview changes and I still get the error.I tried this in a different browser, same thing occurs.I also verified that after deleting and unpublishing, in the project editor, there was NO reference to AP301000 anywhere. I checked this by going to File - Edit Project XM
Using 2020 R2A while back, I created a UDF on the Journal Transactions screen This value comes from a custom maintenance table.When a JE is posted, this field is no longer editable.I made a workaround by creating a custom form to allow the field to be modified. The user clicks the UPDATE button to open a new screen to change the value on the JE. However, that is clunky and not user friendly.You can’t use workflows on Journal Transactions. So I added the field in the Automation Steps screen:Still no luck. At least the Automation Steps was able to see my UDF!
You may have noticed when upgrading to 2022 R1 that PXEmailSourceAttribute is now marked Obsolete. [Obsolete("The Wiki Notifications functionality, which is related to PXEMailSourceAttribute, no longer exists.")] Trying to remove all those annoying messages during compile and cleanup my custom code to remove the obsolete attribute, I commented out my use of [PXEmailSource] which happens to be defined on every primary DAC used by a graph that has approvals coded and configured.After removal of the obsolete attribute and rigorous testing of my code, everything seemed ok except for one of several custom screens that implements approvals… until I went to look at Approval Maps and found the Entity Type (EPAssignmentMap.GraphType) drop-down box was blank for my Approval Maps for my custom screens.As it happens, EPApprovalMapMaint in 2022 R1 still contains the following nugget…private class Definition : IPrefetchable<EPApprovalMapMaint>{ public List<PXSiteMapNode> SiteMapNodes
Hello, I would like to use side panel to display information contained in a GI in order to have all required knowledge prior to creating a record in an entry screenI have noticed that I need to save a first level of data in the entry screen, otherwise the side panel would not open.Is it standard behavior?Nota : I don’t need the entry to be recorded in the DB as I don’t need to pass any parameters from the entry screen to the side panel.
HiIs it possible to detect at runtime the selected filter applied to a grid? I’d like to change the color of the grid depending on the selected filter, but I don’t know which property on the base graph contains the name of the selected filter.Please see below - basically I’d like to know (in my graph extension) which of the two tabs (i.e. Filter Setting) is currently selected by the user.Thanks
I am trying to get a newly added package to have the Shipment Number in the Customer Ref Nbr 1 field automatically. To do this I added a fieldDefaulting event as follows: protected void SOPackageDetailEx_CustomRefNbr1_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e) { var row = (SOPackageDetailEx)e.Row; if (row == null) return; e.NewValue = "SH#" + row.ShipmentNbr; }This works fine when I manually press to add a package but when I use auto pack it ends up with a field with: SH# <NEW> as I presume the row.ShipmentNbr is not populated at that point. What should I use to get the shipment number before it is saved? Thanks for any advice, Phil
Hi all,I have gone through the Acumatica training material a few times on this but cannot find the issue. I have created a new screen with the corresponding DACs’ as per the T210 and T220 training material. I have setup the entire DAC with a master-detail relationship setup but get the following error when trying to create a new item.Error: Inserting 'LTFGItems' record raised at least one error. Please review the errors. Error: 'Batch Nbr' cannot be empty.This is what the screen looks like:The DACs’ are setup with the LTFGHeader (Parent) and LTFGItems (Child) - I have just added the fields in question for the sake of saving space: LTFGHeader#region BatchNbr [PXDBString(15, IsUnicode = true, IsKey = true, InputMask = "")] [PXUIField(DisplayName = "Batch Number", Required = true, Visibility = PXUIVisibility.SelectorVisible)] [PXDefault] [AutoNumber(typeof(INSetupExt.usrFinGoodsBatchNbr), typeof(LTFGHeader.batchDate))] [PXSelector(typeof(Search<LTFGH
Hi Everyone,In the Stock Items, I’m trying to update the existing record with the below code but it is still trying to insert a new record in the Cross-Reference tab.Can anyone help on this? public delegate void PersistDelegate(); [PXOverride] public void Persist(PersistDelegate del) { try { InventoryItem row = Base.Item.Current; if (row != null) { CSAnswers objCSAnswers = PXSelect<CSAnswers, Where<CSAnswers.refNoteID, Equal<Required<CSAnswers.refNoteID>>, And<CSAnswers.attributeID, Equal<Required<CSAnswers.attributeID>>>>>.Select(Base, row.NoteID, "ALTID"); if (objCSAnswers != null && !string.IsNullOrEmpty(objCSAnswers.Value)) { row.GetExtension<InventoryItemCExt>().UsrCAlternateID = objCSAnswers.Value; INItemXRef obj
In 2021R1, I am trying to change “Start Date” to “Creation Date” on the Tasks Screen CR306020I’ve gone through the answers on this topic: None of them are working.If you inspect that field it shows this:I’ve tried doing it in VS for both StartDate and StartDate_Date. In debug, the StartDate fires so I know I am hitting this code. I tried StartDate_Date, but that does not fire.The actual code for the one that fires is:[PXMergeAttributes(Method = MergeMethod.Append)][PXCustomizeBaseAttribute(typeof(PXUIFieldAttribute), nameof(PXUIFieldAttribute.DisplayName), "Creation Date")]protected virtual void CRActivity_StartDate_CacheAttached(PXCache cache){ string joe = "joe";}I also tried editing the field in the Project Editor:Neither of these change the Display Name.I suspect it may have something to do with the fact that the field name shows as StartDate_Date?StartDate_Date is not a field you can select in the editor.I am able to make the other three fields required both in the Project Edito
Hello Gang,I have a customization project that I need to get a sealed class result ApproveInfo(the members of the class are StepID, RuleID, OwnerID, WorkgroupID and WaitTime). Below is my extension:public virtual IEnumerable<ApproveInfo> GetApproversFromNextStep_Extension(SourceAssign Source, EPAssignmentMap AssignmentMap, int? CurrentStepSequence){ if (AssignmentMap == null) { yield break; } EPAssignmentProcessor<SourceAssign> assignmentProcessor = new EPAssignmentProcessor<SourceAssign>(_Graph); foreach (ApproveInfo approveInfo in assignmentProcessor.Approve(Source, AssignmentMap, CurrentStepSequence)) { yield return approveInfo; }}Now I need the sealed calss members and values. below is the code calling the class to get these five fields but it doesn’t work for me. the result assigned to approveInfo is considered as a vaiable but I would like to access approveInfo.StepID, approveInfo.RuleID … and get their values. What I am doing
I’ve created a custom SQL table and DAC, but having difficulty using the new class in a GI. This is the error when referencing any of the fields:Also, when trying to specify the new GI on the navigation tab of a different generic inquiry the [Item] parameter is not available as a filter, and none of the fields appear in the dropdown either.The custom DAC is available to select on the Tables tab of the Generic Inquiry, and the Alias seems to match: The GI runs and filters correctly, but we would like to use it as a side panel on another GI and that won’t work because the navigation parameter isn’t available. I have tried republishing the customization and restarting the application several times.The GI returns data when run on its own: DAC Definition:using System;using PX.Data;namespace SalesHistory{ [System.SerializableAttribute()] [PXCacheName("OE Sales History")] public class PS_Sales_History : IBqlTable { #region Id [PXDBIdentity(IsKey = true)] public virtual int? Id
Hi there,I was tasked to add a PO tab to the SO GI and display the Create PO (PO505000) GI on this tab. I managed to get the tab displayed by using selects from the POCreate graph and creating an SOrderEntry extension.My problem is populating the data for the create PO tab. The create PO GI is displayed with a PXRedirectRequiredException from the SOrderEntry action. I am not sure how to do the same process when it is added as a tab on a different GI.
Hi, I am working with a customization project and we have added custom fields on the Shipments screen. We have a DAC class set up in Visual Studio, the Database Scripts for these fields have been added in the Project Editor, and the fields have also been added to the screen in the Project Editor. We have added custom fields for seven other screens in this way and they are working just fine. However, with Shipments it seems whenever changes are made to the project in Visual Studio and the new DLL is loaded into the Project Editor, the custom Shipment fields disappear from the Customization Project. The fields will remain in the Screen Editor, under the Form tree, but are removed in the Custom Data Fields section in the Screen Editor. They are also not visible on the Shipments page in the Acumatica instance. This occurs when a new DLL is loaded into the Project Editor, even with changes unrelated to the Shipment fields.I have tried removing the artifacts of these fields in the Form tree,
Is it possible to auto-expand text field width based on the text length?
I am attempting to completely replace the default Case Workflow via code. I copied nearly the entire default CaseWorkflow code and customized it to my liking. However, I am not able to make the changes display in any way. Some important bits of code are:namespace CaseTest{ using static PX.Data.WorkflowAPI.BoundedTo<CRCaseMaint, CRCase>; public class CaseWorkflow_CRCaseMaint_Workflow : PXGraphExtension<CRCaseMaint> { public static bool IsActive() => true; public override void Configure(PXScreenConfiguration config) {PXTrace.WriteInformation("!"); var context = config.GetScreenConfigurationContext<CRCaseMaint, CRCase>(); context.ReplaceScreenConfigurationFor(screen => { return screen .StateIdentifierIs<CRCase.status>() .FlowTypeIdentifierIs<CRCase.caseClassID>(true) .WithFlows(flows => {
Version 2021 R1On the Tasks screen (CR306020), my customer would like to send an email to the owner of the Opportunity when a task is completed if the owner of the TASK is different than the owner of the Opportunity.Is there an example somewhere of how to trigger an email from Visual Studio code?I created a Notification Template. I’d like to trigger the template from code. I’d need to be able to supply the From and To fields. I also want to provide a custom body for the email.Is this possible?If this is covered in Acumatica Training, I don’t know which lesson to do. Please let me know if there is training available that I don’t see.
We have a problem where the Side Panels text is too light to read. We are using the Indigo theme and would like to continue using this as people are used to it. I have changed the theme to Default and the text is readable again but we’d really like to use Indigo. While investigating I discovered the Controls.css needs to be edited to fix this issue but our installation is not on prem so I can’t access the files directly. Is there a way to edit this file in our case? Thanks, Phil
Is there anyway to show multi-line text on the dashboards? I have a few text control on our project screen which are defined as multi-line text on project screen. I need to show them on a dashboard as they are defined but dashboards show only a limited number of characters in one row and cut the rest. Can anyone help?
Hello ,Can I have a sample how to customize Category Filter field in Self Service Portal for My Cart Screen or any screen please? Thank youJennifer
Where does Included field get saved in Acumatica.Could you please figure out the table?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.