Report On Hand By Date
From Fishbowl Advanced
This report lists inventory quantities on hand at the end of a given day. Optional estimated total values may be included. Note: Deleted and renamed parts, as well as parts that had not been stocked before the report date, will not be reported. Cost values are based on today's cost. For actual historical costs, see the Historical Part Cost report.
The 
Modify Report button allows the following report filters to be customized:
- REQUIRED TAB
- Report On Date - Choose the date to view inventory on hand information for. This date looks at the EventDate on the INVENTORYLOG table in the database, meaning the date an inventory transaction occurred.
- OPTIONAL TAB
- Costing Method - Choose the costing method to run the report for. Options are: Average, Standard, FIFO, or LIFO.
- Location Group - Choose a specific location group to run the report for. Leave this field blank to run for all location groups.
- Vendor - Choose the vendor to run the report for. This will only show parts that have that vendor set as the default vendor in the Part module, Vendor Tab.
- Part Number - Choose a specific part number to run the report for. Leave this field blank to run for all part numbers.
- Show Inactive Parts - Choose to show/hide inactive parts by checking/unchecking this checkbox.
- Format Report for Exporting - Removes the page breaks and displays the report on one long page for exporting to CSV, Excel, and other formats.
- Include Zero Quantities - Choose to show/hide parts with zero quantities by checking/unchecking this checkbox.
- Show Cost - Choose to show/hide cost by checking/unchecking this checkbox. Costs are based on today’s cost.
- Show Only Zero Quantities - Choose to show only parts with zero quantities by checking this checkbox.
- PRINTER TAB - Allows a default printer to be specified for the report in each location group.