Download To Excel from Customer Ledger Entries and Posted Sales Invoices

(5) Share

Report

Posted on by CU04020508-0

Hi,

I requested my support vendor to add two additional fields in Posted Sales Invoices Header which could be seen in Customer Ledger Entries.

This will cost me say n number of support hours, say 3 hours.

There is a download to Excel option in both the screens.

Will the download to Excel include the two additional fields automatically or does it need extra effort and extra support hours to include the two additional fields in the downloaded Excel file?

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (3)

Suggested answer

Ramesh Kumar 7,547 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

In Dynamics 365 Business Central, adding custom fields to the Posted Sales Invoice Header and making them visible in the Customer Ledger Entries page is one part — but having them included automatically in the "Open in Excel" or "Download to Excel" export depends on how the fields were added and where.

The fields are added using table and page extensions, and They're visible on the page you’re exporting from (e.g., Customer Ledger Entries), If you’re using custom APIs, custom reports, or the fields are not shown directly on the page

https://yzhums.com/39254/?

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
CU04020508-0 39 on at

Like (4)

Report
Copy link

Link copied!

Hi Ramesh Kumar,

This sentence in your reply doesn't seem complete.

..."If you’re using custom APIs, custom reports, or the fields are not shown directly on the page"...

I don't get then what? Can you explain?

The fields will be added in Posted Sales Invoices Header Portion and supposed to be visible in Customer Ledger Entries.

Was this reply helpful? Yes No
Verified answer

Sagar Dangar, MCP 799 Moderator on at

Like (4)

Report
Copy link

Link copied!

Hi,

If fields is visible on page, then it will come in excel.

If it is not visible to page, still you can export to excel by using configuration packages (Where you can select required columns only exported)

Was this reply helpful? Yes No
Verified answer

Matteo Fiocco 260 on at

Like (4)

Report
Copy link

Link copied!

Hi,

👉 If the fields are visible on the page, the Open in Excel feature will include them automatically, with no extra effort.

⚠️ If they are not visible or you need a custom Excel layout, it requires additional development.

💡 Always check with your partner if the fields are added to the UI, not just the backend!

Was this reply helpful? Yes No
Verified answer

Sohail Ahmed 11,169 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

If the fields are only added to the table and not to the page, they won’t appear in the Excel download. To include them, your vendor needs to also add those fields to the page (Page Extension). That may need a bit of extra time, but not much if they’re already adding the fields to the table.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No