The Inventory Turns Report shows the number of times the inventory has turned within a given time period. While there are several different options for generating this report, the steps below review the process for generating a Turns Report.
- Click Inventory Turns.
- Specify whether you want to generate a Turns Report, Inactive Items Report, or Inventory Detail with Aging report. The fields you need to enter vary with each option.
- Select the relevant Customer Name and Warehouse from the grid. To select multiple customers, use < Ctrl > on your keyboard to multi-select.
- Specify whether you want to generate a Facility Summary, Facility Detailed, Customer Summary, or Customer Detailed.
-
- Specify if you want to 'Show Inactive' items.
- Enter a relevant Start Date and End Date, then click Run Report.
The Turns Report generates with the following columns:
- Facility: Name of warehouse
- Customer: Name of customer
- SKU: Primary identifier of an item
- Qualifier: Relevant item qualifier
- Turns: Number of times the inventory turned during the dates selected
- Volume: Number of packaging units shipped out
- Ave Inv. Lvl: Average number of packaging units available during the dates selected
- Begin Inv: Number of packaging units available for allocation on the Start Date
- Ending Inv: Number of packaging units available for allocation on the End Date
The Inactive Items Report generates with the following unique columns:
- Inv. Balance: Current inventory level
- Last Shipment: Details of the last order that deducted inventory from the warehouse
- Last Receiver: Details of the last receipt that added inventory to the warehouse
The Inventory Detail with Aging generates with the following unique columns:
- Part/SKU: Primary identifier of an item
- Item: Description of an item
- On_Hand: Number of primary units currently in the warehouse
- Available: Number of primary units available for allocation
- Allocated: Number of primary units currently allocated to Open and Complete orders
- Aging: Number of days the SKU has been in the warehouse