SageForum for UK versions of Sage 50- Help and support.

Hi,

New to sage. I am trying to create an invoice layout in report designer which will show only message lines BUT i have to add stock into to accurately reflect our stock. However i don't want to show the stock items on the invoice. I.e i need to have a service style invoice with stock but the stock is hidden on the invoice.

i've managed to do this so far by conditional formatting which works but when there are many stock items the invoice still see's the suppressed lines and if there are too many puts all the totals on a different sheet.

Is there a way to not only suppress printing of a line but get the report to ignore it all together, apart from the calculations, so that it all fits on one page?

or is there a much simpler way of achieving what i'm trying to do?

What you want to do is not difficult.

Make sure that you can view properties
Open the layout in the report designer, click on the header of each section on some in the properties you will see conditional printing

There are 2 sections in the middle, one that prints product items and one that prints service items One has a fields called "description" and the other a field called "text"

You can make the conditions a lot tighter, normally, they hide the service item if it is a product and vice verser.

You could just suppress the whole section if you never want to print the product descriptions or you could suppress them only if the product code it supplied by supplier xxx or some other such rule if some products do want to be printed.