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’m trying to generate wrapper classes using ClassGenerator.exe and running it as a CLI tool with the config file.I’m getting the following error as soon as executable starts:C:\Users\abaranov\Documents\Work\_AcumaticaSoftware\TestSDK_22_211_0034_35\ClassGenerator>ClassGenerator.exeWrapper generation has started, please wait. It may take up to 5 minutes for the first wrapper to be successfully generated.Process FAILED - so301000System.Exception: Unable to get screen so301000 with url /CstDesigner/abaranov_PCBCustomizations/so301000.aspx ---> System.Exception: Exception of type System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation.; StackTrace: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: This method cannot be called during the application's pre-start initialization phase.Configuration file ClassGenerator.exe.config:<?xml version="
Hi Acumatica People,I am working on a field updated event handler associated with the base order quantity associated with the sales orders lines.I am a newbie to Acumatica development (took the t190 course) and I want to check the value of an extension column (for specific item classes we will utilize the value in a custom column). Here is a condensed version of my problem code: ------------------------------ public class SOOrderEntryExt : PXGraphExtension<PX.Objects.SO.SOOrderEntry>{ #region Event Handlers protected void _(Events.FieldUpdated<SOLine, SOLine.baseOrderQty> e) { if (e != null) { SOLine row = (SOLine)e.Row; SOLineExt soLineExt = PXCache<SOLine>.GetExtension<SOLineExt>(row);------------------------------I want to view the value in the custom column and throw an exception on the base order quantity column under certain conditions.I am using PXTrace.WriteInformation calls to check what is going on a
Hi, I have this problem that has been driving me nuts for the last 3 hours. This is something that I have done before without issue. Here is the problem.I want to show a grid as a tab on the Customer Maintenance screen (AR303000) with the data sourced from a view.There is a view called PortfolioCustomerVW, which for an example account (717) gives the following:There are 2,318 records in the data set above and the InventoryCD column is unique. The total number of records in the views without any filters (eg on BAccountID) is in excess of 20 million and the results are sourced from multiple tables which is why I have gone for a view (for speed and performance)I have a DAC for the above which has all the fields aside from CompanyIDAnd, a graph extensionThe issue as follows:In the grid, we have multiple records for the same item. The below shows InventoryCD ZWL004-W20 replicated many times. I exported the grid out to Excel and saw 2,318 rows of the same item code (ie. the number of
Hi, I’m creating the following records via the appropriate graphs: purchase orders, sales orders, and purchase requisitions. But things are not working as I hoped/expected. I thought the idea of using graphs to create records was that you would benefit from features added to the graph, for example if you select a customer, the graph would automatically set the currency for you. This doesn’t seem to be happening consistently and I’m wondering if I’ve misunderstood something fundamental to Acumatica development. My test system has a base currency for GBP First, I created a test customer called CUST001 and a test vendor VEND001. These both use USD currency.Next, I created records in the Acumatica UI. For a sales order I enter the customer and press save. The location and currency have been defaulted. The purchase is the same, except I use VEND001. The purchase requisition follows the same idea. I enter the customer as CUST001 and the currency is automatically set to USD.Finally, I’ve used
in 2023r1 i created a customization that is supposed to print a custom report when an order’s status changes to open. I have a PXAutoAction setup in the code and it is displaying correctly. I added the action to a new workflow that extends the SO Workflow. In the open state I added the new action with the Auto run allow set to true and the auto-run condition set to True.The action does not seem to be running. I added some information trace statements to see if they would show up in the trace, they did not.Any advice or steps that you can provide will be appreciated.
I create a user defined field UsrMarkupPct in PMCostBudget. How can I user this field in the Allocation Rules formula?I tried Amount Formula = =[PMTran.Amount] * (1 +[PMBudget.UsrMarkupPct] / 100)But it doesn’t work.
I do customization on Release of Check and Payment with the goal:When the exchange of currency change, the amount of gain (or loss) will be link to an account Gain mean: the additional revenue which come from the rate of currency → link to account 635 Loss mean: the money we loss because of rate of currency → link to account 515 This amount of money will be tracked in Project informationFor example: I have a Check and Payment Record as following: The cross rate is 26.000 (which is higher than the exchange currency in Bill and Adjustment) Then release this one will generate a GL transaction as following: Note: there is a row for Account 635 which include information from APBill and APPayment → this is what I customize Post GL Transaction: As a result, there is a Project Transactions generated This cost will be tracked in Project Cost Budget However, When I turn on Auto Post on Release, There is no Project Transaction being generated. It leads to the cost isn’t statistical
Hello community,I am wondering how can I write a delegate for a method that has "params" argument considering the params argument is needed to be the last parameter in the formal parameter list? public delegate void RunLogActionBaseDelegate(string action, string logType, FSAppointmentDet apptDet, PXSelectBase<FSAppointmentLog> logSelect, params object[] logSelectArgs);[PXOverride]public virtual void RunLogActionBase(string action, string logType, FSAppointmentDet apptDet, PXSelectBase<FSAppointmentLog> logSelect, params object[] logSelectArgs, RunLogActionBaseDelegate baseMethod){ baseMethod?.Invoke(action, logType, apptDet, logSelect, logSelectArgs);}I tried to override the method Any help is appreciated.
I created a custom field to go in the grid in the Line Details dialog on the Purchase Receipts screen.I looked at the solution in the following post, but resetting the defaults on the grid did not make the field show.EDIT: I found out why this is happening. See my next comment below.
Hi,I have a request to add a Customer Status and have it act like one of the existing status. The purpose is to call out certain credit situations.I can add the new status, but how can I attach the logic form one of the other statuses to it, so when selected, it acts the same?So for instance, create a new status that mimics Credit Hold. So this would not allow new orders to be created without approvals, etc. but would be a different status to alert Customer Service to a particular situation.Thanks in advance.
Good afternoon! I wanted to share with you a snippet of code that has helped us tremendously with our credit hold process. We have times when a check is created, or a credit memo is left on the account, but not yet applied to documents. These customers would have invoices that trigger credit hold, but a negative or 0 balance, so it should not. Sometimes, there is a lag time in the processing of these credits/payments, so I had to write a modification to assist. Sometimes tracing through the Code Repository and finding the correct functions to extend or events to inject than writing the actual code! The customer credit verification is held in the CustomerCreditExtension graph extension. This extension is overridden by the SOOrderCustomerCreditExtension with custom logic overriding the base logic for the SOOrderEntry screen. The class SOOrderCustomerCredit is an extension that applies the logic to the screen through extending SOOrderEntry.This uses PXProtectedAccess to access the GetCust
We are trying to update to 23R2 and I was told that one of my customizations will need to be recompiled in order to work with 23R2. What does this entail?
Hello Community;I’m creating a form to retrieve Invoices and Memos infos and calculate some taxes,I’m doing a Left join between ARInvoice table and MasterInvoice where master invoice is a table inherting from ARInvoice, like this : public class MasterInvoice : PX.Objects.AR.ARInvoice{}SelectFrom<ARInvoice> .LeftJoin<Customer>.On<ARInvoice.customerID.IsEqual<Customer.bAccountID» .LeftJoin<MasterInvoice>.On<ARInvoice.masterRefNbr.IsEqual<MasterInvoice.refNbr»The project is published successfully and the MasterInvoice fields are there, but those fields showing no data.Any ideas?
Hi Team,I need to get the Vendor registered or configured Tax Id's (Tax class) to a foreach loop for a particular vendor record (BAccountID = X). Can someone please help me out to give me the BQL query for this?ThanksBhagya
How to create new controls on form dinamicaly? I have a custom screen in which columns are automatically generated in the grid when I select the desired GI in the "Inquiry title" selector. I take them from the GI screen and everything works fine. Now I want to take the parameters from this tab and the parameters on the GI screen and dynamically make these selectors from the code, which would be identical when you click view unquiry on the SM208000 page. How to do it from the code? Because the parameters can change depending on the selected GI. Take a look at the attached files
What are the ways to change the landingcontent when a user signs into the self-service portal?
Hi,A client is wanting to add an Operation field to the Process Shipments screen and have it change the results in the grid when the value changes, like the other fields in this screen.Below is the code I have added to the Graph Extension, but it is not working, so I guess I am going about it the wrong way.What would you suggest I do to ensure this new custom field is included in the filtering function?Let me know if you need any other information.Kind regards,Andrew Operation field highlighted above This is the graph extension for trying to include the Operation field in the filter functions.public class SOInvoiceShipment_Extension : PXGraphExtension<PX.Objects.SO.SOInvoiceShipment> { #region Event Handlers public delegate void ApplyReceiptFiltersDelegate(PXSelectBase<POReceipt> rtCmd, SOShipmentFilter filter); [PXOverride] public void ApplyReceiptFilters(PXSelectBase<POReceipt> rtCmd, SOShipmentFilter filter, ApplyReceiptFiltersDelegate baseMethod) {
Added a new column in Customer’s payment method “Is Autopay” column checkbox type. But it seems its not saving when I try to checked one the save when I reload it’s not checked.Before reloadAfter reload
I would like to set up a role that has access to be able to create workflows without having full Admin or Support permissions. I had thought the “Customizer” role would be sufficient, but when the user creates a project in Customization Projects, they are able to save it without issue. However, when they then click on the project they just created, they are unable to proceed. The following error message pops up: “acumatica-train:30003 saysYou have insufficient rights to access the object (ProjectBrowserMaint). Only by exporting the “Access Rights by Role” report am I able to find anything on Project Browser. It is the “Customization Project Browser” screen and only two Acumatica preset roles have delete status to it. They are the “Acumatica Support“ role and the “Administrator” role. I have verified this situation in the U100 SweetLife training data.I have searched using the Acumatica Navigation field for both Project Browser and Customization Project Browser and it yields zero records
My company is looking into acumatica for our new erp. What limitations do customization have vs building outside of acumatica?
Hi,I am creating a new processing screen that will be used to send invoice reminders to customers, but I am not sure how to set up the send email button to do this correctly.Below is an example of how I was trying to set it up. This code doesn’t publish because of some errors, so I know it’s completely wrong, but I am not sure how I can correct it.public PXAction<DunningLettersDAC> sendEmail; [PXUIField(DisplayName = "Send Email", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] protected IEnumerable SendEmail(PXAdapter adapter) { // Loop through all selected rows to process foreach (DunningLettersDAC currentRecord in Base.ProcessingScreen.Cache.Updated) { var emailSettings = new SendMailSettings { Subject = "Your Email Subject", Body = "Your Email Body", AppendFiles = true }; sendEmail.PressButton(adapter, emailSettings); }
here’s what i’m trying to achieve. I want, when a new record in Sales orders is created, if the SalesPersonID is not filled, if it ends up null, It should, by default, be the same as the Current user’s ID. how can I achieve this? can someone provide the code or an example? and where would I put it?
Checks and payments entry record creating Programmatically using .csv FilePayment Type Pmt Number CashAcct Pmt Date VendID ApplyToVendorRef ApplyToAmt TotalAmtCHECK 10184000001 ORE-OP 11/16/2021 PIOT INV2809 2185.02 2185.02 the above fields i have in csv file.. using Vendor reference number am fetching data from Bills Screen and then am trying to create checks and payments record against to that bill- am able to create header part when coming to insert in APAdjust table am facing an issue above error throwingError: An error occurred during processing of the field Reference Nbr. value 032616 Error: Reference Nbr. '032616' cannot be found in the system.am also sending the code which i have written for APAdjust .. Please suggest me with the Solution APPayment payment = new APPayment(); payment.DocType = APDocType.Check; payment = PXCache<APPayment>.CreateCopy(grp.Document.Insert(payment)
Dear ALL,The Event screen (CR306030) was missing an Owner, so I added it by performing Create Controls with the OwnerID field (Display name: Created By). I have also done:CommitChanges = true Enabled = true But the result of Customization is that the Owner field is still not enabled so it cannot be selected. Please guide me how to handle it ! Best Regards,NNT
Is it possible to make Acumatica load all data into a graph? In the code below I create a SOOrderEntry graph, find an existing sales order and set the current document to the sales order.This sets the current document but it doesn’t load the sales order lines - as it would if I was using the UI. The value of sOOrderEntry.Transactions.Current is null. In the final 2 lines I set the Transactions.Current value myself by selecting the first record returned from Select, but is there a way to make Acumatica load data into the SOLine view (and other views) automatically? (like the UI does)public PXAction<INKitRegister> UpdateSalesOrder;[PXUIField(DisplayName = "Update Sales Order")]protected virtual IEnumerable updateSalesOrder(PXAdapter adapter){ SOOrderEntry sOOrderEntry = PXGraph.CreateInstance<SOOrderEntry>(); SOOrder sOOrder = sOOrderEntry.Select<SOOrder>().FirstOrDefault(x => x.OrderNbr == "SO000276"); sOOrderEntry.Document.Current = sOOrder; SOLine sOLine = sOOrde
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.