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

Accounts payable all open invoices and credit memos. Help

(5) 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 (9)

Answers (0)

Abhilash Warrier 5,402 Super User 2025 Season 2 on at

Like (1)

Report

Hi Naresh,

Could you please move the query to "Business Central Forum" so it can be reviewed by the expected audience. Thank You.

Was this reply helpful? Yes No
Suggested answer

Saif Ali Sabri 2,351 Super User 2025 Season 2 on at

Like (1)

Report
Would you like a quick guide on how to automate the exclusion of vendors via Excel instead of filtering inside Business Central?

Here’s a clear, step-by-step solution to extract all open invoices and credit memos (excluding a few intercompany vendors) from Dynamics 365 Business Central into Excel, so you can generate your weekly AP cash flow report.

✅ Goal:
Export open AP invoices and credit memos with the following columns:

Payee (Vendor No.)

Vendor Name

Supplier Invoice No.

Due Date

Amount Due

Pay Type (if available)

💡 Best Solution: Use the "Vendor Ledger Entries" Page
Why?

It shows all open transactions (invoices, credit memos, and unapplied entries).

Can be filtered.

Can be exported to Excel.

No need to customize reports or use Power BI.

✅ Step-by-Step Instructions
Step 1: Open "Vendor Ledger Entries"

Go to the Search (magnifying glass in the top-right corner).

Type Vendor Ledger Entries and select it.

Step 2: Filter for Open Entries

In the Vendor Ledger Entries page, click the Filter icon.

Apply these filters:

Open = Yes

Document Type = Invoice and Credit Memo

(If "Document Type" filter doesn’t allow multiple selections, do this in Excel later.)

Vendor No. ≠ [intercompany vendor numbers]

You can exclude vendors like this:

plaintext CopyEdit
Vendor No. <> VEND1000 & Vendor No. <> VEND1001 & Vendor No. <> VEND1002
Replace with your actual intercompany vendor numbers.

Step 3: Customize Columns
Click the gear icon (⚙️) > Personalize, and make sure the following fields are visible:

Vendor No. (Payee)

Vendor Name

Document Type

External Document No. (Supplier invoice no.)

Due Date

Remaining Amount (Amount due)

Payment Method Code (Pay type, if used)

🛈 Note: “Remaining Amount” is the current open balance.

Step 4: Export to Excel

Click the Share icon (top right) > Open in Excel.

This will download the current view with applied filters.

✅ Result:
You now have an Excel file with open invoices and credit memos, excluding specific vendors, with all the key fields for your cash flow.

🛠️ Tips:

You can save this filtered view as a saved view for reuse each week.

If “Vendor Name” is not visible, you may need to use the “Vendor No.” to VLOOKUP from the Vendors table.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/payables-reports

https://learn.microsoft.com/en-us/dynamics365/business-central/reports-available-reports

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/reports-available-reports

https://learn.microsoft.com/en-us/dynamics365/business-central/payables-reports

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (3)

Report

Hi, good day
I hope this can help you, and give you some hints.

Cash Flow Forecast in Microsoft Dynamics 365 Business Central

Cash flow overview - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Vahid Ghafarpour 12,090 Super User 2025 Season 2 on at

Like (2)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

You can get all that information from the Vendor Ledger Entries page. Export the page to Excel and apply any filters you need such as document type equals invoice and credit memo.

When running the aging report, you can also choose to export it to Excel instead of PDF.

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
Suggested answer

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

Like (2)

Report

In addition to the Vendor Ledger Entries, the data you need can also be found in the Posted Purchase Invoices and Posted Purchase Credit Memo pages.
If you need a specific format, this needs to be customized.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (2)

Report

Agree with previous responses, Revolves around using the Vendor Ledger Entries as the most practical method for getting the open balances of invoices and credit memos.

Was this reply helpful? Yes No