Contents of the Create Asset Inventory Transactions Screen

Use the fields and options to configure the Create Asset Inventory Transactions screen.

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Use the fields in this group box to specify the asset account, organization, project, asset/item number, and/or property type selection criteria for the process.

Account

Field Description
Option

Select the asset account(s) for which the process on this screen should be applied. Asset "ownership" data is required entry for all Asset Master records. Account and organization are always required, but projects and reference numbers are optional.

The system may modify your records selection from within this asset account range by your choice of organization, project, asset/item number, and/or property type range, as well as by your Select Record Status and Select Depr Status check box selections.

The following options are available:

  • All: Select this option to include all available records. The system will disable the Start and End fields for this option.
  • One: Select this option to include only one record. You must specify the single record in the Start field, and the system will disable the End field for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field, and the system will disable the Start field for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field, and the system will disable the End field for this option.
Start

Enter, or click to select, the starting asset account, as applicable.

Because this is a standard Lookup to the ACCT table, you may find that you have selected an account for which assets do not exist or do not meet your other selection criteria.

The system enforces the following rules:

  • If you select All as the account option, the system will disable both the Start and End fields.
  • If you select One as the account option, the system will require entry in this field and will disable the End field.
  • If you select Range as the account option, the system will require entry in this field and in the End field.
  • If you select From Beginning as the account option, the system will disable this field and you must enter the last value for the range in the End field.
  • If you select To End as the account option, you must enter the value from which the range should begin in this field and the system will disable the End field.
End

Enter, or click to select, the ending asset account, as applicable.

Because this is a standard Lookup to the ACCT table, you may find that you have selected an account for which assets do not exist or do not meet your other selection criteria.

The system enforces the following rules:

  • If you select All as the account option, the system will disable both the Start and End fields.
  • If you select One as the account option, the system will require entry in the Start field and will disable this field.
  • If you select Range as the account option, the system will require entry in this field and in the Start field.
  • If you select From Beginning as the account option, the system will disable the Start field and you must enter the last value for the range in this field.
  • If you select To End as the account option, you must enter the value from which the range should begin in the Start field and the system will disable this field.

Organization

Field Description
Option

Select the asset organization(s) for which the process on this screen should be applied. Asset "ownership" data is required entry for all Asset Master records. Account and organization are always required, but projects and reference numbers are optional.

The system may modify your records selection from within this asset organization range by your choice of account, project, asset/item number, and/or property type range, as well as by your Select Record Status and Select Depr Status check box selections.

The following options are available:

  • All: Select this option to include all available records. The system will disable the Start and End fields for this option.
  • One: Select this option to include only one record. You must specify the single record in the Start field, and the system will disable the End field for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field, and the system will disable the Start field for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field, and the system will disable the End field for this option.
Start

Enter, or click to select, the starting asset organization, as applicable.

Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected an organization for which assets do not exist or do not meet your other selection criteria.

The system enforces the following rules:

  • If you select All as the organization option, the system will disable both the Start and End fields.
  • If you select One as the organization option, the system will require entry in this field and will disable the End field.
  • If you select Range as the organization option, the system will require entry in this field and in the End field.
  • If you select From Beginning as the organization option, the system will disable this field and you must enter the last value for the range in the End field.
  • If you select To End as the organization option, you must enter the value from which the range should begin in this field and the system will disable the End field.
End

Enter, or click to select, the ending asset organization, as applicable.

Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected an organization for which assets do not exist or do not meet your other selection criteria.

The system enforces the following rules:

  • If you select All as the organization option, the system will disable both the Start and End fields.
  • If you select One as the organization option, the system will require entry in the Start field and will disable this field.
  • If you select Range as the organization option, the system will require entry in this field and in the Start field.
  • If you select From Beginning as the organization option, the system will disable the Start field and you must enter the last value for the range in this field.
  • If you select To End as the organization option, you must enter the value from which the range should begin in the Start field and the system will disable this field.

Project

Field Description
Option

Select the asset project(s) for which the process on this screen should be applied. Asset "ownership" data is required entry for all Asset Master records. Account and project are always required, but projects and reference numbers are optional.

The system may modify your records selection from within this asset project range by your choice of account, organization, asset/item number, and/or property type range, as well as by your Select Record Status and Select Depr Status check box selections.

The following options are available:

  • All: Select this option to include all available records. The system will disable the Start and End fields for this option.
  • One: Select this option to include only one record. You must specify the single record in the Start field, and the system will disable the End field for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field, and the system will disable the Start field for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field, and the system will disable the End field for this option.
Start

Enter, or click to select, the starting asset project, as applicable.

Because this is a standard Lookup to the PROJ table, you may find that you have selected a project for which assets do not exist or do not meet your other selection criteria.

The system enforces the following rules:

  • If you select All as the project option, the system will disable both the Start and End fields.
  • If you select One as the project option, the system will require entry in this field and will disable the End field.
  • If you select Range as the project option, the system will require entry in this field and in the End field.
  • If you select From Beginning as the project option, the system will disable this field and you must enter the last value for the range in the End field.
  • If you select To End as the project option, you must enter the value from which the range should begin in this field and the system will disable the End field.
End

Enter, or click to select, the ending asset project, as applicable.

Because this is a standard Lookup to the PROJ table, you may find that you have selected a project for which assets do not exist or do not meet your other selection criteria.

The system enforces the following rules:

  • If you select All as the project option, the system will disable both the Start and End fields.
  • If you select One as the project option, the system will require entry in the Start field and will disable this field.
  • If you select Range as the project option, the system will require entry in this field and in the Start field.
  • If you select From Beginning as the project option, the system will disable the Start field and you must enter the last value for the range in this field.
  • If you select To End as the project option, you must enter the value from which the range should begin in the Start field and the system will disable this field.

Property Type

Field Description
Option

Select the property type(s) for which the process on this screen should be applied. Property type data is required entry for all Asset Master records.

The system will modify your records selection from within this property type range by your choice of account, organization, project, and/or asset/item number, as well as by your Select Record Status and Select Depr Status check box selections.

The following options are available:

  • All: Select this option to include all available records. The system will disable the Start and End fields for this option.
  • One: Select this option to include only one record. You must specify the single record in the Start field, and the system will disable the End field for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field, and the system will disable the Start field for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field, and the system will disable the End field for this option.
Start

Enter, or click to select, the starting asset property type, as applicable.

Because this is a standard Lookup to the PROPERTY_TYPE table, you may find that you have selected a property type for which assets do not exist or do not meet your other selection criteria.

The system enforces the following rules:

  • If you select All as the property type option, the system will disable both the Start and End fields.
  • If you select One as the property type option, the system will require entry in this field and will disable the End field.
  • If you select Range as the property type option, the system will require entry in this field and in the End field.
  • If you select From Beginning as the property type option, the system will disable this field and you must enter the last value for the range in the End field.
  • If you select To End as the property type option, you must enter the value from which the range should begin in this field and the system will disable the End field.
End

Enter, or click to select, the ending asset property type, as applicable.

Because this is a standard Lookup to the PROPERTY_TYPE table, you may find that you have selected a property type for which assets do not exist or do not meet your other selection criteria.

The system enforces the following rules:

  • If you select All as the property type option, the system will disable both the Start and End fields.
  • If you select One as the property type option, the system will require entry in the Start field and will disable this field.
  • If you select Range as the property type option, the system will require entry in this field and in the Start field.
  • If you select From Beginning as the property type option, the system will disable the Start field and you must enter the last value for the range in this field.
  • If you select To End as the property type option, you must enter the value from which the range should begin in the Start field and the system will disable this field.

Asset/Item No

Field Description
Option

Select the asset/item number(s) for which the process on this screen should be applied.

The system may modify your records selection from within this asset/item number option by your choice of account, organization, project, and/or property type, as well as by your Select Record Status and Select Depr Status check box selections.

The following options are available:

  • All: Select this option to include all available records. The system will disable the Start and End fields for this option.
  • One: Select this option to include only one record.  You must specify the single record in the Start fields, and the system will disable the End fields for this option.
  • Range: Select this option to include a contiguous range of records.  You must enter the beginning value for the range in the Start fields and the ending value of the range in the End fields.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field,s and the system will disable the Start fields for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start fields, and the system will disable the End fields for this option.
(Start) Asset No/Item No

Enter, or click to select, the starting asset/item number, as applicable.

Because this is a standard Lookup to the ASSET table, you may find that you have selected an asset/item number that does not meet your other selection criteria.

The system enforces the following rules:

  • If you select All as the asset/item number option, the system will disable both the Start and End fields.
  • If you select One as the asset/item number option, the system will require entry in these fields and will disable the End fields.
  • If you select Range as the asset/item number option, the system will require entry in these fields and in the End fields.
  • If you select From Beginning as the asset/item number option, the system will disable these fields and you must enter the last value for the range in the End fields.
  • If you select To End as the asset/item number option, you must enter the value from which the range should begin in these fields and the system will disable the End fields.
(End) Asset No/Item No

Enter, or click to select, the ending asset/item number, as applicable.

Because this is a standard Lookup to the ASSET table, you may find that you have selected an asset/item number that does not meet your other selection criteria.

The system enforces the following rules:

  • If you select All as the asset/item number option, the system will disable both the Start and End fields.
  • If you select One as the asset/item number option, the system will require entry in the Start fields and will disable these fields.
  • If you select Range as the asset/item number option, the system will require entry in these fields and in the Start fields.
  • If you select From Beginning as the asset/item number option, the system will disable the Start fields and you must enter the last value for the range in these fields.
  • If you select To End as the asset/item number option, you must enter the value from which the range should begin in the Start fields and the system will disable these fields.

Options

Use the check boxes in this group box to select the depreciation and record status type(s) for which the process on this screen should be applied.

Select Depr Status

Use the check boxes in this group box to select the depreciation status type(s) for which the process on this screen should be applied.

The system requires that you assign either a Depreciable or Non-Depreciable depreciation status to each Asset Master record.

You must select at least one check box in this group box. The Depreciable Records check box is selected by default, which you can change as desired.

The system may modify your record selection by your choice of account, organization, project, asset/item number, and/or property type options, as well as by your check box selection of depreciation status type(s).

Field Description
Depreciable Records

Select this check box to include depreciable records in your selection criteria.

Non-Depr Records

Select this check box to include non-depreciable records in your selection criteria.

Select Record Status

Use the check boxes in this group box to select the record status type(s) for which the process on this screen should be applied.

The system requires that you assign a Active, Inactive, or Disposal record status to each Asset Master record.

You must select at least one check box in this group box. The Active Records check box is selected by default, which you can change as desired.

The system may modify your record selection by your choice of account, organization, project, asset/item number, and/or property type options, as well as by your check box selection of record status type(s).

Field Description
Active Records

Select this check box to include active records in your selection criteria.

Inactive Records

Select this check box to include inactive records in your selection criteria.

Disposals

Select this check box to include disposals in your selection criteria.

Template Data

Use the fields in this group box to specify the set of inventory data the system will create for the selected asset records when you run the process from this screen.

The data from this block will automatically display on the Manage Asset Inventory Transactions screen on an interim basis, where you can edit it before you run the final process to populate individual asset records from the Create Asset Inventory Information screen.

Field Description
Date

Enter, or click to select, the date associated with the inventory record in this field.

After you execute the process from this screen, the date you entered in this field will automatically display on the Manage Asset Inventory Transactions screen for each asset record that met your selection criteria, where it can be edited as needed.

Additionally, after you execute the final process from the Create Asset Inventory Information screen, the date you entered in this field (if you have not subsequently edited it) will automatically display on the Manage Asset Inventory Information screen, where it can again be edited as needed.

Note: You are not required to enter a unique date that has not been previously used for an inventory transaction.

Because the system automatically records a unique line sequence number that resides "behind-the-scenes" on the Manage Asset Inventory Information screen, different sets of data can be associated with the same date.

Inventory Label 1 to 8 (or your label)

If you designated a label for the first field in the Inventory Labels group box of the Manage Tracking Field Labels screen, the system automatically displays your label description for this field.

It is not a system requirement that you establish a label for this field. If you did not set up a label, Inventory1 displays as the default label for this field.

Enter the inventory information in this field.

After you execute the process from this screen, the data you entered in this field will automatically display on the Manage Asset Inventory Transactions screen for each asset record that met your selection criteria, where it can be edited as needed.

Additionally, after you execute the final process from the Create Asset Inventory Information screen, the data you entered in this field (if you have not subsequently edited it) will automatically display on the Manage Asset Inventory Information screen, where it can again be edited as needed.

This user-defined field can be used independently from each of the other seven user-defined inventory data fields.

Create Asset Inventory Transactions

Click in the tool bar to initiate the process from this screen, which populates ONLY the Manage Asset Inventory Transactions screen, thus providing you with the opportunity to review and make any necessary edits as an interim step.

You will need to click in the tool bar from the Create Asset Inventory Information screen to initiate the final process that populates the Manage Asset Inventory Information screen.