Update ABC Code

Form ID: (IN506000)

Note: This form is available only if the Advanced Physical Counts feature is enabled on the Enable/Disable Features (CS100000) form.

You can use this form to make mass changes to the ABC codes assigned to the inventory items in a selected warehouse, assigning each item a specific ABC code based on the stock value of the item in the chosen financial period and the code definitions. 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 Inventory Ranking Methods.

On this form, you can view the list of inventory items with their current and projected ABC codes, and update the ABC code assignments for the listed items. Fixed ABC codes assigned to items on the Stock Items (IN202500) form are not reassigned during this processing.

You define the ABC codes for your site by using the ABC Codes (IN208500) form. Initially, you can manually assign ABC codes to items at a specific warehouse on the General tab of the Item Warehouse Details (IN204500) form.

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
Process Updates the ABC code assignments for the inventory items listed in the table, using your ABC code definitions from the ABC Codes (IN208500) form. Fixed codes are not reassigned during processing.

Selection Area

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.

Element Description
Warehouse

The warehouse where the ABC code assignment will be performed.

This box appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.

Period The financial period the ABC code assignment will be based on.

Table

The 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 form.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Column Description
Inventory ID The inventory item at the warehouse whose ABC code can be updated.
Description The description of the inventory item.
Current ABC Code The ABC code currently assigned to the inventory item.
Fixed A check box that indicates (if selected) that the ABC code is fixed for this inventory item. Fixed ABC codes are not updated. You can assign fixed ABC codes to a stock item by using the Stock Items form.
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 inventory item. This assignment is based on the code definition and on the stock value of the item for the selected period.