Discussion Forums

How do you have a distribution addition and not include DRP in it? I find it curious that if this is such a need functionality, why is it not core to the product? Thoughts?

I have a report where I am trying to use the [PageOf] formula, but it only shows “1 of 1” on every page.From searching the forums, I’ve found the following:[PageOf] must be in the pageFooterSection Page footer ProcessOrder must be set to Always Textbox containing [PageOf] must have ProcessOrder set to WhilePrintAll of these criteria are met with my report, but I am still getting “1 of 1” for every page.

How do you set up Direct Deposit to receive payments from customers?

I am trying to create production orders from a sales order, but I keep getting this message:   Thank you

 I want to extend a new customers from business account, but while i try to extend there is error like this and also I can’t add a the new customer or account class. Can anyone help try to solve this?I really appreciate, thank you

Dear Supporters, I don't know why my set up approval have problem the user approval can't approval on the bill. Please kindly advise and Thanks in advance for support.  

Added this formula in the generic inquiry This error appears when trying to view generic inquiry. not sure what does this error means

Relatively new to Acumatica--we would like to make a change to the Profit and Loss financial statement to sort by Account Class then by Account Number.  Can this be changed and if so, what is the procedure to do so.  Thank you in advance.

Hello Community,I need advice regarding a customization we applied on the InventoryItem DAC. Initially, we had a custom field UsrUnitCost defined as [PXDBString], so in the database it was nvarchar. Later, I changed it to [PXDBDecimal] and republished. This altered the DB column to decimal. Recently, I changed it back to [PXDBString] because I wanted to show values like 20.33 BOX. Now in production, I’m seeing errors such as:The entry form (ID: IN202500, title: Stock Items) cannot be automated. An error occurred during processing of the field Unit Cost: Specified cast is not valid. How can I unpublish only one customization to check whether the error goes away or not? This works fine in sandbox but in production this issue occurs 2 days after publish. I have atttached the package. Thanks

Is there a user group conference for the Southern Region of the USA coming up in the next few months?We have a couple of users that are wanting to attend a conference.

Hello, We are running Acumatica 2025 and Shopify Advanced with the  standard Acumatica<>Shopify connector and are experiencing a lot of issues. We have two(2) retail stores, one e-commerce site and an industrial sales division. Our ERP is Acumatica and our online store and POS run on Shopify.We have been unable to get real-time sync of orders. Everything goes through a schedule - orders, item availability, payments, etc. When we do flash sales/promos, we oversell product. We have been unable to to implement BOPIS. The Shopify statuses (Ready for Pick Up and Marked as Picked Up) is not transferred to Acumatica. We have automatizations that close the orders in Shopify automatically. For POS orders, we are ONLY able to do exchanges or returns for original form of payment. Gift Cards or product exchanges are not updated because of a order does not allow modification errors. If a customer buys in store A but returns or exchanges products in Store B, this second transaction is posted t

 I have a screen in Classic UI. there is a Parameters grid in the lower. After adding data to the Parameters grid, it reflected in the Formula Editor when click on Equation field and inside the Fields node. This works correctly in Classic UI likeso, to achieve this, written code in the ASPX.CS file to retrieve parameters inside the Fields node-------------------------------aspx-----------------<pxa:PXFormulaCombo ID="edChildField" runat="server" DataField="Equation" EditButton="True"  FieldsAutoRefresh="True" FieldsRootAutoRefresh="true"   LastNodeName="Fields"   PanelAutoRefresh="True" IsInternalVisible="false"  IsExternalVisible="false"   OnRootFieldsNeeded="edOns_RootFieldsNeeded" CommitChanges="true"/>   -------------aspx.cs:- ------------------------------protected void edOns_RootFieldsNeeded(object sender, PXCallBackEventArgs e) {      EWQCVariableMaint graph = this.ds.DataGraph as EWQCVariableMaint;        if (graph != null) {          String[] parameters = graph.GetAllPar

We went from 2023R2 to 2025R1 (25.101.0153).  I had a request to check a report parameter, but I am getting ‘Authentication Failed.  The user with the given login and password was not found in the system.’ when I attempt to open Report Designer.Upgraded Report Designer with the 2025R1 Acumatica Tools. Verified my user(s) have Report Designer Role My Site URL didn’t change. The user name and password did not change and work in Acumatica. I switched my URL to my local sandbox with the same results.Any guidance?

I would like my generic inquiry to include a variance column for our labor hours. The problem I am running into is that the inquiry doesn’t return a negative number when the “To Date” amount is less than the “Est Labor Hrs”. (Ex. 673.05-1,358.00 should return -684.95 so we can see the difference)This is the current formula I am using for the +/- hours column: =IIf([PMBudget.Type]='E' AND [PMAccountGroup.GroupCD]='LABOR', [PMBudget.ActualQty]-[PMBudget.Qty], 0) I am also using these formulas to get my estimated and to date labor hours.Estimated Labor Hrs: =IIf([PMBudget.Type] = 'E' AND [PMAccountGroup.GroupCD] = 'LABOR', [PMBudget.Qty], 0)To Date Labor Hours: =IIf([PMBudget.Type] = 'E' AND [PMAccountGroup.GroupCD] = 'LABOR', [PMBudget.ActualQty], 0) I know the within the projects the balances tab shows a variance amount, has anyone figured out how to replicate this in their own generic inquiry?

For a webhook that has been registered with an endpoint in Acumatica (24R1), how does a non-developer discover the interface for documentation/testing purposes outside of requesting it from the developer or having access to the underlying class in the VS project? The customization project only has the DLL in it, and there is no option on the screen to view the interface definition or to generate a swagger file.  Thanks.Added:  Additionally, is there a way for a developer to read/consume the webhook endpoint in order to generate a stub for the interface? 

We are looking at the use of Ai to extract data from our production orders and put out in a BI tool the work that each work centre is working on, the current amount of hours done, and whether they are on target or not.Has anyone done this yet? and if so, what tools were found to be the best for doing it?

Has anyone leverage an ISV to assist with customer billbacks short payments for promotions, rebates or etc?  

On some of the service contracts the Default cost Code field was left empty.  This is preventing our Service dept from Processing the service contracts and move them to the expired status. I what I thought was a simple import scenario to update the blank ones to add the default cost code to those missing.  I keep getting the error message of “The System failed to commit the ServiceContractRecords Row when running an import scenario” I tried unchecking the commit box as another post suggested but I am still getting the same error message.  

Hi,  We need to enter additional information when entering sales order lines/Bill and adjustment form.We can use, user defined attribute in Header Level. As mentioned need some information when enter line information using predefined attribute values.  RegardsNethupul 

I am trying to add record through a webhook, it works on my local but on production it gives me 500 internal server error.

Hi everyone,We have enabled Global Languages and AI Translation on the community. For Global Languages, not everything is translated, but it may help with navigation. You can enable your language preference at the top: AI Translation helps with posts and replies: 

Whenever TaskID from PMRevenueBudget is included (either in the join to PMProformaLine or referenced in grouping), the report intermittently fails with one or both of these exceptions:If I remove TaskID from the relationship or from the grouping, the exceptions go away but then I can’t bucket by 001/002/EXTRAS (My first segment of my task 001-000-00 etc.) and lines don’t reconcile correctly. Is there any known limitation in Report Designer that prevents using PMRevenueBudget.TaskID in a dataset that also includes PMProformaLine/PMProformaProgressLine, even with explicit key joins? Is there a supported bridge I should be using instead of joining PMRevenueBudget → PMProformaLine on (ProjectID, TaskID, AccountGroupID)? (e.g., a projection or a different DAC that exposes the budget/pro forma mapping without triggering GetBudgetLineKey?) Has anyone shipped an AIA-style report that lists budget lines and pulls pro forma progress per line? If so, could you share the exact Schema Builder r

Going to lay out the scenario below. Import 1 - worked fineImport 2 - worked fineImport 3 - worked fine (or at least seems so)Import 4 - does not recognize import 3, and sees import 2 as the last import The issue we are having with this is the system is giving us an error that our Start Balance Date and Beginning Balance do not match the last import.Error: “Start date does not match the end date of the previous statement (7/24/2025).” Is it okay to bypass this warning? What could be causing this and is there a way to correct? 

Ok, I don’t know if this can be done. We need a email notification template that can display the full or partial output of the GI within the body. This can be a GI that the business event is based on or it could be a completely separate GI. The idea is not to have to run the GI, or even have a link to the GI. If the output of the GI can be embedded as a PDF or excel that could also work. The business requirement here is to deliver nicely formatted report based on the data from the GI and delivered to specific recipients on a recurring basis. An excel formatted report will also work, but how do you get the excel template into the email notification and yet have the output of the GI go into the excel via Odata?  can it be done?