Page 1 of 1

Customer Price List

Posted: 27 Nov 2008, 07:22
by paulw
This is driving me mental!!! I'm sure it's easy enough to do if you can find the right button!!!
Sage Version 14 WinXP
I am trying to set up a report for a price list. I need the displayed prices
to include VAT.
I've got a report set up and works fine for prices breaks, but I cannot get the values to show up inclusive of VAT.
I can make it display the VAT code but this is not what I need.

Please help as this is about the last stumbling block before my company is ready to launch.

Thanks in advance

Posted: 28 Nov 2008, 11:18
by brucedenney
It depends a bit on which price list you want!

Is the problem simply that you need to get a VAT inclusive price?

Well first you need to remember that the inclusive price is not going to apply to exports. The price of goods is dependant on where you are.

The solution is to use an expression to calculate the VAT amount e.g. TAX_CODE.TAX_RATE * STOCK.SALES_PRICE and then you can work out the inclusive price (TAX_CODE.TAX_RATE * STOCK.SALES_PRICE) + STOCK.SALES_PRICE

The only minor hicup is that the TAX_CODE table is probably not there.

I which case go to

DATA>JOINS

Drag the TAX_CODE table to the work area.

Drag a link from the TAX_CODE field in the STOCK table to the TAX_CODE field in the TAX_CODE table
Press the ok button and now you should be able to access the TAX_RATE filed of the TAX_CODE table in your expression and so calculate the VAT inclusive price.