I am in AP and have a future balance. I couldn't figure out where this future balance comes from. I tried to look at the record of every year to look for a wrong period enter but I couldn't find anything. I went to Vendor History to pull up the future balance and it said I entered in 2019; however, I couldn't find the entry in the system under this account for 2019.
How do I find the future balance under vendor maintenance?
Please help
Thanks
*This post is locked for comments
Meant to say: PerClosed **field** in the APDoc **table**
Just to piggy-back on Butch's reply, use SQL to query APDoc, specifically the PerClosed table:
Select CpnyId, PerPost, PerClosed, BatNbr, Vendid, RefNbr, OrigDocAmt, DocBal, * from APDoc where PerClosed > '201611'
(assuming your current period is 201611 in a calendar-year database. Adjust accordingly if not)
If you have access to the database, you can always look in the APDoc table and see if there is a document released into the future. Someone may have improperly deleted it without updating the corresponding ap_balances table. at any rate, there is an integrity check for Vendor Balances in the AP Integrity Check screen.
Thanks for helping. I just did that. When I went into the Vendor Inquiry screen and tried to pull up the details, it didn't give me any details or documents. It is like there is no document.
If you pull the Vendor up in the Vendor Inquiry screen, you should be able to click a viewer button beside the future balance box and get the details of the document(s) that is giving you the future balance.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
