Epicor Backflush Hierarchy Logic

A reoccurring question I get often from Production Supervisors, Material Handlers, Inventory Managers & Cost Accountants is why Epicor backflushed from a certain location or pulled inventory negative.  Back in Vantage 8.03 and probably prior the Epicor Hierarchy Logic was a bit of a mystery since it was not documented in the embedded help, however since 9.04 the Backflush Heirarchy is included and can be found under: Inventory Management > Working with Inventory Management > Material Backflushing Hierarchy.  It’s a bit wordy so I have summed it up first and then I have included the actual help text:

1. Job Operation’s Resource Group Input Warehouse & Bin, if adequate inventory.
2. Job Operation’s Resource Input Warehouse & Bin, if adequate inventory.
3. Job Operation’s Resource Group Backflush Warehouse & Bin, if adequate inventory.
4. Job Operation’s Resource Backflush Warehouse & Bin, if adequate inventory.
5. Job Material’s Warehouse Primary Bin, if adequate inventory.
6. Job Material’s Warehouse first Bin, with adequate inventory.
7. Job Material’s Warehouse first bin no matter the inventory.

Epicor 10.0.700 Help Article:

Backflush material quantities are reported complete at the job operation level. When the Epicor application performs material backflushing at the job operation level, it uses the following hierarchy to determine how the associated component materials should be backflushed:

• If the available quantity on hand is greater than zero, it uses the input warehouse/bin (defined in the Input Warehouse and In Bin fields in the Resource Group Maintenance > Resources > Detail sheet) for the resource associated with the job operation.
• If an inadequate available inventory balance exists in the input warehouse/bin defined in the Resource Group Maintenance > Resources > Detail sheet (or none has been defined), it uses the input warehouse/bin defined in the Input Warehouse and In Bin fields in Resource Group Maintenance for the resource group associated with the job operation (if the available quantity on hand is greater than zero).
• If an inadequate available inventory balance exists in the input warehouse/bin defined in Resource Group Maintenance (or none has been defined), it uses the backflush warehouse/bin (defined in the Backflush Warehouse and Backflush Bin fields in the Resource Group Maintenance > Resources > Detail sheet) for the resource associated with the job operation (if the available quantity on hand is greater than zero).
• If an inadequate available inventory balance exists in the backflush warehouse/bin defined the Resource Group Maintenance > Resources > Detail sheet (or none has been defined), it uses the backflush warehouse/bin (defined in the Backflush Warehouse and Backflush Bin fields in Resource Group Maintenance) for the resource group associated with the job operation (if the available quantity on hand is greater than zero).
• If an inadequate available inventory balance exists in the backflush warehouse/bin defined in Resource Group Maintenance (or none has been defined), it uses the primary bin defined in the Primary Bin field in Warehouse Maintenance for the associated job material warehouse (if the available quantity on hand is greater than zero).
• If an inadequate available inventory balance exists in the primary bin defined in Warehouse Maintenance (or none has been defined), it uses the first bin for the associated job material warehouse that contains a quantity for the Inventory unit of measure defined for the component part being backflushed (if the available quantity on hand is greater than zero).
• If an inadequate available inventory balance exists in a warehouse bin for the Inventory unit of measure defined for the component part being backflushed, it uses the first bin in the job material warehouse that has an available quantity, regardless of unit of measure.