Business Need

Using GoldFinch’s standard process for Daily Production Backflushing is not ideal, because it back flushes everything that hasn’t been used.

...

  • WHEN a production journal is posted:

    • For each Item Journal Line WHERE Item_Backflush after Work Order = FALSE

      • Populate the following in the Waste Object:

        • Work Order

        • Item Journal Line

        • Item

        • Base UOM

Waste Quantity
  • Calculate the following

    :

    for Waste_Waste Quantity

    • If Item Journal Line > Work Line_Expected Quantity

      -

      • Item Journal Line - Work Line_Expected Quantity

        Save that value in Waste-Waste
    • If Item Journal Line < Work Line_Expected Quantity

      • (

        Work Line_Expected Quantity - Item Journal Line_Quantity

        ) / Work Line_Expected QuantitySave that value in the

Waste Percentage
  • Calculate the following for Waste_Percentage Waste field

    • Waste_Waste Quantity / Work Line_Expected Quantity

Calculate Backflush Quantities

...