Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
On the Process Order page.I have created an action “Create Blanket Lines”Here is my code using System;using System.Collections;using System.Collections.Generic;using PX.Data;using PX.Objects.CN.Subcontracts.AP.CacheExtensions;using PX.Objects.SO;using static PX.Web.Customization.RowFilesTree;public class SOCreateShipment_Extension : PXGraphExtension<PX.Objects.SO.SOCreateShipment>{ protected void ProcessCustomization() { PXTrace.WriteInformation("open 1"); SOOrderFilter filter = Base.Filter.Current as SOOrderFilter; if (filter != null && filter.Action == "SO301000$addBlanketLine") { foreach (SOOrder order in Base.Caches[typeof(SOOrder)].Updated) { if (order.Selected == true) { // My customization code } } } }}The problem I'm having is:I want when I select the action “Create Blanket Lines’ and press the Process button, it will run
Good day im having a problem my record is duplicating and i cant find the reason can anyone help me
I’ve been having trouble getting a custom event handler to fire. I’ve followed this process......as closely as I could, and while the action that fires the event runs, the transition triggered by the event does not. I feel like I’m missing something obvious, but I just can't put my finger on it. I’m working with 24R1 Build 24.101.0059.For context, this is more an exercise in personal edification than looking for a workaround. Any input would be appreciated. // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public class APInvoiceExtZ : PXCacheExtension<PX.Objects.AP.APInvoice> { public class Events : PXEntityEvent<APInvoice>.Container<Events> { public PXEntityEvent<APInvoice> DescChanged; } } // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public class APInvoiceEntry_Ext : PXGraphExtension<APInvoiceEntry> { publi
I have a table that holds a text value of the GL account code from an import. On the Grid in the form, I want to display a Account Selector on the same view that is defaulted to the GL account code from the text field.The PXSelector for AccountID is an unbound field.Here are the two fields from the DAC #region AccountID [PXInt()] [PXUnboundDefault] [PXUIField(DisplayName = "Account")] [PXSelector(typeof(Search<Account.accountID>), typeof(Account.accountID), typeof(Account.description), SubstituteKey = typeof(Account.accountCD), DescriptionField = typeof(Account.description))] public virtual Int32? AccountID { get; set; } public abstract class accountID : PX.Data.BQL.BqlInt.Field<accountID> { } #endregion #region AccountCD [PXDBString(10, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Account CD")] public virtual string AccountCD { get
Hi,I have recently added a new custom Ship Date field to the Project Quotes screen, but I am finding that this field isn’t having its value persisted after saving and refreshing the screen.Is there a property or piece of code I need to add in to ensure this new keeps its value?Below is the code I have used to create the new field, as creating it via the usual method was producing the same non-persisting result.Let me know if you need any other information.Kind regards,Andrew namespace PX.Objects.PM{ public class PMQuoteExt : PXCacheExtension<PX.Objects.PM.PMQuote> { #region UsrShippingDate [PXDBDate] [PXUIField(DisplayName="Ship Date")] public virtual DateTime? UsrShippingDate{ get; set; } public abstract class usrShippingDate: PX.Data.BQL.BqlDateTime.Field<usrShippingDate> { } #endregion }}
Hello community, I have been experiencing something with PXRedirectRequiredException and am wondering if this is intended behaviour.I have an action which creates a Non-Conformance record from a Sales Order.For the purpose of traceability, I added a custom field to display the NCR number.doc = gilMaint.ISORecords.Insert(doc);//Insert the recorddoc.SOOrderNbr = order.OrderNbr;doc.CustomerID = order.CustomerID;gilMaint.ISORecords.Update(doc);gilMaint.Actions.PressSave();//Save the new record to generate a DocNumber through autonumberingSOOrderISOExt orderExt = PXCache<SOOrder>.GetExtension<SOOrderISOExt>(order);//Find DAC extensionorderExt.UsrNCRNumber = doc.DocNumber;//Assign custom field valueorderEntry.Document.Update(order);orderEntry.Actions.PressSave();//Save the Sales Order recordPXRedirectHelper.TryRedirect(gilMaint, PXRedirectHelper.WindowMode.New);//Redirect to the freshly created record to populate it.When executing the action and the PXRedirectRequiredException be
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>>,
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.