Sequence Gap Detector

Sequence Gap Detector

Scan every Odoo sequence for gaps before your auditor does

Your controller is three days into a VAT audit when the external auditor flags it: a gap between INV/2024/0041 and INV/2024/0043. Nobody can explain INV/2024/0042. In many countries, unexplained sequence gaps are a compliance red flag. Hunting through thousands of records to explain them costs your team hours it does not have.

Sequence Gap Detector scans any Odoo sequence — invoices, purchase orders, stock pickings, or your own custom sequences — and lists every missing number instantly. Each result shows the expected reference, prefix, and gap size. Set an optional date range to scope the scan to a specific audit period, then export a dated report you can hand directly to your auditor without pulling raw database exports.

Finance managers run it the morning of an audit and walk in with a clean gap report already in hand. Admins run it before month-end close to catch integration errors from third-party imports before they become audit findings. A manual reconciliation of the same records typically takes three to five hours; a scan here finishes in under two minutes.

Works on Odoo 16, 17, 18, and 19. Find it under the Accounting menu after install and run your first scan in under five minutes.

Details

• Odoo versions: 16, 17, 18, 19
• Dependencies: base, account
• License: LGPL-3
• Technical name: sequence_gap_detector
• Quality score: 89.6/100
• Odoo App Store: view listing
• Source: GitHub