rzyfront/vendix-inventory-valuation

Vendix Inventory Valuation

Purpose

Use this skill for inventory value, historical inventory value, COGS, cost layers, and valuation reports.

Core Rules

• Quantity source of truth is stock_levels.
• Current valuation must use actual stock cost, not products.cost_price as the primary source.
• Historical valuation must use valuation snapshots or movement cost snapshots; stock_levels alone is only current state.
• COGS must be calculated from the stock/location actually consumed.
• CPP and FIFO must affect stock exits, COGS, adjustments, transfers, and valuation.

Costing Rules

• CPP/weighted average uses stock_levels.cost_per_unit.
• FIFO uses inventory_cost_layers ordered by received_at ASC.
• Purchase receipts create/update cost and cost layers.
• Negative stock movements consume cost before/while mutating stock.
• Positive adjustments need an explicit or fallback real cost; never use placeholders.

Snapshot Rules

• Record valuation snapshots after stock mutations.
• Snapshot dimensions should include organization, store, accounting entity, location, product, variant, operating scope, costing method, quantities, unit cost, and total value.
• Historical reports must query the latest snapshot at or before as_of for each stock key.
• Data before snapshot rollout is best-effort only unless enough movement/cost history exists.

Accounting Alignment

• Purchase receipt: DR 1435, CR 2205 using received value.
• Sale COGS: DR 6135, CR 1435 using consumed cost.
• Shrinkage: DR 5295, CR 1435 using local consumed cost.
• Surplus: DR 1435, CR 5295 using real input cost.
• Entries must resolve the correct accounting entity from operating scope.

Related Skills

• vendix-inventory-stock
• vendix-accounting-rules
• vendix-auto-entries
• vendix-operating-scope
• vendix-prisma-migrations