Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Removing C's in Management Reporter Creates Currency Translation Adjustment

Posted on by Microsoft Employee

Hello:

In order to balance assets with liabilities/owner's equity in Management Reporter, I have been placing C's in the "Normal Balance" column of the row definition for such items as Accumulated Depreciation and Accumulated Amortization.

Recently, I have been asked to remove these C's.  The problem is that, upon doing so, a line item for Currency Translation Adjustment (CTA) appears in the equity section.  Normally, the CTA only appears when truly necessary and specifically due to different exchange rates being used.

Is there a way to remove these C's, for proper presentation purposes, and prevent the CTA from appearing when it shouldn't?

Thanks!

John

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Removing C's in Management Reporter Creates Currency Translation Adjustment

    I updated the accounts in GP to be “Credit” instead of “Debit” and I added the Accumulated Depreciation amounts to the Property and Equipment Amounts.

    The combination of these two steps allowed for the balance sheet to balance!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Removing C's in Management Reporter Creates Currency Translation Adjustment

    Hello:

    Just now, I decided to conduct a test by removing the Adjustment and the C's and saving the resulting row definition as a "test" row definition.  Then, I ran my balance sheet with this test row definition,

    When I ran the report, my original issue where assets gets out of balance with liabilities and owner's equity occurred.

    Any thoughts on this?  :)

    Thanks!

    John

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans