Small and medium business | Business Central, N...

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

(0) Share

Report

Posted on by BrutusG

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)

All responses (6)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

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

Hi

Please look into "Open Vendor Entries" report.

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 94,369 Super User 2025 Season 2 on at

Like (0)

Report

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

Hi, For open posted purchase invoices:

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
BrutusG 2 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
BrutusG 2 on at

Like (0)

Report

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

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?

Was this reply helpful? Yes No
Gavin 2,502 on at

Like (0)

Report

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

Hi,

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

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

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

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

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

Hi

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

Was this reply helpful? Yes No