Skip to main content

Notifications

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

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

Posted on by 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

  • 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!

  • Verified answer
    Hein Kruger Profile Picture
    Hein Kruger 501 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

  • Hein Kruger Profile Picture
    Hein Kruger 501 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)

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,651 Super User 2024 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

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans