Debit and credit data showing negative in Management reporter Trial balance

(0) Share

Report

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

I have the same question (0)

All responses (10)

Answers (3)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
JasdeepSingh 192 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

George_D365 on at

Like (1)

Report

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)

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

Was this reply helpful? Yes No
JasdeepSingh 192 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
JasdeepSingh 192 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
JasdeepSingh 192 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

real_ashwin 1,225 on at

Like (0)

Report

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.

Was this reply helpful? Yes No