Skip to Content
0
Former Member
Jan 07, 2011 at 09:05 AM

Scale Pricing

49 Views

Hi,

I am facing an issue where i have maintained scales as shown below:

Scale Type Scale Quantity Unit Amount Unit per UOM

From 1 DAY 4200 SGD 7 DAY

28 3500

Which means scale is:

From 1 Day - Price is 4200 for 7 Days

From 28 Day - Price is 3500 for 7 Days.

That means if i book an order for 31 days my price should be 3500 / 7 days = 500 per day and hence the total order value should be 31 * 500 = 15500

This works when my order is booked in the same month. (Say from 01.01.2011 - 31.01.2011)

But if i book my orders across months then this scale does not work.

For eg: If i book an order from 15.01.2011 to 14.02.2011

The system creates two billing datasets

1) From 15.01.2011 to 31.01.2011 - This is 17 days hence the scale picked is 4200/7 days which means 600 per day and the billing dataset value is 17 * 600 = 10200

and

2) From 01.02.2011 - 14.02.2011 - This is 14 days and hence the scale picked is 4200/7 days which means 600 per day and the billing data set value is 14* 600 = 8400.

The above calculation is wrong. Instead the system should take the price of 3500/7 days and hence 500 per day and multiply it wilth the number of days for each respective billing dataset.

For Billingdata set 1 - 500 * 17 = 8500

For Billingdata set 2 - 500 * 14 = 7000

The total hence should be 15500 as per order booked in the same month.

Can this be handled through standard or is a development required.

Please suggest.

Regards,

Ravi