70
I'm having problems with having my AP aging report tie back to the AP GL account. Why would it be off? Will this have something to do with the date settings? Running the AP Aging report during the month will only show me what is aging at that time, but running the AP Sensitive report, I can set a time frame, but I don't understand why it isn't tieing back to the GL Account for AP. Does Solomon have a certain time frame things have to be posted? PLEASE HELP!!!!
*This post is locked for comments
One issue I have encountered is with Prepayments, when mulitple prepays are applied to the same document, the Period Sensitive report stills reports some of them as open, while other agings and system ledger reflect PP applications/vouchers as closed. We believe it is a flaw in the report calculation.
PS You might also find Knowledgebase article 888149 helpful. This is available on Customer Source & Partner Source
How to reconcile the balances in the Accounts Payable module with the appropriate account in the General Ledger module in Microsoft Dynamics SL
(888149 - modified: 2007-11-21)
This article describes how to reconcile the balances in the Accounts Payable module with the appropriate account in the General Ledger module on a monthly basis. This article also describes the reports that you can use during the process.
Gail J-N
This can be caused by a number of problems, including future & prior period postings, data conversion issues, data fixed "under the hood", batches incompletely released, and other data issues.
The most common cause, though, is that a journal has been posted to the AP Account directly from GL. We have a business rule in our accounting department that says the AP AR Accounts can ONLY be posted to from their respective modules - never from GL. You can check in GL transaction detail for GLTran.Account equal [your AP account] and GLTran.Module Not Equal 'AP'.
Another thing I check after that is whether the AP Aged Balance = Vendor Trial Balance (Prior Period Format) = AP Period Sensitive Trial Balance (Historical Format) when all are run currently (with nothing transacting in between). In theory, all of these reports should agree, and if they don't, you have a data integrity problem. Check out the AP Integrity Check for some potential solutions.
Hopefuly this will get you started.
Gail J-N
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
