Financials

Does anybody know how I can have Acumatica prevent one from Posting an AP Bill against a Purchase Order if the Amount of the AP Bill is greater than the Unbilled Amount of the PO? There is a setting in the Purchase Order Preferences screen where you can choose between No Validation or Validate with Warning but the Validate with Warning still allows you to do it. Our client wants this to be prohibited. I thought of using an Approval Flow to require approval if the AP Bill Total Amount is greater than the PO's Unbilled Amount, but I don't see how to do that. Is there another way?

I am stuck. I setup a Sales Order Invoice approval map so that Certain People can do the approval, but they cannot do their own. When I test myself it works and catches on the NOT Norman with a reject. When I test it with Lana, it catches on NOT Lana, BUT IT APPROVES! but NOT Lana is setup the exact same as mine.I am at a loss

Client has different companies in their tenant.  They would like when downloading the financial reports (balance sheet, Income Statement, etc.)  it exports the file name as Balance Sheet - <Company ID> - 01.31.2026.pdf (the financial period pulled through on the selection page.  Right now it downloads as Balance Sheet (2026-03-19).pdf which is the day the report was ran even though they only pulled as of January 31, 2026.Is there a way to change this?  I know we can change via Report Designer for non ARM reports. 

I prepared statements for the date of 10/31/2025 and successfully sent those statements, however Acumatica is still showing the “Last Statement Date” of 4/30/2025. Why is this date not showing as 10/31/2025 since that was in fact the most recent date statements were generated?

Our CFO wanted to test out some AI Capabilities and started with a question.“Can we use AI and Acumatica to establish patterns and predict when payments for invoices will be made?”I fired up codex and threw in a prompt for Plan Mode. Codex asked me 9 questionsIn total, it took roughly 10-15 minutes for the plan to generate. After user approval to implement the plan, success was almost won! (1 hour and 22 minutes) After having Codex publish and test as a user, it noticed that it forgot to add the site map and enable permissions. Once it cleaned all that up, it alerted me that it was ready for human review.There’s also a tab for each individual invoice, the justification of data, who won’t be paying inside their payment terms, and a few other bonus tabs. Values omitted. Back to the question, can it? It would appear so.

Hi! Has anyone implemented vendor consignment before? I’m trying to setup a vendor consignment warehouse at $0 because we don’t want there to be a financial impact until the inventory is used. I’ve looked at Doug’s article below but was wondering whether this can be done without having to setup a different branch/company. Any ideas?https://www.acumatica.com/blog/how-to-implement-consigned-inventory-part-2/

Publishing works correctly on the Customization Projects List page,but an error occurs on the Customization Project Detail page. 

Hello, I am required to initiate an approval process for Cash Transactions.However, I do not want the approval process to apply when the Cash Transaction originates from the Process Bank Transactions form, as those transactions are released by default without manual intervention.Is there a way to identify the origin of a Cash Transaction and bypass the approval process when it has been created through the Process Bank Transactions form?Thank YouAmanda 

How to change exported excel file name financial statement ( report generated with report definition )? i want to change excel document name to description + ( YYYY-MM-DD) thank you 

Hi all,Has anyone ever seen a situation where an Invoice is Oh Hold or in the Balanced status, yet it has a Batch Number connected to it as it has been posted to the General Ledger?-RJ

Good afternoon,Our company currently has it set up for all sales orders entered to go on an initial “On hold” status...but once thats removed, it moves over to “awaiting payment” status for payment collection.Is it necessary to have both of these set up or does it seem redundant?We have the parameters already set up for credit holds and everything as well...so orders wouldnt move past “awaiting payment” unless manually altered.

What method does everyone use for prepayments on SOs when customer requires a prepayment invoice? Sometimes we will have customers who do not accept SOs with prepayment options. They will not pay on that. Our current fix is to utilize a user-defined field that generates a document which says prepayment invoice but still has the SO number on there. When payment comes through, I apply to the SO so that it will deduct from the balance once we invoice. One issue that arises is that the SO will still show as unbilled given that no invoice is actually generated. Just curious if there is built in functionality that we are not using which handles this situation better. 

We want to recognize COGS at the same percentage that we recognize project revenue.For example, if 10% of the contract value is billed to the customer, then 10% of the total cost of the parts (stock items) should be  posted to COGS. This ensures that revenue and the associated costs are recognized in the same accounting period, rather than expensing all material costs upfront when they are issued to the project. Note: We have Field service and Project integration- The service order type was created for Project transactions.Has anyone implemented this type of workflow in Acumatica using standard functionality, without a customization? 

Hello all,I have been working on ARM reports where I have defined my start and end fin period as the param, has YTD & PTD as columns.So if I run for a periodic range of Jan-26 till May-26 both the columns show the same values. I am unable to understand if I’m missing something in here?   Any ideas?

Hello all,I want to design a P&L based on the item class as in the below screenshot. Now the only thing I am stuck is the . Is there a way we can design the same under ARM report? If not then under my report designer how can I design to include the COGS ? Because i need to calculate cogs based on COGS account class. 

Is there a way to restrict what subaccounts can be used based on the account class?  We use subaccounts for departmental classification.  Like many companies, we do not departmentalize our balance sheet and use 000-000 as our balance sheet class.  With that, we do not want any departmental subacounts used on balance sheet accounts and likewise, we do not want the Balance Sheet 000-000 designation used on any P&L accounts.  We have to clean this up every month because mistakes will be made.

When I create an invoice from multiple departments in the Receivables Module.  I want (“Prefer”) that the GL Codes assigned to my Non-Stock Inventory item to take precedents and to populate the line item detail.  Instead it takes the Customer default setting instead.    Currently I only have one customer that will recognize the GL Codes from the Inventory Line.  I have already set AR Preferences to “IIIIIIII” to update the “masking rule”.  But most of my customers accounts do not recognize this.  Is there some hidden masking rule in the Customer Profile that refuses to recognize the GL Code for the billing item?   What am I missing here? 

Hi everyone,I am currently analyzing the database schema for the Manufacturing Edition, specifically looking at the Cost Roll process (AM508000).I noticed that the core table used during this process, AMBomCost, includes a UserID field as part of its structure.Could someone please clarify the exact architectural purpose of this field? Is it used strictly for session-based data isolation to prevent conflicts during concurrent cost rolls by multiple users, or does it serve another specific tracking/auditing purpose within the Manufacturing module?Any insights into how Acumatica handles data inside AMBomCost during the processing lifecycle would be greatly appreciated.

Hi Team,I’m having a hard time with a refund to a customer.Back on Dec 29, 2025, a payment from customer XXXXX was deposited into our bank account (they’re on PAP)Payment XXX for $1594.05Part of the payment was for an item that was not yet in stock, and part was for an order that was invoiced and sent.The $1554.07 that was intended for an item that had not yet been invoiced was left as an open payment on their account.The customer later cancelled that order, and I refunded them.The initial payment (XXXX) and the refund (YYYY) both show as open in Acumatica. How do I connect these dots and close off the payment and the refund? The refund is appearing twice in the Payment Transaction section of the application history, and it is also reflected in the Refund Transaction section.Please advise connect these dots and close off the payment and the refund

Hello, Has anyone ever added a Vendor Ref # to the ACH export file? I do see this AddendaInfo.APInvoice_InvoiceNbr field but when I add this field value the export always returns a formula error (even if no formula present, tried removing formula all together).  Thanks, Eric 

I have been using the Incoming Documents feature to bring in my invoices into Acumatica with the GL, however the subaccounts never populate even though I have it set up on the non-stock sku.

Hey Community!I am looking to see if anyone has been able to use coding in the Description of a Column set that links to the Ledger ID that is chosen when running an ARM Report?  Instead of creating two sets of ARM Reports for comparing Actuals to Budget and Actuals to Reforecast, I would prefer to choose the Ledger (Budget or Reforecast) when running the ARM Report.  When the ARM Report is printed, then the column heading would reflect the Ledger ID/Description that was chosen when running the report.  The Actual column in the ARM Report would always run the Actual Ledger as that is set on the column in the Column Set.  Thank you! Ken 

Hi, My first time posing a question so please bear with me.  We are still in the process of implementing Acumatica and are at the UAT1 stage.When sending Requests for Proposal the request is only being sent to one vendor and the file attached includes all other vendor requests.  How do I set this up so the email goes to each vendor with only the corresponding document attached? Thank youJacqui

Hi Everyone,I am working on Acumatica 25R2 and have added three custom unbound DAC extension fields to the Expense Receipts (EP301020) screen. [PXDecimal][PXUIField(DisplayName = "...", Enabled = false)]public decimal? UsrReceiptLimitPerBaseUnit { get; set; }[PXDecimal][PXUIField(DisplayName = "...", Enabled = false)]public decimal? UsrMaxReceiptLimit { get; set; }[PXDecimal][PXUIField(DisplayName = "...", Enabled = false)]public decimal? UsrReceiptLimitDifference { get; set; }These fields are calculated in a graph extension and display correctly in the web UI. They are added to the ASPX page under a custom group called Receipt Limit Details.I am now trying to display the same fields in the Acumatica Mobile App.I updated the Mobile Application customization with: update screen EP301020 { update container "ClaimDetails" { add group "ReceiptLimitDetails" { displayName = "Receipt Limit Details" collapsable = True collapsed = True templ

I am creating a GI where I want to show GL account wise period wise and branch wise ending balance and turnover amount .Column A     |  Column B  | Column C |   Column D           | Column FGL Account  |  Period       | Branch      | Ending Balance    | Turnover amount   In the above GI (also attached the XML file ) , the ending balance and turnover amount for each GL account is not showing the correct data when compared with the Account Details screen.