Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Supressing 0.00 for special code M on invoices

Sage 50 general help forum - Free help and support for all general issues
Post Reply
mwakeham
User
User
Posts: 4
Joined: 17 Sep 2007, 13:32

Supressing 0.00 for special code M on invoices

Post by mwakeham » 17 Sep 2007, 13:37

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?
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 02 Oct 2007, 16:31

Use conditional formating.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
mwakeham
User
User
Posts: 4
Joined: 17 Sep 2007, 13:32

Post by mwakeham » 07 May 2008, 14:12

It doesnt seem to work
Top
mwakeham
User
User
Posts: 4
Joined: 17 Sep 2007, 13:32

Post by mwakeham » 07 May 2008, 14:14

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!
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 07 May 2008, 14:35

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).
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Post Reply

Return to “Sage 50 UK version General Help”

Who is online

Users browsing this forum: Amazon [Bot] and 3 guests