ED is not getting calculated at the time of MIRO

[Former Member]

We have a purchase order where the VAT is getting calculated as "4t : ED as App. 14.50% VAT (Non Vatable) Non Cenvatable". Since the tax code non-vatable and non-cenvatable hence the value in the GR consists of base price + ED and VAT on base price + ED. We have done excise capture and post using J1IEX tcode.

However, at the time of doing MIRO, the Excise duty not getting calculated. And VAT is getting calculated on the base amount. So in simulation it shows base price + VAT on base price.

Regards,

Pratima.

[Former Member]

Hi

Since you have said you have done excise capture and post using J1IEX tcode. Checked 2 thing.

1. Tax code is assigned to company code

2. Checked table J_1IGRXREF,its been updated are not

Regard

Nabil

[Former Member]

Hi All,

Yes the duties are getting calculated and are added to the GR/IR account at the time of MIGO.

The GR document exists in the table J_1IGRXREF.

However, I would like to mention that earlier the tax code configuration was incorrect. So we have changed the tax code, then reversed the GR, reversed the MIRO and done a fresh GR. Earlier the GR/IR account in the GR document was not calculating the ED. However, now after correcting the tax code the amount is added in the GR / IR account , but is not getting calculated at the time of MIRO simulation.

[former_member187965]

Hi,

Can you explain with an example in terms of values, so that, it will be easy to understand. Normally, if you are inventorising the excise duties then it gets added to GR/IR account and these duty values will not be visible in MIRO simulation as different G/L lines.

[Former Member]

Hi Shaliesh,

PO base price is 6,00,000. Tax code 4T:ED as App. 14.50% VAT (Non Vatable) Non Cenvatable

GR document accounting entries:

413500 (CWIP P&L-Extnl Proc. ) --> 771,913.20

191161 (GR/IR-Cap Itms CWIP ) --> 771,913.20-

Excise Capture Post done;

At the time of MIRO simulation, entries are:

162000 Padmaja Engineering                      687,000.00-

191161 GR/IR-Capital Items CWIP              771,913.20

413500 CWIP P & L-External Procurement  84,913.20-

So the vendor is getting paid only base price and VAT at 14.5% on base price. Whereas ED should also be paid to the vendor. The difference amount is going to the P&L difference account.

Regards,

Pratima.

[former_member187965]

Hi,

If i am right 84,913.20 is the excise duty value and it is non cenvatable,

Check the following settings,

1) GR based invoice verification indicator in PO

2) Excise conditions are classified, by path, SPRO - Logistics General - Tax on Goods Movements - India - Basic Settings - Determination of Excise Duty - Condition Based Excise Determination - Classify Condition Types

3) Tax code is assigned to company code

[Former Member]

Hi Shailesh,

Yes the difference amount is the ED. The GR Bases IV indicator is ticked in the PO.

Also i think we need to classify condition types and assign tax code to company code only when we are using condition-based excise determination (using TAXINN as the tax procedure). We are using tax procedure TAXINJ.

Please let me know if this is required for TAXINJ also since we dont have point 2 & 3 in our config.

[former_member187965]

Hi,

You should mention such important information (TAXINJ or TAXINN) while posting a question. It helps to go the discussion in the right direction.

Go through the below SAP Note,

Note 1559145 - Frequently asked questions for Procurement in India: CIN

Check under MIRO, second question.

You need to classify the condition types in TAXINJ also. Classify the condition types and check again,

[ajitkumar]

When you have inventoried duty, the same will come in the GR/IR account at the time of MIGO.

hence you will not see separate excise and VAT gls in line item at miro.

the accounting entry at time of MIRO will be credit vendor, debit GR / IR

pl check your MIGO FI document

[jpfriends079]

Use Internationalization and Unicode space for all your CIN related queries.

[former_member187965]

Hi,

Check whether you have assigned tax code to the company code.

[Former Member]

Hi, Please let me know the path for the same.

[former_member187965]

Hi,

SPRO - Logistics General - Tax on Goods Movements - India - Basic Settings - Determination of Excise Duty - Condition Based Excise Determination - Assign Tax Code to Company Codes

As you have inventorized excise duties that will not flow in to MIRO. As per excise rules, if a firm is not availing the excise duty credit (Inventoried excise duties at the time of goods receipt) then capturing of vendor excise invoice is not required.

In your case also, you have inventoried the excise duties then it is not required to capture and post excise invoice.