Hi everyone, I recently training to check on my inventory list in “Inventory Items” tab and i discover that some items that is zero in qty is showing total cost which is not normal. I count this as a bug and please look into it on time. below is the screenshot of what am saying, look at column tha…

Are you using FIFO valuation method?

No i am using Weighted Average Cost

This issue you mentioned i have faced with FIFO not with weighted average valuation. Anyway try this it may work. [image] There is no technical support to solve problems and there is no benefit from the forum Go to balance sheet to the period when these items were last available. Then recalculat…

There is edge case where this could happen. In the latest version (25.1.6), the program will ensure if Qty owned is zero, then Total cost will be also zero. Otherwise it will be a function: Total cost = Qty Owned multiplied by Unit cost

Why not make recalculate button start calculating from the start and make a unit price entry for every in and out of each item? Currently it calculates it for the last available cost (if qty is not zero). This way unit price of every item will be up to date at any date in a period and will match the…

in inventory account’s not everything must done by just a click, it must be evidence and running balances “value and qty” to avoid any trust issues, NUMBERS DIDN’T LIE @shahabb @lubos

Inventory Items showing total cost for zero inventory

shahabb January 5, 2025, 4:09pm 4

This issue you mentioned i have faced with FIFO not with weighted average valuation. Anyway try this it may work.

Topic		Replies	Views
Inventory items - unit cost visibility	12	392	March 20, 2025
Unit costs (problem)	159	3984	March 16, 2025
Added inventory cost correction workflow	23	1675	March 7, 2025
Inventory Write-Off Cost Evaluated to Zero	7	211	February 3, 2025
Inventory profit margins are showing profits for items i have not sold	18	297	February 13, 2025

Inventory Items showing total cost for zero inventory

Related topics