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

I dont know if anyone can help, but we have just started using sales order processing for the first time instead of service invoices. Having set up a product and giving it a discount on quantity purchased ie 11 5% then 26 10% etc when we first set this up and added the discount band to a customer in their record, in the new sales order the price shown on reflected the discounted price ie it dropped from 4.96 to 4.72 which is what we wanted. For some reason, now it keeps the origional price showing no matter what quantity you enter but puts the discount on the total amout. Have we ticked a box or something in settings which has caused this? I have searched through all the settings and cannot find the answer. Does anyone have any idea?

There are several fields in the table that reflect the different prices.

You need to be using the right ones!

There is no field to show the discounts item price, but you can easily enter an expression to show this.

FULL_NET_AMOUNT shows the full undiscounted total for the line
UNIT_PRICE shows the undiscounted item price
NETVALUE_DISCOUNT is the amount of discount for the line
NET_AMOUNT is the discounted value of the line

These are all BASe currency figures but there are a bunch of FOREIGN versions of these which are the currency values

So to show the discounted unit price i would divide the FOREIGN_NET_AMOUNT by the quantity

in the report designer the expression would be SOP_ITEM.FOREIGN_NET_AMOUNT/SOP_ITEM.QTY_ORDER

Thanks for all your help, will give your suggestion a go! Thx Stuart