Forum Discussion

Noels1's avatar
Noels1
Contributing User
2 years ago
Solved

Supplier Credit showing inventory error

Hi we are attemtping to put through a supplier credit but get the error message 'Processing this purchase would leave the item with no items on hand and a non-zero value in inventory.'

 

We have looked at the inventory item and the quantity on hand and the value match the credit, we have even processed the value to the four decimal places shown. Can you please assist.

  • Hi Noels1 , there is a long-standing fault with the way that MYOB processes sales returns,  in that it adds 10% to the returned stock value. So to get this right you'll need to reduce the stock item's value to 260.03, with an inventory adjustment,  then you'll  be able to process the supplier debit.

9 Replies

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    2 years ago

    Hi, Noels1

     

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

     

    This error means that while your inventory quantity will be zero, the value of the items you're adjusting would not return to zero. To correct the situation, please see the Help Article: Error: Non-zero value.

     

    Please let us know if you require further assistance.

     

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

     

    Best regards,

    Doreen

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

    Hi Noels1 , the tax-inclusive GST flag is ticked on the purchase. Take that off and re-do the line value, and it should go through. 

  • Noels1's avatar
    Noels1
    Contributing User
    2 years ago

    Hi Mike,

     

    Thank you for your response to my query. We have unticked the tax-inclusive GST flag as suggested and unfortunately we still get the same error.

     

    Kind Regards

    Noeline

     

  • Noels1's avatar
    Noels1
    Contributing User
    2 years ago

    Hi Doreen,

     

    We have completed the steps as suggested and the report balance matches the amount we are trying to credit. Is there anyway to see if it relates to more than 2 decimal places somewhere in the background?

     

    We have still been unable to process the suppliers credit note.

     

    Kind Regards

    Noeline

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

    Hi Noels1 , you also have to edit the line value to bring it back to -$286.03.

  • gavin12345's avatar
    gavin12345
    Ultimate User
    2 years ago

    Hi Noels1 

     

    Where are you getting the figures for the supplier credit? Are you reversing the original invoice amounts?

     

    The Item profile shows the value as $286.03 (this is the GST exclusive value). So you cannot remove all the items and only $260.03 of the gst exclusive value. You must remove $286.03 (plus GST). If MYOB doesn't allow you to do that, you will need to get a script run as the actual value might be something line $286.03000564.

     

    Regards

    Gavin

  • Noels1's avatar
    Noels1
    Contributing User
    2 years ago

    Hi Mike_James.,

     

    The original purchase from the supplier was for $260.03 +GST = $286.03 so that is what the supplier credit is showing.

     

    The item was then sold and returned. We have entered a refund to the customer for the exact amount that were sold and for the same price $484.80 +GST = $533.28.

     

    I am not sure why the item value is showing the GST inclusive amount, all transactions relating to this item show the GST exclusive amount until the customer credit was issued. I have checked and the customer invoice and credit are exactly the same.

     

    Regards,

     

    Noeline

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

    Hi Noels1 , there is a long-standing fault with the way that MYOB processes sales returns,  in that it adds 10% to the returned stock value. So to get this right you'll need to reduce the stock item's value to 260.03, with an inventory adjustment,  then you'll  be able to process the supplier debit.

  • Noels1's avatar
    Noels1
    Contributing User
    2 years ago

    Mike_James you are a legend, that worked! 

     

    I will type up some instructions so going forward the Accounts team know what needs to be done.

     

    Have a great night and once again thank you for your persistance with finding a solution.

     

    Noeline :)