Change in price- proration problem

[former_member199650]

Hi,

Please guide me about the following query:

Prices are being changes from the mid of a billing period:

Billing Period: 01.01.10 to 31.01.10

Price Change Date : 15.01.10

If a consumer is disconnected through a disconnection doc. then the whole consumption for the biling period is getting billing based on old prices and the consumption is not getting prorated.

Whereas consumption should be prorated and should be devided into two parts based on the per day consumption * no.of days.

Please guide.

Thanks and Regards

[Former Member]

Hi,

Please check the Time category (try to change it to day & specify days in time basis) & in case it is block price ,also check price block adjustment (try to change it to by time slice ) in Price hdr date tab in EA90.

Hope it helps.

[former_member199650]

Hi,

Thanks for your reply please.

The price is a standard price.

And in the Period Control- it is selected for To the Day ('00' option).

Please guide.

Thanks.and Regards

[Former Member]

Goto EA90 and in Price hdr tab :Time category choose Days and enter time basis as 30 (in caseyou have monthly billing).

Hope it helps.

[former_member199650]

Hi,

Thanks for your reply please.

But the problem is with the quantity based price.

As the no.of days in a billing period will lie between 15 to 45 days. Please guide.

Thanks and Regards

[Former Member]

Hi,

If i understand your scenario you are using quantity base block price,the problem you are facing during disconnection is because billing period is less than 30 days.

I suggest you to put time basis as 30 days and do price block adjustment with

lnterval lower limit as 15 days

Interval upper limit as 45 days.

In case it does not solve problem,do mention price type,price historical data, and billing period for customer.

[former_member199650]

Hi,

The price is Quantity based standard price.

Properties:

1 .No Average Price.

2. Do not Round

3. No time category

While calculating Energy chages based on consumption for a period (let us take 30 days) in which from the mid of the billiing period (from 15th day of the billing period) price change has happend, the whole consumption is getting billed based on the old price, whereas based on per day consumption the consumption should have been prorated for the no. of days the old price was applicable and for the no. of days new price is applicable.

This problem is occuring only with the disconnected consumers only (consumer disconnected through disconnection document). For other consumers(non-disconnected) the energy charges is being calculated properly.

Billing period can be 15 to 45 days long.

Example: Consumption 50

No.of days in billing period: 30

start of billing period: 01.01.10

End of billing period: 31.01.2010

Price change is applicable from 15.01.2010.

Old price : 1

New price: 2

Currently the whole consumption i.e. 50 is getting billied based on 1 only for disconnected consumers.

Whereas : 24.19354839 * 1 EC for old price

24.19354839 * 2 should have happend. EC for new price

Please guide.

Thanks and Regards

Edited by: MP Vashishth on May 11, 2010 2:59 PM

Edited by: MP Vashishth on May 12, 2010 3:09 PM

Edited by: MP Vashishth on May 13, 2010 7:04 AM

[Former Member]

Hi,

This problem sometimes occur when installation have multiple disconnection document & reconnection document present with diferent dates in same month.Please check entries in table EDISCOBJ and EDISCOBJH.Remove those entries and then try to bill.

Also check the weignting key for the quantity operands,it should be linear (01).

Hope it helps.

[former_member199650]

Hi,

Thanks for your reply please.

But only one disconnection document (with validity e.g. 01.01.2010 to 31.12.9999) exists in the billing period.

Please guide.

Thanks and Regards

Edited by: MP Vashishth on May 13, 2010 12:15 PM

[Former Member]

Hi,

Please check out the FM ISU_MRRESULT_DEMARCATE,where proration of consumtion is calculated.In this FM,disconnected period is calculated.

There is a Z Include iedmround,here you can write your logice for calculating consumption during disconnection period.

[former_member199650]

Hi,

Thanks for your reply please.

But the FM you have mentioned, no disconnection period is being fetched, as logical register no. is not being populated in the table v_ediscobj. Please guide what can be the other solution or how should proceed as per best practice.

Please guide some way through which log.reg.no. can be populated in the table v_ediscobj.

Note: We are creating disconnection document with ref. to ISUPARTNER,.

Please guide.

Thanks and Regards

Edited by: MP Vashishth on May 21, 2010 10:24 AM

Edited by: MP Vashishth on May 21, 2010 10:26 AM