Financials

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.

i am trying to setup Total row in ARM, after set formula in column. How do I display the total that I have created in the row set? I was asked to create a Trial Balance with an ending balance of Debit and Credit, as a result the column uses a fairly long formula. My guess is that because of the formula, the total row set cannot display the sum. or maybe because I am using a subaccount Row Set the total row set cannot display the sum. Thank you,Jefri

Hello Acumatica folks,Our emailing Statements fail to send, when the print invoices is NOT selected. But when the print statement is selected to the ones that did not process, they then process.  However we don't want to print and mail and also send an email.  If we have both selected we will print / mail and email.  We only want to email.  With invoices we select one or the other, not both.  How do we set NOT to print statements when we just want to email the statement?We can do one or the other or both.  We only want to do one task, not both.  For it to work I had to select both and that is not what we want to do.   Error Message:Email cannot be created for the specified report 'AR641500' because the report has not been generated or the email settings are not specified. We reviewed one account that worked and one that didn't work, one difference we notice is  that the one that didn't work doesn't have the Print statement checked, the one that worked does have this checked,   

Hi Team,I just want to confirm if there is a way for mass deletion of Account in Chart of Account Screen?I tried to map this in Import Scenario but there is no action for delete.Please let me know if you have other recommendation.Thank you!

Does anyone know if it's possible to add the Load Documents Options feature from AR Payments to AP Checks and Payments. In AP the load documents button seems like it only pulls the ~100 oldest records. This would save our payables team a lot of time and effort Screenshot from AR Payments & Applications below 

Looking for a detailed customer report I can generate.  Wasnt sure if there is a standard template already available in Acumatica or is it more of a customization?Just looking based on a customer:Invoice, Total, Dates, Due Date, Checks Received,  etc.I currently just use Customer Details and export to Excel and adjust that way, but wouldnt mind something a little more formal.