Audit vendor invoices
audit_invoicesRun anomaly detection on invoices to flag duplicate numbers, entry lag, overdue-unpaid, amount outliers, rate changes, new charge types, unexplained credits, and inconsistent tax.
Instructions
Run all anomaly rules over a set of invoices (and optional line items): duplicate numbers, entry lag, overdue-unpaid, amount outliers, unit-rate changes, new charge types, unexplained credits, and inconsistent tax. Header-level rules always run; item-level rules run only when line items are supplied.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| items | No | Optional line-item rows: invoice_id, name, price, quantity, line_sum, tax_percent. | |
| today | No | ISO date used as 'today' for overdue checks (default: current date). | |
| invoices | Yes | Invoice rows: id, invoice_number, supplier_id, supplier_name, issue_date, create_date, required_date, sum, sum_paid, status. | |
| overdue_days | No | Days past due before flagging an approved-but-unpaid invoice (default 10). | |
| entry_lag_days | No | Days between issue and entry before flagging entry lag (default 14). | |
| rate_change_pct | No | Percent unit-price change to flag for a recurring item (default 5.0). | |
| amount_outlier_multiple | No | Multiple of a vendor's median to flag as an outlier (default 3.0). | |
| min_invoices_for_baseline | No | Minimum invoices per vendor before outlier logic runs (default 3). |