Forum Discussion

SherylMack's avatar
SherylMack
Contributing Cover User
2 months ago

Negative on-hand Inventory quantities or items received without a bill

Hi - when I try to lock a period (in this case - 1st July 2024) I am getting the message screenshotted on the attached.  I can see this has been asked a few times before in this forum and I have tried the suggestions that have been provided.  I have run numerous reports and cannot see any negative on-hand items.  There are however, 2 with an negative on-hand value of just -$3 and 1 with a -$.01  These have been screenshotted on the attached.  I have also looked at the Purchase Register to see if stock on an order has been received.  This is the case for an order dated 25th July but I am trying to lock the period prior to 1st July.  Would this be causing the issue?  A screen shot is included on the attachment. The Order that has been received is a completely different inventory item to those with the negative value.  How do I find the offending inventory item and then how do I fix it?  Thank you

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator

    Hi SherylMack,

     

    The values of the report and the error message can help a lot with making sense of the problem. Thank you for the screenshot. Normally, items with 0 on hand quantity should also have 0 current value in the inventory. This is likely what's causing the issue. I recommend creating an adjustment or adjustments to make the current value of these items to zero. 

     

    Let us know if you need any further help. We're happy to offer insights. 

     

    Thanks,
    Genreve

  • SherylMack's avatar
    SherylMack
    Contributing Cover User

    Hi - I have created an adjustment journal dated 30th June for the items with the negative value and the report is no longer showing any negative values.  However, when I go to lock the period up to 30th June, I am still getting the same message.  Will it impact the file in any way?  If not, I guess I may just have to live with it. 

    • Princess_R's avatar
      Princess_R
      MYOB Moderator

      Hi SherylMack,

       

      Thank you for trying to adjust your inventory! Based on the screenshot provided, the warning message you are seeing should indeed be resolved with a script fix. I have applied the fixed script to your file. Please double-check your items again and let me know if the warning message persists.

       

      Cheers,

      Princess

      • SherylMack's avatar
        SherylMack
        Contributing Cover User

        Hi Princess

        Thank you for applying the script, however, I am still getting the warning message when I go to lock a period.  See screenshot below