Raw Material Issues
1. Overview & Purpose
What are Raw Material Issues?
2. When to Use Raw Material Issues
Physical Ingredient Dispensing & Scale Weighing (Staging Bay)
Warehouse team dispenses and weighs 500kg of flour and 100kg of butter from raw storage racks, staging them at the mixing room loading bay.
Supplementary Material Requisition due to Floor Spillage
A mixing vat leaks during blending, causing loss of 15kg of liquid eggs and requiring an immediate supplementary ingredient requisition to meet nominal yield.
Ingredient Lot Number Traceability & Quality Audit Compliance
Food safety compliance mandates recording the exact supplier lot codes of dairy and active yeast consumed in each commercial batch.
Automated OUTBOUND Stock Deductions & WIP Value Capitalization
Ensuring digital raw inventory immediately decrements while transferring component costs into the Work-in-Progress balance sheet account.
Unconsumed Raw Ingredient Floor Return to Warehouse
Excess 10kg of sugar dispensed for a run is not consumed and needs to be returned to active dry storage racking.
3. Data Dictionary & Fields
Schema structure for the production_material_issues ingredient staging table:
| Field / Column | Input Type | Requirement | Description & Operational Guide |
|---|---|---|---|
issueNumber | STRING(50) | Required | System-generated unique material requisition code (e.g. MI-20260522-001). |
productionId | BIGINT (FK) | Required | Reference to parent production run work order. |
issueDate | DATE | Required | Timestamp when raw materials were weighed and released to manufacturing floor. |
status | ENUM | Required | State: DRAFT, POSTED, REVERSED, CANCELLED. |
notes | TEXT | Optional | Dispensing notes, lot observations, or scale calibration tags. |
4. Interface Preview
Raw Material Issues console displaying issue numbers, linked production run codes, and warehouse stock deduction triggers.
Screen Preview: Raw Material Issues Console Interface
Visual interface illustration and control layout for menu Route: /admin/production/material-issues
5. Issuing Raw Materials
Open Material Issues Console
Navigate to Production > Material Issues from sidebar.
Select Active Production Run
Click Add Material Issue and pick target work order; BOM lines populate automatically.
Confirm Weighed Quantities
Verify physically weighed ingredient quantities against standard BOM requirements.
Submit & Post to Stock
Click Submit & Post to deduct raw stock from warehouse and transfer value to WIP.
6. Scrap & Actual Usage Variances
Review Issue Slips
Print material requisition slips for warehouse picking records.
Analyze Material Variances
Compare actual material issued vs theoretical standard BOM consumption.
7. Posting & Reversal Rules
Completed Run Inviolability
Material Issue Reversal
If incorrect ingredients were posted, execute Reversal to return stock to warehouse.
8. Cross-Module Impact
| Target Subsystem | Relational & Transactional Effect |
|---|---|
| Inventories & Stock Balances | Directly triggers OUTBOUND stock movement with PRODUCTION_ISSUE type, reducing raw material balance. |
| Production Work Orders (Runs) | Updates total material cost consumed by the work order for accurate COGS calculation. |
| General Ledger Accounting | Debits Work-in-Progress (WIP) asset and credits Raw Materials Inventory asset. |
Operational Best Practices
- Always mandate scale tare verification before recording weights of bulk liquid or dry ingredients.
- Issue materials batch by batch rather than issuing whole-week estimates to prevent floor shrinkage.