Forum Discussion

SherylMack's avatar
SherylMack
Experienced Cover User
11 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

8 Replies

  • 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
    Experienced Cover User
    11 months ago

    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
    11 months ago

    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
    Experienced Cover User
    11 months ago

    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

     

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    11 months ago

    Hi SherylMack,

     

    Thanks for the screenshot! What happens when you click "Yes" and proceed? After that, try checking the items again to see if there are any differences. Then we can look further into what's causing the warning message.

     

    Looking forward to hearing from you soon!

     

    Cheers,

    Princess

  • SherylMack's avatar
    SherylMack
    Experienced Cover User
    11 months ago

    Hi Princess - when I click "Yes" the period gets locked but then each time I click on Security the same message comes up.  I always tick "Yes" to continue and everything seems to be OK.  I have made the adjustments on the inventory value and can't see any issue with any of the items.  On the Purchase Register there is one order where stock has been received without the order being converted to a bill but the order is dated 25th July, which is after the period I am locking.  Thank you

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    11 months ago

    Hi SherylMack,

     

    Thanks for your response! If your reports are all okay and the issue only appears when you go to the security section, this might be a display error. You can try clearing your AccountRight cache before logging in again, as this sometimes resolves odd behavior in the software. If the warning message continues after clearing the cache, please partner with our live chat support team. 

     

    To connect with a live chat agent, please start by contacting our virtual assistant, MOCA, through myob.com/support. If MOCA is unable to resolve your issue, it will transfer you directly to our live chat team for further help.

     

    Cheers,

    Princess