Invoice error

[Former Member]

Dear Experts..

I am facing an error in invoice, problem is final amount goes in cores

Lets see the scenario:

for one customer

his last invoice was generated on : 18.09.2010 with amount of 1000rs.

now the new invoice is generating on: 18.05.2011. but amount comes in cores. but actual consumption is only 177.

but when i check in meter reading results: expected mr : 49,187,379 and expected consumption : 49,186,991.000000000.

actual reading was 565. and consumption 177. i t hink expected can be anything, but for 177 consumption y its coming in crores?

(on 18.09.2010 estimated reading is 388. and on 18.05.2011 actual reading is 565.

on 14.08.2010 meter reading reason 13 (.reading on disconnection) and then on 10.09.2010

the meter reading reason is 18 ( reading on reconnection) both reading are zero(0). )

any body have an idea on this..plz

Cheers..

[Former Member · Accepted solution]

Hi,

Please check the billing line items and identify the line and the bill period start date and end date of the line where the amount is going very high.

If your invoice amount is going very high, then loook at only those bill line items where 'Billing Line Item for Budget Billing Amount Determination' (ABSLKZ) = Blank and 'Billing Line Item Relevant to Posting' (BUCHREL) = X.

the expected consumption is determined by the meter reading estimatation engine. It should not impact the current bill amount. If the current consumption is correct, the invoice amount should not be very high.

Please look at the billing line items and you will get some clue there.

Thanks.

Nirmalya

[Former Member]

Hi,

One more piece of information will help us further. What is the periodic consumption against register and what is value for dial length (Places before the decimal point in a register)?

Regards,

Avinash

[Former Member]

Hi Nirmlya,

thanks for reply , could you please tell that where i can find these fields ? ("Billing Line Item for Budget Billing Amount Determination' (ABSLKZ) = Blank and 'Billing Line Item Relevant to Posting' (BUCHREL) = X")

and i observed that in the period between 19.05.2010 to 16.06.2010 the consumption is 33,333,241

and between 17.06.2010 to 31.03.2011 the consumption is 66,666,938. with line itype zbgp( basic gas price).

cheers..

Hi avinsah..

thanks for reply, the periodic consumption is 15 for 30days... and the decimal places in reg is 8. was maintained.

cheers..

[Former Member]

Hi,

Since the last bill period end date is 18.09.2010, the current bill period start date should be starting from 19.09.2010 to 18.05.2011 (current bill period end date).

Those two fieds you will find in DBERCHZ1 table corresponding to the billing document number. Also in tcode EA22 during display of bill line items you can see those fileds. If you can not see, please change the layout of display.

BUCHREL fieed refers to those items which are relevant to posting and posted in GL which means which are levied from customer and ABSLKZ filed refers to the line item which is not coming from budget billing simulation.

You need to identify the current bill period start date and end date and the line item details which is contributing the high amounts. Also check the start and end date of those line items and related consumption quantity and amount.

Hope it helps.

Thanks.

Nirmalya

[Former Member]

Hi Nirmlaya.

Thanks for valuable info. please chk the following details.

current bill period star date is: 19.09.2010

end period is : 18.05.2011

and the following line items are coming high consumption:

line item type ZBGP ( basic gas price) period between 19.05.2010 to 16.06.2010 triggering qty as 33,333,241

and then with the same line itme ZBGP (basic gas price) period between 17.06.2010 to 31.03.2011 triggering qty as 66,666,938

and frm 01.04.2011 block price was implemented.

all the block pice trigger fine, i mean from 01.04.2011 to 18.05.2011.

i am not able to understand for what reason its going high between 19.05.2010 to 31.03.2011?

is there any pos becoz of meter reading reason 13, 18 ( disconnection and reconnection)?

disconnection was happend in 14.08.2010.

and reconection was in 10.09.2010

but after this i mean 18.09.2010 invoice was generated successfully.

Cheers..

[Former Member]

Hi,

Please check whether you have used any dynamic period control or backbilling in your schema.

If you have activated dynamic period control / backbilling, you can see it in schema header and also you can see it in schema steps. In that case SAP will execute the billing for previous billing period.

For example, if you have activated dynamic period control and if the current meter reading is a actual meter read, based on the configuration SAP can create a billing period from last actual meter read to current actual meter read. If you see the schema steps, you can see the time slice generator (TSG)field, execute dynamic period control will be populated.

According to your comments and after seeing the bill period dates it can be said that billing is executed for older periods due to dynamic period control / backbilling.

Please check the last meter reading dates, meter readings, type of meter readings (actual / estimate) and dynamic period control / backbilling setting.

Hope you will get some hints.

Thanks.

Nirmalya

[Former Member]

Hi Nirmalaya,

Yes. I am using DPC, and in schema my TSG is Past times slices activated.

could you please chk u r mail, i sent screen shorts. i am not able to find any clue.

Cheers..

[former_member213733]

Kindly go through the rules of engagement , please ensure that queries are specificed in the forum instead of sending personal mails .

Hope you understand .

Cheers ,

Dewang

[Former Member]

Dear Dewnag,

Sorry for that....

Hi Nirmalya,

I found something unusual in my meter readings, means for my meter reading on disconnection date 13.07.2010 but when i see the creation date tab it was created 26.10.2010. and on 13.07.2010 consumption shows 99,999,033.000000000.

does this makes the problem?. coz my last correct invoice was generated on 18.09.2010. that means before 26.10.2010.

i guess coz of this its triggering this..?

Cheers..

[Former Member]

Hi,

Was disconnect read was Zero? If yes, then it is case of meter overflow. You can correct disconnection read in that case (may be estimate it).

Regards,

Avinash

[Former Member]

Hi avnisah,

thanks for reply, only for some cust disconnection read zero, not for all.

and does the creation date will make any impact for over flow, coz iam using DPC. (like as i mentioned above post).

Cheers..

[Former Member]

Hi,

Creation date will not have any impact. As i understood, following are meter readings:

13.07.2010 - 0

18.09.2010 - 388

18.05.2011 - 565

If you can list all meter reading results, it will be helpful to understand consumption calculation.

Regards,

Avinash

[Former Member]

Hi avinsh,

creation date means when they actually entered in the system, if we see in display meter results, there creation data...

anyway flowing are the mr results for one cust.

18.05.2011...RR(1)...MT (1).....Mrrec(565)

18.09.2010....01.......03...........388

10.09.2010.....18......Z5.........0

14.08.2010.....13...... z5........0

18.07.2010......01.....03.......332

18.05.2010......01.....01.......277

18.03.2010.......01.....03.......150

18.01.2010.......01......03......120

18.11.2009.......01......03......89

18.09.2009......01.......01.......58

09.04.2009......06.......01.....1

here Z5 is meter reading my utility company.

but till 18.09.2010 the invoice was generated suceesfuly. but in this case when i chk the disconnection created date it was

18.11.2010. but my last success full invoice generation date is 18.09.2011.

and on 14.08.2010 consumption shows 99,999,668.000000000.... iam expecting this coz of the creation date..of disconnection.

cheers..

[Former Member]

Hi,

Definitely, your reads on 14.08.2010 is making the whole difference. On 18.07.2010 we have reading 332 and on 14.08.2010 we have zero. So consumption will be (99999999 (number of dials) - 332 (previous reading) + 1 (because of zero) = 99999667 = 99999668.

Ideally it should have impacted invoice on 18.09.2010, but since these reads were entered after invoice creation, we are facing this issue.

Now, we need to correct reads on 14.08.2010 & 10.09.2010. (or mark them inactive). That should solve our problem.

Regards,

Avinash

[Former Member]

Hi avinash,

thanks for detail explanation..its more informative. and could you please tell me how can i make that inactive?

and for correcting those reads, i need to do the all existing docs reversal na?

coz, in el17 & el29 its not allowing me to make any changes..

Cheers..

[Former Member]

Hi,

Since you have used past time slice in dynamic period control, billing is occuring for the earlier slices also. You need to correct the reconnection and disconnection meter reading so that consumption becomes 0 for that period. You can change the consumption on 14.08.2010 and 10.09.2010 as 332 so the consumption will become 0.

Since you have already triggered the invoice upto 18.09.2010, you need to reverse the invoice so that you can correct the meter reading for disconnection and reconnection via tcode EL27 or EL29.

Thanks.

Nirmalya

[Former Member]

Hi nirmalya ,

Thx for reply, do you have any idea that, i can mark the hig consumption period days as inactive? as above avinsah mentioned?

cheers.

[Former Member]

Hi,

Unfortunately, even to mark those reads inactive, you need to reverse invoice and bill documents. Then you can either mark them inactive, or correct them.

Regards,

Avinash

[Former Member]

Hi,

You can supress the billing of a meter reading through transaction EL29 / EL28 / EL27. You will see the button just on the right side of select all / deselect all icon in the screen of those tcodes. If you click on this, the corresponding meter reading will be supressed for billing. You can see the field in EABLG table in field UNTERDR whether the meter reading is supressed or not.

However this supression comes with a billable meter reading such as periodic / interim. You can not see this with disconnection / reconnection meter read. SAP has given exit EXIT_SAPLEL01_015 where in the INCLUDE ZXES60U11 you can deactivate / supress a meter reading through custom code.

Since you need to correct disconnection / reconnection meter reading, you can correct that through EL29 / EL27 and you can start billing after that.

Hope it helps.

Thanks,

Nirmalya

[Former Member]

Hi Nirmalya & Avinash,

Thank you very much for your valuable information, it was very helpful.

once again thanks for your time.

i am closing this issue.

cheers.