web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / AP - Future Balance
Microsoft Dynamics SL (Archived)

AP - Future Balance

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Butch Adams Profile Picture
    Butch Adams 4,763 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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.  

  • Verified answer
    Butch Adams Profile Picture
    Butch Adams 4,763 on at

    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.

  • Verified answer
    John_Joyce Profile Picture
    John_Joyce 1,042 on at

    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)

  • John_Joyce Profile Picture
    John_Joyce 1,042 on at

    Meant to say: PerClosed **field** in the APDoc **table**

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans