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 ReportComparison Does
The Stock ReportComparison (fb.stock.report) compares your Odoo inventorycompliance lots against your FastBound records, line by line. It uses FastBound's BulkVerify API to checkfetches items in batches, makingfrom the comparisonFastBound fastAPI evenand withcompares athem largeagainst inventory.the compliance lot records in Odoo, identifying any differences between the two systems.
Running a Stock ReportComparison
- Go to FastBound →
ReportingReports → StockReportComparison. - Click Generate Report.
- The system pulls your current Odoo
firearmscomplianceinventorylots andsendsfetches items from theserialFastBoundnumbersAPI toFastBound'scompareBulkVerify API.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
(fb.stock.report.line), one per serial number.
Reading the Results
Each line in the report shows:
- Serial Number — The firearm's serial number
OdooMatch Status —WhetherHow the itemiscomparesinbetween the two systems: Matched, Data Mismatch, OdooinventoryOnly,(InorStock,FastBoundNot Found)OnlyFastBoundFB Status —WhetherThe item's status in FastBound: Available, Pending Disposal, or Disposed
Use the itemView existsDiscrepancies button to filter the report and isshow acquiredonly inlines FastBoundthat (Acquired,are Notnot Found,matched, Disposed)so
Types of Discrepancies
| Discrepancy | What It Means | How to Fix |
|---|---|---|
| Firearm is in your business inventory but not in your bound book | Create the acquisition in FastBound immediately | |
| 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 | |
| Both systems have the item but disagree on | 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 reportcomparison 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.