The confusion of adding up without signs or uniform units
When the inventory team of a mid-sized company reviews the Odoo valuation report, they run into a typical problem: quantities appear without a positive or negative sign, and they mix different units of measure. For example, imagine a product handled in units and in dozens. The report shows an inflow of 10 units, another of 2 dozen, an outflow of 3 units and an internal move of 4. Adding everything up gives 19, but the real stock is very different. A novice analyst could report 19 units to their boss, causing confusion and bad decisions. Moreover, internal moves (shown in black) do not affect stock, but they are included in the total, making the result worse.
The new valuation report: MOF analysis
Odoo has replaced the old valuation report with MOF analysis. Although it visually distinguishes inflows (green) and outflows (red), the quantities still have no sign and the total does not reflect reality. In a distribution company, the inventory manager needed to validate end-of-month stock with the accounting team. When adding up the period's moves, they got a number that did not match the physical count, causing rework and loss of trust. The reason: the report does not account for inflows having to be added and outflows subtracted, and it also mixes units of measure.
The solution: Quantity column for Cardex (Cardex UTI)
The Quantity for Cardex column (also called Cardex UTI) solves all these problems. This column shows inflows with a positive sign and outflows with a negative sign, assigns zero to moves that do not affect stock (such as internal moves in black), and restates all quantities in the product's main unit of measure. For example, for the previous product: an inflow of 10 units (+10), an inflow of 2 dozen (+24 units), an outflow of 3 units (-3), an internal move (0). The total is 10+24-3 = 31 units, which matches the real stock. At the distribution company, using this column, the manager was able to quickly reconcile the period's moves with the final stock, and accounting approved without objections. Ganemo offers this functionality as part of its inventory maintenance, ensuring the data is reliable and auditable.
Direct reconciliation with current stock
The real value of this column is that it lets you reconcile the sum of all historical moves with the product's current stock. For example, if the total of the moves in Cardex UTI is 32 units, checking the product's current stock in Odoo (for example, in the On Hand Quantity field) must match. At a company that went through an external audit, the auditor asked for support for the reported stock. Using Cardex UTI, the inventory team showed that the sum of all moves (properly signed and in the same unit) gave exactly the current stock, demonstrating traceability and precision. Ganemo, as an implementation partner, recommends this practice to avoid discrepancies and make audits easier.
Availability and access
This functionality is available in the Odoo App Store under the name shown in the video. If you are a Ganemo client with inventory maintenance, all the inventory features included in that maintenance are already available to you. You can install it directly or ask your Ganemo advisor to do it for you. It is one of the most requested apps. If you are a member of any Ganemo membership or partner program, you have an exclusive preferential discount. Request your quote to get the corresponding discount.