on 02-17-2009 11:56 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.