Inventory Turnover
Form ID: (IN407010)
By using this form, you can calculate and review the inventory turnover, the average inventory of an item for a selected period, and the average number of days (DSI) required to turn the average inventory into sales.
Form Toolbar
The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.
| Button | Description |
|---|---|
| Calculate Turnover |
Calculates the turnover for the items in warehouses and within the period range defined by the values of the boxes in the Selection area. |
| Manage Turnover History |
Opens the Manage Turnover History (IN507000) form. |
Selection Area
You can use the settings in this area to narrow the range of items listed in the table. The area also contains elements that are used during the calculation of the inventory turnover.
| Element | Description |
|---|---|
| Company/Branch |
The company, branch, or a group of companies for which you want to calculate the inventory turnover. The value in this box is mandatory. By default, the system specifies the current company, branch, or a group of companies selected in the Company and Branch Selection menu. |
| From Period |
The first period of the period range for which you want to calculate the inventory turnover. The value in this box is mandatory. |
| To Period |
The last period of the period range for which you want to calculate the inventory turnover. The value in this box is mandatory. |
| Warehouse |
The warehouse of the items for which you want to calculate the inventory turnover. |
| Item Class |
The class of the items for which you want to calculate the inventory turnover. |
| Inventory ID |
The inventory ID of the item for which the turnover should be calculated. You can leave the box blank to calculate the turnover for all items within the existing selection, or select a particular item and calculate the turnover for this item; alternatively, you can click the List button next to the box, and in the dialog box that opens, add multiple inventory items, so that you can calculate the turnover for a particular list of items. |
| List |
Opens the Inventory Item List dialog box. |
| Column | Description |
|---|---|
| Inventory ID |
The unique alphanumeric identifier of the item for which the inventory turnover has been calculated. |
| Description |
The description of the item. |
| Warehouse |
The warehouse in which the item is stored. |
| UOM |
The base UOM of the item. |
| Beginning Inventory ($) |
The total cost of an item in stock on the first day of the period specified in the From Period box in the Selection area. The currency symbol in the name of this column depends on the base currency of the branch or company. |
| Beginning Inventory (Units) |
The quantity of the item in stock on the first day of the period specified in the From Period box in the Selection area. |
| Ending Inventory ($) |
The total cost of an item in stock on the last day of the period specified in the To Period box in the Selection area. The currency symbol in the name of this column depends on the base currency of the branch or company. |
| Ending Inventory (Units) |
The quantity of the item in stock on the last day of the period specified in the To Period box in the Selection area. |
| Average Inventory ($) |
The average cost of the item available in the stock for the period range specified in From Period and To Period boxes in the Selection area. |
| Average Inventory (Units) |
The average quantity of the item for the period range specified in From Period and To Period boxes in the Selection area. |
| Cost of Goods Sold ($) |
The total cost of the item's quantity sold during the period range specified in From Period and To Period boxes in the Selection area. |
| Qty. of Items Sold | The quantity of items sold from the stock during the period range specified in From Period and To Period boxes in the Selection area. |
| Turnover Ratio ($) |
The ratio that shows how many times an item has been sold during the selected period. The inventory turnover for an item is calculated as the total cost of the sold quantity of the item within a selected period range divided by the average inventory cost of the item in the same period range. |
| Days Sales of Inventory |
The number of days required to sell out the average inventory. |