Report Historical Part Cost Report

From Fishbowl Advanced
Report-Historical Part Cost Report.png

This report displays the historical cost of parts on a specific day. It shows the quantity, unit cost, and the total cost, with an option to select which costing method is displayed. This report requires the snapshot feature to be enabled.

The Modify Report Button.png Modify Report button allows the following report filters to be customized:

OPTIONAL TAB
  • Report On Date - Select the date that will be used to display historical costs. This report pulls data from the PARTCOSTHISTORY table.
  • Costing Method - Choose the costing method to run the report for. Options are: Average, Standard, FIFO, or LIFO.
  • Vendor - Choose the vendor to run the report for. This will only show parts that have that vendor set as the default vendor. The default vendor can be assigned on the Vendors tab of the Icon.Part.png Part module or the Parts tab of the Icon.Vendor.png Vendor module.
  • 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.
  • Show Parts Created After Date - Choose to show/hide parts that didn't exist on the specified date 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.
PRINTER TAB - Allows a default printer to be specified for the report in each location group.