Microsoft Dynamics NAV (Archived)

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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

keoma 32,729 on at

Like (1)

Report

you can set field's property blankzero to yes.

Was this reply helpful? Yes No
Suggested answer

Ashwini Tripathi 4,624 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

You have to use format function for the same

Look at this link

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Rabin 2,976 on at

Like (0)

Report

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...

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

Also, kindly check this link:

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

Was this reply helpful? Yes No