Forum Discussion

KFAll's avatar
KFAll
User
11 months ago
Solved

No inventory on hand recorded or cost value despite Bill posted to item code

Bill was recorded to an Item code with 1 item received and a price of $125,000.00.  This Bill and $125,000.00 is recorded in the Balance Sheet stock on hand GL, but Item in inventory shows no stock on hand and no cost value.  So inventory valuation is out of balance by $125,000. 

 

This item does have a sales order against it, so is committed for sale.  Still a sales order not a sales invoice.

 

How do I adjust the inventory value from 0 to 1 and record 'last purchase price' in inventory item, without posting to GL.  GL is correct but inventory valuation is incorrect.

  • Mike_James's avatar
    Mike_James
    11 months ago

    Hi KFAll , try editing the bill and change the amount to $125,001, then record the bll, then edit it again and change the amount back again.

     

    Doe\s it appear on the stock record now?

5 Replies

Sort By
Replies have been turned off for this discussion
  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    11 months ago

    Hi, KFAll 

     

    Thanks for your post, and welcome to the MYOB Community Forum.

     

    If your inventory value reconciliation is out of balance, kindly check your Inventory Value Reconciliation Exceptions report and check the following:

     

    • Wrong feature used
    • Transactions allocated directly the the inventory asset account
    • Incorrect linked accounts

    These are the possible reasons why your inventory value reconciliation is out of balance. For further information regarding the issue, kindly check The Help Article: Receivables, payables or inventory out of balance.

     

    Please let us know if you require any further assistance with this. We are happy to assist.

     

    Best regards,

    Doreen

Related content