since we now can support branch wild promotion,  the following is all the possible major combination of setting in proaad to set up promotions. It has two part one part explain how to set up discount and price, the other part explain how to set up coupons,

it is ok to define both in a promotion, but please be ware that the amount used to calculate coupon  is the discounted amount.

'''for discounted price related with promotion'''

if there is two promotion  both with promotion discount which effecting the promotion item/cat itself, the effect is accumulative

if there is two promotion both with promotion price effecting the promotion item/cat itself, the lowest price will be used.

the discount on benefit items are accumulative .

'''For setting discount and price'''
|| cell text || cell text spanning 2 columns ||
||location/location group ||Item/category ||Threshold qty/amount ||Benefit item/category ||Promotion discount/price ||Desctiption ||
||L ||I ||Q ||I ||D ||Buy a item for x qty get y qty of another item with a discount in one location ||
||L ||I ||Q ||I ||P ||Invalid ||
||L ||I ||Q ||I ||NA ||Invalid ||
||L ||I ||Q ||C ||D ||Buy a item for x qty get y qty of item from a category with a discount in one location ||
||L ||I ||Q ||C ||P ||Invalid ||
||L ||I ||Q ||C ||NA ||Invalid ||
||L ||I ||Q ||NA ||D ||Buy a item for x qty all this item will receive discount in one location ||
||L ||I ||Q ||NA ||P ||Buy x qty of item for an amount in a location ||
||L ||I ||Q ||NA ||NA ||Invalid ||
||L ||I ||A ||I ||D ||Buy a item for x amount get y qty of another item with a discount in one location ||
||L ||I ||A ||I ||P ||Invalid ||
||L ||I ||A ||I ||NA ||Invalid ||
||L ||I ||A ||C ||D ||Buy a item for x amount get y qty of item from a category with a discount in one location ||
||L ||I ||A ||C ||P ||Invalid ||
||L ||I ||A ||C ||NA ||Invalid ||
||L ||I ||A ||NA ||D ||Buy a item for x amount all this item will receive discount in one location ||
||L ||I ||A ||NA ||P ||Buy x amount of item for another amount in a location ||
||L ||I ||A ||NA ||NA ||Invalid ||
||L ||I ||NA ||I ||D ||Invalid ||
||L ||I ||NA ||I ||P ||Invalid ||
||L ||I ||NA ||I ||NA ||Invalid ||
||L ||I ||NA ||C ||D ||Invalid ||
||L ||I ||NA ||C ||P ||Invalid ||
||L ||I ||NA ||C ||NA ||Invalid ||
||L ||I ||NA ||NA ||D ||All item x will have discount in a location ||
||L ||I ||NA ||NA ||P ||All item x will be sold at discount price in a location it the discount price is lower then the item's original price ||
||L ||I ||NA ||NA ||NA ||Invalid ||
||L ||C ||Q ||I ||D ||Buy any item from a category for x qty get y qty of another item with a discount in one location ||
||L ||C ||Q ||I ||P ||Invalid ||
||L ||C ||Q ||I ||NA ||Invalid ||
||L ||C ||Q ||C ||D ||Buy any item from a category for x qty get y qty of item from a category with a discount in one location ||
||L ||C ||Q ||C ||P ||Invalid ||
||L ||C ||Q ||C ||NA ||Invalid ||
||L ||C ||Q ||NA ||D ||Buy any item from a category for x qty all item of this category will receive discount in one location ||
||L ||C ||Q ||NA ||P ||Buy x qty of item from a category for an amount in a location,*must set discount item code ||
||L ||C ||Q ||NA ||NA ||Invalid ||
||L ||C ||A ||I ||D ||Buy any item from a category for x amount get y qty of another item with a discount in one location ||
||L ||C ||A ||I ||P ||Invalid ||
||L ||C ||A ||I ||NA ||Invalid ||
||L ||C ||A ||C ||D ||Buy any item from a category for x amount get y qty of item from a category with a discount in one location ||
||L ||C ||A ||C ||P ||Invalid ||
||L ||C ||A ||C ||NA ||Invalid ||
||L ||C ||A ||NA ||D ||Buy any item from a category for x amount all this item will receive discount in one location ||
||L ||C ||A ||NA ||P ||Buy x amount of any item from a category for another amount in a location,*must set discount item code ||
||L ||C ||A ||NA ||NA ||Invalid ||
||L ||C ||NA ||I ||D ||Invalid ||
||L ||C ||NA ||I ||P ||Invalid ||
||L ||C ||NA ||I ||NA ||Invalid ||
||L ||C ||NA ||C ||D ||Invalid ||
||L ||C ||NA ||C ||P ||Invalid ||
||L ||C ||NA ||C ||NA ||Invalid ||
||L ||C ||NA ||NA ||D ||All item x will have discount in a location ||
||L ||C ||NA ||NA ||P ||All item from a category  x will be sold at discount price in a location if the discound price is lowered then the item's original price ||
||L ||C ||NA ||NA ||NA ||Invalid ||
||L ||NA ||Q ||I ||D ||Buy any item for x qty get y qty of another item with a discount in one location ||
||L ||NA ||Q ||I ||P ||Invalid ||
||L ||NA ||Q ||I ||NA ||Invalid ||
||L ||NA ||Q ||C ||D ||Buy any item for x qty get y qty of item from a category with a discount in one location ||
||L ||NA ||Q ||C ||P ||Invalid ||
||L ||NA ||Q ||C ||NA ||Invalid ||
||L ||NA ||Q ||NA ||D ||Buy any item for x qty all item will receive discount in one location ||
||L ||NA ||Q ||NA ||P ||Buy x qty of any item for an amount in a location,*must set discount item code ||
||L ||NA ||Q ||NA ||NA ||Invalid ||
||L ||NA ||A ||I ||D ||Buy any item for x amount get y qty of another item with a discount in one location ||
||L ||NA ||A ||I ||P ||Invalid ||
||L ||NA ||A ||I ||NA ||Invalid ||
||L ||NA ||A ||C ||D ||Buy any item for x amount get y qty of item from a category with a discount in one location ||
||L ||NA ||A ||C ||P ||Invalid ||
||L ||NA ||A ||C ||NA ||Invalid ||
||L ||NA ||A ||NA ||D ||Buy any item for x amount all items will receive discount in one location ||
||L ||NA ||A ||NA ||P ||Buy x amount of any item for another amount in a location,*must set discount item code ||
||L ||NA ||A ||NA ||NA ||Invalid ||
||L ||NA ||NA ||I ||D ||Invalid ||
||L ||NA ||NA ||I ||P ||Invalid ||
||L ||NA ||NA ||I ||NA ||Invalid ||
||L ||NA ||NA ||C ||D ||Invalid ||
||L ||NA ||NA ||C ||P ||Invalid ||
||L ||NA ||NA ||C ||NA ||Invalid ||
||L ||NA ||NA ||NA ||D ||All item x will have discount in a location ||
||L ||NA ||NA ||NA ||P ||All item x will be sold at discount price in a location if the discounted price is lower than the original price ||
||L ||NA ||NA ||NA ||NA ||Invalid ||
||G ||I ||Q ||I ||D ||Buy a item for x qty get y qty of another item with a discount in all location belong to a group ||
||G ||I ||Q ||I ||P ||Invalid ||
||G ||I ||Q ||I ||NA ||Invalid ||
||G ||I ||Q ||C ||D ||Buy a item for x qty get y qty of item from a category with a discount in all location belong to a group ||
||G ||I ||Q ||C ||P ||Invalid ||
||G ||I ||Q ||C ||NA ||Invalid ||
||G ||I ||Q ||NA ||D ||Buy a item for x qty all this item will receive discount in all location belong to a group ||
||G ||I ||Q ||NA ||P ||Buy x qty of item for an amount in all location belong to a group ||
||G ||I ||Q ||NA ||NA ||Invalid ||
||G ||I ||A ||I ||D ||Buy a item for x amount get y qty of another item with a discount in all location belong to a group ||
||G ||I ||A ||I ||P ||Invalid ||
||G ||I ||A ||I ||NA ||Invalid ||
||G ||I ||A ||C ||D ||Buy a item for x amount get y qty of item from a category with a discount in one all location belong to a group ||
||G ||I ||A ||C ||P ||Invalid ||
||G ||I ||A ||C ||NA ||Invalid ||
||G ||I ||A ||NA ||D ||Buy a item for x amount all this item will receive discount in all location belong to a group ||
||G ||I ||A ||NA ||P ||Buy x amount of item for another amount in all location belong to a group ||
||G ||I ||A ||NA ||NA ||Invalid ||
||G ||I ||NA ||I ||D ||Invalid ||
||G ||I ||NA ||I ||P ||Invalid ||
||G ||I ||NA ||I ||NA ||Invalid ||
||G ||I ||NA ||C ||D ||Invalid ||
||G ||I ||NA ||C ||P ||Invalid ||
||G ||I ||NA ||C ||NA ||Invalid ||
||G ||I ||NA ||NA ||D ||All item x will have discount in all location belong to a group ||
||G ||I ||NA ||NA ||P ||All item x will be sold at discount price in all location belong to a group it the discount price is lower then the item's original price ||
||G ||I ||NA ||NA ||NA ||Invalid ||
||G ||C ||Q ||I ||D ||Buy any item from a category for x qty get y qty of another item with a discount in all location belong to a group ||
||G ||C ||Q ||I ||P ||Invalid ||
||G ||C ||Q ||I ||NA ||Invalid ||
||G ||C ||Q ||C ||D ||Buy any item from a category for x qty get y qty of item from a category with a discount in all location belong to a group ||
||G ||C ||Q ||C ||P ||Invalid ||
||G ||C ||Q ||C ||NA ||Invalid ||
||G ||C ||Q ||NA ||D ||Buy any item from a category for x qty all item of this category will receive discount in all location belong to a group ||
||G ||C ||Q ||NA ||P ||Buy x qty of item from a category for an amount in all location belong to a group,*must set discount item code ||
||G ||C ||Q ||NA ||NA ||Invalid ||
||G ||C ||A ||I ||D ||Buy any item from a category for x amount get y qty of another item with a discount in all location belong to a group ||
||G ||C ||A ||I ||P ||Invalid ||
||G ||C ||A ||I ||NA ||Invalid ||
||G ||C ||A ||C ||D ||Buy any item from a category for x amount get y qty of item from a category with a discount in all location belong to a group ||
||G ||C ||A ||C ||P ||Invalid ||
||G ||C ||A ||C ||NA ||Invalid ||
||G ||C ||A ||NA ||D ||Buy any item from a category for x amount all this item will receive discount in all location belong to a group ||
||G ||C ||A ||NA ||P ||Buy x amount of any item from a category for another amount in all location belong to a group,*must set discount item code ||
||G ||C ||A ||NA ||NA ||Invalid ||
||G ||C ||NA ||I ||D ||Invalid ||
||G ||C ||NA ||I ||P ||Invalid ||
||G ||C ||NA ||I ||NA ||Invalid ||
||G ||C ||NA ||C ||D ||Invalid ||
||G ||C ||NA ||C ||P ||Invalid ||
||G ||C ||NA ||C ||NA ||Invalid ||
||G ||C ||NA ||NA ||D ||All item x will have discount in all location belong to a group ||
||G ||C ||NA ||NA ||P ||All item from a category  x will be sold at discount price in all location belong to a group if the discound price is lowered then the item's original price ||
||G ||C ||NA ||NA ||NA ||Invalid ||
||G ||NA ||Q ||I ||D ||Buy any item for x qty get y qty of another item with a discount in all location belong to a group ||
||G ||NA ||Q ||I ||P ||Invalid ||
||G ||NA ||Q ||I ||NA ||Invalid ||
||G ||NA ||Q ||C ||D ||Buy any item for x qty get y qty of item from a category with a discount in all location belong to a group ||
||G ||NA ||Q ||C ||P ||Invalid ||
||G ||NA ||Q ||C ||NA ||Invalid ||
||G ||NA ||Q ||NA ||D ||Buy any item for x qty all item will receive discount in all location belong to a group ||
||G ||NA ||Q ||NA ||P ||Buy x qty of any item for an amount in all location belong to a group,*must set discount item code ||
||G ||NA ||Q ||NA ||NA ||Invalid ||
||G ||NA ||A ||I ||D ||Buy any item for x amount get y qty of another item with a discount in all location belong to a group ||
||G ||NA ||A ||I ||P ||Invalid ||
||G ||NA ||A ||I ||NA ||Invalid ||
||G ||NA ||A ||C ||D ||Buy any item for x amount get y qty of item from a category with a discount in all location belong to a group ||
||G ||NA ||A ||C ||P ||Invalid ||
||G ||NA ||A ||C ||NA ||Invalid ||
||G ||NA ||A ||NA ||D ||Buy any item for x amount all items will receive discount in all location belong to a group ||
||G ||NA ||A ||NA ||P ||Buy x amount of any item for another amount in all location belong to a group,*must set discount item code ||
||G ||NA ||A ||NA ||NA ||Invalid ||
||G ||NA ||NA ||I ||D ||Invalid ||
||G ||NA ||NA ||I ||P ||Invalid ||
||G ||NA ||NA ||I ||NA ||Invalid ||
||G ||NA ||NA ||C ||D ||Invalid ||
||G ||NA ||NA ||C ||P ||Invalid ||
||G ||NA ||NA ||C ||NA ||Invalid ||
||G ||NA ||NA ||NA ||D ||All item x will have discount in all location belong to a group ||
||G ||NA ||NA ||NA ||P ||All item x will be sold at discount price in all location belong to a group if the discounted price is lower than the original price ||
||G ||NA ||NA ||NA ||NA ||Invalid ||
||NA ||I ||Q ||I ||D ||Buy a item for x qty get y qty of another item with a discount in all location ||
||NA ||I ||Q ||I ||P ||Invalid ||
||NA ||I ||Q ||I ||NA ||Invalid ||
||NA ||I ||Q ||C ||D ||Buy a item for x qty get y qty of item from a category with a discount in all location ||
||NA ||I ||Q ||C ||P ||Invalid ||
||NA ||I ||Q ||C ||NA ||Invalid ||
||NA ||I ||Q ||NA ||D ||Buy a item for x qty all this item will receive discount in all location ||
||NA ||I ||Q ||NA ||P ||Buy x qty of item for an amount in all location ||
||NA ||I ||Q ||NA ||NA ||Invalid ||
||NA ||I ||A ||I ||D ||Buy a item for x amount get y qty of another item with a discount in all location ||
||NA ||I ||A ||I ||P ||Invalid ||
||NA ||I ||A ||I ||NA ||Invalid ||
||NA ||I ||A ||C ||D ||Buy a item for x amount get y qty of item from a category with a discount in one all location ||
||NA ||I ||A ||C ||P ||Invalid ||
||NA ||I ||A ||C ||NA ||Invalid ||
||NA ||I ||A ||NA ||D ||Buy a item for x amount all this item will receive discount in all location ||
||NA ||I ||A ||NA ||P ||Buy x amount of item for another amount in all location ||
||NA ||I ||A ||NA ||NA ||Invalid ||
||NA ||I ||NA ||I ||D ||Invalid ||
||NA ||I ||NA ||I ||P ||Invalid ||
||NA ||I ||NA ||I ||NA ||Invalid ||
||NA ||I ||NA ||C ||D ||Invalid ||
||NA ||I ||NA ||C ||P ||Invalid ||
||NA ||I ||NA ||C ||NA ||Invalid ||
||NA ||I ||NA ||NA ||D ||All item x will have discount in all location ||
||NA ||I ||NA ||NA ||P ||All item x will be sold at discount price in all location  it the discount price is lower then the item's original price ||
||NA ||I ||NA ||NA ||NA ||Invalid ||
||NA ||C ||Q ||I ||D ||Buy any item from a category for x qty get y qty of another item with a discount in all location ||
||NA ||C ||Q ||I ||P ||Invalid ||
||NA ||C ||Q ||I ||NA ||Invalid ||
||NA ||C ||Q ||C ||D ||Buy any item from a category for x qty get y qty of item from a category with a discount in all location ||
||NA ||C ||Q ||C ||P ||Invalid ||
||NA ||C ||Q ||C ||NA ||Invalid ||
||NA ||C ||Q ||NA ||D ||Buy any item from a category for x qty all item of this category will receive discount in all location ||
||NA ||C ||Q ||NA ||P ||Buy x qty of item from a category for an amount in all location ,*must set discount item code ||
||NA ||C ||Q ||NA ||NA ||Invalid ||
||NA ||C ||A ||I ||D ||Buy any item from a category for x amount get y qty of another item with a discount in all location ||
||NA ||C ||A ||I ||P ||Invalid ||
||NA ||C ||A ||I ||NA ||Invalid ||
||NA ||C ||A ||C ||D ||Buy any item from a category for x amount get y qty of item from a category with a discount in all location ||
||NA ||C ||A ||C ||P ||Invalid ||
||NA ||C ||A ||C ||NA ||Invalid ||
||NA ||C ||A ||NA ||D ||Buy any item from a category for x amount all this item will receive discount in all location ||
||NA ||C ||A ||NA ||P ||Buy x amount of any item from a category for another amount in all location ,*must set discount item code ||
||NA ||C ||A ||NA ||NA ||Invalid ||
||NA ||C ||NA ||I ||D ||Invalid ||
||NA ||C ||NA ||I ||P ||Invalid ||
||NA ||C ||NA ||I ||NA ||Invalid ||
||NA ||C ||NA ||C ||D ||Invalid ||
||NA ||C ||NA ||C ||P ||Invalid ||
||NA ||C ||NA ||C ||NA ||Invalid ||
||NA ||C ||NA ||NA ||D ||All item x will have discount in all location ||
||NA ||C ||NA ||NA ||P ||All item from a category  x will be sold at discount price in all location  if the discound price is lowered then the item's original price ||
||NA ||C ||NA ||NA ||NA ||Invalid ||
||NA ||NA ||Q ||I ||D ||Buy any item for x qty get y qty of another item with a discount in all location ||
||NA ||NA ||Q ||I ||P ||Invalid ||
||NA ||NA ||Q ||I ||NA ||Invalid ||
||NA ||NA ||Q ||C ||D ||Buy any item for x qty get y qty of item from a category with a discount in all location ||
||NA ||NA ||Q ||C ||P ||Invalid ||
||NA ||NA ||Q ||C ||NA ||Invalid ||
||NA ||NA ||Q ||NA ||D ||Buy any item for x qty all item will receive discount in all location ||
||NA ||NA ||Q ||NA ||P ||Buy x qty of any item for an amount in all location ,*must set discount item code ||
||NA ||NA ||Q ||NA ||NA ||Invalid ||
||NA ||NA ||A ||I ||D ||Buy any item for x amount get y qty of another item with a discount in all location ||
||NA ||NA ||A ||I ||P ||Invalid ||
||NA ||NA ||A ||I ||NA ||Invalid ||
||NA ||NA ||A ||C ||D ||Buy any item for x amount get y qty of item from a category with a discount in all location ||
||NA ||NA ||A ||C ||P ||Invalid ||
||NA ||NA ||A ||C ||NA ||Invalid ||
||NA ||NA ||A ||NA ||D ||Buy any item for x amount all items will receive discount in all location ||
||NA ||NA ||A ||NA ||P ||Buy x amount of any item for another amount in all location ,*must set discount item code ||
||NA ||NA ||A ||NA ||NA ||Invalid ||
||NA ||NA ||NA ||I ||D ||Invalid ||
||NA ||NA ||NA ||I ||P ||Invalid ||
||NA ||NA ||NA ||I ||NA ||Invalid ||
||NA ||NA ||NA ||C ||D ||Invalid ||
||NA ||NA ||NA ||C ||P ||Invalid ||
||NA ||NA ||NA ||C ||NA ||Invalid ||
||NA ||NA ||NA ||NA ||D ||All item x will have discount in all location ||
||NA ||NA ||NA ||NA ||P ||All item x will be sold at discount price in all location  if the discounted price is lower than the original price ||
||NA ||NA ||NA ||NA ||NA ||Invalid ||


'''For coupon printing'''
||location/location group ||Item/category ||Threshold qty/amount ||Description ||
||L ||I ||Q ||A coupon for every x qty of an item in a location ||
||L ||I ||A ||A coupon for every x dollars of an item in a location ||
||L ||I ||NA ||A coupon for everyone of an item in a location ||
||L ||C ||Q ||A coupon for every x qty of any items belong to a category in a location ||
||L ||C ||A ||A coupon for every x dollars of any items belong to a category in a location ||
||L ||C ||NA ||A coupon for every unit of any items belong to a category in a location ||
||L ||NA ||Q ||A coupon for every x qty of any items in a location ||
||L ||NA ||A ||A coupon for every x dollars of any items in a location ||
||L ||NA ||NA ||A coupon for every unit of any items in a location ||
||G ||I ||Q ||A coupon for every x qty of an item in any location belong to a group ||
||G ||I ||A ||A coupon for every x dollars of an item in any location belong to a group ||
||G ||I ||NA ||A coupon for everyone of an item in any location belong to a group ||
||G ||C ||Q ||A coupon for every x qty of any items belong to a category in any location belong to a group ||
||G ||C ||A ||A coupon for every x dollars of any items belong to a category in any location belong to a group ||
||G ||C ||NA ||A coupon for every unit of any items belong to a category in any location belong to a group ||
||G ||NA ||Q ||A coupon for every x qty of any items in any location belong to a group ||
||G ||NA ||A ||A coupon for every x dollars of any items in any location belong to a group ||
||G ||NA ||NA ||A coupon for every unit of any items in any location belong to a group ||
||NA ||I ||Q ||A coupon for every x qty of an item in any location ||
||NA ||I ||A ||A coupon for every x dollars of an item in any location ||
||NA ||I ||NA ||A coupon for everyone of an item in any location ||
||NA ||C ||Q ||A coupon for every x qty of any items belong to a category in any location ||
||NA ||C ||A ||A coupon for every x dollars of any items belong to a category in any location ||
||NA ||C ||NA ||A coupon for every unit of any items belong to a category in any location ||
||NA ||NA ||Q ||A coupon for every x qty of any items in any location ||
||NA ||NA ||A ||A coupon for every x dollars of any items in any location ||
||NA ||NA ||NA ||A coupon for every unit of any items in any location ||