Hi, when you do a stock adjustment it does update the actual cost but not the last cost like it does when you do a stock receipt. You can update the last cost with an import scenario.
When you say you have an stock item with cost and no qty I assume you are using Standard Costing method? If you are not using Standard costing method have you tried to Recalculate Inventory Balances?
Hi @byates
For your question#1, you can do an inventory cost adjustment. Refer to the following thread.
If you want to remove all inventory and then bring it in with new cost, you can do an inventory issue document and then an inventory receipt. Or inventory adjustment with negative quantity to remove and then with positive quantity to bring it in.
For question#2, on what report have you noticed the value with no quantity ? This should not have happened. You may run ‘Recalculate inventory’ for specific item and warehouse and check the numbers again.
Regards,
Hi @byates
For your question#1, you can do an inventory cost adjustment. Refer to the following thread.
If you want to remove all inventory and then bring it in with new cost, you can do an inventory issue document and then an inventory receipt. Or inventory adjustment with negative quantity to remove and then with positive quantity to bring it in.
For question#2, on what report have you noticed the value with no quantity ? This should not have happened. You may run ‘Recalculate inventory’ for specific item and warehouse and check the numbers again.
Regards,
@vkumar thanks for the reply. Regarding #2, I am seeing that on all of my Validation reports. More specifically, on the Historical Inventory Valuation report. I am not seeing a “recalculate Inventory” process in my IN module. Perhaps it is somewhere else? I have run the “Validate Inventory” and included “rebuild item history” but that did not correct the costing issue.