Tips and Tricks of Fishbowl Inventory Reports (Part 2)

In our previous blog post, we discussed a few ways to make your reports easier to read, and more accessible.  We continue along that path with a few more tips in this week’s post.

Dashboard Reports

Adding Reports to Your Dashboard

The Dashboard can be a helpful tool, especially to gauge the ebb and flow of your daily business activities.  To help make your Dashboard complete, you can add any Fishbowl report, and then pull it up within a few moments.  All of this can be done without having to go to the reports module to open the report.

Just remember that the more reports you add to the Dashboard, the longer it will take your Fishbowl Client to load.  Another thing to be aware of is that the reports on your Dashboard will be displayed with whatever filters you have set on the report in the Report Module.  For tips on saving multiple reports, but with different filters, see our last blog post, or give us a call.

Scheduling Reports For Export

Reports can be scheduled to export on a regular basis.  These reports can be exported as excel files (including csv’s), as pdf’s, or as Rich Text Files, which can be helpful if you want to keep a record of your reports within a designated folder.  At the same time, the reports can also be emailed to a designated recipient.

One of the known problems in Fishbowl Inventory is that some reports are not accurate if you are back-dating the report.  For example, the “On Hand by Date” report shows you the inventory quantities from your chosen date, but it displays the asset values as of today.

Another example is the “Inventory Valuation Summary” report.  This report cannot be back-dated, so if you did not save a copy of the report on a given date, that report is lost forever.

We suggest that you find the reports that most impact your business, and schedule them for automatic export on a daily basis.

Default Reports

Fishbowl has set up their own reports as defaults in specific modules (e.g. the “Sales Order Report” in the Sales Order Module, or the “Pick Ticket” in the Picking Module).  But, what if you want to print or email a different report from these modules, when prompted?  This can be accomplished in the Reports Module by choosing which Default Reports you want to have assigned to each Module within Fishbowl.

Setting up Default Reports in specific modules can help you more easily get the reports you need, at the time you need them.  The report that you have set up as the default report for each module will be the one that prints out when you click the “Print” icon in the module, or when you are prompted to print a report after completing a step while processing orders.

Other Settings (Module Options)

In the Module Options of the Report Module, you will find some other handy options that you might not already know about.  Some of these options include:

  • Displaying the “Modify Report” dialog box upon opening a report
  • Setting a Default Date Range
  • Setting a Default Location Group
  • Setting a Default Salesperson
  • Choosing how many decimal places to show on your reports
  • How the date displays on your reports

These options can be helpful for getting the most out of your reports.

Let us know if you have any questions about Fishbowl reports.  As always, we are happy to help!

Tips and Tricks of Fishbowl Inventory Reports (Part 1)

There are over 150 built-in reports in Fishbowl Inventory.  However, not all of those reports are helpful in their default settings or configurations.  In this two-part series, we will discuss some changes you can make to the reports, and some settings that can help make your life a little easier.

Reports

Use the “Modify Report” Feature

When you first view a report, the default filters for that report will be used.  For many, the standard filters are not sufficient.  So, to change the report filters, just click the “Modify Report” button at the top-left of the report.  This will open a window that allows you to change date ranges, statuses, details, displayed fields, etc.  Changing some of these simple filters can help change a useless report into a valuable tool.

After you have changed your filters, don’t forget to click the “Save Filters as Default Filters” icon (the one that looks like a little disk and is located at the bottom-left of the “Modify Reports” window).  Then, your filters will be applied every time you open the report.

While in the “Modify Report” window, don’t forget to check out the “Printer” tab, which allows you to choose which printer your report will be sent to when printed.  You can choose a specific printer for each of your Location Groups that you have set up in Fishbowl.

Finding Your Favorite Reports

In the Reports Module, you can add your most-used reports to your “Favorites” folder.  This not only helps you to find your reports quickly and easily, but you can also save specific filters to these reports.

To add a report to your “Favorites” folder, right-click on it in the search pane of the Reports Module, and click “Add to Favorites”.  In addition to setting your favorite reports, you can also copy your reports, rename them, and have multiple versions of the same report, but with different filters set on each one.

Make Your Reports More Accessible

Not everyone wants to go to the Reports Module to open their reports.  Luckily, you have the option of assigning your reports to your chosen modules.  For example, if you want to see the “Purchase History” report in the Sales Order Module, you can assign it to the Sales Order Module, and then you will be able to find the report in the “Reports” drop-down menu within the module.

To make reports available within the modules, you will go to the Reports Module and open the report you want to assign to a module.  Once open, click on the “Details” tab at the top of the report.  In the Details Tab, you will see a list of all of the modules in Fishbowl.  Simply check the boxes next to the module(s) you want to associate the report with, and then click the “Save” icon at the top-left of the screen.

Get a Custom Report (or a modification)

If you can’t get the information you need from the default Fishbowl reports, you can build the reports yourself, if you have some programming knowledge.  Or, you can call on us to write the report for you.  We have built many reports over the years that have helped save time and money for our clients.  After all, Fishbowl Inventory is just a tool that relates information, and the better your reports are, the more informed you will be.

If you create your own report, it will need to be installed on your Fishbowl Server.  To install the reports, you will paste the files into the correct directory, and then use the “Upload” button in the Reports Module to load the report into your Fishbowl Database.  Once you have installed the reports, make sure you assign them to the correct modules in Fishbowl.

Stay tuned for part 2 of our story on Fishbowl Inventory Reports.