Track lot consumption across manufacturing process in Odoo

Many manufacturing businesses need detailed visibility into where and how product lots are consumed. That’s why we’ve developed the Product Lot Consumption Report—a new feature in Odoo that precisely tracks lot consumption across your manufacturing process.

What Does This Feature Do?

The Product Lot Consumption Report allows users to:

• View lot consumption details over time
  • See where a specific lot was used, how much was consumed, and the downstream products it helped create.

• Track consumption chains
  • For example, if Lot 123 was used to make widgets, which were later used in another manufacturing order, you can trace that full flow.

• Monitor lots with expiration dates
  • Lots’ expiration dates are also listed in the report, allowing you to accurately track when those lots expire.

How This Feature Works.

1. In the manufacturing model, go to Reporting > Lot Consumption Report >

1. Enter a product and select from the list of lots related to that product, or enter a desired lot number.

2. Select the desired start and end dates for the report range, then click “View Report”.

The report will show a list view of information related to how the lot was consumed, such as:

• Date
  • The date that the “Source” MO consumed items in the lot

• Source
  • The original Mo that consumed items in the lot

• Component Product
  • The product that the Source MO created

• Component Lot
  • The lot that the “component Product” went into

• Component Qty/UoM
  • The amount of “component product” produced

• Product Produced
  • The product that the “component product” was consumed to create

• Produced Lot
  • The lot that the “product produced” went into.

• Produced Qty/UoM
  • The amount of the “product produced” that was created.