Data Discrepancy Checks
- New Data Discrepancies section in Settings with four data integrity checks:
- Invoice Total Mismatch — finds sales where the stored grand total doesn't match the sum of line items; links directly to each sale
- QC & Repair Stock Count — finds items with an open QC or Repair record that are no longer in the corresponding location; offers a Fix All to close stale records
- Sold Location Mismatch — finds items with an active sale record whose current location is not Sold; offers a Fix All to correct the location
- Purchase Return Location Mismatch — finds items linked to an active purchase return whose current location is not Purchase Return; offers a Fix All to correct the location
- All checks show a preview table with item-level search links before any fix is applied