The latest version (24.10.28) is streamlining workflow when using periodic inventory revaluation. Going to Reports tab, creating a revaluation worksheet, then viewing it, then copying results to new Inventory Revaluation etc. It’s too many steps. In the latest version, the number of steps has been…

@lubos there is still an issue with calculation of items that are produced not purchased even if production order got only one Finished Item and this is distorting the financial statements, and we also don’t know how much a product is costing us. Previously it would give us precise info about the co…

[image] shahabb: there is still an issue with calculation of items that are produced not purchased even if production order got only one Finished Item and this is distorting the financial statements, and we also don’t know how much a product is costing us. In the latest version (24.10.30) rec…

Thanks @lubos . Just checked its calculating it now but still the cost is not matching the avg cost of automatic revaluation (it is not due to FIFO). Apart from that also noticed the worksheet is also missing other costs such as duties etc where qty is zero just amount is entered. Any drilldown men…

[image] shahabb: Apart from that also noticed the worksheet is also missing other costs such as duties etc where qty is zero just amount is entered. Fixed in the latest version (24.11.1) [image] shahabb: Any drilldown menu to see from where these suggested costs are coming would be excel…

@lubos can you explain how these extra costs (duties freight etc) are applied in FIFO? In Average method it makes sense where the costs is added to the total value and divided by total qty but in FIFO it is applied to which invoice? As there is no option in allocating those extra costs to a Purchase…

[image] shahabb: how these extra costs (duties freight etc) are applied I assume those costs are distributed among all items on the invoice.

@Patch i am not talking about Freight-in buitin feature. [image] shahabb: qty is zero just amount is entered. What happens in this case. To which qty this cost is allocated? When is this capitalized cost expensed out? As it is not linked to any Qtyonhand/Qtyowned and in FIFO qty of older pur…

@lubos Checked different scenarios in a Test business and found that Recalculation screen carry those extra costs indefinitely and add those amounts whenever you are recalculating even if those costs are not relevant at that point. Yes it now takes those amounts into consideration but doesn’t expens…

[image] shahabb: Yes it now takes those amounts into consideration but doesn’t expense it out even when the qty is sold to which those costs belong. Actually it does expense them but it didn’t expense them proportionally. This has been improved in the latest version (24.11.2)

Can’t we do like a reverse line discount on purchased items that have duty? like Item Unit Price Qty Customs Duty Item1 10.00 10 10.00 Item2 5.00 5 5.00 This way you can assign the duty at the exact amount if you buy multiple items that have different duty rates.

Streamlined workflow for revaluating inventory items

Topic		Replies	Views
Added periodic revaluations for inventory items	31	1894	October 22, 2024
Added inventory cost correction workflow	23	1660	March 7, 2025
Added "Inventory Costing Calculation Worksheet"	19	1919	January 22, 2025
Inventory value of finished goods is getting wrong	20	457	February 27, 2025
Unit costs (problem)	159	3960	March 16, 2025

Streamlined workflow for revaluating inventory items

Related topics