Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Debit and credit data ...
Finance | Project Operations, Human Resources, ...
Answered

Debit and credit data showing negative in Management reporter Trial balance

(0) ShareShare
ReportReport
Posted on by JasdeepSingh 192

I am getting right figures of Opening balance, Debit, Credit  in Trial balance generated through Management reporter. But some of the debit and some of the credit amounts in reports are showing in negative due to which closing balance data is coming wrong.

I checked in Ax2012 R3 trial balance for the same period and no record is having Debit or credit as negative.

Can somebody tell the issue due to which debit or credit data is showing as negative. Any help would be appreciated.

This is the column definition which I am using to generate trial balance.

4186.Capture1.PNG

  • Suggested answer
    real_ashwin Profile Picture
    real_ashwin 1,221 on at
    RE: Debit and credit data showing negative in Management reporter Trial balance

    If you use MR to generate to the rows in a row definition using "Edit>insert rows from dimension" some line will have a C mentioned in column F "Normal Balance". This happens on all Main accounts where the "main account type" is set as "Liability".

    What C does is that it reverse the sign of a row. So if you dont want it delete that C character. If you want to reverse a normal positive balance add a C instead of creating a calculation field it will be faster since you do not have to add an extra row. Also note totals and calculated rows are not  affected by a C code so they ignore the C when they do a total/calc. But you could use a C on a total/calc row to change the sign.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Debit and credit data showing negative in Management reporter Trial balance

    Hi Jasdeep,

    One possibility is to make use of a calculated column. That is, add a new column of the type Calc and multiply your existing column by *-1

    Best regards,

    Ludwig

  • JasdeepSingh Profile Picture
    JasdeepSingh 192 on at
    RE: Debit and credit data showing negative in Management reporter Trial balance

    Thanks Ludwig,

    Is there any functionality where I can reverse the sign of a particular column only?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Debit and credit data showing negative in Management reporter Trial balance

    Hi Jasdeep,

    Good to hear that you found the 'C' setup.

    About your signs:

    Standard AX uses a positive sign for debit transactions, such as expenses.

    All credit transactions, such as sales have a negative sign.

    So, the system and your report seem to be ok but probably not in the way you like it.

    You might have to do some additional setups / testing to flip the signs as you want to have it.

    Best regards,

    Ludwig

  • JasdeepSingh Profile Picture
    JasdeepSingh 192 on at
    RE: Debit and credit data showing negative in Management reporter Trial balance

    Hi George,

    Yes it was specified C automatically in some rows. Now that I have removed it, report is showing debit data as positive which is correct, but all credit data is showing negative which should be positive as per standard ax report.

    What could be the reason of credit data showing negative.

  • JasdeepSingh Profile Picture
    JasdeepSingh 192 on at
    RE: Debit and credit data showing negative in Management reporter Trial balance

    Hi Ludwig,

    I have checked for XCR function and it isn't used anywhere in my column definition. Also, XCR can be applied to calculated columns only but debit and credit columns are not calculated columns.

  • Verified answer
    George_D365 Profile Picture
    George_D365 on at
    RE: Debit and credit data showing negative in Management reporter Trial balance

    Hi Jasdeep Singh,

    There is a setting in Row Definition that I suspect might be activated in your case for some or all of the accounts:

    C   (Sign on account balance will be reversed)

    pastedimage1597235340913v1.png

    Can you, double-check, please, if this is enabled in your rows?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Debit and credit data showing negative in Management reporter Trial balance

    Hi Jasdeep,

    There is a specific function that allows you flipping the signs in your report (XCR) and I wonder if this function is used somewhere.

    Best regards,

    Ludwig

  • JasdeepSingh Profile Picture
    JasdeepSingh 192 on at
    RE: Debit and credit data showing negative in Management reporter Trial balance

    Hi Ludwig,

    I dont think row definition could be the reason because Iave created it by inserting row from dimensions and inserted all the main accounts. I have not made any changes.

    And for the example as i am not able to insert image here. let me quote it here:

    Vendor-Foreign main account is having opening balance in Ax as -101,455.78 and in report it is showing 101,455.78

    similarly, it is having debit and credit positive in ax but debit in negative and credit in positive in report, and due to which closing balance is quoted wrong in report.

    And other records are having the same issue, but i dont find any pattern here.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Debit and credit data showing negative in Management reporter Trial balance

    Hi Jasdeep,

    Can this be the result of a setting that has been made in the row definitions?

    Can you share a concrete example of the data that you see in the management reporter report and the one that has been posted in the voucher?

    Best regards,

    Ludwig

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,892 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,772 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans