Under Tools->Routines->Financial->Reconcile to GL and choosing Payables Management it shows about two dozen transactions as unmatched with these transactions listed on the payables side but not on the ledger side. However, when I do queries on the corresponding ledger entries I can zoom back to the payables transactions so they are not unmatched. How is this report determining what it considers as unmatched?
Hi Richard,
If there is 'nothing' on the GL side, then most likely just a timing difference, such as the GL side posted Dec 1, and the Pm side is dated Nov 30, so they show as 'unmatched' as of your date range used. Investigate the dates, or as a test, run the spreadsheet for a wider date range (only as a TEST) to see if they show as matched. All GL transactions should be listed on the GL side within your date range.
There are some reasons that some PM distributions may not show (which does not sound like your issue), but you can read these in KB 866570 in Q4.
support.microsoft.com/.../866570
Please mark as answer if this helps you.
Cheryl Waswick
Microsoft Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156