You’re offline. This is a read only version of the page.
45
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.
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.
its the same number, nothing has changed and the balances were calculated normally
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.
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.
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
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (