Page History: Item ABC Codes Update
Compare Page Revisions
Page Revision: Mon, 07 May 2012 17:00
General Information
Default Menu Location: Transaction >> Item Control >> Item ABC Update
Screen Name: ABCITEM
Function: Updates items' ABC code based on user-selected criteria such as usage value, on hand value, or usage qty.
 Item ABC Update |
How To Update
First, choose your calculation criteria. We recommend basing your ABC codes on
Usage-Total Value.
Second, enter your percentages for each code. You can select up to 26 different classifications, but the totals must equal 100%.
Third, if calculating your codes based on usage, enter your date range for the calculations. Usage includes timesheet entries, shipments, and production work order assignments. It does not include transfers or adjustments.
Click
Update to update the
Item Master. After the program finishes, it will export the results to Excel (item, descrip, old ABC, new ABC, qty used, total cost, current on hand, current on hand value).
