Patterns the cleaner surfaced that finance should review and correct in SFO. None of these block the load – they're flagged for human attention.
Error: Parser Error: syntax error at or near "union"
LINE 3: union select 'All'
^
LINE 3: union select 'All'
^| Code | What it means | Where to look in SFO |
|---|---|---|
outlier_check_number | Check number wildly outside the school's normal range (typo). | Edit the check in SFO and correct the check number. |
duplicate_check_same_amount | Multiple rows for one check# with identical amount, payee, and date but only some GL accounts. May be a true duplicate. | Verify against the paper check; void one if duplicate. |
cross_year_deposit_id_reuse | Same deposit_id used on two different dates. SFO numbering reset mid-year. | Confirm both deposits are real; consider renumbering. |
open_check_long_outstanding | Check still marked 'open' (not reconciled, not voided) more than 365 days after issue. | Reconcile with the bank or void if uncashed. |
liquidated_po_without_check | PO closed but no liquidating check#. Probably paid via JE / wire / cash. | Confirm method of payment is documented. |
outstanding_po_long | PO still open more than 365 days after PO date. | Liquidate or void the PO. |
orphan_liquidating_check | PO points to a check# that doesn't exist in checks. | Fix the liquidation link in SFO. |
zero_amount_transaction | Check, receipt, or deposit with $0.00. | Placeholder or error; review and either complete or delete. |