Does debit and credit have difference in trail balance in standard report in ax 2009?

(0) Share

Report

Posted on by akshaykupra

516

i am generating trail balance report in Ax 2009 , in every transaction having debit and credit entry but it means when i total debit and credit it should be matched, in my report it is not correct. please help me about this trail balance report , formatte .

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (2)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi akshaykupra,

To check whether your trial balance report is correct simply add the debit and credit transactions of all the accounts that you have and built the sum of all accounts. The total result should be 0. If not, there must be something wrong.

Best regards,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 301,049 Super User 2025 Season 2 on at

Like (0)

Report

Hi akshaykupra,

What report are you referring to? Is it a customized report?

Was this reply helpful? Yes No
akshaykupra 516 on at

Like (0)

Report

André Arnaud de Calavon, no it is standard report from microsoft

trail balance report in GL

Was this reply helpful? Yes No
akshaykupra 516 on at

Like (0)

Report

hello Ludwig Reinhard, see when i am generating Trail balance from 4/1/2015 to 31/3/2016 . then report showing debit and credit total this in image when i get this report in excel and do manully adding debit side and credit side then it does not match

Was this reply helpful? Yes No
akshaykupra 516 on at

Like (0)

Report

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi akshaykupra,

We cannot see the headers of your columns.

Yet if the 2nd one says debit, the 3rd one credit and the 4th one the balance for the period, then there does not seem to be an error as debit and credit balances.

Best regards,

Ludwig

Was this reply helpful? Yes No
akshaykupra 516 on at

Like (0)

Report

hi Ludwig,

but when i export this report in excel sheet and then total debit side and credit side it come totally deference from report totaling check in excel image

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Can this issue be related to an Excel formatting error where dots and commas are probably not correctly differentiated?

Can you identify the account (line) where there is a difference to the Report data?

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 301,049 Super User 2025 Season 2 on at

Like (0)

Report

Hi akshaykupra,

Please change the tag you used when creating the question. You indicated it is related to "Development / Customization / SDK". It appears to be not related to a customization, but Financial / General ledger.

If you haven't exported all rows to Excel or didn't select all for the totaling, you can also expect a not balancing total.

Was this reply helpful? Yes No
akshaykupra 516 on at

Like (0)

Report

Hi Ludwing,

there are some account showing which conatian account type "Total"(which does not contain transaction option) in trail balance report.

is this right to see entry of account type "total" included in trail balance report?. see the example

Was this reply helpful? Yes No