Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Negative debits and Credits are not showed in Management Reporter

Posted on by 70

Hello there,

Recently I upgraded from FRx to Management Reporter.

I have marked the company option to Allow negative Credit an Debit in General Ledger.  In my Trial balance in FRx I had: Period Beginning Balance - Debit - Credit - YTD

I could see in FRx the negative amounts in the debit and credit columns. Now In MR, negative amounts are not showed in Debit or Credit Columns, although they are considered for the Beginning balance and YTD columns.

Therefore, the sum BB(+)Debit(-)Credit is not equal to YTD.

Is there a way to correct this issue? if not, Is there a script to change negative amounts into positive amounts on the other side?

Thank you!!

Regards!

*This post is locked for comments

  • Rafael Ruiz Profile Picture
    Rafael Ruiz 70 on at
    RE: Negative debits and Credits are not showed in Management Reporter

    Hello JoshP,

    You are right!!! DataMart is working fine.

    Thank you very much!

    Rafael Ruiz

  • Rafael Ruiz Profile Picture
    Rafael Ruiz 70 on at
    RE: Negative debits and Credits are not showed in Management Reporter

    Hello Josh,

    Thanks for answer.

    I installed the CU16 and I am using Legacy provider.

    I will change to Data Mart provider and I will notify you.

    Thanks!

    Rafael Ruiz

  • Verified answer
    JoshP Profile Picture
    JoshP on at
    RE: Negative debits and Credits are not showed in Management Reporter

    Hello Rafael,

    I believe that the Management Reporter 2012 data mart may handle negative debits/credits better than the Legacy provider, due to a limitation with the Legacy provider. Are you using the data mart? Also, what is the full version number of your MR 2012 installation? CU16 is the newest release.

    Thanks!

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans