SBX - Search With Button

SBX - Forum Post Title

Trial Balance Report Issue

Microsoft Dynamics NAV Forum

Danny87 asked a question on 21 May 2018 8:36 PM

Question Status

Suggested Answer

Hi there,

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?

Regards,

Danny

Reply
Nileshkumar Panchal responded on 21 May 2018 11:45 PM
My Badges

what are the filters are you applying in both report and g/l entries?

Reply
Danny87 responded on 21 May 2018 11:57 PM

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.

Reply
Nileshkumar Panchal responded on 22 May 2018 12:00 AM
My Badges
Suggested Answer

Is store code is your Dimension?

Just use the Date Filter in both report and G/L Entry.

Reply
Danny87 responded on 22 May 2018 12:09 AM

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?  

Reply
Nileshkumar Panchal responded on 22 May 2018 12:13 AM
My Badges

Does your report has any customization?

Reply
Danny87 responded on 22 May 2018 12:16 AM

No nothing

Reply
Nileshkumar Panchal responded on 22 May 2018 12:00 AM
My Badges
Suggested Answer

Is store code is your Dimension?

Just use the Date Filter in both report and G/L Entry.

Reply

SBX - Two Col Forum

SBX - Migrated JS