Announcements
Hi all, I'm currently working to resolve an issue where the balance shown on the vendor maintenance screen is not matching what is seen on the aged ap report. I've checked the documents tab, switched the detailed viewing option from current plus open to all documents and have discovered 6 transactions that were not showing initially and doesn't show on the aged ap report as well. However when I added up all the transactions showing in vendor maintenance, the total I got was what was showing on the aged ap. Is there any way to get the balance to show on the aged ap to show in vendor maintenance.P.S. the 6 transactions that were found does not have a status of active, is it that the vendor maintenance screen will only show active transactions as well as the aged ap report? I'm still learning the system so any advice and tips would be appreciated.
They should match - that balance is kept in AP_Balances table. You might want to reach out to your VAR and see about running AP Integrity check. This process should only be run after you have taken a backup of your data, which is why you should work with them. It sounds like you may need to rebuild your Vendor Balances, but your VAR would be the best to determine that.
Marc
Hi thanks for the reply, checked in with them and did the backup, going to try to rebuild AP vendor balance using the ap integrity check.
Update, so the integrity check is complete and this is the result.
Calcd CurrBal:-2873.77 <> AP_Balances.CurrBal:-2373.77
Calcd YtdBal: -2373.77 <> Calcd Curr Bal: -2873.77
As you can see the balances arent really matching, really out of ideas at this point, but im still searching various forums for help on this matter.
Did it change after you ran the integrity check? Or same number?
What is your current A/P for that vendor on an A/R report? For your calc'd balance, is that by hand? Or via SQL?
its the same number, nothing has changed and the balances were calculated normally
Update issue was resolved. Ran a database restore, rebuilt the vendor balances from documents, ran another integrity check to verify the document balances. Checked vendor maintenance and the balances are now matching with aged ap. Thanks so much for the advice.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 393 Super User 2026 Season 1
Subra 385
Martin Dráb 252 Most Valuable Professional
