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

[former_member1052317]

Do not put the scale on number of DAYS. Instead use the scale on these two fields in the billing data set.

"IS-M: No.of Placements Qual.for Disc.Due to Pub.in Other BUs" and "IS-M: No.of Placements Qual.For Dis.Due to Publc.On Oth.Days". They should populate your requirement correctly, even otherwise you can populate the required number using the Billing dataset user exit.

you can also use "IS-M/AM: Series Rule" which is in the Billing dataset if you are using ECC 6.0

[Former Member]

Hi,

how can I use the same 'Scale' to configure the price for selling a Format Proposal 'SMS' which has different pricing, depending on the count of database to which the SMS is sent.e.g. if SMS is sent to 100 nos. than the price will be 1 Re. each, and if SMS is sent to 200 nos. than the price will be 50 paise each.

Please let me know.

[Former Member]

Hi,

I have applied the following logic and it works. Thanks for your inputs.

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