How to Convert a Fishbowl Inventory Export Into a CSV Flat File For Analysis
Fishbowl is an extremely capable inventory and production management system. It comes out of the box with a large assortment of reports covering all the critical business processes you might want (Sales, Inventory, Purchasing, Accounting, Manufacturing, etc.). It also has the capability to connect to the database for more in-depth reporting, as well as writing custom SQL code. But if your needs are somewhat greater than what the standard reports provide, but you don’t have the skill to write custom SQL there is an intermediate solution.
In this article we take you through how to turn a monthly Inventory Status report, including Part Numbers, Descriptions, Units on Hand and extended cost, into a flat file that you can then load into Excel or Access or whatever business analytics front end you desire. This example does require some VBA, which is provided, but can be used as a template for other reports.