topic Re: Cancel Excise Invoice Posted in Application Development and Automation Discussions

Cancel Excise Invoice Posted

Former Member — Wed, 16 Dec 2009 09:45:45 GMT

Hello Gurus

I have created Migo and Miro and J1iex and posted the excise invoice in both part1 and part 2

now i need to cancel the excise invoice posted how to proceed

searched the sdn no concrete answer available

thanks in advance

Rajesh

Re: Cancel Excise Invoice Posted

Former Member — Wed, 16 Dec 2009 09:51:50 GMT

Incase of Cancel of excise, kindly follow the below steps:

1. Cancel the GRN, and it will cancel the part 1

2. Cancel the Excise Invoice using J1IEX, This will cancel the Part 2 entry.

Hope this will help

REgards

Prasanna

Re: Cancel Excise Invoice Posted

Former Member — Wed, 16 Dec 2009 10:01:32 GMT

Thanks sir for the reply

i have tried this but not working

Thanks in advance

Re: Cancel Excise Invoice Posted

Former Member — Wed, 16 Dec 2009 10:19:02 GMT

What is the issue!, if your getting any error, if so then send me the same

regards

Prasanna

Re: Cancel Excise Invoice Posted

Former Member — Wed, 16 Dec 2009 10:28:02 GMT

Hi,

As u have posted MIRO also, in order to cancel the Excise follow the below steps.

1.cancel the MIRO doc using MR8M

2. then cancel the GR doc

3. In J1IEX cancel the Excise doc, so status will become as in process

4. Again in J1IEX, Post the same, your entries will get reversed.

regds,

Re: Cancel Excise Invoice Posted

Former Member — Wed, 16 Dec 2009 10:28:49 GMT

Hi,

As u have posted MIRO also, in order to cancel the Excise follow the below steps.

1.cancel the MIRO doc using MR8M

2. then cancel the GR doc

3. In J1IEX cancel the Excise doc, so status will become as in process

4. Again in J1IEX, Post the same, your entries will get reversed.

regds,

Re: Cancel Excise Invoice Posted

Former Member — Wed, 16 Dec 2009 10:37:29 GMT

Thank you for the replies

i am able to easily cancel the MIRO

but when i cancel MIGO it is not possible to cancel as excise entry only part 1 is there so it is not allowing to cancel the GRN

thanks in advance

Re: Cancel Excise Invoice Posted

Former Member — Wed, 16 Dec 2009 10:49:16 GMT

Thank You for the INputs

i have canceled the MIRO and MIGO document using MBST

when i try to cancel the excise invoice in J!iex the error is

Excise invoice xxxxx 2009 has already been posted for vendor xxxx

how to cancel the vendor excise invoice

Regards

Rajesh

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 05:50:58 GMT

Any replies for the problem

Rajesh

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 06:27:25 GMT

The error what is get when i try to cancel the excise invoice in J1iH is

Excise modvat accounts not defined for CEIV transaction and excise group

Thanks in advance

Rajesh

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 06:34:23 GMT

Hi,

Go to the below path,

spro >> Logistics - General >> Tax on Goods Movements >> India >> Account Determination >> Specify Excise Accounts per Excise Transaction

Check for the below,

CEIV CR Credit MSUSP CENVAT suspense account

CEIV DR Debit PLAAED PLA AED account

CEIV DR Debit PLABED PLA BED account

CEIV DR Debit PLAECS PLA ECS Account

CEIV DR Debit PLANCD PLA NCCD Account

CEIV DR Debit PLASED PLA SED account

CEIV DR Debit RG23AED RG 23 AED account

CEIV DR Debit RG23BED RG 23 BED account

CEIV DR Debit RG23ECS RG 23 ECS Account

CEIV DR Debit RG23NCD RG 23 NCCD Account

CEIV DR Debit RG23SED RG 23 SED account

And also check the below path as well.

spro >> Logistics - General >> Tax on Goods Movements >> India >> Account Determination >> Specify G/L Accounts per Excise Transaction

21 CEIV BP01 Chart of Acs GL accs

regds,

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 06:43:08 GMT

For this error msg: Excise modvat accounts not defined for CEIV transaction and excise group

1) Maintain following combination for taxes on goods movement account determination - G/L excise account per excise tranaction for :

Excise Transaction type - sub transaction type - Debit/credit and description for the CEIV. One you have to maintain with subtransaction type 01 and with blank. Then

2) Maintain for G/l a/l per excise transaction : for the combination of ETT - STT - INT - Excise group - CC----maintain the g/l accounts . again one with 01 subtranaction type and one with blank.

Hope it resolves your issue.

Regards,

Prashanth Pai

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 09:31:13 GMT

Thanks for all the valuable inputs

what ever earlier told every thing is there in the system

but still i am not able to cancel

in j1iex i am getting the error

Excise invoice xxxxx 2009 has already been posted for vendor xxxxxx

when i tried to cancel in J1IH

the error is

Excise modvat accounts not defined for CEIV transaction and excise group

so whether the process is wrong it is configuration mistake

Thanks in advance

Rajesh

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 09:48:14 GMT

You are not expected to cancel the GR through MBST when there is an excise invoice involved. MBST is not supported for CIN.

You have to cancel the GR wrt the 101 document, part 1 will automatically be reversed & then you should post & then cancel the excise invoice.

Since you have cancelled GR through MBST there will be no update in part 1 table for 102. What you have to do is to update part 1 for 102 through J1I5 and then do the following.

When the GR is cancelled, there are two new entries, one in the table

J_1IPART1 and another in the table J_1IGRXREF. In both these entries,

the reference to the Excise Invoice must be made available. The

relationship must be as follows:

For the table J_1IPART1:

J_1IPART1-DOCNO = J_1IEXCHDR-DOCNO

J_1IPART1-DOCYR = J_1IEXCHDR-DOCYR

J_1IPART1-TRNTYP = J_1IEXCHDR-TRNTYP

For the table J_1IGRXREF:

J_1IGRXREF-EXNUM = J_1IEXCHDR-EXNUM

J_1IGRXREF-EXYEAR = J_1IEXCHDR-EXYEAR

J_1IGRXREF-EXC_ZEILE = J_1IEXCDTL-ZEILE

J_1IGRXREF-EXDAT = J_1IEXCDTL-EXDAT

J_1IGRXREF-LIFNR = J_1IEXCHDR-LIFNR

The data must be available in this form.

In your case, you would have run the transaction J1I5 to update the

tables J_1IPART1 and J_1IGRXREF. Please ensure that the relationship as

mentioned above is maintained correctly.

Now, see the status of the Excise Invoice in the table J_1IEXCHDR,

the field being J_1IEXCHDR-STATUS = ' '. Note, you are changing the

field value from 'P' to blank.

After doing this, you may run J1IEX, use the option 'Post CENVAT'. This

will reverse the credit. Run J1IEX again, use the Cancel Option this

time and cancel the excise invoice.

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 09:48:42 GMT

You are not expected to cancel the GR through MBST when there is an excise invoice involved. MBST is not supported for CIN.

You have to cancel the GR wrt the 101 document, part 1 will automatically be reversed & then you should post & then cancel the excise invoice.

Since you have cancelled GR through MBST there will be no update in part 1 table for 102. What you have to do is to update part 1 for 102 through J1I5 and then do the following.

When the GR is cancelled, there are two new entries, one in the table

J_1IPART1 and another in the table J_1IGRXREF. In both these entries,

the reference to the Excise Invoice must be made available. The

relationship must be as follows:

For the table J_1IPART1:

J_1IPART1-DOCNO = J_1IEXCHDR-DOCNO

J_1IPART1-DOCYR = J_1IEXCHDR-DOCYR

J_1IPART1-TRNTYP = J_1IEXCHDR-TRNTYP

For the table J_1IGRXREF:

J_1IGRXREF-EXNUM = J_1IEXCHDR-EXNUM

J_1IGRXREF-EXYEAR = J_1IEXCHDR-EXYEAR

J_1IGRXREF-EXC_ZEILE = J_1IEXCDTL-ZEILE

J_1IGRXREF-EXDAT = J_1IEXCDTL-EXDAT

J_1IGRXREF-LIFNR = J_1IEXCHDR-LIFNR

The data must be available in this form.

In your case, you would have run the transaction J1I5 to update the

tables J_1IPART1 and J_1IGRXREF. Please ensure that the relationship as

mentioned above is maintained correctly.

Now, see the status of the Excise Invoice in the table J_1IEXCHDR,

the field being J_1IEXCHDR-STATUS = ' '. Note, you are changing the

field value from 'P' to blank.

After doing this, you may run J1IEX, use the option 'Post CENVAT'. This

will reverse the credit. Run J1IEX again, use the Cancel Option this

time and cancel the excise invoice.

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 09:48:54 GMT

You are not expected to cancel the GR through MBST when there is an excise invoice involved. MBST is not supported for CIN.

You have to cancel the GR wrt the 101 document, part 1 will automatically be reversed & then you should post & then cancel the excise invoice.

Since you have cancelled GR through MBST there will be no update in part 1 table for 102. What you have to do is to update part 1 for 102 through J1I5 and then do the following.

When the GR is cancelled, there are two new entries, one in the table

J_1IPART1 and another in the table J_1IGRXREF. In both these entries,

the reference to the Excise Invoice must be made available. The

relationship must be as follows:

For the table J_1IPART1:

J_1IPART1-DOCNO = J_1IEXCHDR-DOCNO

J_1IPART1-DOCYR = J_1IEXCHDR-DOCYR

J_1IPART1-TRNTYP = J_1IEXCHDR-TRNTYP

For the table J_1IGRXREF:

J_1IGRXREF-EXNUM = J_1IEXCHDR-EXNUM

J_1IGRXREF-EXYEAR = J_1IEXCHDR-EXYEAR

J_1IGRXREF-EXC_ZEILE = J_1IEXCDTL-ZEILE

J_1IGRXREF-EXDAT = J_1IEXCDTL-EXDAT

J_1IGRXREF-LIFNR = J_1IEXCHDR-LIFNR

The data must be available in this form.

In your case, you would have run the transaction J1I5 to update the

tables J_1IPART1 and J_1IGRXREF. Please ensure that the relationship as

mentioned above is maintained correctly.

Now, see the status of the Excise Invoice in the table J_1IEXCHDR,

the field being J_1IEXCHDR-STATUS = ' '. Note, you are changing the

field value from 'P' to blank.

After doing this, you may run J1IEX, use the option 'Post CENVAT'. This

will reverse the credit. Run J1IEX again, use the Cancel Option this

time and cancel the excise invoice.

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 09:49:12 GMT

You are not expected to cancel the GR through MBST when there is an excise invoice involved. MBST is not supported for CIN.

You have to cancel the GR wrt the 101 document, part 1 will automatically be reversed & then you should post & then cancel the excise invoice.

Since you have cancelled GR through MBST there will be no update in part 1 table for 102. What you have to do is to update part 1 for 102 through J1I5 and then do the following.

When the GR is cancelled, there are two new entries, one in the table

J_1IPART1 and another in the table J_1IGRXREF. In both these entries,

the reference to the Excise Invoice must be made available. The

relationship must be as follows:

For the table J_1IPART1:

J_1IPART1-DOCNO = J_1IEXCHDR-DOCNO

J_1IPART1-DOCYR = J_1IEXCHDR-DOCYR

J_1IPART1-TRNTYP = J_1IEXCHDR-TRNTYP

For the table J_1IGRXREF:

J_1IGRXREF-EXNUM = J_1IEXCHDR-EXNUM

J_1IGRXREF-EXYEAR = J_1IEXCHDR-EXYEAR

J_1IGRXREF-EXC_ZEILE = J_1IEXCDTL-ZEILE

J_1IGRXREF-EXDAT = J_1IEXCDTL-EXDAT

J_1IGRXREF-LIFNR = J_1IEXCHDR-LIFNR

The data must be available in this form.

In your case, you would have run the transaction J1I5 to update the

tables J_1IPART1 and J_1IGRXREF. Please ensure that the relationship as

mentioned above is maintained correctly.

Now, see the status of the Excise Invoice in the table J_1IEXCHDR,

the field being J_1IEXCHDR-STATUS = ' '. Note, you are changing the

field value from 'P' to blank.

After doing this, you may run J1IEX, use the option 'Post CENVAT'. This

will reverse the credit. Run J1IEX again, use the Cancel Option this

time and cancel the excise invoice.

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 09:57:12 GMT

Yes Sir/Madam

you are right i am cancelling in MBST

but when i cancel in migo it shows the excise part 1 entry i am not able to cancel the excise

invoice

how to cancel in MIGO in that case

Rgards Rajesh

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 09:59:13 GMT

You cannot cancel the EI through MIGO. You have to use J1IEX, 1st post the EI if part 2 is already posted & then cancel the EI.

Re: Cancel Excise Invoice Posted

Former Member — Thu, 17 Dec 2009 10:35:03 GMT

Yes

you are correct

i cannot cancel EI in MIGO but when i cancel the excise invocie in J1IEX it says

Excise invoice xxxxx 2009 has already been posted for vendor xxxxxx

thanks and regards

Rajesh