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

Accounts payable all open invoices and credit memos. Help

(4) Share

Report

Posted on by CU09040002-0

I have just started with business central, and am actually using two different erp products for sister companys.

I have to turn in a weekly cash flow for AP for both company's. This is for approval for payments and well cash flow planning.

I need to be able to pull an excel the has the following columns

I need all open invoices except for 5 intercompany vendors. ( i tried to filter them out and got an empty report, im sure they were not set up properly)

I can not even find a screen that lists all invoices (just invoices not payments)

the aging report i find is either giving the wrong dates, or is only pdf.

I do not have authority to write a power bi (most likely because the last person couldn't)

I do not want to reinvent the wheel and attempt to fix setup issues as this company will be standerdizing with the sister companys by October. Especially as there are bigger issues i must fix.

I just need the basic info to plug into our current mostly automated cash flow.

open invoices (with current outstanding balance)

and credit memos.

i swear i can not find this info anywhere. I have looked, and now that my access is working i have checked the program.

Please please help

(payee is vendor number)

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Valentin Castravet 31,505 Super User 2025 Season 2 on at

Like (1)

Report

There are multiple ways to get this information. One option is to go to the Vendor Ledger Entries page, apply a filter where Open = Yes, and then filter the Document Type field to show only Invoices and Credit Memos. You can also filter by Vendor No., Vendor Posting Group, or similar fields to exclude specific vendors if needed. You can then export all the data to excel.

Alternatively, when running the Aged Accounts Payable report, you can choose to export the results to Excel instead of PDF, which allows for easier filtering and analysis.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
CU09040002-0 24 on at

Like (1)

Report

@Valentin Castravet

Unfortunatly the aging report only gives me totals by company. And I need the actual invoice numbers. (also I am told that it doesn't work, and even if you select by due date it goes off of the entry date or accounting date to deside when the due date is.

Is there no way to filter out 3-5 companys when using the ledger display before generating?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (1)

Report

Are you looking in Business Central? Your Excel Header doesn't look like BC.
If so, as Valentin mentioned, all outstanding details can be found in Vendor Ledger Entries.

In addition, these details can also be found in Posted Purchase Invoices.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,588 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

Adding on to Valentin's Vendor Ledger Entries suggestion where he did mentioned that you can add in the Vendor No. filter field.

This is how you can add in the 3-5 companies by using the Vendor No. filter field.

Was this reply helpful? Yes No