962 - Reporting - Manage Age Categories

Assign inventory age categories to product and location combinations to provide visual guidance in inventory planning activities.

To create an inventory age category:

1. Select the Add Inventory Age Category button.
2. Specify a display name for the category and select Submit. This adds an entry to the Inventory Age Categories table.
3. Specify From Days (>=) and To Days (<=) values so these are sequential and there are no gaps. 
   • The first category must have From Days (>=) set to one.
   • Subsequent categories must start a day after the previous one ends.
   • The last category must have To Days (<=) value set to zero as a catch-all.
4. For each category set an Age Color Coding (-10 to +10) value. 
   • Categories with a value of 1 to 10 sets the cell's color to green.
   • Categories with a value of -1 to -10 sets the cell's color to red.
   • Values between 10 and -10 display in intermediate shades of green and red, depending on the number of categories that exist.

Once you have created your categories, select the Sort Inventory Age Categories button to maintain an ordered sequence. It's essential to sort after any additions or edits. This requires a workspace administrator permission in the model.

To delete an inventory age category:

1. Select Delete? against the Inventory Age Category item you want to delete.
2. Select Delete Inventory Age Category.