Skip to Content
avatar image
Former Member

Excise duty not populated in MIRO from J_1IGRXREF

Hello All,

When i am doing MIRO i am not getting issue. I.e the Excise amount are not flowing to MIRO from J_1IGRXREF. But calculated directly at the MIRO level based on the PO amount and condition record details.

Here in PO netvalue=200RS but in J1IEX i have changed the Excise base value to 220RS

JMOP (BED %) = 12.5% = 27.5RS as per Excise posting but in PO the JMOP (BED %) = 12.5% = 25 RS which i see in the MIRO Simulation. But i need the BED = 27.5RS in MIRO which was posted in the J1IEX.

I have already refereed many of the previous threads in the forum

Based on the Previous threads i have check following points.

  • TAX code is assigned to company code
  • TAX code is linked to country- IN and TAXINN
  • Invoice date falls with in the validity period of the Condition records for Excise duty
  • Excise master is maintained for the Material and Vendor in J1ID
  • Table J_1IGRXREF and J_1IEXCDTL has the same values
  • condition type JMOP for set off % and JMX1 for Set off total contains Cond. class=D Taxes, Calculat.type = A Percentage, Cond.category D Tax with Access sequence JTAX
  • In PO JMOP and JMX1 has the value along with VAT (JVRD)
  • Process Flow PO>MIGO (only part1) > J1IEX > MIRO.
  • JMOP is assigned for Accounting key VS1 and in OB40 GL account is assigned based on correct TAX code.
  • under the path

SPRO -- > Logistics general -- > tax on Goods Movements -- >India -- > Basic setting -- > Determination of Excise Duty -- > Condition-Based Excise Determination -- > Classify Condition Types

I have maintained

TAXINN JMOP BEDSETOFFP BED set off condition Percentage

TAXINN JMX1 BEDSETOFFT BED set off condition Total

SPRO -- > Logistics general -- > tax on Goods Movements -- >India -- > Basic setting -- > Determination of Excise Duty -- > Maintain Excise Defaults

I have maintained

A/P BED Cond = JMOP

BED Percentage condition = JMX1

Note: I have attached screen shots of MIRO and table J_1IGRXREF

table-j1igrxref.jpg

miro.jpg

Kindly help me to solve this issue.

Regards,

Manoj

miro.jpg (468.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 10, 2017 at 12:32 PM

    Hi Manoj,

    Does the tax code you have mentioned in PO, has and entry under following config?

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

    When you assign tax codes here, the system fetches excise values (for this tax code) in MIRO based on excise part 2 than from purchase order

    Hope so your issue gets resolved

    Regards

    Ranjjini

    Add comment
    10|10000 characters needed characters exceeded