Configuring Report Definitions

Hi ​@nomii as per my opinion use the below formula for Row set and Column set

Use Intercompany Accounts + Report Formula:

1. GL Accounts Setup:

   • B→C Sales → Intercompany Revenue (6000-InterCo)

   • C→B Purchases → Intercompany Expense (5000-InterCo)

2. Row set definition: 
   Revenue:
   =IIf(BranchID.In("B","C"), 0, Sum(GLTran.DebitAmt))
   WHERE AccountID NOT LIKE '6%InterCo%'
    
3. Column set:
   Organization = "=CurrentUnit()"
   Branch Filter = "=ParentUnit()"  // Excludes sub-unit internal txns

Hello ​@nomii ,

You can configure a Balance Sheet or Income Statement with Eliminations using ARM reports (In Finance - Preferences section).  Columns that contain original amounts and elimination columns may be hidden, reporting only the ‘cleaned’ columns with eliminations subtracted out.

 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.

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.

I hope this helps you. 

Laura

Thank you, Laura. But in our case, inter-company transactions between B and C should only be eliminated once the goods are sold to a third party and leave the warehouse. I’m a bit stuck on how to set this up—checking every single transaction to see if the items are sold sounds like it would be incredibly time-consuming. Could you give me some advice on this case?

Hello,

I recommend that you speak to your Acumatica Partner or your CPA about your workflow & procedures for recording your goods.  Are the goods on consignment? Inter-company sales?

In general, it seems like the goods will at first be accounted for by sitting in a different warehouse and/or in a different company/branch asset until they are sold. It’s unclear to me (as an outsider) to which company, in what GL Accounts the revenue, expenses, the inventory asset, the COGS, etc. belong and whether there is any inter-company due to/from.

Your partner will be familiar with your implementation, will be familiar with your work-flows, and will have provided written instructions (SOP) to your company, and will be able to advise you.

Laura

Thanks for your help, Laura. I’ll discuss with our partner.