I have eliminated an intercompany lease income account from our consolidation. I now need to eliminate this same amount from our facilities expense line, in the eliminations column. I have tried adding a line to not print, equal to the lease income account. However, the amount does not display on the consolidation. If I change the print control to print, the amount to eliminate shows on a separate line. Can someone provide me with a solution to have the eliminated lease income amount to deduct on the facilities expense line, but in the elimination column?
*This post is locked for comments
I have the same question (0)We use the User defined field 1 renamed to IntercoFlag in the G/L Account Card to store an elimination entry number i.e. XXX001. In our consolidation report column format we then have an elimination column and we go to the Dimension Filter line. IntercoFlag shows up as a Dimension choice and we enter operator "-" and "XXX???" in the Dimension IntercoFlag. Use the same elimination entry number on both accounts and it works great as long as the full balance of each account is to be eliminated.