web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / 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) ShareShare
ReportReport
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

salesExamplePDF.PNG

pastedimage1677854852430v1.png

I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 31,637 Super User 2025 Season 2 on at

    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

  • Hein Kruger Profile Picture
    Hein Kruger 629 on at

    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)

  • Verified answer
    Hein Kruger Profile Picture
    Hein Kruger 629 on at

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

  • fvl92 Profile Picture
    fvl92 40 on at

    What a bummer. Thank you all for your answer!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,703

#2
YUN ZHU Profile Picture

YUN ZHU 803 Super User 2025 Season 2

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 750 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans