Hello guys,
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.
Thank in advance.
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.
@lubos could you please comment here
Improved in the latest version (25.2.5). You will see last unit cost even if Qty owned is zero.
@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.
You have already enabled Average cost column (4th one).
average cost is showing the cost before tax and if I bought an item and got discount for it the average cost goes different, but unit cost was showing the cost after tax even if I purchased an item and paid for it or got full discount. and this point is very important to me for limited access users usage.
@lubos
You got it wrong. Tax got nothing to do with Inventory item value. The tax amount goes to Tax accounts. So on inventory tab you will only find the value of item without tax.
Still if you want to see value before and after tax then you need to find it on other tabs like Payments and Purchase Invoices.
However, if you click on Total cost figure of an item you will get the Unit cost value of an item which is again before tax.
First I don’t know where to enter the screenshot you have sent.
2nd, I can access and see the inventory unit cost but the limit access users can’t and I want them only show the cost after tax. It was appear at inventory items section and working normally then suddenly disappear.
