Vendor Maintenance Balance not matching Aged AP balance

(0) Share

Report

Posted on by The New Recruit

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.

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

MARC_ 626 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
The New Recruit on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
The New Recruit on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
MARC_ 626 on at

Like (0)

Report
Copy link

Link copied!

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?

Marc

Was this reply helpful? Yes No
The New Recruit on at

Like (0)

Report
Copy link

Link copied!

its the same number, nothing has changed and the balances were calculated normally

Was this reply helpful? Yes No
The New Recruit on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No