Report Reconcile Report

From Fishbowl Advanced
Report-Reconcile Report.png

This report generates a list of POs that have been reconciled, and it displays the original cost, the billed cost, and the landed cost. The Billed Total will be red if it is more than the Original Total and green if it is less than Original Total. If currency conversion is enabled, the costs can be displayed in the vendor's default currency.

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

OPTIONAL TAB
  • PO Number - Select a Purchase Order number to run the report for. Leave this field blank to run for all Purchase Orders.
  • Part Number - Choose a part number to run the report for. Leave this field blank to run for all parts.
  • Date Range - Choose a date range to run the report for. This date range looks at the DateReconciled on the RECEIPTITEM table in the database, meaning the date the item was reconciled.
HIDE/SHOW TAB - Choose which columns to show/hide on the report by checking/unchecking the checkbox next to each column name.
  • 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.