Page History: Item ABC Codes Update
Compare Page Revisions
Page Revision: Thu, 30 Aug 2012 07:48
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. This will calculate the total cost of items used in production, shipments, and time sheets.
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.
You can (and probably should) exclude non-stock, miscellaneous, and items with Custom BOMs.
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).
Check the
Export Only box to run all of the calculations, but only export the results instead of actually updating the database.
