Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
HelloI am facing an issue with an Acumatica Instance, verison 2021 R2. The problem occurs when order’s come into Acumatica Instance from third party Integration.The Integration works as expected. However, when it creates a Sales Order into Acumatica, it throws an error , An error occurred during processing of the field Subaccount: Subaccount 'System.Object' cannot be found in the system.Please verify whether you have proper access rights to this object. PX.Data.PXOuterException: An error occurred during processing of the field Subaccount: Subaccount 'System.Object' cannot be found in the system. Please verify whether you have proper access rights to this object Note:-The Above error started occuring, when we did a refresh of data, i.e copied data from Live Instance to Test Tenant. The Instance is on 2021 R2.-When I de-activated sub account on test tenant, I was able to create sales order. Clarification: 1) Does this issue occur due to subaccount active on two different tenant?2) Is t
I need to retrieve all data when value of branchID field is not selected in printing statements screen. when the branch id is not selected the result should be retrieve all data of printing statements.
This code changes the default calculation for SOLine.CuryUnitPrice on SOOrderEntry:protected virtual void _(Events.FieldDefaulting<SOLine, SOLine.curyUnitPrice> e, PXFieldDefaulting b){ SOLine row = e.Row; if (row is null) return; b?.Invoke(e.Cache, e.Args); var rowExt = row.GetExtension<DSDSOLine_Ext>(); e.NewValue = (row?.OrderQty ?? 0m) * (row?.CuryUnitCost ?? 0m) * (rowExt?.UsrMultiplier ?? 0m); e.Cancel = true;}There are several fields that when updated need to trigger this calculation. I do this exactly like the system does:protected virtual void _(Events.FieldUpdated<SOLine, DSDSOLine_Ext.usrMultiplier> e){ SOLine row = e.Row; if (row is null) return; e.Cache.SetDefaultExt<SOLine.curyUnitPrice>(row);} Unfortunately, despite not actually setting the value of CuryUnitPrice anywhere except the FieldDefaulting event, ‘Manual Price’ gets set to true during this process. I can’t figure out why, and I can’t figure out how to prevent it
How to save currentCost filed in Database ?This CurrentCost Filed is custom filed/* DAC */namespace PX.Objects.IN{ public class INItemCostExt : PXCacheExtension<PX.Objects.IN.INItemCost> { public static bool IsActive() => true; #region UsrCurrentCost [PXDBPriceCost(BqlField = typeof(INItemCostExt.usrCurrentCost))] [PXUIField(DisplayName = "Current Cost")] [CurySymbol] public virtual Decimal? UsrCurrentCost { get; set; } public abstract class usrCurrentCost : PX.Data.BQL.BqlDecimal.Field<usrCurrentCost> { } #endregion }}/* InventoryItemMaint_Extension */ Bussiness Logic;namespace PX.Objects.IN{ public class InventoryItemMaint_Extension : PXGraphExtension<PX.Objects.IN.InventoryItemMaint> { public static bool IsActive() => true; #region Event Handlers protected void INItemCost_RowInserted(PXCache cache, PXRowInsertedEventArgs e, PXRowInserted InvokeBaseHandler) {
Hi Team,I need to save some data into an another table in the DB. I created a table in the DB and also created a DAC. Can someone please help me?public PXSelect<CISTaxSubmittedData> cisTaxSubmittedData;[PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Submit Tax Report", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = false)] protected virtual IEnumerable submitTaxReport(PXAdapter adapter) { need to save data to the cisTaxSubmittedData return adapter.Get(); }
Hi there, I am having trouble to display the custom field value for Inventory Item Class in Storage Summary screen as shown below: My DAC:public class StoragePlaceStatusExt : PXCacheExtension<PX.Objects.IN.StoragePlaceStatus>{ #region UsrItemClass [PXDBString(30,BqlField=typeof(StoragePlaceExt.usrItemClass))] [PXUIField(DisplayName = "Item Class")] [PXDBScalar(typeof(Search2<INItemClass.itemClassCD, InnerJoin<InventoryItem, On<InventoryItem.itemClassID, Equal<INItemClass.itemClassID>>>, Where<InventoryItem.inventoryID, Equal<StoragePlaceStatus.inventoryID>>>))] public virtual string UsrItemClass { get; set; } public abstract class usrItemClass : PX.Data.BQL.BqlString.Field<usrItemClass> { } #endregion} When I tried creating the field in Customization Project Editor screen, it seems like it was created in two places: StoragePlace and StoragePlaceStatus. However, referring from the Element Inspector
Good day everyone, I am trying to update the Display name of a field on the AR508000 screen and I get the following error:The underlying field is a surrogate. Attribute overriding for this field is not supported. These are the fields in question on the ARDocumentList data view. I have tried extending the DAC and also tried changing it via the CacheAttached but cannot get it to work correctly or publish it without errors. Any help would be greatly appreciated. Thanks,
Trying to set default value for a Project Manager Field on Project Screen from Attribute field. Looks like I have set everything in Customization Project but doesnt work. Any ideas?
Hello, Is it possible to link a custom table to an existing screen in Acumatica? I am aware of creating custom fields and adding to existing screens, but wondering if we can add fields from a custom table. I am trying to add a new tab item for the Inventory Maintenance screen and add new options that are in a custom table.
My customer wants GI screens with “Between” on string/varchar fields. I don’t see a way to do this in a GI. Am I missing something?
In Sales Order Entry, the header SOOrder.OrderQty is SumCalc by the SOLine.OrderQty. I changed the SOLine.OrderQty in the SOLine_RowUpdated event by: cache.SetValueExt<SOLine.orderQty>(row, newValue); The line quantity did change to the new value, but the header SOOrder.OrderQty still keep the old value. I added another statement: PXUnboundFormulaAttribute.CalcAggregate<SOLine.orderQty>(cache, row);But still no change. Am I missing something? Thanks,
Hello,I try to create a custom PXSelector reference field in my CRCase (Servicetickets). I want to set a SalesOrder SOOrderEntry as reference field with a selector.Exactly like the green box but as new field with SOOrder to select.currently i created a new string field.every attempt to use a PXSelector with SOOrderEntry fails due to not set references. SOOrderEntry does just not exist in this scope.CRCase simply has no region for SoOrderIDBest case would be an automaticly set reference in the corresponding order aswellhow can I add the reference and region for SoOrderID and what would be the best approach? best regards
Hi,How can I put “Not provided” in notification template if the value is empty for the data field in body?
I have made a custom action that I want to execute when shipment is confirmed.I have tried to extend the workflow and add the new action as auto run true. https://community.acumatica.com/topic/show?tid=10301&fid=288 I have followed above reference.I have also added condition after using True and IsConfirmed which were not executing my method.ConditionWorkflowAny thoughts on this ??
Hi,We have created two custom fields to get invoice numbers. These fields are not visible in the UAT environment but are visible in the production environment. When I move the field to a different column, this happens. But these fields remain visible in the Production environment even after we publish this customization project to Production. does anyone know what causes this and how to fix this?Thank you.
My customize code working fine but when we use software more a week, this block of code stop working. But if we restart IIS service, it start working gain. Could you advice how to do it
Hello, I would like to create a processing screen which will check a group of invoices, if an invoice has a file attached then the files will be added to a zip file. The user will download the zip file. I’ve found a document which explains how to use zip files in Acumatica, link below:https://www.acumatica.com/blog/zipped-up-acumatica-manipulating-files-part-1-zip/It suggests using an object called ZipArchive in the following way using (ZipArchive zip = ZipArchive.CreateFrom(zipStream, false)){ using (MemoryStream fileStream = new MemoryStream()) { fileStream.Seek(0, SeekOrigin.Begin); file.Write(fileStream); fileStream.Seek(0, SeekOrigin.Begin); zip.AddFile(fileName, fileStream.ToArray()); }}I cannot find the ZipArchive type, does anyone know which references and/or ‘using’ statements is required?The article suggests using PX.Common.Std, I have a reference to this file but I still cannot access ZipArchive.Thanks
Good day, everyone.We customized a requisition (RQ302000) screen Ref Nbr. Selector to load data based on a logged in user's user role.The selector worked fine when there were few records, but now we have thousands of records and every field on the screen takes time to update the value because of this custom selector.The code for the custom selector is shown below. What is the best way to avoid this performance problem, and what changes should we make to this custom selector? public class RequisitionEntryRQNbrExt : PXGraphExtension<RQRequisitionEntry> { #region Ref nbr attribute override [PXMergeAttributes(Method = MergeMethod.Append)] [PXRemoveBaseAttribute(typeof(PXSelectorAttribute))] [RQRequisitionRestrictExt] protected virtual void RQRequisition_ReqNbr_CacheAttached(PXCache cache) { } public class RQRequisitionRestrictExt : PXCustomSelectorAttribute { public RQRequisitionRestrictExt()
Hi,I need to know from where and how data is populated to the following attached screen. Can someone please help me out? Here, Tax Agency is a customized one for me. Thanks.Bhagya
What’s the best practice for adding fields to my own custom table after the customization has been published?Should I create an extension for my own table or can I generate a script to update the table as if the fields had always been there?
Hello Everyone, can anyone found any difference between 2022R2 and 2023R2 Customization. if so can you provide the details...
I am trying to add address fields to the Location selector on the Opportunities screen.I copied the code from Sergey’s blog at https://asiablog.acumatica.com/2015/10/customizing-selector-attributes.htmlFrom the blog, the code is like this: #region CustomerLocationID public abstract class customerLocationID : PX.Data.IBqlField { } [PXMergeAttributesAttribute(Method = MergeMethod.Merge)] [PXCustomizeSelectorColumns( typeof(PX.Objects.CR.Location.locationCD), typeof(PX.Objects.CR.Location.descr), typeof(PX.Objects.CR.Address.addressLine1))] [LocationID(typeof(Where<Location.bAccountID, Equal<Current<SOOrder.customerID>>, And<Location.isActive, Equal<True>, And<MatchWithBranch<Location.cBranchID>>>>), typeof(InnerJoin<Address, On<Location.defAddressID, Equal<Address.addressID>>>), DescriptionField = typeof(Location.descr), Visibility = PXUIVisibility.SelectorVisible)] public int? CustomerLocationID { get; set;
Hi Team,How I can ignore the standard Validation error during the release Process. Could you please help me on this. GL Error: Cash account doesn't exist for this branch, account and sub account (PRODWHOLE , 10200, 000FIN) Regards,Ramya Krishna
This should be simple. I have a custom dialog with some data fields, and an OK button. I want the OK button to perform a save of the fields as well as other processing. I’ve tried many things, but so far, my OK button doesn’t perform my associated code. I defined a new dialog within the page editor. I added an action button that appears on the menu, and it opens my dialog just fine via button command delegate method and the AskExt() method of the view. But my OK button just closes the dialog and seemingly does nothing else. I have tried setting breakpoints after the OK is returned:if (view.AskExt("viewPanel", true) == WebDialogResult.OK){ // other code here, with a breakpoint}else{ // other code here, with a breakpoint{and no breakpoints are hit. I also set the dialog button’s AutoCallback command to a custom method with a breakpoint. I tried a method signature of both protected void <method>() that matches a button action delegate and a public IEnumerable <meth
I am trying to open the Inventory Summary screen with a PXRedirect and pass a parameter for the Inventory ID.Dictionary<string, int> parameters = new Dictionary<string, int>();var baseGraph = PXGraph.CreateInstance<InventorySummaryEnq>();//hard coded for testing//14998 = Inventory CD "1007"parameters.Add("InventoryID", 14998);throw new PXRedirectRequiredException(baseGraph, "Inventory Summary", parameters) { Mode = PXBaseRedirectException.WindowMode.Layer };The Mode = part is because I am populating a side panel. Since I am opening the Inventory Summary screen via Javascript from an SO Line detail, I cannot do this from a standard Side Panel.The Inventory Summary screen opens in the Side Panel, but the Inventory ID field is not being populated.One option to get the data and display it in a side panel using a GI. But there are over 2000 lines of code in the Inventory Summary graph to calculate the values displayed on that screen. I don’t think that is an option.Is t
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.