Backflush Variance and Missing Remnant in Pharmaceutical Packaging
A pharmaceutical packaging site uses MES with backflush issuing for blister cards and foil. ERP inventory shows 42,600 blister cards on hand. The MES lot genealogy report shows only 31,900 cards consumed across the last 14 batches and 8,200 cards remaining in WIP. Batch record B2407-11 was closed with a yield of 98.2%, but the line clearance record shows partial remnants returned to the warehouse as lot B2407-11-R. The next batch starts in 6 hours and requires 9,000 cards. A customer audit is in 3 days. The warehouse cannot locate the returned remnant. MES has no transaction for the remnant return, and a supervisor posted a manual ERP adjustment. What do you do?
1. What immediate containment and batch disposition actions should be taken before the next batch starts?
Read the worked answer
Place a hold on the affected blister-card lots, including B2407-11-R, and do not run the next batch until the material balance is explained. Quarantine the physical area where the remnant should be and perform a supervised physical count by lot. Check whether B2407-11 was released or shipped and whether the yield calculation depended on the missing 2,500 cards. The arithmetic gap is 42,600 minus 31,900 consumed minus 8,200 WIP, which equals 2,500 cards unaccounted for. That is not a rounding error and must be resolved before further consumption. Notify QA and the customer-audit owner. The next batch needs 9,000 verified cards; 8,200 in WIP is insufficient without a confirmed physical balance. Do not reverse or accept the supervisor's manual ERP adjustment until the transaction history and physical count support it. If the physical count confirms 42,600, MES consumption is understated; if it confirms about 40,100, ERP is overstated.
2. How would you reconcile MES and ERP and decide which record is wrong?
Read the worked answer
Reconcile from a common equation: opening balance plus receipts minus issued minus scrap minus returned equals on-hand. Pull the ERP transaction history, the MES genealogy, line-clearance records, backflush settings, and the manual adjustment. Count the warehouse, WIP, and line-side locations physically, tagged by lot. Compare the remnant return documentation with MES: the missing return transaction suggests MES did not record the remnant, so ERP may have received a manual credit without a corresponding MES lot. Check whether backflush quantity was based on a wrong BOM or whether scrap was not recorded. Review the supervisor's adjustment authorization and reason code. Decide based on physical evidence, not which system is newer. If the physical count matches ERP, the MES consumption record is incomplete and must be corrected through an approved adjustment with genealogy. If the physical count matches MES, reverse the ERP adjustment. Document the reconciliation and get QA approval before releasing material.
3. What root causes and preventive controls would you propose to prevent recurrence?
Read the worked answer
The likely root causes are a backflush process that has no remnant-return transaction, a manual ERP adjustment that bypassed MES, and no routine MES-to-ERP reconciliation. Line clearance captured the remnant physically but not electronically. Preventive controls should include a mandatory remnant-return transaction in MES with barcode scanning at the warehouse, a block on manual ERP inventory adjustments without MES reference and QA approval, and a daily or per-batch reconciliation report that flags variances above a defined threshold. Add a backflush variance check at batch close and require the operator to confirm scrap and remnant quantities. Review audit trails for manual adjustments monthly. Train supervisors on the transaction sequence and add the remnant return to the line-clearance checklist. For the audit in 3 days, prepare the reconciliation, CAPA, and evidence that the affected lots were contained.