When I run Trial Balance report it shows 15000$ debit for one on the accounts, but when I check GL entries for the same period its not showing any variance. Does anyone know how Trial Balance report calculate values for debit and credit for different accounts?
what are the filters are you applying in both report and g/l entries?
Thanks for replay Nileshkumar,
For the report I use the store code and the date range as filter, in the preview it shows 15000$ debit for account 1365.
In G/L I use the account number as filter.
1365 is the account that suppose to be balanced off.
Is store code is your Dimension?
Just use the Date Filter in both report and G/L Entry.
Yes the store code is my dimension.
Sorry maybe I haven't explain it good enough, when I run the report for the store for a specific period of time it shows 15000$ debit for account 1365. When I saw the variation I went to g/l to check where its coming from, in g/l I used the same filter for store and date range but the result is not the same. What I am wondering is how debit in Trial Balance report has been calculated? is it using anything else beside g/l table?
Does your report has any customization?
Business Applications communities