Inventory Aging Group (ICAPG_IM09)

The Inventory Aging Group (ibis_icapg.im09) resource is used to create codes that represent the inventory aging analysis structure as defined by the inventory aging periods which are used to age your inventory.

• The Inventory Aging Group is used in conjunction with the Inventory Aging Period (ibis_im04) program which assigns the periods to each analysis group code defined here.

• These two programs are then utilized by Inventory Aging Generation (ibis_ic61). IC61 ages your inventory based on the periods defined and the output is available in view format in various inventory aging query views.

The following list identifies every field in the inventory aging groups table (icapg):

• Aging Group - displays the inventory aging group code. The code can be a maximum of 6 alpha numeric characters in length. Once an inventory again group is created, you cannot edit this field.

• Aging Group Description - displays a description of the aging group code. The description can be a maximum of 35 alpha numeric characters in length. TIP: The description should represent what the Inventory Aging Group Code does, for example you may want to enter '30/60/90 and older', 'Quarterly and older' or 'Monthly for 3 years'.

• Company - the company field is available when you create a new record. The company defaults to the company assigned to your user id in the Session Parameters view. You can change the default company during the creation process only. Once the record is created, the company to which the record is associated displays in the General section (at the top of the view).

• Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

• Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

• Last Aging Period Description - this field represents the period that falls outside of the Aging Periods defined in the Inventory Aging Period (ibis_im04) resource. Here is an example to illustrate this concept:
  • You set up an inventory aging group code of 'HDGIFT' that is defined to age inventory over 30, 60, and 90 days.
  • Inventory that is greater than 90 days old falls into the period beyond this definition.
  • We have called this period the Last Aging Period. Inventory that is greater than 90 days old will fall into this last aging period. In this example, we will give the last aging period a description of 'Greater than 91+'.

  The Last Aging Period Description can be a maximum of 35 alpha numeric characters in length.

• Modification Counter - this field is not maintainable. The date and time the record was last modified.

• Modified By - this field is not maintainable. The user or system process that last modified the record.

• Modified On - this field is not maintainable. The date on which the record was last modified.

• Revision Number - enter a revision number that represents the current revision of the inventory aging period and the inventory aging group. For more information on the Inventory Aging Period (ibis_im04) resource, please see the Inventory Aging Period topic.

• Version Pending - if the aging group record is pending, i.e. not yet in use, enter a Y in this field. This is not a mandatory field.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.