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
Try it here, free
SyteLine Material Transaction and Reference Types Reference
The transaction and reference types behind SyteLine material transactions, with where each comes from and whether it counts as usage, so you can build reliable usage and aging reports.
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.
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.