UBS Inventory Software » Housekeeping

ID #1230

Set discount % formula for the 2 conditions


Set discount % formula for the  2 conditions below

a) Selling price between RM 10 & RM 19 —  5% item discount b) Selling price more  than  RM 19 —  10%  item discount



Following below steps: 

1.    Go to Housekeeping—Run Setup—General Setup—User Define Formula—type in IIF (PRICEE <= 9,O,IIF (PRICEE <= 19,5,1O)) in Disc %

2.    Go to Housekeeping—Run Setup—General Setup— Transaction: tick With per item


3.    Go to Transactions—Invoice: select any customer code and access  to body then  select any

item code with 1 quantity. If user  key in the  selling price between RM 10 “ RM 19 then  STK

will show 5% discount automatically; else if selling price is more  than  RM 19, STK will show

10%  discount


Tags: Set discount % formula for the 2 conditions

Related entries:

Last update: 2010-11-11 07:47
Author: Noor Diyana
Revision: 1.0

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this FAQ:

Average rating: 0 (0 Votes)

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry