Why its not possible to have last known unit cost of inventory items for the items with zero quantity, I think that’s will be helpful and good idea to maintain unit cost visible all time unless there is a reason behind this behaviour.
Dear @palfal, no need for advance thanks, though you have raised very very pertinent point and I full agree and endorse it, as no one is going to take this serious. Inventory unit cost has ruined the whole working.
@palfal Manager won’t calculate unit cost for inventory items where Qty owned is negative or zero. Just wait until these items have some quantity. Then Recalculate button will put in unit cost and that unit cost will stay in there even after Qty owned eventually comes to zero.
Or you can open balance sheet report at the historical date and use Recalculate button within balance sheet. If those items had positive quantitiy owned as per balance sheet date, then Recalculate button will establish unit cost.
yeah but these items was having stock before but I think the time I register the purchase invoice I didn’t press the calculate button and I did the sale invoice for the item and that’s why it didn’t have cost price at cost worksheet … im guessing that the reason
@palfal yes, that’s correct. Recalculate button is to calculate book value of unsold inventory items. If all your inventory items are sold, then book value for your inventory on balance sheet is zero no matter what. There is nothing to calculate.