The latest version (25.1.3) introduces a new report under the Reports tab called Inventory Costing Calculation Worksheet. [image] This report is designed to calculate the unit cost of your inventory items as of a specific date and based on a specific valuation method—currently, FIFO or WAC. [ima…

HI @lubos , My COGS is messed up again after i do the inventory costing calculation, as shown in this picture, i have restart my cloud server and the issue still there. [image] Shown = 37,241,574, but that’s not correct COGS, and when i clicked on it, shown like this = [image] I have sent you a…

Even after removing the Costing Calculation & Restart the Cloud, the issue still remain the same @lubos

[image] lubos: Drilling-down is partially broken when using custom cost of goods sold accounts. Working on it. We look forward to your proper update on this. More grace to your strength

[image] lubos: Drilling-down is partially broken when using custom cost of goods sold accounts. Working on it. Please also look bugs here >>> Anomaly number in COGS account I see the drill down consist of opening, purchase and closing. As addition for your work in drill down, please create s…

[image] lubos: meaning updates to the inventory costing algorithm could retroactively change figures @lubos The current algorithm for calculating WAC is same as the one used in automatic recalculation or it has been changed? Because the calculated cost on Production Order differs from the cos…

[image] ejjaadiargo: As addition for your work in drill down, please create some feature that we are still able to see the details in dropdown regard the COGS that have been recognized/used, not only opening, purchasing and closing This won’t be possible. The reason why I’m moving to COGS = O…

[image] lubos: The point is decoupling these complex calculations from general ledger so if there are improvements to any inventory costing algorithm, it won’t impact historical general ledger figures. so what is going on below? This picture below is coming from PnL Statement on COGS account…

[image] lubos: The point is decoupling these complex calculations from general ledger so if there are improvements to any inventory costing algorithm, it won’t impact historical general ledger figures. That is great news! However, I still think that a lot has be left on the table. Most other…

[image] Ealfardan: Idealy, every batch should have its own cost known otherwise why bother using Manager to record production. Yes that’s good. Should in FIFO counted based on every single batch per item in inventory. So if user wants to use the item, the inventory unit cost determined by whi…

Added "Inventory Costing Calculation Worksheet"

lubos January 3, 2025, 3:07am 3

Drilling-down is partially broken when using custom cost of goods sold accounts. Working on it.

Unit costs (problem)

Topic		Replies	Views
Added inventory cost correction workflow	23	1687	March 7, 2025
Unit costs (problem)	159	3987	March 16, 2025
Streamlined workflow for revaluating inventory items	11	1722	December 21, 2024
Added "Cost of sales" to sales invoices tab	19	633	February 17, 2025
Added ability to batch recalculate inventory costs	8	2337	October 15, 2025

Added "Inventory Costing Calculation Worksheet"

Related topics