fishbowl inventory and custom production

Frequently, this report is used to post an adjusting entry, when needed, to bring the QuickBooks inventory asset balance in alignment with Fishbowl’s representation.

One the primary uses of this report is to reconcile total inventory asset value as detailed in a daily Fishbowl Inventory Valuation Summary report vs. Generally, we set this report to run just before midnight on a daily basis. This report can be set up as a Scheduled Task to be generated and distributed on the frequency of your choice (options are Minute, Daily, Weekly, Monthly, Annually) or generated on demand. Then for each part you get the on-hand quantity, unit of measure, unit cost and extended cost (or Asset Value as the column is titled). a warehouse, customer consignment location, etc.), by Location (Location is a subset of a Location Group), by Part Number. This very useful report includes a listing if inventory by Location Group (Location Group is the top level inventory location identifier, e.g.

One example of this technique is with the Inventory Valuation Summary report, which you can find in the Reports module as shown below: Transforming the Inventory Valuation Summary Report This approach is especially useful because you can distribute simple macro-enabled Excel workbooks to inventory analysts and others within your company allowing them to generate Fishbowl CSV data on the fly. Over the next 6-12 months we’ll go to the next level of development in our business because we’ll be using things which integrate well with Fishbowl.Learn how to create CSV data from Fishbowl standard reports using Excel Visual Basic to get more value from your inventory, purchasing and production reports. We’re expanding beyond the basics of what we originally expected of Fishbowl. Since we’ve stabilised the Warehouse and it’s basic Warehousing functions, we are now looking at things like a web-based sales application for sales team etc. It’s also allowed us to standardise our business processes which was something lacking in a business which is growing, and we needed to have systems in place to stabilise the business. The inventory management was a key thing and that’s been provided by Fishbowl.

It didn’t really handle warehousing as such and all the requirements of a warehouse system. One of the issues we had was basically with an accounting system which was just exactly that. So we were looking at ways to improve our business processes and in particular across our warehouse. Our business has been growing for a number of years, exponentially.

Fishbowl inventory and custom production