Excise invoice cancel

[Former Member]

Hi.. Gurus...

My user cancel the the GR doc through MBST tcode.. now I would like to cancel the Excise invoice through J1IEX, but it is not happening as the doc cancel through MBST.. plz suggest the way..

regards,

sandeep.

[former_member192897 · Accepted solution]

SAP Donot Recommend to Cancel the Material document through MBST. If reversed through MBST then update part1 through J1I5 for the 102 document and update part 1 and GRXREF tables with correct values.

Correct process is :

Cancel the Material document through MIGO

Post the Excise invoice through J1IEX

Then Cancel the Excise invoice through J1IEX

[Former Member]

Hi,

You are not following correct process. use MIGO for reversal of material document, post excise against this reversal in Rg23 part 1 and then cancel excise invoice.

[Former Member]

Hi,

Pls do not use MBST to cancel the GR. Always cancel it via MIGO only.

Now for this one doc,pls follow the below work around.

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.This can be achieved through a Z program.

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.

You will need to 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, make the status of the Excise Invoice in the table J_1IEXCHDR,
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.

Regards,

Rajasree

[former_member201758]

Hi,

Please use forum "Internationalization and Unicode" for CIN issues.

Regards,

[Former Member]

Hi Sandeep,

As u have cancelled the material document through MBST T.CODE due to which no part -1 entries have been reversed . So please reverse Part-1 Entries through J1I5    t.code by updating register with 102 MVT TYPE.

Next Cancel the Excise invoice document.

Steps to be followed for canceling excise invoice

1> create po
2> capture excise invoice
3> post gr
4> post part 2
5> cancell GR
6> post vendor excise invoice
7> cancell vendor excise invoice.

Regards,

Chowdary

[former_member187965]

Hi,

If you cancel the material document through MBST then system doesn't cancel the excise entry automatically, as happens in MIGO.

So follow the below steps,

1) Update the part 1 register for 102 mvt type through J1I5 - This will reverse the part 1 entries.

2) Post the vendor excise invoice through J1IEX -  This will reverse the part 2 accounting entries.

3) Cancel the vendor excise invoice through J1IEX - This sets the cancel status to the invoice.

Now try to post the new MIGO with the same vendor invoice.