...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Business Need
Using GoldFinch’s standard process for Daily Production Backflushing is not ideal, because it back flushes everything that hasn’t been used.
...
These values then would be used to populate the Yield Sheet PDF
See example values here:
...
Example Scenarios
Item Setup
Item = Jar 16 Ounce Salsa
BOM
Mixed Salsa
Phantom BOM
Tomatoes
Jalapenos
Jar
Label
Backflush after Work Order = FALSE
Mixed Salsa
Tomatoes
Jalapenos
Backflush after Work Order = TRUE
Jar
Label
Scenario 1
Produced less than work order.
Work Order for 10000 Jars of Salsa
Production Journal Output = 9995
No Packaging wasted.
Item Journal Lines:
Tomatoes = 10000
Jalapenos = 10000
Jar = 9995
Label = 9995
Waste
5 Tomatoes
5 Jalapenos
Backflush
Jar = 5
Label = 5
Scenario 2
Work Order for 10000 Jars of Salsa
Production Journal Output = 9995
50 Jars won’t thread
Before journal is posted:
Movement created in Goldfinch to move 45 jars from warehouse bin to input bin.
Item Journal Lines:
Tomatoes = 10000
Jalapenos = 10000
Jar = 10045
Label = 9995
Waste
5 Tomatoes
5 Jalapenos
50 Jars
Backflush
Label = 5
Scenario 3
Work Order for 10000 Jars of Salsa
Production Journal Output = 9950
50 Jars cracked after filling
Item Journal Lines:
Tomatoes = 10000
Jalapenos = 10000
Jar = 10000
Label = 9950
Waste
50 Tomatoes
50 Jalapenos
50 Jars
Backflush
Label = 50
Scenario 4
Work Order for 10000 Jars of Salsa
Production Journal Output = 10000
50 Jars cracked after filling
Before journal is posted:
Movement created in Goldfinch from warehouse bin to input bin.
50 Tomatoes
50 Jalepenos
50 jars
Item Journal Lines:
Tomatoes = 10050
Jalapenos = 10050
Jar = 10050
Label = 10000
Waste
50 Tomatoes
50 Jalapenos
50 Jars
Backflush
None
Acceptance Criteria
Waste Object
...
WHEN a production journal is posted:
For each Item Journal Line WHERE Item_Backflush after Work Order = FALSE AND Item Journal Line < Work Line_Expected Quantity
Populate the following in the Waste Object:
Work Order
Item Journal Line
Item
Base UOM
Calculate the following for Waste_Waste Quantity
Work Line_Expected Quantity - Item Journal Line_Quantity
Calculate the following for Waste_Percentage Waste field
Waste_Waste Quantity / Work Line_Expected Quantity
For each Item Journal Line WHERE Item_Backflush after Work Order = FALSE AND Item Journal Line > Work Line_Expected Quantity
Populate the following in the Waste Object:
Work Order
Item Journal Line
Item
Base UOM
Calculate the following for Waste_Waste Quantity
Item Journal Line - Work Line_Expected Quantity
Calculate the following for Waste_Percentage Waste field
Waste_Waste Quantity / Work Line_Expected Quantity
For each Item Journal Line WHERE Item_Backflush after Work Order = TRUE AND Item Journal Line > Work Line_Expected Quantity
Populate the following in the Waste Object:
Work Order
Item Journal Line
Item
Base UOM
Calculate the following for Waste_Waste Quantity
Item Journal Line - Work Line_Expected Quantity
Calculate the following for Waste_Percentage Waste field
Waste_Waste Quantity / Work Line_Expected Quantity
Calculate Backflush Quantities
...