How can I set up a consolidated report to eliminate intercompany transactions between Company A (Branch AA) and Company B? I attempted to use the Consolidation in Acumatica but couldn't get it to work. Any advice on what I might be missing?
Thank you for your support!
Best answer by Laura03
Hello,
You can configure a Balance Sheet or Income Statement with Eliminations using ARM reports (In Finance - Preferences section):
ARM Report Design screens
In the Column Set, you will add at least one Eliminations Column. The Eliminations column will include all Inter-company Due To/Due From Accounts. Alternatively, you could configure one Eliminations Column for Each Company.
Start Account includes all Due To/From Accounts on BS/Intercompany Sales/Expenses on IS)
Eliminations column may print or may be hidden. Eliminations may be subtracted from the total of previous Columns, to produce a Company-wide balance sheet that does not include eliminations.
You can configure a Balance Sheet or Income Statement with Eliminations using ARM reports (In Finance - Preferences section):
ARM Report Design screens
In the Column Set, you will add at least one Eliminations Column. The Eliminations column will include all Inter-company Due To/Due From Accounts. Alternatively, you could configure one Eliminations Column for Each Company.
Start Account includes all Due To/From Accounts on BS/Intercompany Sales/Expenses on IS)
Eliminations column may print or may be hidden. Eliminations may be subtracted from the total of previous Columns, to produce a Company-wide balance sheet that does not include eliminations.