Lot management and container management
This section explains the lot management and container management systems, including lot number naming conventions, process-level traceability, and container state transitions.
Purpose of this feature
In manufacturing, it is crucial to be able to track "which raw material lot this finished product was made from" and "which product the defective raw material ended up in." Lot management and container management is a system that records the entire process from raw material receipt to finished product shipment as a single continuous line.
This article will provide a comprehensive explanation of the following four screens and functions.
| Screen/Function | Purpose | URL |
|---|---|---|
| Lot data entry | Record lot number upon completion of each process | /app/lot-work-entry |
| Container Ledger | List and Status Check of Containers | /app/container-commit-view |
| Traceability Graph | Visualizing the sequence of lots | /app/commit-link-graph |
| Container Inventory Ledger | Inventory Trend Report by Container Type | Report Screen |
What is a "container"? Here, "container" refers not only to physical tanks or boxes, but also to a unit for managing the status of work-in-progress in lot units. On the screen, the quantity and process progress are recorded for each container.
Lot Number Naming Convention
Lot numbers are assigned in three different formats depending on the manufacturing stage.
| Type | Prefix | Form | Example | Explanation |
|---|---|---|---|---|
| Raw Material Lot | R | R{年月日}-{連番} | R260302-01 | R (Raw) + Year/Month/Day + Sequential number in order of arrival |
| Work-in-Progress Lot | W | W{年月日}-{工程記号}{連番} | W260302-A1 | W(WIP) + Date + Process Symbol + Serial Number |
| Finished Product Lot | None | {年月日}-{ライン記号}-{連番} | 260302-A-01 | Date + Line Symbol + Serial Number |
Process symbols and line symbols are registered in the equipment master as follows: "A = Immersion", "B = Steaming", "C = Inoculation", "D = Fermentation".
Container condition
A container (work-in-progress in lot units) goes through three states.
| State | Meaning | Situation |
|---|---|---|
| Available | Ready to use in the next step | After the step is complete |
| Processing | Currently being used in time-consuming processes such as fermentation | Waiting until discharge |
| Consumed | Used up in the next process, or shipped | Process completed/shipped |
Image of state transitions
利用可能 → (処理中)→ 利用可能 → 消費済み
Discontinuous processes such as fermentation involve a step where the status changes to "processing" and then returns to "available" upon completion of the process.
Manufacturing Flow (Lot Tracking by Process)
Overall Flow
graph LR
subgraph 原料受入
A["R260302-01<br/>黒豆 3000g"]
end
subgraph 初工程_浸漬
B["W260302-A1<br/>浸漬完了 60個"]
end
subgraph 中間工程_蒸煮
C["W260302-B1<br/>蒸煮完了 60個"]
end
subgraph 中間工程_接種
D["W260302-C1<br/>接種完了 60個"]
end
subgraph 最終工程_発酵
E["260302-D-01<br/>発酵完了 60個"]
end
A -->|親| B
B -->|親| C
C -->|親| D
D -->|親| EOperation of each step
1. Receiving raw materials
| Item | Operation |
|---|---|
| Lot number | R{年月日}-{連番} Automatic numbering |
| Container | Create receiving container in "Available" state |
| Inventory | Automatically creates incoming records and inventory journal entries |
2. Initial Process (First Processing Step)
| Item | Operation |
|---|---|
| Lot number | W{年月日}-{工程記号}{連番} New numbering |
| New container | Create new in "Available" state |
| Previous container | Change receiving container to "Consumed" |
| Raw material consumption | Automatically generate inventory journal entries (material disbursements) |
| Parent Lot | Recorded as Parent = Raw Material Lot |
3. Intermediate Processes (Second and subsequent processing steps)
| Item | Operation |
|---|---|
| Lot Number | Newly assigned (different lot number from the previous process) |
| New container | Create new in "Available" state |
| Previous container | Change the container from the previous step to "consumed" |
| Parent Lot | Recorded as Parent = previous process lot |
4. Time-consuming processes (fermentation, etc.)
Processes that take time, such as fermentation, are handled in two stages: "addition" and "discharge".
When inserted:
| Item | Operation |
|---|---|
| Lot Number | New Numbering |
| Container | Created in the "Processing" state |
| Additional Information | Record the date, time, and location of fermentation start |
At the time of payout (at the time of process completion):
| Item | Operation |
|---|---|
| Container being processed | Change to "Consumed" |
| New container | Create new in "Available" state |
| Parent Lot | Recorded as Parent = the lot that was being processed |
5. Final stage (the stage in which the product is completed)
| Item | Operation |
|---|---|
| Lot number | Format for finished product{年月日}-{ライン記号}-{連番} Numbering by |
| Container | Create a finished container in "Available" state |
| Previous container | Changed to "Consumed" |
| Inventory | Automatically generate inventory journal entries for manufacturing |
| Lot Integration | Integrates with lot management information within the system |
6. Shipping
| Item | Operation |
|---|---|
| Finished product container | Change to "Consumed" |
Operation of the Lot Performance Input Screen
URL:/app/lot-work-entry
Screen Configuration
- Select Manufacturing Order: Choose the appropriate order.
- Process List: The processes registered in the Bill of Materials (BOM) are displayed in order.
- Operations at each stage: Perform operations such as completion, loading, and unloading at each stage.
Completion of continuous processes (immersion, steaming, inoculation, etc.)
- Select a process
- Enter the completed quantity.
- (First step only) Select the raw materials to be consumed (by scanning the barcode or selecting from the list).
- Click the "Complete Process" button.
- The lot number will be displayed on the screen, and the label printing button will also be displayed.
Time-consuming processes (such as fermentation)
Input:
- Select the target process (the process that displays "Processing").
- Enter the quantity and location of input.
- Click the "Input" button.
- A lot in the "Processing" state is created.
Disbursement (Process Complete):
- Select the process currently being processed (displays "Processing")
- Enter the quantity of good products.
- Click the "Complete" button.
- A new lot number is issued.
Completion of the final step
- Confirm that all intermediate processes have been completed.
- Select the final step
- Enter the completed quantity.
- Click the "Manufacturing Complete" button.
- Manufacturing inventory entries are automatically created, and the finished product lot number and label printing URL are displayed.
Cancel operation
You can cancel the completion of the previous step.
- Specify the equipment ID.
- Click the "Cancel" button.
- The record of completion of the final process is canceled.
Traceability
Parent-child relationships of lots
Each lot has a parent lot recorded, allowing you to trace back to the previous lot. This establishes complete traceability from raw materials to finished products.
R260302-01 (原料:黒豆)
└─ W260302-A1 (浸漬) ← 親: R260302-01
└─ W260302-B1 (蒸煮) ← 親: W260302-A1
└─ W260302-C1 (接種) ← 親: W260302-B1
└─ 260302-D-01 (発酵 = 完成品) ← 親: W260302-C1
Record of changes in containers
All changes to the container's state are recorded in the history.
| Record | Content |
|---|---|
| New Creation | Creation of a new container upon completion of a process |
| Consumption | The container was used in the next process or shipped out. |
| Transition in progress | Placed into a time-consuming process |
Graph Display
/app/commit-link-graphThen, you can visually trace the preceding and succeeding processes starting from the lot number.
You can view information on raw material suppliers, quantity changes at each stage of the process, and even the final product's shipping destination, all in a single graph.
Relationship with cost accounting
Records of container creation and consumption are used in the following processes of monthly cost accounting:
| Processing | Data Used | Purpose |
|---|---|---|
| Extraction of work-in-progress events | Container status change history | Aggregation of work-in-progress movement |
| Identification of the final product | Finished product code recorded on the container | Identification of the lot group leading to a single finished product |
| Order of material consumption | Container consumption/creation history | Cost calculation using first-in, first-out (consuming older materials first) |
| Cost allocation by material | Raw material information recorded on the container | Allocate material costs to each item |
Tips for Use
- Label Printing: You can print labels with barcodes (Code39 format) from the URL displayed upon completion of the process.
- Barcode Scanning: Scanning the barcode of the lot number will automatically take over the lot number from the previous process.
- Prevention of duplicate entries: The system automatically checks to prevent duplicate entries even if you attempt to complete the same process twice.
- Prevention of skipped steps: An error will occur if you attempt to complete the next step before the previous step is completed.
- Quality Notes: You can record quality notes and the amount of waste incurred at the completion of each process.