web

You’re offline. This is a read only version of the page.

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!

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 98,122 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,033 Super User 2026 Season 1

#2

Dhiren Nagar 1,105 Super User 2026 Season 1

#3

YUN ZHU 1,035 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans