Report Turnover Report

This report displays the number of times inventory is turned over during the given date range. The Total Units should display as Total Units Sold. It lists the total units sold in the date range specified on the report. The Avg QOH is the Average Qty on hand for that part in inventory. It adds up all the on hand quantity per day and divides that total by the number of transactions in the date range. Average TO is the number of days it will take you to turn over your current inventory, given the date range selected. It is calculated as the Turnover quantity divided by the number of days in the date range. The Turnover is the turnover rate in that date range specified. It is calculated as the Total Qty Sold divided by the Avg QOH.

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

OPTIONAL TAB

• Group By - Choose to group by Location Group or by Part Number
• Location Group - Choose a specific location group to run the report for. Leave this field blank to run for all location groups.
• Part Number - Choose a specific part number to run the report for. Leave this field blank to run for all part numbers.
• Date Range - Enter the desired date range to see turnover information for. The date range looks at the DateLastFulfillment on the SOITEM table in the database, meaning, if a line item with a quantity greater than 1 is partially shipped, the most recent fulfilled date (when a partial quantity was shipped) is what will be used for all quantity fulfilled so far. It also looks at the EventDate on the INVENTORYLOG table in the database, meaning the date an inventory transaction occurred such as a receipt, cycle, or scrap.
• 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.