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 o...
  • 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?

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

  • KFAll's avatar
    KFAll
    User
    11 months ago

    Hi Doreen_P 

     

    Thank you for your suggestions.

     

    The Inventory Value Reconciliation Exeptions report does show the total out of balance is $125,000 but the items list on the report are small values from a few years ago.

     

    The entry was a Bill which the stock item 1509 was used.  I have checked Stock item 1509 linked accounts and they appear correct.  When I check the History tab in Item 1509 the purchase on 23.2.2023 does not show in the month of Feb 2023.

     

    I can see the PJ entry for the Bill recorded in the Inventory GL 1-1340 but no value or quantity is recorded in item 1509.  attached are screen shots.

     

    Any other suggestions please?

     

    Thanks

     

    • Mike_James's avatar
      Mike_James
      Ultimate Partner
      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?

Related content