Infor SyteLine4 min readNetray Engineering Team

How to Set Up Backflushing in Infor SyteLine

Backflushing in Infor SyteLine automates material consumption based on finished goods completions rather than requiring individual material issue transactions. This reduces shop floor data entry and speeds up production reporting for repetitive manufacturing environments. Proper backflush configuration ensures accurate inventory and cost accounting while minimizing transaction overhead. This guide covers item-level backflush settings, operation-level triggers, and variance management best practices.

Configuring Item-Level Backflush Settings

Open the Items form (SLItems) and navigate to the Production tab for each component item you want to backflush. Set the Backflush field to Yes to enable automatic consumption when the parent item is completed or moved to the next operation. The backflush flag is stored in the item table's backflush column. For items with variable consumption rates, leave backflush disabled and use manual material issues instead. Configure the Backflush Location field to specify which warehouse location the system draws inventory from during backflush processing. The default backflush location is typically a dedicated floor stock location near the production line.

  • Set Backflush = Yes on the Items form Production tab for each eligible component item
  • Define the Backflush Location to a dedicated floor stock warehouse location per item
  • Leave backflush disabled for variable-consumption items like adhesives, paints, or chemicals
  • Configure lot-tracked and serial-tracked items with caution as backflush auto-selects lots by FIFO

Setting Up Operation-Level Backflush Triggers

SyteLine supports backflushing at specific routing operations rather than only at job completion. On the Job Materials form (SLJobMaterials), set the Backflush Operation field to the operation sequence number where consumption should occur. When labor is posted against that operation, all materials flagged for backflush at that operation are consumed automatically. This is controlled by the matl table's backflush_op column. Use operation-level backflush for multi-stage assemblies where components are consumed at different production steps. The JobmatlPostSp stored procedure handles the actual inventory deduction during backflush processing.

  • Set Backflush Operation on Job Materials form to the operation number triggering consumption
  • Materials are consumed when labor is posted to the specified operation via Job Transactions
  • Use operation 10 for raw materials and operation 20+ for sub-assemblies in multi-stage processes
  • Review the Job Material Transaction History form to verify backflush quantities match expected consumption

Managing Backflush Variances and Exceptions

Backflush variances occur when actual consumption differs from BOM standard quantities. Review variances on the Job Cost Variance Report accessible from Production > Reports. Common variance sources include scrap, yield loss, and BOM quantity errors. Configure the Scrap Percentage on BOM components to automatically inflate backflush quantities for items with predictable scrap rates. For significant variances, use the Material Issue Adjustment form to post correcting transactions. Run the Backflush Exception Report weekly to identify items where backflushed quantities consistently deviate from physical inventory counts by more than 2-3%.

  • Set Scrap Percentage on BOM components to account for predictable material loss rates
  • Review Job Cost Variance Report monthly to identify systematic backflush inaccuracies
  • Use Material Issue Adjustments to correct variances exceeding 3% of standard quantities
  • Perform cycle counts on backflush location items at least weekly to maintain inventory accuracy

Frequently Asked Questions

What types of items should not be backflushed in SyteLine?

Items with highly variable consumption rates, expensive components requiring individual tracking, and serial-controlled items with strict traceability requirements should avoid backflushing. Approximately 15-25% of component items in a typical BOM are poor backflush candidates. Items costing more than $500 per unit or those with consumption variance exceeding 5% of standard quantities are better managed with manual material issues for cost control.

How does backflushing work with lot-tracked items in SyteLine?

SyteLine automatically selects lots for backflushed items using FIFO (First In, First Out) logic from the designated backflush location. The system reads the lot table to find the oldest available lot with sufficient quantity. If a single lot cannot satisfy the requirement, multiple lots are consumed. Approximately 30% of manufacturers using lot tracking disable backflush for lot-controlled items to maintain explicit lot selection control for traceability compliance.

Can I reverse a backflush transaction in SyteLine?

Yes, backflush transactions can be reversed using the Material Return form (SLJobMatlReturn) or by posting a negative material issue on the Job Transactions form. The reversal creates an offsetting inventory transaction that restores the consumed quantity to the backflush location. Process reversals within the same accounting period when possible, as cross-period reversals affect 2 fiscal periods and require approximately 3-5 additional reconciliation steps.

Key Takeaways

  • 1Configuring Item-Level Backflush Settings: Open the Items form (SLItems) and navigate to the Production tab for each component item you want to backflush. Set the Backflush field to Yes to enable automatic consumption when the parent item is completed or moved to the next operation.
  • 2Setting Up Operation-Level Backflush Triggers: SyteLine supports backflushing at specific routing operations rather than only at job completion. On the Job Materials form (SLJobMaterials), set the Backflush Operation field to the operation sequence number where consumption should occur.
  • 3Managing Backflush Variances and Exceptions: Backflush variances occur when actual consumption differs from BOM standard quantities. Review variances on the Job Cost Variance Report accessible from Production > Reports.

Deploy Netray AI agents to analyze your SyteLine backflush variance patterns, identify items with chronic over- or under-consumption, and recommend BOM scrap factor adjustments for improved inventory accuracy.