Forum Discussion

Anna12's avatar
Anna12
Contributing User
3 years ago

Received item but On hand shows zero

Can anyone please help me to solve this inventory issues:

 

We have started our new business on 1st November 2021.

I have purchased item PackPC  x 5 on 14/12/21 and another 5 on 22/12/21. When I tried to use this item to build the product, the system shows Not enough item on hand. I looked at this itme Quantity On Hand, it only has 5 instead of 10 (please see attached screen shot - PackPC).

     When I looked at Item Register, the first purchase, Quantity 5, On Hand 0 (please see attached Screen Shot 

     I tried to print this Item Register, then it shows On Hand 10 (attached Item Register - PackPC)!

 

2. I purchased item Mochakenya 13.50 kg on 14/12/21. But Quantity On Hand shows only 3.375kg (please see attached Mochakenya). And item Register shows 13.50kg (please see attached Item Register - Mochakenya). 

    I was not able to use this item to build as system says not enough on hand quantity.

 

Appreciate your help in advance.

 

Anna

    

 

  • Can't laugh - after spending hours to try to figure out!

  • The_Doc's avatar
    The_Doc
    Ultimate Cover User

    Hi Anna12 

     

    Any Sales orders queued for the product - can you delete or zero the 2nd purchase on the 22/12 - and have a look at the item in inventory.

     

    Click each of the blue arrow links beside the 

     

    QOH

    Current Value etc to see the entries.

     

    Inventory can do some funny things but that seems weird - you have got autobuild working - have you got autobuild triggered to build a product from these items if it gets below a certain number.

     

    The Doc

    • Anna12's avatar
      Anna12
      Contributing User

      Thank you for your reply. 

       

      I deleted the entire sales order for the two products, the on hand quantities did not change. I tried to delete the two purchased but won't let me (please see attached).

      I tried to manually adj the inventry. But after adding the extra 5 for PackPC and 10.125kg for Mochakenya, I was still NOT able to built the product. 

      These two items don't have autbuild. 

      I've tried everthing, it does not seem to work.

       

      Anna

      • The_Doc's avatar
        The_Doc
        Ultimate Cover User

        Hi Anna12 

         

        The fact that you cannot delete PackPC purchases means you have underlying sales orders - or something that has now grabbed them.

         

        As per my suggestion - go to the item and click each of the blue drill downs and see what shows - 

         

        The Doc