Delete a bill that has received stock

Hi sueby01 

That error message is essentially letting you know that the dollar value of the inventory must be equal to or over the value shown on the bill. Without knowing all the details of your inventory on that item and its value, consider this example:

Assume your bill is for 130 items at $2 per item. That stock of 130 has a total value of $260. To do a straightforward adjustment of -130, you must have inventory on hand equivalent to or exceeding that amount, and it must be valued at the equivalent or exceeding amount. In other words, you wouldn't be able to delete the bill for 130 items if you only had 120 on hand, and you wouldn't be able to make a -130 adjustment if the dollar value of the stock on hand is less than $260.

So if your on hand quantity and/or on hand dollar value is less than what is showing on that bill, the adjustment would not work and you would receive an error.

To correct this, please do the following. Increase the quantity of that item by 1 over what you see on the bill, i.e., make an adjustment for +131 on hand. Then, increase the total value to $1 more than what's on the bill. In the example above, if each item is $2 and the total value on the bill is $260, you would increase the total value in AR to $261 (do this as it applies to the dollar value on your bill). This should now allow you to delete the bill because you have more on hand quantity and value than what is shown on the bill. When you delete the bill, you will still have 1 item valued at $1 left. Lastly, in a seperate adjustment, you can reduce the on hand quantity by 1 and the on hand value by $1, leaving you with 0 items at $0. 

Let me know how that goes for you and if I can be of any further assistance.

Thanks Emily! All fixed

Hello sueby01 

To correct this, you can to an inventory adjustment to increase the stock you have on hand to reflect the amount on the bill. Please have a look at this Help Article: Making inventory adjustments and follow the steps listed. You should then be able to delete the bill as needed. Please do let me know if I can assist further.

Hi Emily,

The bill automatically entered the stock as received. I was meant to order 130 items as we have nil and our inventory is showing as 130. If I decrease the inventory by 130 will it affect our costings?

I have followed link and done as stated but it comes up with an error message saying "The value of your inventory must be less than zero". I have decreased inventory by the exact amount i have entered on bill

i had previously tried to decrease stock by exactly same quantity and cost in adjust inventory and received error message. I have just increased stock by 1 item and same costing as bill which processed ok. I then went into adjust inventory and decreased qty and price by exactly same amounts as bill but i am still getting error message stating "the value of your inventory must not be less than zero" even though i am decreasing by 130 and inventory shows as 131 in stock. Sorry to be a pain :(