Forum Discussion

Noels1's avatar
Noels1
Contributing User
9 months ago

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 lo...
  • Mike_James's avatar
    Mike_James
    9 months 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.

Mike_James's avatar
Mike_James
Ultimate Cover User

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
9 months 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

 

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    9 months ago

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

  • gavin12345's avatar
    gavin12345
    Ultimate User
    9 months 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
      9 months 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
        9 months 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.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.