Skip to Content
Author's profile photo Former Member

CIN: Capturing Additional Excise at Depots Due to Price Change – A Certificate

This document describes the standard process of raising a supplementary excise invoice and its subsequent capture at a depot, due to change in price of a product for which stock transfer has already been completed from Manufacturing Unit to Depot. Even though this is a standard SAP functionality from SAP for CIN, I found many people are unaware of how to use it and hence, thought of creating this document.

This is my first document on SCN. Looking forward to constructive criticism from experts.

Scenario:                 

The distribution chains of most manufacturing companies in India have a manufacturing plant transferring their stock to a depot before sale to the customer.

A manufacturing plant is registered with the Central Board of Excise and Customs (CBEC) as a manufacturer of dutiable goods and can maintain RG23A, RG23C and RG1 registers.


A depot or a warehouse is one which is not involved in manufacturing activities, however they receive cenvatable goods from either a manufacturing plant in the same company or from an excise registered external vendor and sale to customers issuing Cenvatable invoices. Such depots are registered as first stage dealers and have to maintain RG23D registers.RG23D entries are always in reference to a parent manufacturing plant/vendor invoice.


In certain cases, after the stock transfer is complete, the goods may lie for some time at the depot before being sold to the customer. It may so happen that at a later date the price of the material changes in depot with retrospective effect. In such circumstances the manufacturer (own plant/vendor) will pay the additional duty via A-Certificate and send the details to the depot.

User can enter a new A-certificate by entering the number , date and amounts for the A-certificate against a RG23D Folio. This is possible only if some quantity is still available for future despatches. If the invoice is fully despatched then you cannot enter an A-certificate.

I have elucidated below the transaction flow with assumption that the manufacturing plant belongs to the same company. In case the plant is of a different company/external vendor, only the steps ‘Activities to be performed at depot’ will be valid.

Prerequisites:

  • The plant for which the transaction is run should be marked as Depot in CIN IMG
  • The excise invoice should have been captured in the depot using Excise capture at depot
  • RG23D should be maintained in the depot.
  • Folio number generation has to be active in the depot for the excise group used.

Activities to be performed at the manufacturing plant:

  1. The excess Basic Excise Duty, Education Cess and Secondary and Higher Education Cess as a result of the price increase have to be calculated. For most materials this will be 12%, 2% and 1% respectively.
  2. Creation of Excise JV (for Supplementary Excise)
    1. Open transaction J1IH for entering Excise JV for the excess excise duty./wp-content/uploads/2014/04/1_436658.png
    2. Select option ‘Other Adj.’
    3. Input the data as shown in the next screen.The reference document no. should be the original Excise Invoice number generated at the plant dduring dispatch to the depot (processed through J1IIN).

/wp-content/uploads/2014/04/2_436663.png

      3. Enter the requisite document date and posting date for the supplementary invoice.

/wp-content/uploads/2014/04/3_436746.png

      4. Click on Details  /wp-content/uploads/2014/04/1_436658.png  button.

      5. Enter the Material Number, Quantity Dispatched and the Batch as shown. This should be the same as the original delivery sent to the Depot.

          /wp-content/uploads/2014/04/4_436766.png

  Scroll to the right to enter the BED, HE Cess and SHE Cess as calculated in Point number 1.

      /wp-content/uploads/2014/04/5_436767.png

Note: The duties should be entered batch-wise. If there were multiple batches in the initial delivery, include multiple lines in the JV screen

    6. Click on ‘Determine G/L Accounts’

/wp-content/uploads/2014/04/6_436768.png

    7. Against the G/L accounts automatically determined, enter the corresponding business area for the manufacturing plant.

      /wp-content/uploads/2014/04/7_436769.png

  8. Save the Excise JV and note the Number generated. This has to be communicated to the concerned Depot. Posting the Excise JV, affects    the appropriate Excise and Excise Clearing Accounts at the Manufacturing Plant.

Actions to be performed at the Depot – Capturing the A- Certificate:


  1. Identify the Depot Excise Invoice Number which was entered into RG23D during the initial Goods Receipt using J1IG at the depot.

        The easiest way to search for J1IG invoices/folio numbers is through report J1I7. This report has numerous parameters including PO               document/ Material document number to help search.

               

     1.PNG

   2. Open transaction J1IGA – Additional Excise entry at Depot

   3. Enter the Original Depot Excise Invoice Number and the Excise year as identified in step 1.

/wp-content/uploads/2014/04/8_436770.png

    4. Hit enter. The details of the Original Excise Invoice Captured are populated.

/wp-content/uploads/2014/04/9_436771.png

    5. Scroll to the extreme right. In the column of ‘A certificate’ and ‘Certificate Date’, enter the Excise JV Number and Excise JV date respectively, as obtained from the Manufacturing Plant/external Vendor

/wp-content/uploads/2014/04/10_436772.png

    6. Now enter the Additional BED, Additional HE Cess and Additional SHE Cess exactly as passed on from the Manufacturing plant, in the respective fields.

/wp-content/uploads/2014/04/11_436773.png

/wp-content/uploads/2014/04/12_436774.png

      7. Hit Enter. At the bottom of the screen, the final BED, HE Cess and SHE Cess is displayed. Check the same and post the document.

      8. Now, when the original Excise Depot Invoice is referred to during sale (using J1IJ), the additional Excise values will be displayed.

      To display captured A certificates, use transaction J1IGAD with the internal invoice number.

Assigned Tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Narayana N
      Narayana N

      Hi Manosij Basu,

      Nice explanation and documented well. As you mentioned that this is your first document, expecting for more documents 😎 .

      Regards,

      Narayana N

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you for your encouragement Narayana N          🙂

      Author's profile photo Mahesh Naik
      Mahesh Naik

      Hi Manosij,

      Nice Document!!.

      Author's profile photo Pradeep Mani
      Pradeep Mani

      Hi Nice document.

      1)Suppose if there is price increase were will enter JV,if any screen shot added on that would be good.Gives an idea were the price is changed.Suppose ED remains @ 12.36% remains same also ,do we want to enter once again in JV.

      Identify the Depot Excise Invoice Number which was entered into RG23D during the initial Goods Receipt using J1IG at the depot

      2)Suppose if we did not note down,how to find.

      3)Suppose if we are doing some fresh billing for remaining quantities,does the excise values depend on changed values.

      Overall the document is great.Expecting Lot more from you.

      Pradeep

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you for the encouraging feedback Pradeep Mani.

      For your queries:

      1) Yes we will still need to pass the JV. Say, the price was 100 initially, at 12.36% the taxes would have been Rs. 12.36. Now price changes to 200, ED is still at 12.36%, however the excise payable becomes Rs 24.72. We have to pass a JV for Rs. 12.36 (=24.72 - 12.36). The amount for the JV will have be calculated manually, CIN does not calculate it automatically.

      If the manufacturing plant is own company, and the product is at standard price, this will be changed in MR21, I did not put a screenshot for this as this is technically not a part of CIN.

      2) Thank you for point this out. I have added screenshots to explain this. You can find it in J1IG -> display -> against the goods receipt material document

      3) Yes, any further billing against this batch(es) will pick up the additional excise duties. Just refer to the original excise invoice in J1IJ after creating the delivery and before billing.

      Author's profile photo Former Member
      Former Member

      One of the best documents on CIN. Great work...Keep it up !

      Author's profile photo Former Member
      Former Member

      Hi Manosij,

      A very informative document. Thanks so much for sharing.

      regards,

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks a lot for your encouraging feedback.

      Regards,

      Manosij.

      Author's profile photo Nagendra m
      Nagendra m

      Hi, Manosij,

      Very good and informative document. Thanks for sharing.

      Regards,

      Nagendra.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Nagendra!

      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Manosiji,

      Very nice explanation.Keep it up 🙂 .Looking forward many doc's from you.

      Thanks,

      Naren

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks for the encouragement! 🙂

      Author's profile photo Shreekumar SAP
      Shreekumar SAP

      Really it's a nice document .Nice Explanation.

      Thank you and keep it up

      Author's profile photo Former Member
      Former Member

      Hi Manosij

      Excellent document. I have one question regarding this.

      1. Suppose I transferred one material of 10 PC with basic ED @100.

      2. I sold 2 out of 10 from the depot. I am left with 8 PC.

      3. Now I want to sell 3 PC with basic ED @120.Therefore I need to generate A-Certificate with difference of 20.

      Can I generate it for 3 PC and sell these 3 PCs?

      Thank you

      Author's profile photo Ashok Kumar Telugu
      Ashok Kumar Telugu

      Yes, it can be done. Can you check and let us know if you have any challenges?