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 / Small and medium business | Business Central, N... / Get balance and list v...
Small and medium business | Business Central, N...
Suggested Answer

Get balance and list vendor ledger entries that were open on historical date

(0) ShareShare
ReportReport
Posted on by BrutusG 2

Hello,

How do I get a list of all open posted purchase invoices on the 31st of december?

I allready made payments last days on invoices that were open on the 31 st of december, so they are not open anymore.

Is there a standard filtering/function for this?

Thank you in advance!

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,593 on at

    Hi

    Please look into "Open Vendor Entries" report.

    Also you can go to Vendor Ledger Entries and filter based on Open and Posting Date 

    pastedimage1641403998256v1.png

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,086 Super User 2026 Season 1 on at

    Hi, For open posted purchase invoices:

    pastedimage1641430892623v1.png

    Hope this will help.

    Thanks.

    ZHU

  • BrutusG Profile Picture
    BrutusG 2 on at

    Hello Mahgah,

    When I type in 'Open Vendor Entries' in the search I don't get the report..?It doesn't exists.

    When I go to Vendor Ledger Entries and use the filter you highlighted in yellow, which I allready tried myself ( that was the problem :) ), it gives the following problem:

    the payments that are posted on the Vendor Ledger Entries from the 1st tot the 6th of january have closed a number of Vendor Ledger Entries on that were posted before 1-1-21 and were still open on 31-12-21.

    So I want the list of Vendor Ledger Entries that were open on 31-12-21.

    Do you have another idea?

    Thank you in advance.

  • BrutusG Profile Picture
    BrutusG 2 on at

    Hi Zhu,

    Unfortunately this doesn't help :(.

    the payments that are posted on the Vendor Ledger Entries from the 1st tot the 6th of january have closed a number of Vendor Ledger Entries on that were posted before 1-1-21 and were still open on 31-12-21.

    So I want the list of Vendor Ledger Entries that were open on 31-12-21.

    Do you have another idea?

  • Gavin Profile Picture
    Gavin 2,510 on at

    Hi,

    For this I'd use the "Aged Accounts Payables" report.

    pastedimage1641460908861v1.png

    In the "Aged as of" enter your date. In this case 31/12/21.

    pastedimage1641460929710v2.png

    This should show everything that was outstanding "as of" this date regardless of whether its been paid after the 31/12/21.

    Hope this helps.

    Thanks

    Gavin

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,593 on at

    Hi

    it could be because of your location and version. I can see it in my environment. Try the method Gavin suggested. 

    pastedimage1641479431672v1.png

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,005 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,148 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans