Skip to main content

Product & Inventory Reports

Product & Inventory Reports

CloudFFL's product inventory report gives you a high-level view of your compliance inventory, aggregated by manufacturer,your type,chosen and model.grouping. While the Stock ReportComparison and Serial Audit focus on individual serial numbers, the Product ReportInventory report answers bigger-picture questions like "How many Glock pistols do we have?" or "What's our total rifle inventory?"

Accessing the Product Inventory Report

  1. Go to FastBound → ReportingReports → Product ReportInventory.
  2. Select a grouping option for how you want the data organized. The reportavailable options are: Manufacturer (fb.product.report) displays your compliance inventory grouped bydefault), manufacturerItem Type, firearm typeCaliber, andManufacturer + Type, or modelManufacturer + Model. You select one grouping option per report.
Click Generate to produce the report.

What the Report Shows

For each grouping (e.g., Glock / Pistol / G19 Gen5)Gen5, depending on your selected grouping option), the report shows:

  • Available: Firearms currently in stock and not pending any transaction
  • Pending Disposal: Firearms that are part of an open sales order or transfer but have not yet left your inventory
  • Disposed: Firearms that have been sold, transferred, or otherwise left your inventory
  • Caliber breakdown: Counts per caliber within each grouping
Condition: New vs. used counts

FilteringUsing Grouping Options

Choose the Reportgrouping

Useoption thethat filterbest andanswers group-byyour options to answer specific questions:question:

  • "How many Glock pistols do we have in stock?" → FilterUse bythe Manufacturer =+ Glock,Type Statusgrouping =and Availablelook for Glock / Pistol
  • "What shotguns have we sold this month?" → FilterUse bythe Item Type =grouping Shotgun,and Statusreview =the Disposed,Shotgun Date = This Month
"Show me all used firearms in inventory" → Filter by Condition = Used, Status = Availablerow "What's our totalinventory 9mmby inventory?caliber?" → FilterUse the Caliber grouping to see totals broken down by Calibercaliber ="Show 9mm,me Statuseverything =by Availablea specific manufacturer and model" → Use the Manufacturer + Model grouping

Exporting Reports

You can export the product report for your records:

  • Click the Export button (or use Odoo's built-in list export feature)
  • Choose your format (Excel or CSV)
  • Save the file for your records, insurance documentation, or accountant

Discrepancy Report

In addition to the product report, CloudFFL tracks lot/serial records that have FastBound sync issues. If a serial number failed to sync to FastBound (due to an API error, connection issue, etc.), it will show up in the discrepancy view. Check this periodically and resolve any sync failures by re-committing the records.

When to Use These Reports

SituationWhich Report
ATF inspection preparationStock ReportComparison + Serial Audit + Product ReportInventory
Insurance documentationProduct ReportInventory (export full inventory)
Business planning (what's selling, what's sitting)Product ReportInventory with datedifferent filtersgrouping options
Checking a specific serial numberStock ReportComparison or Serial Audit
End-of-year inventoryAll three reports
Identifying sync issues between Odoo and FastBoundStock Comparison (use the View Discrepancies button)

Tip: Export and save a copy of your Product ReportInventory report at the end of each month. This gives you a historical record of your inventory levels over time, which is useful for business planning and proves your compliance diligence to ATF inspectors.

Sync Issues: If the discrepancy report shows serial numbers that failed to sync with FastBound, resolve them immediately. A firearm that is in your physical inventory but not in FastBound is a bound book violation. Go to the affected records and re-commit them, or manually create the entry in FastBound if the API sync cannot be fixed.

Back to top