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

How to export a list invoices

(0) Share

Report

Posted on by Anders Mariestad

How do I export (to excel) a list of customer invoices including:
- invoice number
- invoice date
- Customer organisation number
- Total amount excl. VAT.

I assume I hav to use the Configuration packages, but which tables and fields?

All responses (3)

Answers (0)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can try this as below
Anders Mariestad 5 on at

Like (0)

Report
Copy link

Link copied!

Thank you!!!

But, I do not find the registration number of the customer and the total amount of the invoice...

More suggestions ;-)

/Anders
Suggested answer

YUN ZHU 103,085 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, VAT Registration No.:

But the Amount in Sales Invoice Header is flowfield. This cannot be exported directly.......You can export 113 Sales Invoice Line table and process totals outside the system.

If you are considering customization, I hope the information below can give you some hints.

https://yzhums.com/4180/

Thanks.

ZHU