Review materials reconciliation

Open Purchasing → Reconciliation to review the material-cost chain for the current branch. If you can work across branches, use the branch selector to choose one branch or all branches.

The report keeps seven controls separate so a normal timing difference in one workflow is not mistaken for a broken total elsewhere:

• Purchasing compares purchase-order value with posted receipts.
• Receiving compares posted receipts with live, non-rejected vendor bills.
• AP exceptions lists bills whose match, approval, delivery, or conflict state needs attention.
• Truck stock compares van balances with the stock-movement ledger and checks that transfers have one out leg and one in leg, even when the two locations belong to different branches.
• Allocation starts with each eligible PO line, vendor-bill line, and consumed inventory item, including sources with no allocation. A positive remainder is available or not yet allocated; a negative remainder is an anomaly.
• Job cost compares reconstructed material cost with immutable cost-attribution events by currency.
• Accounting sync partitions every approved bill into disabled, export-ready, pending, delivered, failed, or conflict. These states add back to the approved total.

When Accounting sync is disabled for the selected branch, historical report data stays visible, but approved bills are shown as disabled instead of pending and CSV export is unavailable. When the capability is enabled but QuickBooks is not connected, approved bills without a terminal delivery result are shown as export-ready, not synced.

Use Export CSV when Accounting sync is enabled to download the same scoped facts and anomaly labels shown on screen. Source IDs in the report and export are intended for investigation; follow them back to the purchase order, bill, stock movement, allocation, or cost-attribution record before correcting data.

Roll back and verify an accounting repair

Disabling Accounting sync for a branch stops newly approved bills in that branch from entering the outbox and removes the reconciliation export affordance. It is a reversible release control: purchasing, receipt, stock, allocation, job-cost, outbox, mapping, and conflict records remain visible. Nonterminal approved bills are counted as Disabled, not pending delivery; earlier delivered, failed, and conflict evidence is retained.

Disabling the capability does not cancel a row that was already queued. Follow Review accounting sync status for the connection-level stop, dead-letter investigation, same-row requeue, conflict/crosswalk forward repair, stable provider requestId, and post-repair verification procedure. Never delete reconciliation evidence to make a section balance.