Fishbowl inventory report costs of goods on hand

Fishbowl inventory report costs of goods on hand how to#

So you can see the challenge with converting this to a flat file. The report itself was more than 1,900 rows in Excel. But in this the example, the Fishbowl client had four Location Groups, 485 active Locations and 577 Part Numbers, totaling more than $2.5M of inventory value.

If we only had one Location Group with a small number of Locations, we could easily parse this report just cutting and pasting by hand and get the desired result. Next, you cannot easily distinguish Location Groups from Locations given that they are in the same column. For one, the Location is not on the same row as each Part Number. If you look at the example above as compared to how we want the information summarized, you can begin to see the problem. What we want is to have the data in the following flat file format to import into our data warehouse, by column: The Torrance Location Group has hundreds of Locations in this example. Within the Gardena Location Group we have three locations-Packaging, Receiving and Stock. In the snippet above you can see that we have two Location Groups-Gardena and Torrance. Here is an example of a CSV export to Excel to better illustrate the challenge: But if you look at the report, it does not lend itself to being easily transformed into a flat file format with all the Location Group and Location information. The Challenge With Using A Standard ReportДЄt month end, we capture the values in this report to help with analyzing inventory efficiencies. When variances do arise, you can look at the daily inventory asset balance in QuickBooks and compare that to the daily Fishbowl Inventory Valuation Summary and root cause what transaction(s) are creating the variance. 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.

Fishbowl inventory report costs of goods on hand how to#

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.