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 kindWhat it doesDefault
Date rangeKeeps rows whose date is between the two dates. Fill one end to leave the other open.Empty: all dates
DropdownKeeps rows that match any value you pick.Empty: all values
"contains" boxKeeps rows whose number or name contains what you type.Empty: all rows
CheckboxTurns one rule on, such as "Open lines only".Shown on the report
Custom fieldsAdds 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.

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

How the numbers work

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:

ExportWhat it holds
XLSXEvery row, with dates and numbers as real dates and numbers, a total row, and a second sheet that lists the parameters used.
CSVEvery row, as plain data with no total row.
MarkdownEvery 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.

ReportWhat it shows
Open Sales OrdersLists 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 LinesThe 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 ProductAdds 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 CustomerAdds 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.
BackordersLists 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 OrdersLists 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 MonthAdds 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 SalespersonAdds 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 MarginsShows 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 SalesLists 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 DiscountsLists 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 TaxAdds 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 DiscrepancyLists 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 HistoryAdds 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 CustomersLists 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 ListLists 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 ListLists every product with its list price, unit of measure and part number. It shows the list price only: pricing rules are not applied.
Pricing RulesLists 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 ComponentsLists 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.
ShipmentsLists 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.
RMAsLists 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.

ReportWhat it shows
On HandLists 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 AvailabilityShows 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 ValuationValues 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 LayersLists 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 AgingSplits 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 InventoryLists 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 ReportLists 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 PointsLists 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 ListA 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 HistoryThe 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 HistoryFollows 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 AdjustmentsLists 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 ConsumptionAdds 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 TurnoverCompares 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 ListLists 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 HistoryLists 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 DemandLists 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 AnalysisRanks 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.

ReportWhat it shows
Open Purchase OrdersLists 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 LinesThe 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 VendorAdds 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 PartAdds 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 HistoryLists 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 ReceiptsLists 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 PartsLists 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 PerformanceAdds 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 ListLists 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.

ReportWhat it shows
Bill of MaterialsLists 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 OrdersLists 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 OrdersLists 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 CostShows 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.
ProductionAdds 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 ConsumptionAdds 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.

ReportWhat it shows
Open PicksLists 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 LinesLists 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 OrdersLists 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 LinesThe 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 LogLists 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 RightsLists 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.
LocationsLists 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.