Hi everyone,

I am facing an issue with inventory valuation reconciliation for products sold as bundles in Odoo v18. Here’s the scenario:

1. What I Sell:

I sell a bundle product (e.g., “Office Setup Kit”) that includes multiple components:

• 1 Desk (A)

• 1 Chair (B)

• 1 Accessory Set (C).

2. Customer Invoice:

• The invoice correctly shows the bundle (“Office Setup Kit”) as a single line item, which is what the customer expects.

• No problem here—the invoice is fine.

3. Inventory Movements and Valuation Accounts:

• On delivery (wh/out), inventory movements are recorded at the component level (A, B, C). This is correct because these are the actual stock items being deducted.

• However, in the journal entries for the inventory valuation account (account for outgoing inventory), Odoo registers the product as “Office Setup Kit” (the bundle).

4. The Problem with Reconciliation:

• When I try to reconcile the inventory valuation accounts (entries for inventory receipt vs. inventory outgoing), I need to match these at the component level (A, B, C).

• Since the outgoing inventory account reflects the bundle (“Office Setup Kit”) instead of the components, there’s a mismatch between the valuation of incoming and outgoing inventory, leaving unreconciled balances.

Has anyone encountered this scenario before or found a way to handle it? 

Any insights would be greatly appreciated.

Thank you!