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

Customer Price List

Sage 50 general help forum - Free help and support for all general issues
Post Reply
paulw
User
User
Posts: 1
Joined: 27 Nov 2008, 07:16

Customer Price List

Post by paulw » 27 Nov 2008, 07:22

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 28 Nov 2008, 11:18

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.
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.

Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 35 guests