Skip to Content

SAP Supported process for Import Purchase with CIN .

Pre requisites / Process steps :

1)Material Master

2)Vendor Master

3)Condition records (Optional) for JCV1, JECV, J1CV, JADC, JCDB, JEDB, JSDB (In order to auto populate the  condition types in Imports Purchase order)Can also be entered manually during PO creation.

4)While creating import PO, in the rate field, enter the rate of CVD that will be levied on the material when it arrives at customs.

5)While creating PO under conditions tab select the custom condition types and click on detail and enter the vendor field, enter the vendor master record that you have created for the customs office.

6)The tax code used in the PO should be a zero rate tax code.

7)GR BASED IV should NOT be ticked in the PO. (Because Custom duty has to be paid first for Import purchases)

8)Ensure that the vendor,plant and material are relevant for excise.

9)Material should be declared as Raw or consumables as per requirement in J1ID.

10)Plant should be relevant for Excise.

11)Since Vendor excise details are not known in  imports purchase, an hyphen must be entered in vendor excise details of J1ID.

12)The Customs MIRO should be done before MIGO with the said conditions.

13)The Customs MIRO should be done in currency INR only.

14)In MIGO in the commercial Invoice Pop up enter the customs MIRO number and year. Capture the Excise invoice here or you can do it through J1IEX as per your requirement.

15) Post the Excise in J1IEX.

16)MIRO should be done for Goods and also for planned deliveries (If any)

Configuration Part :

Create following condition types for Import Duties (Do not create any Z-condition type)

JCDB IN:Basic Custom Duty

JCV1 IN : CVD

JECV IN : Ed Cess on CVD

J1CV IN : H&SECess on CVD

JEDB IN : Ed Cess on BCD

JSDB IN : H&SECess on BCD

JADC Addnl Duty of Custom

SPRO > Logistics – General > Tax on Goods Movements > India > Basic Settings > Determination of Excise Duty > Maintain Excise Defaults > Here assign following for Tax Procedure;

CVD cond. – JCV1

ECS cond. – JECV

ADC cond. – JADC

Need not to maintain condition type “J1CV” in above option since it hard-coded in standard program itself.

SPRO > Logistics – General > Tax on Goods Movements > India > Basic Settings >Maintain Company Code Settings

Maintain Exchange rate type for CVD “ M” & CENVAT document type “ED”

CVD account (As per your requirement)

SPRO > Logistics – General > Tax on Goods Movements > India > Account Determination > Specify Excise Accounts per Excise Transaction Maintain the below entries.

GRPO IP         CR     CLEAR

GRPO IP         DR     ONHOLD

GRPO IP         DR     RG23AED

GRPO IP         DR     RG23AT1

GRPO IP         DR     RG23BED

GRPO IP         DR     RG23ECS

GRPO IP         DR     RG23SED

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

    

Maintain GL accounts against Excise transaction type GRPO, CAPE, EWPO, DLFC, DIEX with Sub transaction type IP here for your Excise group and Company code.

    

Note :

1)JCDB, JEDB, JSDB will get loaded to Stock and JCV1 (BED), JECV (ECS), J1CV (SEcess) and JADC (AED) will get posted to CENVAT Accounts.

2)For Validations on Commercial Invoice Pop up in MIGO transaction, refer SAP notes (1572603 & 1303077)

3)If you want to Inventorize the Cenvat in Import purchase, proceed with any of the following options.

a) You may change the excise material type under MIGO / J1IEX to “Non Cenvatable” then the Cenvat will be loaded on Inventory irrespective of Excise material type in J1ID.

b) You may also create four new condition types by copying JCV1, JECV, J1CV & JADC in M/06.

c)You may use the user exit J_1I7_USEREXIT_IMPORT_INV_DUTY. Refer SAP note 1021736

4)In standard imports Capital purchases, you cannot take the ADC (AED) 50% in First year and remaining in Second year. To enable 50% ADC credit on first year and remaining on subsequent years refer SAP note 1394771 & 1669512.

    

5)Important tables related to excise:

J_1IEXCHDR Excise Header table

J_1IEXCDTL Excise item table

J_1IGRXREF GR reference table for Excise

J_IPART1 Excise Part 1 table

J_1IPART2 Excise part 2 table

J_1IMOVEND Vendor Excise Details table

J_1IMTCHID Material & Chapter Id combination table

J_1IMVMT Movement types versus register relevance

I welcome comments / suggestions if any…

Regards,

Ashok Kumar Telugu

To report this post you need to login first.

23 Comments

You must be Logged on to comment or reply to a post.

  1. Lakhya Pratim Baruah

    Nice doc Ashok. Thanks for sharing. But I have a confusion in these two:

    Maintain Exchange rate type for CVD “ ED” – Not able to find.

    GRPO – IP/ CAPE?

    (0) 
    1. Ashok Kumar Telugu Post author

      Sorry, It was a typo mistake. It was actually a CENVAT document type “ED”..

      You need to maintain the Exchange rate type as “M” under Exchange rate settings under path India-Basic settings-Maintain Company code settings..

      Regarding GRPO IP, CAPE IP; you need to maintain the GL accounts under India-Account Determination-Specify G/L Accounts per Excise Transaction for GRPO as well for CAPE (Capital goods)

      Thanks for correcting me.

      (0) 
  2. Nilesh Kshatriya

    Hello Ashok,

    Pls note below comments :

    – The document seems to be older version….

    – The cess on CVD (JECV & J1CV) are cancelled by govt. on 13.03.2011. So, as per leatest scenario, this should not come in this document.

    – Missing step of capturing/positng of excise invoice in J1IEX in first 15 steps and importance of entering the custom MIRO no./FY in pop-up in J1IEX.

    – I am disagree with the statement – To enable 50% ADC credit on first year and remaining on subsequent years — as per business scenario & sap standard, you can get 100% credit of ADC in this year only..then, why client would require 50% credit this year + 50% next year.

    – It would have been interesting, if you would have mension that during J1IEX, the CVD Clearing a/c get hit from CoCd setting and NOT cenvat clearing a/c.

    Regds,

    Nilesh

    (0) 
    1. Ashok Kumar Telugu Post author

      Yes, i missed the J1IEX part. Thanks. There are already several documents and threads where the import procedure is clearly given, So, i didnt again talk abt the accounting entry or excise entry part. I just wanted to share this information because i have seen most of the threads which are being posted in scn for the given configuration only. For example, Inventorize Cenvat, Missing Account determination, Commercial invoice pop up, and for Subtransaction related.

      Regarding 50% ADC credit on subsequent year in import scenario, please go through the specified SAP notes once again, Recently, i implemented this notes in one of my client. Some clients requires this in exceptional cases or may be even frequently for import purchases.

      In addition, I have seen few clients who are still using the said conditions currently. Thats the reason i have mentioned the condition types in this document. I am not sure whether the said conditions are really cancelled by the govt. as i am looking into the localization issues / clients rarely now..

      I will ensure in future posts that all the relevant steps are there in the document.

      Thanks for your comments…

      (0) 
      1. Lakhya Pratim Baruah

        Hi Ashok,


        Want to ask you something. I have got the ADC 50% scenario. SAP has replied with the note 1394771. I have an import scenario where cleint wants JADC(Additional Custom duty) to be 50%. Before implementing this note is there any precaution I need to take or what should I keep in mind? Which transaction type should i mention the G/L’s (CAPE/GRPO……)

        Everything is working up to the mark. So i want to be double sure before I mess up something.

        Wand your advice though this question might sound too silly…….

        (0) 
        1. Ashok Kumar Telugu Post author

          What you have done is perfect. Both GRPO and CAPE IP gl accounts have to be mapped. Please check the SAP note besides 1669512 besides 1394771. The said notes should clear all your doubts.

          (0) 
            1. Ashok Kumar Telugu Post author

              Yes, the said notes enables 50 % ADC for Imports for subtransaction type IP only. You may go through the corrections and you will understand how it works.

              (0) 
                1. Ashok Kumar Telugu Post author

                  Import condition types need not to be classified as they are a part of pricing procedure. They only need to be maintained in Excise defaults for condition types JCV1, JADC, JECV.. J1CV is not required as it is harcoded in the program itself.

                  (0) 
    1. Ashok Kumar Telugu Post author

      /wp-content/uploads/2015/04/j1id_682921.pngWhat Account assignment? If you are procuring text material, you can create one dummy material code and have used it in import purchase. or else you can maintain an entry in J1ID in Material & Chapter id combination with out Material code.  Ie.. Maintain Plant code and Chapter id alone.. Leave Material field blank and save..

      (0) 
      1. Rama rao

        Hi Ashok Kumar ,

        while i am searing in SCN I found your blog and Its really very good documentation, I got a requirement  from our client that they will import RM and Capital goods, currently there is a gl mapped for CVD clearing for both RM and Capital goods, now they want it to be split as 2 different gls  for RM separate and Capital Material separate gls.

        how this can be achieved.??Can you please suggest.

        Regards

        Ram

        (0) 
        1. Ashok Kumar Telugu Post author

          Can you post the Accounting entry of both Raw and Capital Import procurement and high light where you want the GL account to be differentiated. Custom duty payable and Cenvat Clearing account will be picked from OBYC and Cenvat Receivables and Cenvat clearing account will be picked from GL account determination for CIN and Company code settings respectively.

          (0) 
          1. Rama rao

            Dear Ashok ,

            During Imports they will Import RM separately and CG separately(Order will be different).

            assume that the below example for Import of RM and CG also that same example.

            1.Create Import PO.

            2.Planned delivery cost (MIRO)

            Customs Clearing GL DR

            CVD Clearing-Imports GL DR

                      TO Commissioner of Customs   CR

            3.GRN Posting MIGO

            Inventory  GL DR

                   TO   GR/ IR Clrg  GL CR

                    TO  Customs Clrg GL CR 

            4. J1IEX -Excise Invoice (CVD Credit taking)

            BED  DR

            AED  DR

              TO CVD Clrg- Imports CR

            5.Import vendor invoice (MIRO)

            Now in the current system  both materials post to same CVD Clearing -Import GL , they want it to be post to different gl for RM and CG.

            And one more thing they want the CVD GLs at plant level like excise gls we assign at excise group level and excise group can have at plant level.

            My doubt is we assign CVD gl at MAINTAIN SETTIGN FOR COMPANY CODE <BASIC SETTTINGS <INDIA.

            it will pick the GRPO -with reference to PO.

            why sap given CVD gl at company code level even if we give under excise gl settings for GRPO it will not take from J_1IEXCACC table. please correct me if I am wrong, will wait for your comments.

            Thanks

            Ram

            (0) 
            1. Ashok Kumar Telugu Post author

              Your understanding in absolutely correct. If the CVD indicator is ON, system will fetch the GL account from Excise Company code settings. This is not with respect to any plant and is applicable for all plants.

              If you want to Influence it, you may have to written a substitution exit at FI module. Check with FI team once.

              (0) 

Leave a Reply