Inventory Count Update Using the Variance Module

Follow

Comments

12 comments

  • Avatar
    confluence

    Guys & Gals,

    This method of counting inventory has a major flaw:  There is no way to catch the items that show inventory in the database but actually have 0 on hand.

    If the item is not scanned at least once, it will not be adjusted.  So for example if a particular item is lost/ stolen and there was only one.  It will still show 1 in inventory after the variance count.  

    There needs to be a reference set generated before the count. 

     

  • Avatar
    Ty Clement

    Hello, thanks for comment. We actually just recently discussed the need for the same thing. We were thinking of tracking and displaying non-adjusted inventory after an upload. This would allow you to see things that were not changed, and allow you to make the necessary updates to those items. Would that work for your needs?

  • Avatar
    Gail

    YES!!  Thank you confluence who ever you are- this is exactly why we have not had accurate inventory counts-  You definitely need some kind of a way to show what was not counted that still shows up in inventory.  Thank you!!! 

  • Avatar
    Ty Clement

    Gail, thanks for your feedback as well! 

  • Avatar
    Gail

    Hi Ty - do we have anything we can do to address what was not counted?   Has this idea you mentioned before been implemented?  Thank you.

     

    "We were thinking of tracking and displaying non-adjusted inventory after an upload. This would allow you to see things that were not changed, and allow you to make the necessary updates to those items. Would that work for your needs?"

  • Avatar
    Ty Clement

    Gail,

    It's been discussed and submitted however the development team has not yet started on it. Some factors we consider when prioritizing tasks like this are the following:
    - The amount of people requesting a particular feature.
    - The amount of people it will positively impact.
    - The complexity of the project or the length of time it will take to complete.

    Let me know if you have any other questions!

  • Avatar
    Gregg Ostrom

    Hi Andy. Thanks for the overview. Could you clarify the terms "Inventory Count" and "Current Inventory?" My intuition tells me the definitions are flipped in the article.


    The variance math and reporting make more sense if Current Inventory is the system quantity, and Inventory Count = scanned and uploaded quantity. Right?

  • Avatar
    Andy Wheeler

    Hi Gregg,

    You're exactly right, I had those switched around! Thanks for pointing that out, I'm fixing that now.

    Thank you!

  • Avatar
    Gregg Ostrom

    I know the Variance Module does not like a blank (null) field. Could you confirm that uploading Count = 0 is allowable?

  • Avatar
    Ty Clement

    Gregg, that's correct. Setting an item as 0 will work. You may consider looking into the Batch Module as that has an option to automatically add in all unscanned items and set them to 0 inventory. 

  • Avatar
    Gregg Ostrom

    Thanks, Ty. Good tip on the Batch Module. Maybe we'll try that next time around. At this point, Variance Model appears to have more robust (and exportable) reporting.

  • Avatar
    Kristi Villani

    I'm wondering if there is an update to the above question. I'm doing an inventory count and having trouble because I want the sold out items to be zeroed out so the batch module makes sense. However, the variance module makes sense in other ways. Accuracy is very important to me.

     

Please sign in to leave a comment.