Wrong GR/IR created while posting a MIGO of a dealer purchase with splitting quantity

[nilesh_malvi]

Hello Experts,

I have a issue with GR/IR creation while punching a MIGO document. The details are:

PO - 20 pcs x 1525 Rs. = 30500 + 2 % CST 610 comes to 31110/- total amount. As it is dealer purchase, the rate 1525 includes Basic and Excise amount.

While creating MIGO document we split qty into 2 pcs & 18 pcs as we received BED & AED for 2 pcs only and BED, AED, Ecess & SHE for 18 pcs.

Also we put required data in Excise tab as below:

                    Base Amt     BED          AED          ECess          SHE

For 2 pcs       2,598.93        328.00      123.07        0                  0

For 18 pcs   24,267.64      2,160.05      957.51        43.20            21.60

MRP indicator ticked and IP is given as sub trans.type.

System passed below FI entries :

for MIGO :

     Stock - Sprs&OTH Dom     2,659.93

          GR/IRTools & Others          2,659.93-

     Stock - Sprs&OTH Dom     23,939.37               It should be Rs. 24267.64 as we mentioned earlier.

          GR/IRTools & Others          23,939.37-

For MIRO :

xxxxxxx supplier     31,110.01-

GR/IR Acc.               2,659.93

GR/IR Acc.             23,939.37

Material                       877.27   problem in amount which goes to material acc which is due to GRIR generated with lesser amount, don't know why?

CENVAT Clearing         328.00

CENVAT Clearing         123.07

CENVAT Clearing        2160.06

CENVAT Clearing         957.51

CENVAT Clearing           43.20

CENVAT Clearing           21.60

Please suggest...

Thanks,

Nilesh M.

[Former Member]

Dear Nilesh,

I think for the first GR you forgot to put MRP indicator while posting  MIGO Please check it once. Also While posting the MIRO document what amount your are entering into Amount Field. Is it as mentioned below ?

For  2 qty = 2,659.93

For 18 Qty = 23,939.37

Regards

Anupam

[nilesh_malvi]

Hi Anupam,

Thanks for your reply.

GR is only one, we have split the total qty 20 into 2 parts, i.e.2 and 18. So we need to put MRP indicator only at header level in Excise tab.

Also we put amount 2659.93 (for 2 pcs) and 24267.64 (for 18 pcs). and system gives above mentioned FI entries.

Thanks,

Nilesh

[Former Member]

Dear Nilesh,

Fully agree with you that there will MRP indicator for once in Header. As per standard the use of MRP indicator deducts the Excise Duty component from the Base value.  So as in your scenario the value of GR should be

For 2 Qty - 2147.86

For 18 Qty - 21085.28

This should be be your base amount also while posting MIRO

Please also check link below for reference

http://www.sapfunctional.com/MM/MRPindicator/excise.htm

Regards

Anupam

[nilesh_malvi]

Anupam,

The base amount we entered are correct for both lines in MIRO. i.e. 2659.93 (for 2 pcs) and 24267.64 (for 18 pcs).

My problem is at GR level. it is posting amounts for 2nd line wrongly.

You can see entries in previous message.

For 1st line for 2 pcs it is creating GR/IR for amount 2,659.93. It is correct, 2598.93 + 61 cst = 2659.93

So ideally it should do same process at 2nd line...

For 2nd line it is creating GR/IR for amount 23,939.37 instead of 24816.64 ( 24267.64 + 549 cst = 24816.64)

So total invoice amount will be 2659.93 + 24816.64 + all excise duties = 31110.10

But as it is considering less GR/IR 23939.37 the difference amount is given by system 877.27 Rs.

Hope it is more clear...

Thanks,

Nilesh

[Former Member]

Hi Nilesh,

Which tax code you use in MIRO? Make sure AED condition must be there in that tax code.

Regards

PR

[nilesh_malvi]

Hello PR,

All parameters are correct.

Thanks,

Nilesh

[former_member192897]

Why did you chose the Subtransaction type IP which is used for Import Procurement? In dealer procurement, you should change the base amount in MIRO. I seem that there is something wrong with your GR/IR amount caluclation itself..

Could you share your excise item as well header screen shots..

[nilesh_malvi]

Hello Ashok,

IP is required as it contains AED. Also find required screenshots.

Thanks,

Nilesh

[former_member192897]

IP is only required if you want to avail AED 100% in Domestic procurement. Else you will get only 50% of AED for Capital goods in Domestic procurement.

For me, it seems to be a bug. You may raise an OSS message...