Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Format 0's to not ...
Microsoft Dynamics NAV (Archived)

Format 0's to not show(or white) on invoice etc

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

On my invoice, offers etc. I often have items, with units, price and total being 0(or 0,00)

How do I get it not to show these 0 - though I still wanna see the description on the item on that line.

(This is on custom layout - WORD)

*This post is locked for comments

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Format 0's to not show(or white) on invoice etc

    Also, kindly check this link:

    dynamicsuser.net/.../decimal-should-print-as-blank-if-it-is-zero

  • Verified answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: Format 0's to not show(or white) on invoice etc

    I agree with Archer and Ashiwini,

    1. Changing the property "blankzero" to Zero will work...

    2. If you want to do the same in Report then you can write IIF expression here...

    3678.a.png

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Format 0's to not show(or white) on invoice etc

    Hello,

    Take text type Global Variable in report and write code in OnAfterGetRecord

    IF DecimalValue > 0 THEN
    EVALUATE(TxtVariable,DecimalValue)
    ELSE
    CLEAR(TxtVariable);

    And In Report Update this TxtVariable.

    For More Info see Word Layout reports data control by C/AL

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Format 0's to not show(or white) on invoice etc

    You have to use format function for the same

    Look at this link

    msdn.microsoft.com/.../dd301367(v=nav.90).aspx

  • Suggested answer
    Ashwini Tripathi Profile Picture
    Ashwini Tripathi 4,624 on at
    RE: Format 0's to not show(or white) on invoice etc

    You can take text type field in report.  Format your variable using some code in report designer inside Navision on after get record trigger. Add this field in your word layout rather than decimal fields.  In case blank on zero doesn't work for word layouts.

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Format 0's to not show(or white) on invoice etc

    you can set field's property blankzero to yes.

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 us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans