Discussion Forums

Key Changes Acuminator Console Runner Code Map Enhancements Changes in Code Analysis New PX1099 Diagnostic For Banned API Detection New Diagnostics For DACs and DAC Extensions New Diagnostics For Graphs and Graph Extensions

Hello all,I have created 3 SOs for the same customers on different dates. I then created a single Shipment for those 3 SOs but upon creating an invoice, from the Shipments screen, it create 3 individual invoices. i did check under the order Types, Bill Separately checkbox is inactive.Not only this when the other day I created another set of SO for another customer, 3 SOs → 1 Shipment, it generate 2 invoices from the single shipment for 3 SOs. What could be the other reason for so?Any thoughts?

Hi everyone, I want to asked, if we want to import trial balance (TB) in Acumatica, specially for Account Accumulated Depreciation, shall we add sign minus (-) in the amount? or we just put positive? please help me to answer this by your experience, thank you.

Hello. I’m using the Acumatica API to update one field inside the Sales Order entity.This field is ‘Terms’, a relationship field in which users can select a Credit Terms record, to set it as parent.I was using my Default web service endpoint, version 23.200.001. I made a Query to a Sales Order to see if the ‘Terms’ field was returned, but it wasn’t returned.So, I created a new Web Service Endpoint, extending the Default one. Then I went to the Sales Order entity and added a new entry for the Terms field, like in this picture:  Currently we have these Terms records available:Now when I use my custom endpoint ‘SalesOrderTerms’, and exe

Hi, we have a sales order for a stock item that has unit cost of 0.4568 back in June 2025, but I can’t find the cost in inventory transaction history. How is this calculated and where is this inherited from? Help please..Item’s valuation method: FIFO This is the UOM of the stock item 

Hi there,I’m wanting to create journals that hit Inventory ID.For background, we only have non-stock items, and don’t have any stock items as our business doesn’t deal with inventory.However, when I click into Inventory ID to select a stock item, the pop up only shows Stock items, which of course we don’t use/don’t have any. How do I get it to show our Non Stock so I can select that?In contrast, the journals seem to be able to do this, below is a journal with a source document originating from the Receivables module, where the non stock item has been chosen on the invoice document. 

Hello! We currently have the “centralized period management” option enabled in our environment, however would prefer to have the option to close individually at different times of the month instead. Our problem with this is we have 55 Companies and it would be very time consuming, especially since they will all be closed by the same person. Is there a way to create an import scenario for this instead?

Hi everyone,Our business operates with four different branches. Our website allows single-cart checkout, meaning a customer can place an order containing items from multiple branches but only complete one payment at checkout.That payment comes through as a single prepayment, which is posted to our Unearned Revenue account.On the backend, our system then creates the appropriate sales orders for each branch (one sales order per branch). The single prepayment is applied across all of those individual sales orders.Our question is:Is there a way to associate multiple AR accounts with a single prepayment based on the branch of the sales orders tied to that prepayment?Ideally, we would like the portion of the payment applied to each sales order to post to the AR account associated with that branch, rather than every

Simple example:000-000  Default, “Balance Sheet” entries000-001  Operations      “Indirect” (“Overhead”, “G&A”)000-002  Finance000-003  Marketing/Sales000-004  Health & Safety100-000  Hospitality   “Direct” (COGS, Revenue)200-000  Retail300-000  Education400-000  Health/HospitalsWhat is the best way(s) to limit the use of the 000-000 Subaccount to only in conjunction with Balance Sheet Accounts?...the 000-00# Subaccounts on a) on non-job (e.g. “X”) transactions and b) to be paired w/only indirect, overhead Accounts? ...the #00-000 Subaccounts a) on PROJECTS only and b) to be paired w/only direct, COGS, Revenue Accounts? 

I’m trying to update the Days Sales Outstanding to accurately reflect how our accounting team calculates DSO. I’m able to get monthly sales and current AR, however, I can’t get prior AR. For example, for March, 12th of 2026, I would want to pull open AR for March 12, 2025, December 12th 2025, and September 12th, 2025. Is there a way to pull that information into this table, and if so, how? 

Hi everyone, I am trying to use a parameter in a column set to get the percent of a column but is giving me an error.    I was wondering if anyone has encountered this since we are using the parameter in another column set.  Thank you in advance for your time. 

We purchased goods, released the PO receipt, and created and paid the AP bill. Two months later, the vendor offered a discount on those items.We’d like to enter this credit in Acumatica so that it updates the inventory cost for the specific stock items that were purchased, rather than booking it to a GL expense account. Since Acumatica does not allow selecting a stock item in a debit adjustment transaction, what is the best way to enter this with the correct posting?

Hello all,Can you help me in building up the logic in coloring the rows of a GI where if the Date is due in the next 2 days it should turn the row as orange.I have applied the logic as below:Date<=Today()+2, ‘orange’ where upon running the GI it throws the error for system cannot convert +2 system.int. How to resolve this?

Hi,I’ve been using—and actively advocating for—this software for years. I’ve recommended it to numerous companies and even helped guide a sister company through implementing it.That said, I was under the impression that I had a full license for the features I needed, and that if something wasn’t included, I could simply purchase the specific module. When I originally bought the software for my company, it was with the understanding that there were no individual user licenses—it was unlimited.Now, five years later, I’m finding out that the only way to get access to AI Studio is to change my license. On top of that, I’d have to pay a premium for tenants that were already included in my original license, and my user count would now be capped at 50.To add insult to injury, the cost increase comes out to roughly 55%.Is anyone else experiencing this? Thoughts on what your doing next? 

Hello everyone, I’m trying to find a way to have the notes on a Stock or Non Stock item automatically print on a Purchase Order.  I know I can add notes on the individual line, but I don’t want to have to manually copy the notes per line item for every time I make a PO. Use Case: For our ISO 9000 certification, I need the stock item note to call out a spec reference sheet every time I make a PO for that item.

We use Converted UoMs (Sales, Purchase, and Base Units) so that each party in the transaction can work in their preferred unit of measure — which is a core ERP capability.Acumatica is configured to support this, and the conversion logic works correctly in most areas. However, we’re running into an issue during billing.After further investigation, it appears that the converted UoM must be defined as an integer value (no decimals). If that’s the case, it significantly limits the usefulness of the converted UoM functionality, especially for customers who require fractional quantities.This seems inconsistent with how UoMs are handled elsewhere in the system, and it undermines the purpose of having flexible unit conversions in the first place.Has anyone found a workaround for this? Or is there a configuration setting we may be overlooking?

Hello! Is there any way to have the Record Notes / Pop-Up Notes show up when we enter a material line directly into the Production Order Details? Currently we have a bunch of items that are Kanban and we do not want anyone to use the Mark for PO functionality to set purchase demand without checking stock first. Initially I put pop-up notes on the specific Kanban Stock Items and found that it didn’t pop-up when entered into the Prod. Ord. Details screen. Thought I’d try and see if it would copy as an internal note instead and came to the same result. Any help would be greatly appreciated! Thank you!!

Hello everyoneHow can invoices be made by joining more than one sales order but consolidating the amounts in a single line?Example:Sales order A item 001 for 4 units.Sales order B item 001 for 5 unitsAn invoice with a single item 001 for 9 units is desired.How can this operation be performed?

We have a situation where customers come into the facility multiple times/day or week to get product.  We are just using an Invoice type sales order (no shipments) to record the shipment by entering warehouse/location in the sales order.  Upon prepare Invoice it creates invoice and processes inventory issue, etc.  This works fine one by one.  However, we would like to be able to create consolidated invoices for the day/week using Process Orders screen.  I know that we can choose Prepare Invoice in that screen and it will create one invoice for all the orders for that customer that met the criteria entered on top.  We need it to apply additional grouping.  For example, in one day or week, 12 sales orders/invoices, 5 have PO/Cust Order Number 1234 and 7 PO/Cust Order Number 5678.  If I just ran wide open it would create one invoice with all 12.  I need it to create 2 invoices, one for each PO/Cust Order Number.  Actually, these are all for Projects and I'd need that to be the first gr

Advanced Kitting Boost your sales with bundles!Acumatica’s Advanced Sales Order Kitting capability is designed to streamline and optimize your sales bundles. This feature improves visibility into non-stock kit components and inventory availability, and significantly boosts profitability by enabling better control over pricing and margins. It streamlines the order entry process, allowing customer service representatives to customize sales orders and packing lists, which leads to increased operational efficiency and a superior customer experience.  Additional highlights of this solution can be found below.Be a part of our Acumatica Labs Program to implement this innovative solution and help shape the future of sales order kitting! 

Hi,I’m publishing an eSign customization package in a sandbox (version ). The process validates successfully, then gives the following error on publication. Everything publishes OK without that package selected. What does it mean?[2025-04-22 23:34:06.571] npm run build failed with output:> screen@0.1.0 build> cross-env node --max_old_space_size=6144 --optimize_for_size --stack_size=6144 --trace-warnings ./node_modules/webpack/bin/webpack -- --env production --env tenant=[REDACTED] screenIds=SM202510Publishing customization FAILED

Hello Experts, I am stuck in one of the approval process i am creating Purchase approval with two levels 1 level- No conditions, and have two user any one approves the document it will be approved.2 level- having two user and condition (If Amt. < 50,00000) any one of the user from level 2 approves the document it gets approved.having single user in which (Amt.> 50,00000) single user assigned to it will approves the document.

Hi all,I need to create an import using the Close Production Orders screen.  The file upload in the Import Scenario will contain the Order Number and other details about all the completed prod orders.  Our process on closing the production orders is if it is completed by >= 14 days.Any help appreciated.Cheers,Laura 

Can I generate bulk invoices for tenants where the standard item, such as the rental fee, is already pre-filled?