Skip to main content

Process Flow — Field Notes to Odoo Mapping

This page translates VGC's hand-drawn process flow ("Existing Finished Good → New Finished Good (Coffee)") into the Odoo MRP concepts that will implement it.

Side-by-side mapping

Hand-drawn stepOdoo conceptNotes
StartTrigger: planning team confirms a Sugbo production run
Existing Coffee Blend (e.g. Blu Espresso Blend 500g)BOM ComponentSame product is also a sellable SKU. type=product, purchase_ok=True, sale_ok=True
Item requested & approved → Roastery Raw Materials InventoryInternal Transfer (Main WH → Roastery RM) gated by blu_mrp approval wizardNew custom step — see Open Questions re: who approves
Existing blend opened, ground to desired size, measured to desired weightWork Order 1: Grinding at Roastery — Grinding work centerCost = labor + electricity + equipment depreciation per hour
Weighed coffee grounds repackaged to coffee pouchesWork Order 2: Repackaging at Roastery — Packaging work centerConsumes Coffee Pouches BOM line; cost = labor per hour
Repackaged ground beans transferred to Main WarehouseMO Finished Move: Roastery WIP → Main WHAutomatic on MO completion
New SKU for Coffee Blend (e.g. Sugbo Blend 70g)Finished Product of the BOM/MOmanufacture route enabled
EndMO state = Done; Sugbo Blend 70g now sellable

Stock movement diagram

┌────────────────┐ Internal Transfer ┌──────────────────────┐
│ Main Warehouse │ ──────────────────────► │ Roastery / Raw Mat. │
│ Blu Espresso │ (approval gated) │ Blu Espresso 500g │
│ Blend 500g │ │ Coffee Pouches │
└────────────────┘ └──────────┬───────────┘

│ Manufacturing Order

┌──────────────────────┐
│ Roastery / WIP │
│ (production loc.) │
│ │
│ Op 1: Grinding │
│ Op 2: Packaging │
└──────────┬───────────┘

│ MO finished move

┌──────────────────────┐
│ Main Warehouse │
│ Sugbo Blend 70g │
└──────────────────────┘

Inputs captured at each step

The hand-drawn flow annotates two work-station inputs:

Grinding station inputs

  • Labor — operators feeding the grinder and weighing portions
  • Electricity — grinder power draw
  • Use of space and equipment — depreciation / overhead allocation for the roastery floor and grinder

These three are bundled into the Roastery — Grinding work center's cost_per_hour. See Costing for the breakdown formula.

Packaging station inputs

  • Coffee Pouches — physical material consumed; modeled as a BOM component
  • Labor — operators sealing and labeling pouches

Coffee Pouches is a BOM line. Labor is the Roastery — Packaging work center's cost_per_hour.

Approval gate

The "Item requested & approved" callout in the field notes maps to a custom raw-material requisition wizard in blu_mrp:

  1. Roastery operator (or production planner) opens the wizard, selects target SKU + quantity
  2. Wizard previews the BOM expansion (how much Blu Espresso 500g, how many pouches)
  3. Wizard creates the Internal Transfer in draft state
  4. An approver (group blu_roastery_approver_group) confirms — transfer moves to assigned
  5. Stock is moved to Roastery RM, MO is created and ready to start

See Open Questions for what remains undecided about the approval flow.