How to do intercompany eliminations on consolidated reports

My client has purchased the Connector and Report Designer modules for Sage Intelligence Reporting (SIR), plus I have installed the Report Designer Add-In.  They are on Sage 500 v. 7.4, with the SIR version for that.  They have two companies for which they need to do consolidated reporting: a manufacturing company (Co A) and a distribution company (Co B).  Co A sells more than half its manufactured goods to Co B, and those sales go through a general Sales GL Account, so are not separated out in Co A's GL.  In accordance with Canadian accounting principles, when reporting on two such closely related companies, you must eliminate intercompany amounts.  So on an income statement, you must have a column, called Eliminations, which excludes the sales of Co A to Co B.  In FRx, I used the purchases of Co B, since they would be at the same amount as the sales of Co A, and since Co B buys only from Co A.  But it is a fussy calculation:  Purchases = Ending Inventory (an Asset account) for the period you are reporting on MINUS Opening Inventory for the year you are reporting on PLUS Cost of Sales YTD.  This works in FRx, but I cannot figure out how I am going to do this using SIR.  Has anyone done this yet?  (This is for YTD totals only, not for period data.)

Also, in the canned reports, SIR is consolidating the two companies' data  into a single column, whereas my client needs to see a column per company, plus the elimination column, plus a total column  Does anyone have any suggestions on how to break that out, without starting from scratch?

Many thanks.

Parents Reply Children
No Data