Hi,
I am using NAV 2013. I created a Jet reports to generate Sales Amount (Invoice+Credit Memo) for August, the Sales Amount doesn't match the Aug. Sales in General Ledger. But it has little difference, around 11K.
The G/L Ledger Aug Sales is same as the Sales in Cust. Ledger.
Can someone explain it?
Thanks!
*This post is locked for comments
Transactions in General Ledger can be populated via different sources. If you post a document, such as an invoice or credit-memo, then G/L entries will have relevant document type. However sometimes users can post General journal lines without selecting the document at all or selecting a different from invoice or credit-memo.
You need to drill down to the list of G/L transactions, copy them to Excel and create a Pivot table by the document type. Most likely you will have your 11k posted with a different document type, or with a document type "blank".
Hi Allen,
If you have filtered GL for Document Type = 'Invoice' and 'Credit Memo', what if there are records with Document Type = '' (Blank)?
Kindly check whether any user passed any journal entry directly in sales account or check whether any particular transactions is not considered during reporting.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (