MIGO - GRN Valuation issue

[Former Member]

Hello Gurus,

We have a issue on posting of MIGO. User have wrongly posted many PO's like below

Users have posted MIGO entry like below

Correct calculation

Quantity   rate        Calculation

41500     295     = 41500*295/1000=12242.50

Wrongly calculated in SAP

System calculated with 41500*295 = 122425000 instead of 12242.50 its happened because of selecting price unit  as 1 while posting purchase order instead of entering 1000 as price unit.

If we change price unit as 1000 and post MIGO its posting correctly.

We can reverse the GR, But the problem is user has posted for more than 400 POS's for the same way.

Any input from your end in this regard will be appreciated.

Thanks in advance

Regards,

Shanthi

[Former Member · Accepted solution]

Hi Shanthi,

Since, there are 400 entries, it is difficult to reverse those 400 documents.

The best way is, keep those 400 document numbers without reverse.

And pass JV Posting via FI transactions.

The entries are as follows.

GR/IR Account Dr

Inventory Cr.

Before passing JV, first to go FS00 and deselect Post automatically and Pass JV

Ravi Polampalli

[Former Member · Accepted solution]

Hello Ravi,

Thanks for your inputs ravi and

if material is different  for all PO's and Valuation class is different in that case we need to post JV's for each valuation class?

Please need your suggestion on this aswell

[Former Member · Accepted solution]

Hi Shanthi,

You are right.

Find out Posted document numbers against Material codes and Pass those material codes in MBEW table

Find out Valuation Area (Plant) against Valuation class in the table MBEW

Now Go to OBYC and click on transaction BSX

Find out valuation class (MBEW Table data) against GL Codes (those are Inventory GL Codes)

If posted documents have 5 valuation classes, then you need to take 5 gl codes

Find out  GR/IR clearing GL code (whether one or more)

Double click on WRX transaction (If GR/IR created valuation class wise take same passion) otherwise take existing one.

Ravi Polampalli

[ajaycwa1981 · Accepted solution]

Hi Ravi

That would be disastrous.. How can you suggest to post manual correction entries to stock accounts??

@ Shanti - Please reverse these docs and post the GR again. Thats the only way

Create a LSMW if you wish

Br. Ajay M

[sampat_kumkar]

Dear,

I also agree with Ajay sir and Dev

If user posted more than 400 PO and MIGO with wrong value, it has to reverse manually only.

It is not recommend pass JV or manually interface into stock account GL.

Regards

Sampat

[former_member183424]

I agree with Ajay Sir,

You should not post a JV entry...

Have you ever think, what will be the effect at the time of Invoice Posting ?

You should not do another mistake to correct the entry...

You should reverse the all Goods receipt.. Then post again the goods receipt.

[Former Member]

Hi,

I would not go for a manual adjustment of stock accounts.

If material are still in stock, you should reverse movement, correct PO and repost (using LSMW). That would be the best.

In any case, I guess you need to correct the price unit in the PO to get a correct invoice.

If material are already consumed and you cannot reverse the consumption:

- if they are valuated at standard price, you can decide to wait for the invoice to come before period end closing .This will trigger a variance due to GR/IR difference that will offset the variances you got when posting the good issue. You would have to allow such variance for these specific invoices.

     - if invoice is not there at month end closing you can post a correction journal against a manual variance account and a manual GR/IR account, and reverse it the next month (until invoice is created).

- if they are valuated at moving average price, you can decide to wait for the invoice to come before period end closing . there should be no stock coverage and therefore the variance will be post in PL account that will offset the variance caused in the production. You would have to allow such variance for these specific invoices.

      - if invoice is not there at month end closing you can post a correction journal against a manual variance account and a manual GR/IR account, and reverse it the next month (until invoice is created).

Not easy but in that way you don't mess with automatic accounts and you document the corrections.

Regards

Ali

[Former Member]

Hi Shanthi,

How do you valuate those purchased materials: at standard or at moving average?

Do you use material ledger?

Since posting MIGO for those materials have and goods issues for them been posted?

If yes, to what object?

Regards,

Szymon

[former_member195434]

Hi Shanthi,

I would strongly suggest you to not post to material accounts (BSX) manually. I think your materials have been valuated with wrong prices too becuase of wrong GR entry.

If you make only FI adjustment MM and FI will not be in sync.

It might be a tiresome job but reversing the GR and redoing them is a better solution. Consult your MM member if he can find a better solution.

You will plenty of pages in SCN for 'mass reversal of material documents'.

BR

Abhinav

[Former Member]

Hi Shanthi,

Please do not go for Reversal of MM documents.

To reversal of  400 Purchase orders it is not easy job as far as Stock is concerned.

Through 101 stock might have consumed against Production order/Process order.

To bring back the stock from 261 to 262 (reversal) and from 101 to 102 (Reversal) and again making 101 and 261 it is very very difficult task. Simultaneously to manage the regular purchase orders also very very difficult.

Please pass JV, as I told you earlier reply.

Ravi Polampalli