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... Turn Sales Order into ...

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

Answered

Turn Sales Order into Sales Invoice: 0 Quantities are shown in sales report

(0) Share

Report

Report

Posted on by fvl92

40

Hello,

I have the following problem: I am turning a Sales Order into a Sales Invoice.

- For sales line 1 and 2 I assign a quanityt

- For sales line 3 I dont

On the pdf of the sales invoice it shows sales line 3, with a 0 quanity

-> I dont want to show lines with zero quanitites

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Suggested answer

Valentin Castravet 31,996 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Unfortunately that's how the functionality works out of the box, one option and the easiest one would be to customize your sales invoice report to not display lines with a quantity of zero

Was this reply helpful? Yes No
Hein Kruger 658 on at

Like (1)

Report
Copy link

Link copied!

I agree with Valentin ,

See link attached to add row visibility. The code will be similar to the following.

=IIF(Fields.Menge.Value=0,TRUE,FALSE)

Was this reply helpful? Yes No
Verified answer

Hein Kruger 658 on at

Like (1)

Report
Copy link

Link copied!

dba.stackexchange.com/.../how-to-hide-rows-in-ssrs-report

Was this reply helpful? Yes No
fvl92 40 on at

Like (0)

Report
Copy link

Link copied!

What a bummer. Thank you all for your answer!

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,986 Super User 2026 Season 1

#2

YUN ZHU 1,071 Super User 2026 Season 1

#3

Dhiren Nagar 975 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans