User guide
For the person who runs the reports. This guide covers the whole set: 61 reports in five folders. Every report works the same way, so the first sections apply to all of them.
What it shows
Base Reports is a set of 61 reports on your Fishbowl data. Each report reads the data when you run it and changes nothing in Fishbowl.
In Fishbowl the reports are in five folders under Reports: Sales, Inventory, Purchasing, Manufacturing and Operations. The section "The reports" below lists each one.
Parameters
Parameters narrow what a report reads. Each report has its own, and its Parameters panel names them.
| Parameter kind | What it does | Default |
|---|---|---|
| Date range | Keeps rows whose date is between the two dates. Fill one end to leave the other open. | Empty: all dates |
| Dropdown | Keeps rows that match any value you pick. | Empty: all values |
| "contains" box | Keeps rows whose number or name contains what you type. | Empty: all rows |
| Checkbox | Turns one rule on, such as "Open lines only". | Shown on the report |
| Custom fields | Adds your Fishbowl custom fields as columns or filters. See below. | None |
If you leave every parameter empty, the report reads everything. On a large database, set a date range first. Inventory History and Dormant Customers need a date before they run.
Select Run to load the report. Change a parameter and select Run again to reload it.
Custom fields
Most reports can show your own Fishbowl custom fields. Select Edit custom fields in the Parameters panel.
- Columns: tick a field to add it as a column.
- Filters: select Add filter, then pick the field, a condition and a value. The conditions match the field's type: text, number, date, list or checkbox.
- AND and OR: each filter after the first joins with AND or OR. AND is applied before OR, and the dialog shows the result in words.
A report offers the custom fields of the records its rows come from. A summary report offers fewer, because one row adds many records together. Your choices last until you close the report.
Columns
- Columns button: shows or hides columns.
- Column heading: sorts by that column.
- Search box: keeps the rows that contain what you type, in any column.
- A blue number or name, such as an order number, opens that record in Fishbowl.
How the numbers work
- Total row. The row under the table adds the quantity and money columns. It follows the Search box, so it totals the rows you see, across all pages of the table. Averages and percentages are not totaled.
- Open. A sales order line is open when it is a sale, misc. sale or drop ship line that is not yet fulfilled. Open quantity is the quantity ordered less the quantity fulfilled.
- Days late. The days from the scheduled date to today. It is 0 when the date has not passed.
- Credit returns. Credit return and misc. credit lines count as negative quantities and amounts, so returns net out of every total. Returned Sales is the exception: it lists returns and shows them as positive figures.
- Units. A summary by product or part shows quantities in that product's or part's own unit of measure, and converts lines sold or bought in another unit.
- Cost. Cost appears only on the reports that are about cost: Sales Margins, Inventory Valuation, Cost Layers, Part Cost History, Inventory History, Inventory Adjustments, Work Order Cost and the purchasing reports. Every other report shows price only.
- Stock figures. On hand, allocated and available come from Fishbowl's own inventory totals, per part and location group. Available is on hand less allocated and not available.
Reading the result
"No data available" means nothing matched the parameters. Widen the date range or clear a filter and run the report again.
The export buttons save what the report loaded:
| Export | What it holds |
|---|---|
| XLSX | Every row, with dates and numbers as real dates and numbers, a total row, and a second sheet that lists the parameters used. |
| CSV | Every row, as plain data with no total row. |
| Markdown | Every row as a table, with the parameters used and a total row. |
An export holds every row the report loaded, not only the rows the Search box leaves on screen.
The reports
Sales
Sales orders, what was sold, customers, pricing, shipments and returns.
| Report | What it shows |
|---|---|
| Open Sales Orders | Lists every sales order that is Issued or In Progress, one row per order, with its open lines, open quantity, open amount, scheduled date and days late. Narrow it by status, dates, customer, salesperson or location group. |
| Sales Order Lines | The detail report for sales orders: one row per line, for any order status, with the product, part, quantities, unit price and line total. Narrow it by order status, line type, dates, customer or product, or show open lines only. |
| Sales by Product | Adds up what was sold in a date range, one row per product, with the number of orders, quantity, amount and average unit price. Credit returns reduce the totals, and quantities are shown in the product's own unit. |
| Sales by Customer | Adds up sales orders in a date range, one row per customer, with the order count, subtotal, tax, total, average order, and first and last order date. Narrow it by status, customer, salesperson or location group. |
| Backorders | Lists open sales order lines whose part has more demand than available stock in the order's location group, with on hand, available, short quantity and short amount. Each line is checked against all of the part's stock, so short quantities for one part can overlap across lines. |
| Sales Orders | Lists every sales order, one row per order, with its status, customer, dates, salesperson, subtotal, tax and total. Narrow it by status, date issued, date completed, customer, salesperson or location group. |
| Sales by Month | Adds up sales orders by the month they were issued, with the order count, subtotal, tax, total and average order. Narrow it by date, status, customer, salesperson or location group. |
| Sales by Salesperson | Adds up sales orders in a date range, one row per salesperson, with the number of orders and customers, subtotal, tax, total and average order. Narrow it by date, status, customer or location group. |
| Sales Margins | Shows the price, cost, margin and margin percent of each sale and drop ship line. Fishbowl posts a line's cost when the line is fulfilled, so an unfulfilled line shows no cost yet. |
| Returned Sales | Lists every credit return and misc. credit line on a sales order, with the product, quantity returned and amount credited. Quantities and amounts are shown as positive figures. |
| Sales Discounts | Lists every discount line on a sales order, with the discount name, its type, the percentage or amount, and the discount total. Narrow it by date, customer, order status or discount name. |
| Sales Tax | Adds up sales orders in a date range by tax rate, with the order count, subtotal, taxable subtotal and tax. It also counts the orders that have a line on a different rate from the order's own. |
| Price Discrepancy | Lists sale lines whose unit price differs from the product's list price, with the list price, price charged, difference per unit, difference total and percent off list. Set a minimum difference percent to leave out small differences. |
| Customer Purchase History | Adds up what each customer bought in a date range, one row per customer and product, with the number of orders, quantity, amount and last order date. Credit returns reduce the totals. |
| Dormant Customers | Lists active customers that have had no sales order issued since the date you choose, with the last order date and number, days since the last order, and lifetime order count and total. A customer with no orders at all is included. |
| Customer List | Lists every customer on one row, with status, default salesperson, payment terms, carrier, tax rate, credit limit, and the main address, phone and email. Narrow it by active, status, name or state. |
| Product Price List | Lists every product with its list price, unit of measure and part number. It shows the list price only: pricing rules are not applied. |
| Pricing Rules | Lists every pricing rule with the customers and products it applies to, the adjustment it makes (percent, amount or fixed price), and its quantity and date limits. Narrow it by active, rule name, customer or product. |
| Kit Components | Lists every kit product and the items in it: the component products, the choices for optional items, quantities and price adjustments. Search by kit or by component to see which kits use a product. |
| Shipments | Lists every shipment with its status, order, ship-to, carrier and service, date shipped, carton count, total weight and tracking numbers. It covers shipments for sales orders, purchase orders and transfer orders. |
| RMAs | Lists every RMA line with its status, customer, product, quantity, reason, date resolved and the original sales order. Narrow it by status, date created, customer or RMA number. |
Inventory
Stock on hand, its value and age, reordering, and the history of every part.
| Report | What it shows |
|---|---|
| On Hand | Lists stock on hand, one row per part, location and tracking combination, with lot, expiration date, serial numbers and the quantity committed. Narrow it by location group, location, part or part type. |
| Inventory Availability | Shows each inventory part in each location group with its on hand, allocated, not available, drop ship, available and on order quantities, from Fishbowl's own inventory totals. On order counts every open order type. |
| Inventory Valuation | Values the stock on hand, one row per part, as quantity on hand times Fishbowl's average cost for the part. Cost is kept per part, not per location group, so the report cannot be split by location group. |
| Cost Layers | Lists every cost layer of every part with its original quantity, remaining quantity, unit cost, remaining value and the order that created it. Narrow it by part, date created or status, or show only layers with quantity remaining. |
| Inventory Aging | Splits each part's stock on hand into bands of 0-30, 31-60, 61-90, 91-180 and over 180 days since it came in, and shows the date of the oldest stock. |
| Expiring Inventory | Lists stock on hand that is tracked by expiration date, by part, location and lot, with the days left until it expires. Choose an 'expires on or before' date, and include or leave out stock that has already expired. |
| Reorder Report | Lists parts at or below the reorder point set for a location group, with on hand, allocated, available, on order, a suggested order quantity and the default vendor. It needs reorder points to be set in Fishbowl. |
| Reorder Points | Lists the reorder point and order-up-to level set for each part and location group, with on hand and available stock. It can also list the inventory parts that have no reorder point set. |
| Cycle Count List | A count sheet: stock on hand by location, part and tracking values, sorted in location order, with the date each was last counted. Narrow it by location group or location, or to stock not counted since a date. |
| Inventory History | The inventory audit trail: one row per transaction with the part, type, quantity change, quantity on hand after, locations, source order, user and cost of the change. A date range is required. |
| Tracking History | Follows a lot number, serial number or other tracking value: every inventory transaction that carried it, with the part, quantity, locations, source order and user. A transaction that carried two tracking values shows once for each. |
| Inventory Adjustments | Lists manual inventory changes in a date range, with the part, the type of change, quantity change, posted cost of the change, location, note and user. |
| Part Consumption | Adds up what left inventory in a date range, one row per part, split into sold, used in manufacturing, scrapped, adjusted down and other, with averages per day and per month. |
| Inventory Turnover | Compares the quantity shipped on sales orders and used in manufacturing in a date range with the quantity on hand now, one row per part, and works out turnover and days of supply. It divides by current on hand, not by an average over the period. |
| Part List | Lists every part with its type, unit of measure, ABC code, tracking, default location, default vendor and vendor part number, UPC, weight and dimensions. Narrow it by active, part type, ABC code, part number or description. |
| Part Cost History | Lists each recorded change in a part's average or standard cost, with the cost before and after, the quantity and the total value at that point. Narrow it by date or part. |
| Part Demand | Lists every open order line that is holding or waiting for stock of a part, across sales orders, work orders, transfer orders and vendor returns, with the quantity needed and picked. Use it to see what a part's allocated quantity is made of. |
| ABC Analysis | Ranks parts by sales amount in a date range, with each part's percent of total, the cumulative percent, a suggested class (A, B or C) and the ABC code the part has now. |
Purchasing
Purchase orders, receipts and vendors.
| Report | What it shows |
|---|---|
| Open Purchase Orders | Lists every purchase order that is issued or partly received, one row per order, with its open lines, open quantity, open amount, scheduled date and days late. Narrow it by status, dates, vendor, buyer or location group. |
| Purchase Order Lines | The detail report for purchase orders: one row per line, for any order status, with the part, vendor part number, quantities, unit cost and line total. Narrow it by status, line type, dates, vendor or part, or show open lines only. |
| Purchases by Vendor | Adds up purchase orders in a date range, one row per vendor, with the order count, ordered amount, received amount, average order, and first and last order date. |
| Purchases by Part | Adds up what was bought in a date range, one row per part, with the number of orders, quantity ordered and received, amount, average unit cost and last unit cost paid. |
| Receiving History | Lists every received purchase order line with the vendor, part, quantity received, date received, receipt status, billed cost, landed cost and date reconciled. It covers purchase orders only. |
| Unreconciled Receipts | Lists purchase order lines that were received and are not yet reconciled to a vendor bill, with the quantity, date received, days since received and expected cost. |
| Vendor Parts | Lists each vendor and part pairing with the vendor part number, last cost, default vendor flag, lead time and minimum order quantity. Narrow it by vendor, part or vendor part number. |
| Vendor Performance | Adds up the purchase order lines received from each vendor in a date range: how many arrived on or before the scheduled date, how many arrived late, the on-time percent, average days late and average lead time. A line with several receipts counts once, by its last receipt. |
| Vendor List | Lists every vendor on one row, with status, payment terms, carrier, lead time, minimum order, currency, and the main address, phone and email. Narrow it by active, status, name or state. |
Manufacturing
Bills of materials, manufacture orders and work orders.
| Report | What it shows |
|---|---|
| Bill of Materials | Lists the items on every bill of materials, one level deep, with each item's type, part and quantity. Search by part number to find every bill of materials that uses a part. |
| Manufacture Orders | Lists every manufacture order with its status, dates, location group, the sales order it came from, and how many of its work orders are finished. |
| Open Work Orders | Lists every work order that is entered or started, with the bill of materials, the part it builds, builds finished and remaining, scheduled date and days late. |
| Work Order Cost | Shows the cost of each work order: material cost, labor and other cost, total cost and cost per unit built. Fishbowl posts these costs when the work order is finished. |
| Production | Adds up what was built on finished work orders in a date range, one row per finished good part, with the number of work orders, quantity built, and first and last finish date. |
| Work Order Consumption | Adds up the raw goods used by finished work orders in a date range, one row per part, with the planned quantity, the quantity used, the variance and the variance percent. |
Operations
Picking, transfer orders, locations and users.
| Report | What it shows |
|---|---|
| Open Picks | Lists every pick that is entered, started or committed, with its order, customer or destination, scheduled date, days late, assigned user, and the lines and quantity still to pick. |
| Pick Lines | Lists every item on an unfinished pick, sorted by pick-from location, with the part, quantity to pick, item status and tracking. Narrow it by pick status, item status, location group, part or scheduled date. |
| Transfer Orders | Lists every transfer order with its status, type, from and to location group, dates, carrier and line quantities. Narrow it by status, date issued or location group. |
| Transfer Order Lines | The detail report for transfer orders: one row per line, with the part and the quantities to fulfill, picked and fulfilled. Narrow it by status, scheduled date, location group or part, or show open lines only. |
| User Login Log | Lists each login event Fishbowl recorded, newest first, with the user, date, time and whether multi-factor sign-in was used. Narrow it by date or user. |
| User Access Rights | Lists each user with the user groups the user belongs to and the access rights each group grants, one row per right. Narrow it by user, user group, module or access right. |
| Locations | Lists every location with its location group, type, and pickable, receivable and available-for-sale settings, plus how many parts are stocked there and the quantity on hand. It can show empty locations only. |