Page 1 of 1

Supressing 0.00 for special code M on invoices

Posted: 17 Sep 2007, 13:37
by mwakeham
How do I stop the 0.00's appearing in the Quantity and Unit Price columns when using the message line product code M and printing invoices?

Posted: 02 Oct 2007, 16:31
by brucedenney
Use conditional formating.

Posted: 07 May 2008, 14:12
by mwakeham
It doesnt seem to work

Posted: 07 May 2008, 14:14
by mwakeham
I have tried what I think should work using conditional formatting and the sage help on this but the condition that looks correct to me doesnt seem to do anything - help!

Posted: 07 May 2008, 14:35
by brucedenney
What condition are you using?

I would opt for printing in "white ink" or use the suppress print option if the product code is equal to M.

If you want to paste your code here, I will see if it looks right.

What formatting are you applying (conditionally).