Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Eliminations in Manage...

Eliminations in Management Reporter

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (1)

Answers (0)

Suggested answer

dnodo on at

Like (0)

Report

RE: Eliminations in Management Reporter

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.