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

Simple way to make physical inventory easier?

Currently doing inventory is very painful for us. Originally we would scan everything once we received the docs and scanned everything manually and whatever we couldn't find we had to start scrounging around for. Now if we are missing anything they are going to lock down shipments of that material number until we find it or have it marked as lost which is going to be extremely painful so I have started exporting an excel sheet of what we are supposed to have in our room and manually going through each one and then when I have a list of missing items I talk to my team to try and find it until we have everything. Does anyone have a faster/easier method of doing this? Doing it manually takes multiple hours just to redo it when it really is time to do physical inventory (which admittedly is faster since I just copy and paste from excel the serials).


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 14, 2016 at 04:01 AM


    For any material, you have particular material number or material code- Just cross check booked material stock with material number or material code( MMBE,MB52 and MB5B) in system and compare actual stock for that material number or material code from site/storage location- Any mismatch on material stock go for physical inventory with MI01, MI04 and MI07

    If more material numbers or material codes involved, then all the materials stocks to be checked, verified, counted and then corrected with physical inventory only.


    Biju K

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      The amount of equipment we have going in and out on a daily basis has us being forced to do monthly physical inventory vs quarterly. Monthly inventory counts all the materials used and we have to count all the serials vs quarterly where we only count serials when there is a discrepancy with the amount of materials.
      Is there maybe an excel add-in that can be used or something where i can just quickly scan everything and whichever is scanned gets hidden or highlighted so it's easier to view missing items to look for? Maybe a different type of scanner we can purchase to help with the process?

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.