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

hi,
wondering if someone can help cos I am just about going insane with this!
I have a label i have designed for our products and it shows various bits of information including the price. however, i want it to show the price including vat which at the moment it just shows the price excluding vat.
so i currently have "STOCK.SALES_PRICE" in there
i have tried numerous different expressions to have this figure but with 20% added on but it wont seem to let me!
would very much appreciate if someone can help by giving me at least some clue as to what im doing wrong!!
many thanks in advance

have you tried

STOCK.SALES_PRICE*1.2

thank you thank you thank you! it worked!!!

I'm having this same issue, I need a product price including VAT. Our Sage V22 does not give me the option of variable that has been suggested in this post All I can find is SALES_PRICE. Would be very appreciative if someone could suggest a solution for me. Thanks!

SALES_PRICE exists in several tables.

So on the invoice items, on the sales order item and in the stock table the same field exists.

The way we express which one we are talking about is done by prefixing it with the name of the table.

In the above example we were using the price from the STOCK table. so we call it STOCK.SALES_PRICE

OK, I've got you! I have just edited the code to the before mentioned suggestion and it works!
Thank you so much for this post. It has saved my life!

Just working with this now and it adds VAT onto products that are zero rated. Is there another way to do this? I am making price labels, some items we sell include VAT and others do not include VAT.

You could make it conditional on the default Tax Code of the product being T1