cancel
Showing results for 
Search instead for 
Did you mean: 

Control Excise invoice cancellation

Former Member
0 Kudos

Hi All

Our Business process is Proforma invoice -


Excise invoice -


Commercial invoice (Pass to accounting )

Problem - After generating Commercial invoice system is allowing to cancel Excise invoice through J1IH or J1IIN with out checking commercial invoice ..

We need the system to check Commercial invoice at the time of cancelling Excise invoice .

Is there any user exit or Badi to control the Cancellation of Excise invoice if commercial invoice exists

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos

You can try in J_1I7_USEREXIT_EXCISE_BEF_SAVE where you can define a logic such that if there is F2 preceding document, then the respective excise invoice should not be cancelled. For this, you can consider table J_1IEXCHDR and the Field STATUS.

thanks

G. Lakshmipathi

Answers (1)

Answers (1)

Former Member
0 Kudos

Dear Marathanda,

CIN is not a statdard SAP offering, It has been built for India requirements and that is the reason why excise Invoice doesn't show up in the document flow..like SO, Del, Invoice..which gets updated in Table VBFA. and that is the reason why there is no check at Excise Invoice cancellation level that if commercial Invoice exists then cancellation should not be allowed. there is one more factor for that, in many business scenarios we are creating Excise Invoice after the commercial Invoice and in many we are creating after delivery..say at the time of despatch of goods from factory premises or Stock Transfer Order so it's a tricky situation.

In your case, the commercial invoice is getting generated after the Excise Invoice i.e.with Excise Invoice is getting generated with ref to the pro forma Invoice and then you want to restrict the cancellation of the Excise Invoice then first you need to check the Internal Number created at the time of Excise invoice, that number will give you the billing reference number (of pro forma Invoice). now from that billing document (pro forma Invoice) check in table VBFA , enter that precceding document number and and item number along with subseqent document number catagory as "M" It will give you the Commercial Invoice Number. you can put your restriction there.

Thanks,

N