web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 29,766 Super User 2025 Season 2 on at
    RE: Turn Sales Order into Sales Invoice: 0 Quantities are shown in sales report

    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
    RE: Turn Sales Order into Sales Invoice: 0 Quantities are shown in sales report

    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
    RE: Turn Sales Order into Sales Invoice: 0 Quantities are shown in sales report

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

  • fvl92 Profile Picture
    fvl92 40 on at
    RE: Turn Sales Order into Sales Invoice: 0 Quantities are shown in sales report

    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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,308

#2
Sumit Singh Profile Picture

Sumit Singh 2,798

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,793

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans