Intercompany out of balance report

Content

Hello Gurus

 

we looking at developing the following report

we are not using AGIS and we have one ledger only.

we would like to get the account balance twice on the same row where company A is a balancing segment value and company B is intercompany segment Value then switch it over so company A is intercompany segment value and company B is company segment value

 

have you developed something like this before , any idea how to achieve that? OTBI , FRS or smartview tool?