Scale Pricing

[Former Member]

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

[Shiva_Ram · Accepted solution]

This needs to be handled through development only.

Develop a routine in t.code VOFM with calculation logic (menu Formulas->scale base). Add this routine in the condition type (t.code V/06) in the scale formula field and test.

Regards,

[rasikm_waghela · Accepted solution]

Hi,

Please check the scale type for condition.

Whether you have selected Qauntity scale or time period scale.

I believe this can be standard by combination of calculation type of condition and the scale tpye for the condition.

This will be the trial and error method.

Regsrds,

Rasik

[Former Member]

Hi,

I have managed to apply the logic below and it works. Thanks for your help.

To read the dates at the item level and compute the active schedule lines. Based on this the correct scale is picked which is stored in the condition records. This price will apply to all billing data sets for the same item.

The value will be computed by multiplying qty field (which is updated as per the active schedule lines (including cancellations if any) for each monthu2019s billing data set) with the price/day.

Regards,

Ravi