Skip to Content
author's profile photo Former Member
Former Member

MIGO - GRN Valuation issue

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


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 30, 2014 at 10:26 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2014 at 01:14 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 02, 2014 at 06:06 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 02, 2014 at 09:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 02, 2014 at 10:41 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 03, 2014 at 07:34 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.