News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Clean data for Excel use

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

Suggested answer

Clean data for Excel use

(1) Share

Report

Report

Posted on by NicoJ

12

Hello.

Wondering if anyone has any experience in cleaning up NAV report data for Excel use. Not sure if it's a custom report on our end, but the report is named /Sales by Customer-Item Date/. It comes out as a classic NAV report though, with weirdly formatted columns and rows. If anyone can provide some insight as to how they cleaned up the data using VBA or formulas that would be greatly appreciated.

Thank you!

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 77,981 Super User 2025 Season 1 on at

Like (0)

Report

Clean data for Excel use

Sales by Customer-Item Date looks like a custom report. You can check the Report ID to determine whether it is a standard report.

Open the About this Page/Report window (Zoom) Ctrl+Alt+F1

And, I'm sorry that I may not fully understand your question. If you want to clean up the data exported to excel, can't you export the report directly after filtering, or export an empty report?

If the layout doesn't meet your needs, you can just modify the layout in the function below.

https://learn.microsoft.com/en-us/dynamics-nav/how-to--change-which-layout-is-currently-used-on-a-report?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,399 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans