Forum Discussion

Noels1's avatar
Noels1
Contributing User
3 months 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 lo...
  • Mike_James's avatar
    Mike_James
    3 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.

gavin12345's avatar
gavin12345
Ultimate User

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
3 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 Partner
    3 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.

    • Noels1's avatar
      Noels1
      Contributing User
      3 months 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 :)