Business Need
Using GoldFinch’s standard process for Daily Production Backflushing is not ideal, because it back flushes everything that hasn’t been used.
Once ingredients are picked for a blending Work Order, they do not return to inventory at the end of a day because those ingredients may get held over to the next day to finish the work order.
The only thing that would go back into inventory is unused packaging, or Bulk Blended ingredients from a packaging BOM after the WO quantity is fulfilled.
There is a need to backflush inventory that wasn’t used for the work order, like packaging. Additionally, for inventory like ingredients, it should not be backflushed, but instead be marked as waste.
Finally, the waste should be calculated for the items that were not backflushed.
These values then would be used to populate the Yield Sheet PDF
See example values here:
...
Scenario Examples
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
Work Order for 10000 Jars of Salsa
Production Journal Output = 9995
Scenario 2
...
Business Need
Using GoldFinch’s standard process for Daily Production Backflushing is not ideal, because it back flushes everything that hasn’t been used.
Once ingredients are picked for a blending Work Order, they do not return to inventory at the end of a day because those ingredients may get held over to the next day to finish the work order.
The only thing that would go back into inventory is unused packaging, or Bulk Blended ingredients from a packaging BOM after the WO quantity is fulfilled.
There is a need to backflush inventory that wasn’t used for the work order, like packaging. Additionally, for inventory like ingredients, it should not be backflushed, but instead be marked as waste.
Finally, the waste should be calculated for the items that were not backflushed.
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
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
...
Work Order
Lookup
Item Journal
Item
Lookup
Base UOM
Lookup
Waste Quantity
Number
Percentage Waste
Percentage
Waste Weight
Conversion = Waste Quantity to Base UOM.
Percentage Yield
Formula - Percentage
1 - Percentage Waste
Item Setup
For Item Type = Inventory
Add a field:
Name: Backflush after Work Order
Type: Checkbox
Default = Not Checked
Help Text: Check this box if this item should be backflushed after a work order is completed. Do not check this box waste should be calculated for this item after a work order is completed.
For Item Type = Service
Do not add the field.
...
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
...