Dynamics GP
Dynamics GP
Organizer:
- JOSE Organized by
-
-
AP Trial Balance – Year End Report
-
AP Trial Balance – Year End Report
At year end we run an AP Trial Balance with options. Select year end date – Enter Date 12/31/2025.
Is there a reason this report will not match the GL? All AP is posted to GL prior to running.
Any additional information steps that are needed, I appreciate this.
-
7 Replies
-
Hi @Christine –
There are several things that can cause the subledger not to match the GL. We’ll start with low hanging fruit.
1.) Are you running the Historical Aged Trial Balance report? There are others that don’t work as well for this purpose.
2.) Are you choosing to run based on document date or GL post date?
3.) Are you choosing to exclude credit balances?
If it’s easier, please add a screenshot of your report parameters before you run it, and I’ll take a look. If it ends up not being a report setting, then we can talk about other potential causes of discrepancies.
Thanks,
Samantha Walter
-
See screen shot of the report parameters before I run this.
-
@samanthastageconsulting-org
Hello @samanthastageconsulting-org – I attached two options, not sure which one is best.
-
Hi @Christine – I’m sorry for the delay. For some reason, I’m not getting notifications of the replies even though I checked the box to notify me (note to self to dig into that later!).
The historical aged trial balance is the recommended report to try to tie to your GL. I would recommend running that report over the Aged Payables with options. We can go into the details of why that report is recommended over the Aged Payables if you’d like, but for now I’ll focus on helping you get reconciled.
In addition to running the Historical Aged Trial balance instead,if you’re trying to reconcile to the GL I would recommend the following changes to your report options:
1.), Do not credit balances because those, in theory, were also posted to the AP GL account and could cause reconciliation issues.
2.) Do exclude unposted Applied credit documents. The fact that they are unposted means they will not be reflected in your GL which will automatically cause a subledger to GL recon issue.
If those changes don’t fix the problem, then we start talking about how to dig – when was the last time it reconciled properly, etc. we’ll cross that bridge when we get to it. š
Thanks,
Samantha
-
-
At end of December. the AP Trial Balance did match to the G/L balance. The balance sheet report of the A/P-Trade Account did not tie. I had voided a check. When that transaction was posted to the balance sheet, Great Plains ‘tagged’ the DEBIT part of the transaction AS VOID. Marked as VOID it was not included on the balance sheet print-out.
In looking at the General Journal Posting Report from the sub-ledger there was no indication of that line being VOID. When I viewed the journal entry in the table GL20000, I saw the VOID flag. My system can only VIEW the tables. The FIX was by our GP Admin, who changed the VOID flag to 0. I think we had 3 such occurrences for VOID CHECKS.
We are running the most recent GP2018.
Log in to reply.
