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 Comparison Does
The Stock Comparison report compares your Odoo compliance lots against your FastBound records, line by line. It fetches items from the FastBound API and compares them against the compliance lot records in Odoo, identifying any differences between the two systems.
Running a Stock Comparison
- Go to FastBound → Reports → Stock Comparison.
- Click Generate Report.
- The system pulls your current Odoo compliance lots and fetches items from the FastBound API to compare them.
- Wait for the report to complete. For large inventories (500+ items), this may take a minute or two.
- The report displays a list of report lines, one per serial number.
Reading the Results
Each line in the report shows:
- Serial Number — The firearm's serial number
- Match Status — How the item compares between the two systems: Matched, Data Mismatch, Odoo Only, or FastBound Only
- FB Status — The item's status in FastBound: Available, Pending Disposal, or Disposed
Use the View Discrepancies button to filter the report and show only lines that are not matched, so you can focus on items that need attention.
Types of Discrepancies
| Discrepancy | What It Means | How to Fix |
|---|---|---|
| Odoo Only | Firearm is in your business inventory but not in your bound book | Create the acquisition in FastBound immediately |
| FastBound Only | 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 |
| Data Mismatch | Both systems have the item but disagree on details (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
ATF Inspection Alert: When an ATF Industry Operations Inspector visits your shop, they will compare your physical inventory against your bound book. If there are discrepancies — firearms in your safe that are not in your bound book, or records for firearms that are not on your shelves — you will have serious problems. Running this stock comparison regularly is your best defense.
Tip: After resolving discrepancies, run the report again to confirm everything matches. Keep a record of each reconciliation you perform (date, number of items checked, discrepancies found and resolved). This demonstrates compliance diligence to ATF inspectors.