Financials

Hello,We are using Acumatica to manage VAT on payment / cash-basis VAT.Our requirement is to recognize or track VAT on payment, especially through the screen TX503500 – Recognize Input VAT, but without generating additional GL transactions.This is a one-time / temporary requirement, only until December 2025. Starting from January 2026, we would like to return to the standard Acumatica behavior, including the normal generation of GL transactions related to VAT recognition.From our understanding, the standard VAT recognition process generates GL entries to reclass VAT from suspended VAT to recognized VAT. However, during this transition period, we only want to track or report this information for tax / reporting purposes, without any additional accounting impact.Is this possible in standard Acumatica?If yes, how can we configure it or handle it correctly?Thank you in advance for your feedback and recommendations.Best regards,

Hi there! I am seeing GL batches created and I’m not sure what is causing them or why The transactions in question are the blue highlighted batches. I’m able to link all of the other GL transactions back to their source documents and they make complete sense but it seems like AFTER we release an invoice (and after the GL for that action is created) another GL is created moving funds from the HEADOFFICE unearned revenue accounts to the SEEDS unearned revenue accounts. When I click the source document for these 2 batches it brings me back to the prepayment. When I click the audit history of these batches I’m able to link the creation back to an automation that releases the invoices but to me it doesn’t make sense as to why it’s happening when it happens. 

When a customer is set to credit hold or inactive they do pop up in the search.  My concern with this is we had an employee accidently create a new customer for someone that was previously set on credit hold (also happened for one set as inactive) that we shouldn’t be selling to due to past due account.  How is this best handled in the system so employees are seeing these customers when searching.  

Hi, how do I reverse FA Reconciliation+ type? 

The International Accounting Standards Board has issues IFRS 18 - the new standard on presentation and disclosure in financial statements with a focus on Profit and Loss. One area addressed by this standard is foreign currency. “IFRS 18 requires foreign exchange differences to be classified in the same category as the income and expenses from the items that resulted in the foreign exchange differences, unless doing so would involve undue cost or effort.”In Acumatica, Revaluation Gains and Losses are set up for each currency. Since the Revaluation process Creates a CM batch in the General Ledger an accountant can manually adjust the batch to allocate foreign currency gains and losses to the related income and expense accounts.  Does anyone have suggestions for a more sophisticated approach to this?

Hi, Is there a configuration that allows revenue to be recognized as sales income at the time of shipment confirmation? Thanks,

I want to get the payments details of a specific customer reagarding the payments he did for this year from Jan 2025 to Current and the invoice details that were set off thorugh those payments.It can be a report or anything.Thank you

How can I enter a credit and a rebill when we are charged the wrong amount for materials.  It really isn’t a return and as of now, I cannot figure out how to do this.

 We need your help understanding the system's behavior regarding a negative Landed Cost.In warehouse Item A beginning quantity = 52 units, using Average Cost. We received 12 units via 2 receipts (applied initial Landed Cost) -> Did some inventory transactions -> Ending quantity = 12 unitsThe vendor gave us a credit. We created a negative Landed Cost linked to the original 2 receipts to reduce costs.When released, the system credited both the Inventory account and the COGS account.Why is the amount split between Inventory and COGS? Where is this posting behavior configured in the system? How does the system calculate the specific amount allocated to each account?Thank you!

Our customer has segmented subaccount numbers. They wish to do a search on the account details screen with a partial segment that will pull all subaccounts with that partial. Is it possible to use a lookup field for segmented numbers?  See screenshot below. 

If an item is received under the correct unit cost, specifically due to landed cost errors, would the best way to correct this is to do an adjustment referencing the receipt number, and adjusting the extended cost of the item? I thought that would be the best way to do this but when I tried in our test tenant I noticed that the cost layer for that item/receipt combination did not change. 

Hi, We are looking for Acumatica customers and partners interested in participating in the Beta program for AcuGuide.AcuGuide is an intelligent Acumatica assistant designed to help users find answers to configuration and process questions in natural language.Key capabilities include:Guided assistance for common Acumatica tasks Reduced dependency on support teams for routine questions Faster onboarding and user adoptionWe are seeking a small group of Acumatica customers and partners to provide feedback and help shape the product roadmap.If you are interested in participating in the beta program, please reply below or contact us directly.Thanks, Ashish

When calculating the amount of daily bank funds transfers, sometimes mistakes are made.  The most easy fix would be to reverse the entire entry and start over.  However, Acumatica will not allow us to reverse a funds transfer entry.  Here is the error message:In the G/L #1001 is designated as a Cash Account as we use it for cash clearing.  Appreciate any ideas about what is stopping even our Admin from reversing a funds transfer.We only have 1 branch within Acumatica.

I have a customer that is using Plaid to as their provider for bank feeds. There is a column in the file labeled check number with the check number in the field. The check number is not appearing in the when the bank feed is processed. I attempted to map that field but when I did that, the customer received the error “object reference not set to an instance of the object. 

We recently purchased a piece of equipment that came with three separate bill (for its different components). However, for accounting purposes, these need to be recorded as one asset. When we try to use Reconciliation Addition to combine the costs, the system only updates the current cost value. The Orig. Acquisition Cost remains stuck at the value of the first bill, which doesn't reflect the true total cost of the asset on our reports. We need the final Asset ID to show an Orig. Acquisition Cost that equals the sum of all three bill.How can we set up for this?  

 Error: Unhandled exception has occurred, your changes have been rolled back: Error: An error occurred during processing of the field Cash-In-Transit Subaccount: Error: An error occurred during processing of the field Subaccount: Error: Branch, Product Group of Subaccount do not exist in the system.We don’t use subaccounts so I’m a little confused.The reason I am trying to change these preferences is because none of our credit card settlement transactions are matching even though I can find them via the Processing Center ID every time so I’m wondering if the document date is holding too much weight. We are also still using Authorize which I know is no longer supported so...maybe that’s the issue?

There were few transactions from 2025 and early 2026 that are showing in the Process Bank Transactions. How to clear these ones. I’ve noticed that these transactions has been reconciled in the Reconciliation statements CA302000 and they were cleared. I can modify the match settings to hide it, but i want to completely remove them on the process bank transactions screen. 

I was doing some work in a column set and noticed validation errored when I tried to use @EndPeriod in a caption column. Running the report, it still generated correctly using @EndPeriod. I noticed on Row Sets, you can still select report parameters from the Formula window. DPL standard Column Set from Acumatica: DPL standard Row Set from Acumatica:   We just upgraded to 2026R1 but I noticed the same in a 2025R2 environment with the modern UI. Switching the column set back to Classic UI, the parameters validated correctly. 

How can I break down a budget by vendor?  You can’t use vendor as a subaccount which was what I initially thought.  Thanks in advance!

Hello - We have a Row Set that is quite large, tens of thousands of lines, and we need to copy it to make a similar report with just a few changes. When I attempt to copy it, the copy seems like it works, but when I save, I get the below error message. Is there any work around to this?Thanks!  

We use Velixo for Acumatica. I am trying to export Detail GL data from Acumatica to Excel using Velico but have not been sucessful. I can export toal debit and total credits but I need them exported with dates when the changes occurred. Can anyone point me on the right direction. In the format below. Thank you all.  

Hi, we have been using Acumatica for 2 years now. Our Receivables customers were originally setup with only an “account name” (Legal name field is not operational - refer below). Our Payables suppliers have both “trading name” and “Legal name”. Customers  SuppliersCan you please advise how we can add the “Receivables Legal Name” field into the Receivables Customer screen or if we need MYOB to make these changes. Thankyou. 

I’m looking for guidance on a scenario I’m running into with non-stock Sales Orders, and would appreciate any insights or best practice advice.We are using Sales Orders to manage non-stock items (services / consulting type work). Our requirement is fairly straightforward from a business perspective:We create a Sales Order and progressively add lines over time We generate invoices from the SO as work is billed Occasionally, after an invoice has been released, we need to: issue a partial credit, or fully credit the invoice and then re-invoice The challenge is trying to manage both invoices and credit memos against the same Sales Order, while keeping the SO open so we can continue adding lines and invoicing in the future.What I am seeing so far:Using standard SO order types, I can invoice as expected, but there doesn’t seem to be a clean way to issue credit memos from the SO Using IN or MO order types allows more flexibility around mixed transactions, however these appear to complete or

An item was received into Warehouse A with an incorrect unit cost, but it has already been transferred to Warehouse B. The stock item uses the Average Cost method. Can we create an INV Adjustment to adjust item’s cost at warehouse B or we have to transfer it back to Warehouse A to adjust it?

We created an ARM Consolidated Income Statement with the following details: Report Code: CONPL Title: Consolidated Statement with Trees Issue:All units in the Unit Set are printing, including sub-units.Desired behavior:We only want the root-level units (directly under ROOT, such as AJ, AK, AP, AQ) to print.We do not want child units under those nodes to print (for example: AJ106030, AJ206030, AJ506030).We attempted to control this using Printing Group, but it appears that Printing Group only controls row/column visibility—not whether a unit itself prints.Question:Is there a way in ARM to prevent sub-units from printing within a Unit Set (for example via Printing Group, filtering, or wildcards), or is the only supported approach to create a separate Unit Set that includes only the root-level units intended for consolidated reporting?Any confirmation or best-practice guidance would be appreciated.