Discussion Forums

I’ve done many different import scenarios and regularly make mass changes to our item configurations as we’re preparing for go-live with Acumatica Manufacturing and finalizing how everything will need to be structured. However, I’ve run into this problem that I can’t resolve.We have about 600 configurable items, each with close to 200 lines of options, so making any changes manually is really not an option.Currently, all the configurations are set to revision “0” and are in the pending status, so I can make any needed updates with an import scenario. However, once we are live with this, we’ll need to increment the revision number on all the configurations whenever there is a change, which happens frequently.I’ve attached a screenshot of my update scenario mapping below. The line circled in red is the one that is causing the error. I’m simply trying to take the value from the data provider and increment it by 1. The error that it throws is

Hi everyone,I’d like to share a practical integration pattern we recently implemented using Acumatica’s native tools, without hardcoding or external middleware.Instead of building custom APIs inside Acumatica, this approach combines: Automated data preparation on the source side Import by Scenario (SM206036) File Synchronization (SM202530) Automation Schedules (SM205020) It has proven to be simple, stable, and very easy to maintain.High-level architectureThe overall flow looks like this:External System (API)→ Python script prepares and normalizes data→ Excel file is generated→ Windows Task Scheduler runs the script daily→ File is saved into a shared folder→ Acumatica File Synchronization picks it up→ Automation Schedule executes Import Scenari

Hi everyone,I’d like to share some hands-on experience configuring AI Studio in Acumatica, specifically for generating  transaction summary directly inside the ERP.Recently, we tested AI Studio in a real implementation and found that it can be very effective when set up properly – especially for reducing manual content work while keeping everything inside Acumatica.Here is the approach we followed:1. Enable AI StudioAI Studio must first be enabled in Enable/Disable Features (CS100000). Once enabled, the AI Studio screens become available.2. Create an LLM ConnectionWe configured an OpenAI connection in LLM Connections (ML201000).From a cost and performance perspective, we found gpt-4o-mini to be a good balance for ERP use cases like descriptions and summaries.3. Design LLM Prompts carefully

I know it’s early but thought I’d ask the question now… When the Acumatica AI Studio launches, will there be a new area in these forums for us to discuss and collaborate with others?

I completed

We plan to use Acumatica to track items' expiration dates. Here's our workflow:First, print a physical copy of the purchase receipt. The warehouse receiver then uses this paper to accept goods, fills in the received quantity on the receipt, and records the expiration date for items requiring expiration tracking. After receiving the completed physical receipt, the office clerk enters the details into the system.        However, we encountered an issue: once the "Track Expiration Date" feature is enabled, we can't create a purchase receipt in Acumatica unless we first enter an expiration date. But without creating the purchase receipt, we can't print the physical copy—this is a total catch-22.A paradox where one step depends on the other.Any suggestions on how to resolve thi

Is there a way in Acumatica, we are on version 2024 R2 for a few more months, to setup a discount so that it doesn’t discount a promotional sale price?We would prefer that the customer gets the better price of:Base price Customer specific price Sale Price Discounted base priceHowever, when I setup a discount that would include an item with a sale price, Acumatica discounts the sale price driving down the margin unacceptably.Thanks!

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Acumatica Community Webinar - Understanding Cost Projections and WIP in Acumatica: What Every Project Team Should Know - December 16, 2025Cost projections and WIP reporting are two of the most powerful tools in Acumatica’s project accounting. In this sess

I'm using Acumatica from my Local host for the mobile application, and I'm getting an error when I'm trying to save expense receipt and also when I'm trying to add Activity under Contacts, the error is - Server Protocol Error - ERROR 404 - requested URL or resource not found. 

     Our company plans to set some items to capture expiration dates upon receipt. However, these items are frequently used, and it’s impossible to wait until the inventory is exhausted before replenishing. In other words, there is always an on-hand quantity in stock. I noticed that when I try to modify the lot serial class, items that are in use (which should mean having an on-hand quantity) do not allow me to switch from the default class to the expiration date track class.How can this problem be solved? What is the best approach. Please advise.

Hi all - We are in the heavy civil construction industry; when paying for subcontractors, we can only pay what paid (meaning, if the open commitment quantity is for 10 units, and we are only paid 7 units from the project owner, we can only pay the subcontractor 7 units). We receive invoices from the subcontractors for work complete, but there’s no way to track that quantity in any report. We currently use Progress Worksheets in the Construction module to log the invoices, but these “completed quantities” don’t go anywhere/aren’t reportable/can’t tie to project commitments. How are others tracking the submitted/invoiced quantities for subcontracts, but not actually entering the invoices into payables?  

Hi everyone,We’re running into a strange issue and I’m hoping someone here has faced something similar.In our environment, we have a Test site and a Production site. The expectation, of course, is that publishing a customization package (CPE) to Test should not impact anything in Production. However, we are noticing situations where: A field added and published only in Test suddenly appears in Prod Customization packages in Prod seem to get unpublished and republished automatically With 3–4 developers working simultaneously on different customization projects, it’s becoming difficult to trace the root cause We are trying to understand: Is there any scenario where publishing to Test can affect Production indirectly? Has anyone experience

Hello,I noticed recently that if the inventory is negative, the connector ‘adjusted’ the inventory in Shopify to 0.   Since both systems normally handle negatives, does anyone know why this would occur?  it's 25R1

Does anyone have a solution for how to setup PTO Banks for Sick and Safe time where it is time earned per 30 hours worked?

I create a new report. And i need set visible group header by some condition When i set =$LaborReport_RowsCount>0  in visibleExpr this headers was not visible. But i have rows in Labor Report.

We understand that In Acumatica, the "estimated lead time" is typically calculated by combining the vendor lead time that is manually entered in the vendor details with any additional lead time days that are manually entered on the inventory line item itself and then displayed as the estimated lead time for that item.  Based on the information we've found so far; it seems that the manual process mentioned above is the only option. For companies with large inventories, numbering in the tens of thousands, automating this function is essential.Our questions are:Does Acumatica have logic that automatically calculates estimated lead times.  If so, how do we go about setting it up?For example, instead of manually updating the lead time on both the vendor master record and the item master under the vendor tab, is there a way for the system to automatically calculate the average lead time based on PO issue date

We recently implemented using a weight scale and connected to the device hub and we are now noticing the scale is creating 3-6X the ERP transactions in the database.  The user is simply putting box on top of scale and selecting “capture weight” then removing the box but Acumatica is seeing this as 5X the transactions instead of 1 time.  Anyone else going through this dilema?  We are seeing the SCALE try to poll every two seconds in some cases.  Thanks,Nirav S.

When add table in schema builder have this error. I reopen report designer and I have this problem again.  

Hi,When attempting to redirect to my custom screen using PXRedirectRequiredException, Acumatica throws the error ‘You have insufficient rights to access the object.’I have verified that the user has Grant All permissions on both the screen and the graph, and the user can open the screen directly in the UI without any issues. What else could cause this error during programmatic redirection?

I have field Description or other and i need wrap text with label for this field. How I can do this? For example i have this structure And in report my field description stuck other field, but label description not. 

Does anyone know what might be causing this issue? I hadn’t published this project before on this instance. I downloaded it via Git, changed the site paths, built it, created a customization project, and uploaded the data from the folder.On another PC, this project publishes without any issues.Text:[2025-12-12 08:23:41.342] Failed to load types from the PX.BarcodeProcessing assembly with the message: Method 'GetBqlTableSystemData' in type 'PX.BarcodeProcessing.ScanHeader' does not have an implementation.[2025-12-12 08:23:41.369] Failed to load types from the PX.Objects.AM assembly with the message: Method 'GetBqlTableSystemData' in type 'PX.BarcodeProcessing.ScanHeader' does not have an implementation.[2025-12-12 08:23:41.370] Failed to load types from the PX.Objects assembly with the message: Met

Hi Team,We have implemented the functionality of the Line Details button across multiple tabs and grids in Classic UI, and it is working as expected there. However, in Modern UI, the button is not functioning.Could anyone please help us resolve this issue?An early response would be greatly appreciated.Regards,Subodh 

I set vendor access by user. I want to filter the data by the vendor or employee when running the report in Report Designer. I remember that in customer access, I only needed to link another table to the Customer table, and the data was filtered automatically. But for vendor access, I don’t know how to make it work. Please guide me

Does anyone have any xml files for basic Cash Account Generic Inquiries?  I would really like to build something simple that just shows me a total for a cash account based on todays current Balance and adjust for any AR or AP that is due within the parameter date range I give it.  I want to be able to say, how much will I have on 11/20/2025 based on the balance of today, any due AR and AP, and any future AR and AP that has not been paid yet.  Almost all of the banking and finance inquiries are Customizations that do not let me pull that information in as a data source. And I am not experienced enough to mess with the customizations themselves.   Has anyone made something like this? Or does anyone know how to make one?  Needed info: Cash accountBeginning balance @TodayDate filter/parameterSum AR completed and due within Date filterSum AP completed a

I’m trying to create a attribute that records every time a specific Sales Order gets rejected. I thought to use a Field Update in the action field on a Customization project to create a running counter, however, I only get the error: “Specific Cast is not valid.” Is there a simple way to do this, or no?