Site Cost Comparison Report
Overview:
The Site Cost Comparison report will list the last received cost and date for inventory items for each Site, in a side-by-side format. It will run for a selected date range, inventory department, category, or group, and for all or a selected vendor. You can drill down on a cost to see the invoice detail. An example of the report is shown below:
Things to know!
- This report will list the last received cost and date for inventory items for each Site.
- This report will only be accessible and visible to users who are given access to this report function.
- This report is for customers that have more than one Site set up in COGS-Well.
Report Parameters
To Run the Site Cost Comparison report, use the Sidebar to navigate to the Receive menu option, and then select the Site Cost Comparison report from the submenu. Upon selection, a Report Parameters screen like the one below will display:
Begin Date: From the drop-down calendar, select a starting date range.
End Date: From the drop-down calendar, select an ending date range.
Inventory Department: If you want to view only one Inventory Department, use the drop-down search to select the Department.
Inventory Category: If you want to view only one Inventory Category, use the drop-down search to select the Category.
Inventory Group: If you want to view only one Inventory Group, use the drop-down search to select the Group.
Vendor: If you want to view only one Vendor, use the drop-down search to select the Vendor.
Run Report: Once you have selected your report parameters, click the Run Report button to list the report.
Site Cost Comparison Report:
Selecting to Run this report will display a report similar to below:
Item Name: The name of the Inventory Item followed by the name of the Vendor in parenthesis.
Pack Size: How the vendor is packaging and pricing the Inventory Item.
Sites: There will be a column for each Site in your database that shows the last received cost and date for the Inventory Item. You can drill down on the cost to see the invoice detail.
Report Options: For a description of the toolbar provided at the top of the report, please see "Report Options" for help. Report Options link.