Skip to Content
0
Former Member
Jul 22, 2009 at 02:46 PM

Scales dependent Price determination for Cumulative order quantity

153 Views

Hi Guru's,

I have a scenario to determine the price based on cumulative quantity scales. The scenario is as under..

Price Agreement with Customer :

From (Pages) To (pages) Unit Price / Page

1 40000 100.00

40001 60000 75.00

60001 70000 50.00

70001 25.00

Now the sales occurs to the customer continuously, but once the cumulative order quantity crosses 40000 pages the price should be picked as 75.00 and once it crosses 60000 pages the price should be 50 and so on.....

I have tried using the condition update functionality, but the result is that i can only see the cumulative quantity in the condition type > Extras>Cumulative Values screen and has no impact on the price determination.

The prices are not getting picked..

Can anybody guide me through...

Regards

Bhushan