Update ABC code (IN506000)
The system arranges items by decreasing percentages in total stock value, calculates subtotals for each item (starting from the top of the list), and assigns projected ABC codes in accordance with the code threshold percentages. For details, see: About inventory ranking methods
In this window, you can also view the list of stock items with their current and projected ABC codes, and update the ABC code assignments for the listed items. Fixed ABC codes assigned to items in the Stock items (IN202500) window are not reassigned during this processing.
You define the ABC codes for your site by using the ABC codes (IN208500) window. Initially, you can manually assign ABC codes to items at a specific warehouse on the General settings tab of the Item warehouse details (IN204500) window.
The top part
In this area, you select the warehouse where the ABC code assignments will be updated and the financial period used to provide cost and stock value statistics for assigning ABC codes to items.
| Button | Description |
|---|---|
| Process | Updates the ABC code assignments for the stock items listed in the details table, using your ABC code definitions from the ABC codes (IN208500) window. Fixed codes are not reassigned during processing. |
| Element | Description |
|---|---|
| Warehouse | The warehouse where the ABC code assignment will be performed. Note This field is only displayed if the Multiple warehouses functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Period | The financial period the ABC code assignment will be based on. |
The table
This table shows the read-only list of items available in the selected warehouse for which ABC code assignments will be updated, based on the data of the chosen financial period. If no data is available for the period, the lowest code is assigned to all items.
Assignment of codes is performed automatically and cannot be edited by using this window.
| Column | Description |
|---|---|
| Item ID | The stock item at the warehouse whose ABC code can be updated. |
| Description | The description of the stock item. |
| Current ABC code | The ABC code currently assigned to the stock item. |
| Fixed | This check box indicates (if selected) that the ABC code is fixed for this stock item. Fixed ABC codes are not updated. You can assign fixed ABC codes to a stock item by using the Stock items (IN202500) window. |
| Criteria value | The criterion value for the item. |
| Ratio (%) | The ratio (expressed as a percent) calculated for the item as the criterion value (item stock value) divided by the criterion total value (for all items). |
| Cumulative ratio (%) | The sum of ratios from the top of the list, including the current item. |
| Projected ABC code | The ABC code to be assigned to the stock item. This assignment is based on the code definition and on the stock value of the item for the selected period. |