topic Calculation in Excise invoice in Application Development and Automation Discussions

Calculation in Excise invoice

Former Member — Tue, 05 Jan 2010 11:15:22 GMT

Hi,

While running the Excise Invoice (J1IIN), the values are flowing properly. But when i am going to save system throwing error

"Divide by 0 (type F) in the program "SAPLJ1I6"...

I have observed that in program SAPLJ1I6,after executing this function module 'J_1I7_USEREXIT_QTY_UNIT_CONV'

the new_unit(condition price unti) is ZERO.

After this the calculation goes on like this,

num_unit = j_1iexctax-kpein.

cal_amount = new_qty * j_1iexctax-amount / num_unit.

since kpein value is zero,its unable to calculate the amount.

i have checked the values in the table j_1iexctax also,kpein value is ZERO...

Can anybody tell me how to overcome this issue,

Thanks in advance.

Regards,

Sharmista

Re: Calculation in Excise invoice

Former Member — Tue, 05 Jan 2010 15:33:24 GMT

Please check the condition below.



if j_1iexctax-kpein is not initial.
num_unit = j_1iexctax-kpein.
cal_amount = ( new_qty * j_1iexctax-amount ) / num_unit.
else.
cal_amount = ( new_qty * j_1iexctax ) .
endif.

Regards

Satish Boguda

Re: Calculation in Excise invoice

Former Member — Wed, 06 Jan 2010 06:43:42 GMT

Hi Satish,

Thank you for your response.

I cannot chage the code here,its standard program..

Regards,

sharmista

Re: Calculation in Excise invoice

Former Member — Wed, 06 Jan 2010 06:51:27 GMT

Hi Sharmista,

You need to check why j_1iexctax-kpein value is zero.

I believe this field gets populated while doing the transaction.

Please check where it is becoming zero.

Thanks,

Sai

Re: Calculation in Excise invoice

Former Member — Wed, 06 Jan 2010 06:57:34 GMT

Hi,

Please check in the view J_1IVTXRAT, whats the value of kpein is maintained ?

you can use J1ID T.code, there you can find excise tax rates. You can check there.

Thanks,

Sai