Reports

From Fishbowl Drive

The Reports module displays many reports that can be customized and exported. Below is a general description of some common report options, followed by a list of reports.

FBO Reports 1.png

Presets and options in all reports

In every report, you have the ability to customize it and then save your preferred settings by creating presets. Plus, there are several options or tools above each report that allow you to adjust it, print it, email it, and more. We will explain how to do those things in the following sections.

How to create a new preset

To save a revised report’s settings for easy access in the future, click the CREATE NEW PRESET button on the top-right of the window. A popup will appear asking for just one thing: Preset Name. Add any name you like. For example, it can be the name of some of the settings the report includes. Then click the SAVE button. You can either do this before you begin making changes to the report, or you can do it at the end. If you want to make additional changes to the report, click the UPDATE button. The CREATE NEW PRESET button changes to UPDATE when you’re in a report preset.

Additional presets

To create another report preset, first click the X to the right of the dropdown menu containing the name of the current preset. Then you can go through the same steps above to create a new preset.

The first report preset you create will automatically be the default. Once it’s saved, there will be a Default checkbox option above the UPDATE button.

If this isn’t the first time you’ve opened a report, and you previously created at least one preset, you will see the default report preset first thing. And you will be able to see all of the report presets you have saved listed in the dropdown menu on the top-right.

To set a new default report preset, click the Default checkbox in it and click the UPDATE button. If you uncheck the Default checkbox on the default report preset and click the UPDATE button, you’ll receive an error message. That’s because there usually has to be a default. However, if you delete the default report preset, there won’t be a default report, and it will show the original default options when you click the Show Report option under the More Icon Button.png More button in an individual receipt. That is, until you select a report preset as the default or create a new one.

To delete a report preset, first click the trashcan icon next to the UPDATE button. Then click the red DELETE button in the message that pops up.

Once you save a preset as the Default and then leave and return to the report, that preset’s settings will show up automatically.

Report options

The following buttons are at the top of each report to enable you to make adjustments and send the report to other people. Tooltips appear when you mouse over these buttons for a couple seconds. They succinctly explain what each one does.

  • Zoom Out - This makes the text in the report appear smaller.
  • Reset - This restores the report to its original size.
  • Zoom In - This makes the text in the report appear larger.
  • Next Page - If the report has multiple pages, this button enables you to move to the next page.
  • Previous Page - If the report has multiple pages, this button enables you to move to the previous page.
  • Download XLSX File - This enables you to download the report into an XLSX file, which you can open in Excel.
  • Download PDF - This enables you to download the report into a PDF, which you can open with Adobe Acrobat.
  • Print Report - This enables you to print a hard copy of the report.
  • E-mail Report - This enables you to email the report to as many recipients as you like. It opens a popup where you can add email addresses in the To, Cc, and Bcc textboxes. Then you can add a subject and message. Click the SEND button to send the email with the report as a PDF attachment. If the recipient doesn’t receive the email in their inbox, they will need to check their junk folder and add fishbowl@fishbowlonline.com to their address book so that future emails aren’t marked as spam.
  • Expand - This expands the report to the full size of your browser window. When you click this button, it changes to a Contract button, which you can click to return the report to its previous smaller size.

List of reports in Fishbowl Drive

Below is a list of the included reports in alphabetical order. Click the report to see more details.

Barcode Report

This report generates barcodes for your items.
Report-Barcode.png

Customer History Report

This report shows details on sales by customer.
Report-Customer History.png

Cycle Count Report

This report generates a list of items to check their quantities on the shelves.
Report-Cycle Count.png

Inventory Availability Report

This report displays the following inventory quantities: On Hand, Allocated, Not Available, Drop Ship, Available, Incoming, Committed, and Short.
Report-Inventory Availability.png

Inventory Event History Report

This report lists when new items were received into your inventory or rejected.
Report-Inventory Event History.png

Inventory On Hand Report

This report shows how many items are in stock by location.
Report-Inventory On Hand.png

Inventory Valuation Summary Report

This report shows the value of assets in stock.
Report-Inventory Valuation Summary.png

Item Barcode Label Report

This report displays barcodes for all of the items on a purchase order.
Report-Item Barcode Label.png

Item Barcode One Off Report

This report generates barcodes for your items on individual pages.
Report-Item Barcode One Off.png

Item Price List Report

This report lists sale items and their prices.
Report-Item Price List.png

Location Barcode Report

This report generates barcodes for your Parent Locations and Child Locations.
Report-Location Barcode.png

Margin Report

This report displays profit margins by sale item, customer, or tag.
Report-Margin.png

On Hand By Expiration Report

This report lists items by their expiration date.
Report-On Hand By Expiration.png

Packing List Report

This report generates a packing list by Ship Number.
Report-Packing List.png

Pick Report

This report shows information on a pick based on a sales order number.
Report-Pick.png

Purchase Order Report

This report shows information in a specific purchase order.
Report-Purchase Order.png

Purchase Order Summary Report

This report lists all purchase orders in a date range.
Report-Purchase Order Summary.png

Receiving List Report

This report generates a receiving list by Receipt Number.
Report-Receiving List.png

Reorder Report

This report generates a list of items that have fallen below their reorder point.
Report-Reorder.png

Sales Order Report

This report shows information in a specific sales order.
Report-Sales Order.png

Sales Order Summary Report

This report lists all sales orders in a date range.
Report-Sales Order Summary.png

Shipping Invoice Report

This report generates a shipping invoice by Ship Number.
Report-Shipping Invoice.png

Total Item Sales Report

This report lists all of your sales by item and dollar amount.
Report-Total Item Sales.png