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
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
- - - - - - - - - - - - - - - - - - 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
Customer Price List
- brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
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.
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.
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.
Who is online
Users browsing this forum: Semrush [Bot] and 35 guests