Skip to Content
avatar image
Former Member

Physical invemtory Book Quantity

Hi Experts,

user has created and posted a physical Inventoty on 05/06/2010.

In physical Inventory document it is showing the book quantity as 3,283.

where as in the report MB5B for the posting 05/06/2010 it is showing as 897.

User has counted the quantity physically in storqage location which is 783 and entered in the PID.

by the efect the of posting of PID 783 ,a material document is generated for -2500.

My issue is why MB5B report is showing quantity as 897 for the posting date.

and why PID document is showing book quantity as 3,283 on that posting date.

early feed back is greatly appreciated....

Regards,

Laxmi....

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 25, 2010 at 07:21 AM

    Hi,

    If you see the stock on posting date that will show only particular date Inventoey.

    Check MB52.

    SAM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Chcek with MB51 report ,do analysis for that particular material in that period .Then you will come to know what went wrong.

  • avatar image
    Former Member
    Jun 25, 2010 at 09:04 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      From my previous physical Inventory experience, MB5B does not count stocks with Vendor.

      If your company has stocks provided to vendor, please check the quantity for this.

      This can be one of the reason of discrepancy.

  • avatar image
    Former Member
    Jun 30, 2010 at 03:46 PM

    Hi Experts,

    Any feed back on this.please give me your valuable feed back.

    I lookng in ti the MB51 report where my posting date and Entry dates are different .physical inventory document date is 06/05 and where as my Material document

    Document Date = 06/05

    posting date =06/05

    Created on = 14/05.

    From the above on which date stock is updated as Book quantity in PI document.

    Regards,

    Laxmi.....

    Add comment
    10|10000 characters needed characters exceeded

    • it depends on settings you use to create the physical inventory document.

      as it is a longer story, please read the OSS Note 368296 - How does the system determine the book inventory?

      and Note 202834 - Determ. of book quantity within physical inventory