Items Missing From GL Trial Balance Report - Searching for Root Cause

(0) Share

Report

Posted on by Community Member

We have a Document ID that should have shown on the GL Trial Balance but doesn't. We can do inquiry on the DOC and see that it was paid on 5/7. It is within the account range for which we're running the report. Any idea what prevents items that are absolutely in the data from showing on the GL Trial Balance?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

I would start by pulling up the document date and check the posting date. Is this date in the period for which you are looking? Did this document post all the way through the ledger?

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Have you checked the criteria considered when printing the GL Trial balance,

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Without revealing too much about my client, it was a "post to"/"post through" issue. "If you mark the Post Through General Ledger Files option, batches posted in other modules automatically will update the module in which the transactions originated and the appropriate posting accounts in General Ledger. Your transactions will post to General Ledger and not through General Ledger when posting transactions individually (without a batch)." Someone at the client changed options to Post Through. When this was done, they neglected to go back and POST ALL. The variance that had concerned me (between the system feeding GP and GP itself) practically vanished once all this backed-up stuff finished posting to GL - more on this topic here:

dynamicsgpblogster.blogspot.com/.../why-my-transactions-dont-post-through.html ~ as always, though, thank you for trying to help me! You folks are great!

Was this reply helpful? Yes No