Custom Inventory Reports

Welcome to a new age of reporting! POSaBIT is thrilled to release custom inventory reporting with the ability to build all the inventory reports you desire. In this article, you will learn all the ins and outs of POSaBIT's custom inventory reporting.

Building Custom Inventory Reports

To get to the custom reports, go to the POS portal --> Reports --> Custom Reports.

Custom Inventory Reporting Basics

From the Custom Reports page, you will select Inventory at the top. Then you can select what you would like to Report by, and Group by based on what is being reported, turn subtotals on or off, add optional filters, and customize the date range. Click Search to run the report.

  • Date range (Custom Date Ranges now have no restriction)
  • Report by: This is what the report will start filtering by (Example: Product Type will show the inventory by different product types)
  • Group by: This is how the report will group the "Report by" items (Example: If Brand Name is the Report by and Group by is Product Type, it will show a breakdown of each product type for the different brands).
  • Subtotals: Turning this toggle on will show subtotals of the groups.
Caveat - subtotals are totaled by page, so if data from a grouping runs off onto another page, then the suggestion would be to increase the number of entries per page (100, 250, 500)
  • Download CSV / Download Excel: These will download the custom report based on the customized settings of the report into either a CSV or Excel file.
  • Columns: Show or hide columns based on your preference. Click Reset to bring back the default columns.

Example Custom Report: Report by Brand Name, and group by Product Type, with subtotals turned on, and it would look like this:

This is one example of hundreds of ways to customize a report. To break down the different customization options, see below:

Suggested Reports:

Under the Suggested Reports dropdown, users will have the ability to use one of POSaBIT's pre-built custom reports. These have been built based on some of the more commonly requested reports. This will show all types of custom reports, not only custom inventory reports.

To make your own custom reports, see the different customization options below:

Report by options AND Group by Options:

Brand Name
This will display the inventory by Product Brands, with a link to go directly to each brand.
DOH Compliant (WA Only)
Shows DOH Compliant inventory vs non-DOH inventory (WA Only)
Flower Type
This will display inventory by Flower Types (Indica, Hybrid, Sativa, CBD, etc.)
Is Marijuana
Separates marijuana vs non-MJ inventory
Lot Age In Days
Display inventory by lot age in days old.
Lot Age Range
Display inventory by lot age range
Lot Barcode
Display inventory by barcode
Lot Expiration
Display inventory by lot expiration date.
Lot Is Sample
Display lots by sample vs non-sample
Lot Number
Displays inventory by Lot Numbers
Lot Status
Display inventory by lot status (Active and Inactive)
Manifest Ref
Display inventory by manifest reference number
Product Family
This will display inventory by Product Families
Product Internal ID
This will display inventory by Product Internal ID
Product Name
This will display the Product Names
Product Strain
This will display the Product Strain
Product Type
This will display the Product Type (Flower, Vaporizer, Edible (Solid/Liquid), Pre-roll, etc.)
Room
Display inventory by Room
SKU Name
This will display inventory by SKU.
Supplier Name
This will display the supplier
Weight Unit
Display inventory by Weight unit

Additional Filter Options:

Click Filters to show or hide these options:

  • Product types
  • Suppliers
  • Brands
  • Rooms
  • Strains
  • Is marijuana (Yes or No)
  • No order since (Last time this was purchased)
  • Lot status
  • Age over (days) / Age under (days) (Display inventory based on a custom age)
  • Qty over / Qty under (Display inventory by custom on-hand amount)
When building these reports, keep in mind that if you're building a report with more than 3,000 rows of data, only the first 3,000 rows will show.

Saving Custom Inventory Reports

If you are building a report you want to reuse, you can also save the report you built to make it easier in the future.

  1. Once you have your report built out to your liking, click the Save button at the top of the report.
  2. This will open a pop-up where you can customize the report name, interval, and you can even schedule the report to send to any existing user or email, with an option for scheduled frequency.
Note: When adding emails to scheduled reports, the emailed user must have a portal login to access the report. This is to ensure important data is never leaked.
  1. Once you have filled out your ideal name, interval, and schedule, click Save to save it to your custom reports.
  1. To see all your saved reports, from the Custom Inventory Report page, click Manage.
    1. You can also get to the saved reports by going to the Saved Reports page under the Reports tab.
  2. This will take you to a page with all your previously saved custom reports for easy access.
To edit the report, click on the report name. To edit the scheduling, click the green "Edit" button on the right side of the page.

Report Inbox

There is also a way to view all previously sent scheduled reports by going to the Report Inbox page under the Reports tab. On this page, you will have access to all your scheduled reports that have been sent out. Click the blue Download button to get a downloaded copy.



How did we do?

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)