Skip to main content

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

  1. Go to FastBoundReportingReportsStock ReportComparison.
  2. Click Generate Report.
  3. The system pulls your current Odoo firearmscompliance inventorylots and sendsfetches items from the serialFastBound numbersAPI to FastBound'scompare BulkVerify API.them.
  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
  • OdooMatch StatusWhetherHow the item iscompares inbetween the two systems: Matched, Data Mismatch, Odoo inventoryOnly, (Inor Stock,FastBound Not Found)Only
  • FastBoundFB StatusWhetherThe 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

Matchyou /can Mismatchfocus on Whetheritems thethat twoneed systems agree attention.

Types of Discrepancies

DiscrepancyWhat It MeansHow to Fix
InOdoo Odoo, not in FastBoundOnlyFirearm is in your business inventory but not in your bound bookCreate the acquisition in FastBound immediately
InFastBound FastBound, not in OdooOnlyFirearm is in your bound book but not in your business inventoryInvestigate: was it sold, transferred, or lost? Update Odoo or create a disposition
StatusData mismatchMismatchBoth systems have the item but disagree on statusdetails (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

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.