11.3.1. Update ABC Class

11.3.1. Update ABC Class
	11.3. Update Item Controls

11.3.1. Update ABC Class

Item ABC classifications can be used as a filter on various inventory reports and be used to determine an Item's cycle count frequency. The basic formula the system uses to determine the ABC classification of Items is to multiply the volume of transactions for an Item during a specified period by the Item Costs for the Item. Those Items having the greatest transaction value are considered Class "A" Items. Those Items having the least transaction value are considered Class "C" Items. Items may be grouped into ABC classes on a Site-by-Site basis, using any percentages you want.

For example, let\qs say you want to do a 70-20-10 split—where A = 70% of the value for a period, B = 20%, and C = 10%. In this scenario, you would open the "Update ABC Class" screen shown below and enter the following values:

Class A Cutoff: 70
Class B Cutoff: 90

The remaining Items having the lowest percentage of the value (10%) would be assigned to the Class "C." By contrast, if you wanted to do a 50-30-20 split, you would enter the following values:

Class A Cutoff: 50
Class B Cutoff: 80

The remaining Items having the lowest percentage of the value (20%) would be assigned to the Class "C."

To update the ABC classification for Item Sites within a given Site and Class Code, select the "ABC Class" option. The following screen will appear:

Update ABC Class

Note

Updating ABC Class values across multiple Sites simultaneously can lead to inaccuracies in your data—especially if ABC values are calculated differently in different Sites. For this reason, it may make more sense to update ABC Classes on a Site-by-Site basis.

When calculating the ABC class of Item Sites within a given Site and Class Code, you are presented with the following options:

All Sites: Select to update ABC Classes in all Sites.
Selected: Specify Site where ABC Classes are to be updated.
All Class Codes: Select to update ABC Classes for all Class Codes.
Selected: Specify Class Code whose ABC Class you want to update.
Pattern: Enter a Class Code pattern to select a range of Class Codes. Refine your search using Regular Expressions.
Class A Cutoff %: Allows you to set the cutoff percentage for Class A Items.
Class B Cutoff %: Allows you to set the cutoff percentage for Class B Items.
Evaluation Start Date: Date entered determines the day from which the value will be calculated.
Evaluation End Date: Date entered determines the day at which the value will stop being calculated.

The following buttons are unique to this screen:

UPDATE: Updates Item Site ABC classifications, using the specified parameters.


11.3. Update Item Controls		11.3.2. Update Cycle Count Frequency

xTuple ERP Reference Guide

11.3.1. Update ABC Class

Note