I am requesting information about the best practice for handling a receiving scenario in NetSuite.
We use a handheld to receive inventory off purchase orders. When receiving with the handheld, there is no way to see the cost of the item that is received; it is simply received at the amount on the purchase order. We have found situations where the purchase order has an incorrect cost that is not discovered until we receive the bill. At that time, the receipt is already done at the wrong value and the items might have already moved through the system. We use NetSuite's vendor bill variance to catch small differences, but we need to know the best way to fix this if there are significant differences. For instance, we have an item that was received in at $10,800 (for qty 600) that should have been $108 (for qty 600). This receipt is causing inventory to be overstated and the average cost of this particular item to be artificially high.
The original thought was to use an inventory adjustment to adjust out the received items at the erroneous received cost and adjust back in those same items at the correct costs. However, we found that you cannot specify the cost for a negative adjustment. Negative adjustments will only adjust out the average cost as confirmed in the following article.
https://netsuite.custhelp.com/app/answers/detail/a_id/13279/kw/negative%20inventory%20adjustments/related/1
So that leaves us to try to figure out how to handle this kind of situation. I wondered if the approach would be to create the adjustment but use the figures that NET to the correct value?
For instance, if we added the items at $7.27/ea but they should have been $7.44/ea, we want the net amount of the adjustment to be $.17/ea. Therefore if the negative adjustment is automatically set to $8.58/ea, our positive adjustment should be using $8.75/ea. I don't know if this is the recommended way to handle the situation but this is only possible when the amounts are not significantly different.
But now take the first above scenario, we received 600 at the wrong price and now the average cost is 14.34. The qty 600 will adjust out at 14.34, but we need to adjust out a total difference of 10,692 and that is not possible using the previous method. In this case, how should we adjust out this amount to avoid an overstatement of inventory and COGS?