Forum Discussion

BNS's avatar
BNS
Contributing User
2 years ago

Error Not Enough Items on Hand to Record Transaction

I am trying to process a write-off (inventory adjustment) for an Inventory Item that has a quantity of 2 with a total value of $7.14. I am getting an Error message saying "You do not have enough of item on hand to record this transaction". It is Consignment Stock with us as the Consignor so in a separate Inventory Code to normal inventory.

 

I have tried Inventory Adjustment to expense code, Inventory adjustment to another inventory code, processing invoice to sell the 2 items. Nothing has worked.

 

See attached screenshot of balance in Item Register, copy of Inventory Adjustment and Error message received. 

 

How do I fix this error to clear this stock?

 

8 Replies

  • Hi BNS

    Thanks for your post and welcome here to the Community Forum. Thank you for expressing your concern to us and for providing a screenshot. We apologize that you are having difficulties with the error you are receiving, and we appreciate your patience on this matter. 

    If you encounter this error, it could be related to the quantity on hand for your item. You may check our article titled "Error: Not enough items on hand to record these transactions" for more information and instructions. The article guides you on which report to review and compare with the transaction you're attempting in the software.


    Please do not hesitate to post again if you need help in the future. 

    If my response has answered your enquiry, please click "Accept as Solution" to assist other users find this information. 

    Cheers,   
    Leneth

  • BNS's avatar
    BNS
    Contributing User
    2 years ago

    Hi Leneth,

     

    Thanks for your email. It didn't help me though. You can clearly see from my attachments that the system shows there are 2 items of inventory in MYOB. What would be your next fix for this issue?

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    2 years ago

    Hi BNS , go to the Inventory, Item List, edit the item and see what values are displayed for Qty and on hand value. If they are different, try using those values for the adjustment.

  • BNS's avatar
    BNS
    Contributing User
    2 years ago

    Thanks for your response Mike. Unfortunately it didn't help as it showed zero items on hand with zero value so nothing to adjust. Reports are all still showing 2 items on hand with a value though. Any ideas how to do it when the Item list says no items on hand?

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    2 years ago

    The item information screen is probably correct. The reports that may agree are the item register detail and the inventory value reconciliation report. 

  • BNS's avatar
    BNS
    Contributing User
    2 years ago

    Yes but unfortunately it is showing on my Balance Sheet as a separate line item which is why I need to clear it up. Makes me think maybe the item list isn't correct at all.

     

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    2 years ago

    Hi BNS, the inventory value reconciliation report shows each asset account separately. For that account, does it show a stock total of nil and a GL amount, therefore the same amount as out of balance? If so, just write off the GL value to cost of sales.

  • BNS's avatar
    BNS
    Contributing User
    2 years ago

    Hi Mike. Thanks again for replying.

    The inventory value reconciliation report shows a value for the asset which agrees to the GL amount in the report (so no out of balance amount). This also agrees to the Balance Sheet of course. The Item List Report however, shows zero on hand and zero value so I can't process an inventory adjustment or a sale to clear the amount in the Balance Sheet. If I process a journal to clear it from the Balance Sheet, then I will have an out of balance amount on the inventory value reconciliation report.

    Is it something that MYOB needs to log in and fix?