Stock Reconciliation (Odoo vs FastBound)

Stock Reconciliation (Odoo vs FastBound)

Your shop has two systems tracking firearms: Odoo (your business inventory) and FastBound (your electronic bound book). These two systems must agree. If Odoo says you have a firearm in stock but FastBound does not (or vice versa), you have a problem that needs to be resolved before an ATF inspector finds it.

What the Stock Report Does

The Stock Report (fb.stock.report) compares your Odoo inventory against your FastBound records, line by line. It uses FastBound's BulkVerify API to check items in batches, making the comparison fast even with a large inventory.

Running a Stock Report

1. Go to FastBound → Reporting → Stock Report.
2. Click Generate Report.
3. The system pulls your current Odoo firearms inventory and sends the serial numbers to FastBound's BulkVerify API.
4. Wait for the report to complete. For large inventories (500+ items), this may take a minute or two.
5. The report displays a list of report lines (fb.stock.report.line), one per serial number.

Reading the Results

Each line in the report shows:

• Serial Number — The firearm's serial number
• Odoo Status — Whether the item is in Odoo inventory (In Stock, Not Found)
• FastBound Status — Whether the item exists and is acquired in FastBound (Acquired, Not Found, Disposed)
• Match / Mismatch — Whether the two systems agree

Types of Discrepancies

Discrepancy	What It Means	How to Fix
In Odoo, not in FastBound	Firearm is in your business inventory but not in your bound book	Create the acquisition in FastBound immediately
In FastBound, not in Odoo	Firearm is in your bound book but not in your business inventory	Investigate: was it sold, transferred, or lost? Update Odoo or create a disposition
Status mismatch	Both systems have the item but disagree on status (e.g., disposed in FastBound but still in-stock in Odoo)	Determine the correct status and update the incorrect system

How Often to Run This Report

• Weekly: Recommended for active shops that sell firearms daily
• Monthly: Minimum for shops with lower firearm volume
• Before ATF inspections: Always run a reconciliation before any scheduled or anticipated inspection