Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Dear experts,I want to make field Tax Registration ID required but a single space or multiple spaces should still be considered valid inputI implemented following event handler: RowPersisting, FieldVerifying, FieldUpdated but the value of this field is always null even though I input a space character “ “I don’t know if Acumatica might be automatically trimming whitespace inputs to null during data processing.Have you experience this kind of issue?
Is this expected?It takes a frustrating amount of time for the build process to run for frontend source code.I was hoping development would be faster on the new UI, but so far it has been very slow. Every time I make a change to the typescript or html files, rebuilding the source code takes approximately a minute, even for a simple screen. Anyone have any ideas?
Hi, I’ve created a custom screen (table, graph screen definition) and associated a sequence number to the reference number field (hence the <NEW> showing). The key is Reference Nbr + Revision. For whatever reason on save (or if I say change commithchanges to true for Vendor ID), it always throws this unhandled exception error about the Reference Nbr not existing. I assure you its both the database and DAC DAC (I confirm it’s reading that sequence number, I tested changing it’s placeholder value to ensure its reading the correct one): Screen: Database: Trace: Has anyone encountered this or know how or why this would happen and how to fix it? It surely must be some mapping I missed in the screen definition or something. Using 2024R1 Build 24.109 Thanks. Regards, Andrew
The PXDBWeblink field currently opens as a new tab.Does anyone know if it’s possible to have it open as a new window?
I have created an action in a custom screen graph which is responsible for setting some field values base on few complex conditions. These conditions are based on DACs except the main DAC of the screen. Since it does few DB updates can’t use the Row Selected event also. is there any way to call that method just after initialization of the screen?Note: Topic Should corrected as “How to call an action just after initialization of a custom Screen”
Hello everyone,I'm facing an issue with a custom Acumatica screen that involves managing customer records (SanitationCustomer). I have a custom graph (SanitationCustomerMaint) and DAC (SanitationCustomer) that allow users to select a different ClientID using a selector. The main problem occurs when switching between tabs and updating the ClientID.Here is the specific issue: When I update the ClientID from the General tab, the customer information is correctly updated for fields such as name, address, city, etc., and all the related views are refreshed accordingly. However, when I switch to a different tab (e.g., Brewers or Invoices) and change the ClientID, the new ClientID appears to be set, but when I navigate back to theGeneral tab, the customer information shown is still from the previous ClientID. Additionally, if I save a new record to a related view (e.g., AssignedBreweries), it gets associated with the previous ClientID instead of the newly selected one. using System;using
Hi, I have a user defined field in customer screen (LocationExt.usrExpectedPaymentDate) as below, I need to access this field for a calculation in the sales order entry graph but I get this error.[2024-10-23 04:45:10.957] \App_Code\Caches\SOOrderEntry.cs(159): error CS0246: The type or namespace name 'StandaloneLocationExt' could not be found (are you missing a using directive or an assembly reference?)using System;using System.Collections;using System.Collections.Generic;using System.Diagnostics;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CA;using PX.Objects.CM;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.DR;using PX.Objects.EP;using PX.Objects.GL;using PX.Objects.IN;using PX.Objects.PM;using PX.Objects.PO;using PX.Objects.TX;using POLine = PX.Objects.PO.POLine;using POOrder = PX.Objects.PO.POOrder;using PX.CarrierService;using PX.Concurrency;using CRLocation = PX.Objects.CR.Standalone.Location;
Hi, I’m working on a custom validation that requires looking up PO commitments for a given Branch/ExpenseAcct/ExpenseSub/Fiscal Year. The fiscal year is a custom field that was added as an extension to the POLine DAC. I’ll be converting this query to fetch the sum of unbilled amounts, but for now I’m just trying to get the correct lines to be filtered and I’m getting a crash (stack overflow on FIeldVerifying) when my current BQL query is executed. Is there something I’m missing to be able to connect the POLineExt in this query?public SelectFrom<POLine>.Where<POLine.branchID.IsEqual<@P.AsInt>.And<POLineExt.usrFiscYr.Contains<@P.AsString>>.And<POLine.expenseAcctID.IsEqual<@P.AsInt>>.And<POLine.expenseSubID.IsEqual<@P.AsInt>>>.View POLineView;Thank you!
Hello po i just want to ask if i can change the report when the print is clicked ? base on Branch
I have a requirement to include a field for storing the user ID of the person who released the invoice. How can I achieve this?
I created an action button to create a service order from the customer screen. The customization works great. The only problem is the Address Lookup seemed to stop working. Any Idea what may be causing this?using PX.Data;using PX.Objects.CR;using PX.Objects.FS;using System.Collections;using PX.SM;namespace PX.Objects.AR{ public class CustomerMaint_Extension : PXGraphExtension<PX.Objects.AR.CustomerMaint> { public class CustomerServiceOrderDac : IBqlTable{ [PXString(4, IsFixed = true, InputMask = ">AAAA")] [PXUIField(DisplayName = "Service Order Type", Required = true)] [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] [FSSelectorActiveSrvOrdType] public virtual string ServiceOrderType{ get; set; } public abstract class serviceOrderType : PX.Data.BQL.BqlString.Field<serviceOrderType> { } } public PXFilter<CustomerServiceOrderDac> pXFilter; public PXAction<Cus
Hi,I have a requirement to grant permissions for specific fields in a form to different users or user roles. Is there a method to control field-level permissions based on user roles or specific users who have permissions in Acumatica? If so, could you please provide detailed steps or guidelines on how to achieve this task?Thank you in advance for your assistance!
Hello Community, I have a customization created that is enabling the InTranSplit.expireDate field in the IN > Receipts screen on released documents. This allows me to update the expiration date on the table which works just fine. However, the lot\serial report pulls from INSiteLotSerial table which doesn’t update using this method. Is there something else I need to call to get this extra table updated or is it just a bad idea to update the expiration date this way? Should I instead create a processing screen that instead generates a copy of this receipt and one line to adjust it out and another to adjust it in with a new date? public class INReceiptEntry_Extension : PXGraphExtension<PX.Objects.IN.INReceiptEntry> { #region Event Handlers protected void INTranSplit_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { InvokeBaseHandler?.Invoke(cache, e); var row = (INTranSplit)e.Row; if (row != null) { Base.
Good day,I am developing a customization to make the selection of a Contact field required on both the Opportunity and Quote. I know how to make the field required using the customizations. However, I am concerned on how it could affect the workflow. Adding quotes, processing, action areas, etc.For example; Opportunity/Quotes. Are their any issues or problems that could arise. Management wants sales reps to have contacts on all their opportunities and quotes. We also have an Approval process for large quotes. Since the documents are interconnected, Should the customization be separate or together? I don’t want to slow down the Sales process; however it does present some issues with sales Approval process? issues Actions being affected; Convert to Order, etc.Does anyone have a better suggestion? Or a better way to go?Thank you.
I have a question why it is not displaying the data of RefNBR
i am able to create check before one month but now i cant able to create checki have posted this data {"CuryOrigDocAmt":{"value":0},"CashAccount":{"value":"10060"},"Type":{"value":"Check"},"Vendor":{"value":"V001097"},"CurrencyID":{"value":"USD"},"Hold":{"value":false},"PaymentAmount":{"value":10.19},"PaymentMethod":{"value":"CREDITCARD"},"Details":[{"CashAccount":{"value":"10060"},"PostPeriod":{"value":"102024"},"BranchID":{"value":null},"InventoryID":{"value":null},"OrderQty":{"value":0},"WarehouseID":{"value":null},"AmountPaid":{"value":10.19},"Balance":{"value":10.19},"CashDiscountBalance":{"value":null},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"001301"}}],"PostPeriod":{"value":"102024"}}and my endpoint https://localhost//entity/acumaticalocal/1.0.3/Check
Hi I have a custom checkbox created in the Stock Items screen under the manufacturing screen, when this is checked I need the "Allow Preassigning Lot/Serial Numbers" to be automatically checked as well in the Production Order Maintenance screen. My code works but when the event handler is triggered it clears out the other header fields such as the Inventory ID. How can I fix this?Custom Checkbox FieldEvent Handler to be Applied to this Checkboxusing PX.Objects.Common.Scopes;using PX.Objects.PM;using IQtyAllocated = PX.Objects.IN.Overrides.INDocumentRelease.IQtyAllocated;using LocationStatus = PX.Objects.IN.Overrides.INDocumentRelease.LocationStatus;using LotSerialStatus = PX.Objects.IN.Overrides.INDocumentRelease.LotSerialStatus;using SiteLotSerial = PX.Objects.IN.Overrides.INDocumentRelease.SiteLotSerial;using SiteStatus = PX.Objects.IN.Overrides.INDocumentRelease.SiteStatus;using System;using PX.Data;using PX.Objects.IN;using PX.Objects.CS;using System.Collections;using System.Collec
I am trying to update my references from Acumatica endpoint version 20.200.001 to 22.200.001 because only the later version contains mappings for Invoice line detail field Tax Category.Current ReferenceBut when I update these references to Acumatica.Default_22.200.001 (updated all versions to latest version 5.3) I get this error for the namespace using Acumatica.Auth.Api; which worked perfectly fine before.Reference ErrorError CS0234 The type or namespace name 'Auth' does not exist in the namespace 'Acumatica' (are you missing an assembly reference?) SkillInvestAPIIntegration C:\PROJECTS\MYOB\SkillInvest\CODE NOT MODIFIED\SkillInvestAPIIntegration\SkillInvestAPIIntegration\SkillInvestAPIIntegration\Rep\MYOBFunctions.cs 1 ActiveCould I please get some assistance on this, thank you!
Hi,In the Sales Orders screen, a client is wanting to search for a customer in the Customer box using the Ext Ref Nbr as well as the Customer ID, as they have migrated some customer data across from another system which could be looked up via both an ID and a reference number.I have added the Ext Ref Nbr column to the selector, as shown below, but I am unsure how to include this column in the filtering function.The code below is how I attempted to do it, but this just made the Customer selector return no results at all when you first click on the magnifying glass icon of the selector.Do you have any recommendations for how I could implement this?Let me know if I can provide any other information.Kind regards,Andrew [PXDefault][Customer( typeof(Search<BAccountR.bAccountID Where2< Where<BAccountR.acctCD, Like<Current<SOOrder.customerID>>, // Search by Customer ID Or<BAccountR.acctName, Like<Current<SOOrder.customerID>>,
Hello Team,I Got Some Error during customization on Acumatica 2024 R1, the codes works fine on Acumatica 2021 R2, but when upgrading to Acumatica 2024 R1 it throw error A data corruption state has been detected here simple customization code. protected virtual void _(Events.FieldUpdated<RQRequisition,RQRequisition.vendorID> e){ if (e.NewValue != null) { int? vendorID = Convert.ToInt16(e.NewValue); foreach (var line in Base.Lines.Cache.Cached.RowCast<RQRequisitionLine>()) { var vendorPrice = GetVendorPrice(vendorID, line.InventoryID, line.SiteID, line.PromisedDate); decimal lastPrice = vendorPrice == null ? 0m : vendorPrice.SalesPrice ?? 0m; Base.Lines.Cache.SetValueExt<RQRequisitionLine.curyEstUnitCost>(line, lastPrice); Base.Lines.Cache.RaiseExceptionHandling<RQRequisitionLine.curyEstUnitCost>(line, null, null); } }}
Hi All, I want to add a related Item to SOLine in a sales order programmatically. I tried to find a relationship between SOLine DAC and RelatedItem DAC. But I was unable to find a clue to proceed with this requirement. Any help would be much appreciated. Thanks
Hello Acumatica Community,We have developed a customization that requires storing an API Key, but we need to ensure that generic users cannot access it. Our initial approach was to save it as a password field in the database. However, we noticed that this method still allows the key to be read as base64 from snapshot files, which can then be converted back to the actual key.Our customers are mostly using SaaS instances from Haufe, so we're unable to modify snapshot configuration files directly. Therefore, we're looking for solutions to either:Hide or secure the key in a way that prevents it from being exposed via snapshots, or Exclude the custom table that stores the key from being included in snapshots through a customization project.If these options aren't feasible, is there a way to manage the key externally or implement a similar secure solution like dynamic encription?Any suggestions or insights would be greatly appreciated. Thank you!
One of my clients recently had a very significant issue due to the way the Acumatica Customization Projects screen works when publishing customizations to the Customer Portal. Because of the behavior of the publishing screens, a mistake was made that unpublished the portal project and opened up some security issues as the customization on the portal is used to restrict user’s access to Acumatica data based on some items such as the class of the user.Here is the scenario:We have a large number of projects published in ERP. We have ONE project published in the Portal. When you open the Customization Projects screen in the Portal, it shows all projects, both ERP and Portal. The same is true in the ERP screen. It shows everything.In ERP, we have the Selected checkbox saved next to all projects EXCEPT the portal project. If you try to publish a portal project in ERP, you will get an error, which is good.If you open Customization Projects in the Portal, it shows all the projects and th
I created a sales order, and the shipment has been confirmed with an attached inventory reference. Now, I need to delete the shipment, but since the inventory reference is in a released status, I'm unable to proceed. Is there any way to resolve this?
After converting from 22R2 to 24R1, I’m now getting this error:The method or operation is not implemented. I’m not sure why since my class is deriving from the PXBqlTable class as required:https://help.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=0f93d1d7-e0e5-b731-8677-4fb4fe145e0c Am I supposed supposed to implement the GetBqlTableSystemData() method? How?Here’s my class:[Serializable] //[PXHidden] public class InventoryItemPrintSelectFilter : PXBqlTable, IBqlTable { #region Selected [PXBool] [PXUIField(DisplayName = "Selected")] public virtual bool? Selected { get; set; } public abstract class selected : PX.Data.BQL.BqlBool.Field<selected> { } #endregion #region InventoryID public abstract class inventoryID : PX.Data.BQL.BqlInt.Field<inventoryID> { } protected Int32? _InventoryID; [StockItem(Visibility = PXUIVisibility.SelectorVisible)] [PXDefault] public virtual Int32? I
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.