Contents of the Print Asset Inventory Information Report Screen

Use the fields and options to configure the Print Asset Inventory Information Report 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 block to specify the asset account, organization, project, asset/item number, and/or inventory date selection criteria for the process.

Asset Accounts

Field	Description
Option	Select the asset account(s) for which the report data should be generated. 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 inventory date type range, as well as by your Select Record Status and Select Depreciation Status check box selections. The following selection 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 inventory records do not exist or do not meet your other selection criteria.
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 inventory records do not exist or do not meet your other selection criteria.

Organizations

Field	Description
Option	Select the asset organization(s) for which the report data should be generated. 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 inventory date range, as well as by your Select Record Status and Select Depr Status check box selections. The following selection 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 inventory records do not exist or do not meet your other selection criteria.
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 inventory records do not exist or do not meet your other selection criteria.

Projects

Field	Description
Option	Select the asset project(s) for which the report data should be generated, as applicable. Asset "ownership" data is required entry for all Asset Master records. Accounts and organizations 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 inventory date range, as well as by your Select Record Status and Select Depr Status check box selections. The following selection 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 inventory records do not exist or do not meet your other selection criteria.
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 inventory records do not exist or do not meet your other selection criteria.

Asset/Item Numbers

Field	Description
Option	Select the asset/item number(s) for which the report data should be generated. The system may modify your records selection from within this asset/item number option by your choice of account, organization, project, and/or inventory date, as well as by your Select Record Status and Select Depr Status check box selections. The following selection 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 fields 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 for which inventory records do not exist or that do not meet your other selection criteria.
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 for which inventory records do not exist or that do not meet your other selection criteria.

Inventory Dates

Field	Description
Option	Select the inventory date(s) for which the report data should be generated. The system may modify your records selection from within this inventory date option 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 selection 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 fields 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	Enter, or click to select, the starting inventory date, as applicable. You may find that you have selected an inventory date for which inventory records do not exist or that do not meet your other selection criteria.
End	Enter, or click to select, or use Calendar Lookup to select, the ending inventory date, as applicable. You may find that you have selected an inventory date for which inventory records do not exist or that do not meet your other selection criteria.

Options

Use the check boxes and fields in this group box to select the depreciation type(s) and record status type(s) for which the report should be generated, as well as your choice of the specific inventory data that should display in the four available data columns on the report.

Select Record Status

Use the check boxes in this group box to select the record status type(s) for which the report should be generated.

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

The system may modify your record selection by your choice of account, organization, project, asset/item number, and/or inventory date options, as well as by your Select Record Status and Select Depr Status check box selections.

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

Select Data for Report

Use the data fields in this group box to optionally specify up to four of the eight available user-defined inventory data fields to print on the report.

Your selected user-defined inventory data, as applicable, will print on the report in the sequential column order that you specify. For example, the system will display the data you have specified for Column 1 first, the data you have specified for Column 2 next, and so on.

If you do not want to include four data fields on the report, you can leave any of these columns blank. Because the column fields are optional and will print in the order you select, you can use the selection in this group box to create many different report formats.

The system will not shift blank columns to the left on your printed report and will display these as blank spaces on the report. If you want to include blank spaces between columns to make it easier to review your data, you can select data fields for alternate columns only. For example, if you select data fields to be printed only in Columns 1 and 3, Columns 2 and 4 will then print as blank columns, leaving extra space on the report.

Field	Description
Column 1	Enter, or click to select, the desired inventory data field (from the eight data fields available) that should display in Column 1, as applicable. If you designated one or more labels for the inventory data fields in the Inventory Labels group box of the Manage Tracking Field Labels screen, the system automatically displays your labels for the inventory data fields in the Lookup. It is not a system requirement that you have one or more pre-established labels for the inventory data fields. If you did not set up labels, the system displays the corresponding default labels for the data fields, such as Inventory1, Inventory2, and so on.
Column 2, Column 3 and Column 4	Please refer to the documentation for the Column 1 field.

Select Depreciation Status

Use the check boxes in this group box to select the depreciation status type(s) for which the report should be generated.

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 inventory data options, as well as by your Select Record Status and Select Depr Status check box selections.

Field	Description
Depreciable Records	Select this check box to include depreciable records in your selection criteria.
Non-Depreciable Records	Select this check box to include depreciable records in your selection criteria.

Sort By

Use the fields in this group box to specify sort and page break options.

Field	Description
1st Sort	Select the primary sort field for the report from the drop-down list. You can choose to sort the inventory data records by: Asset/Item Number: Select this if you want the system to sort the records first by ascending asset/item number and then by ascending inventory date. Asset Account/Org: Select this if you want the system to sort the records first by ascending asset account/organization, and then by ascending asset/item number, then by ascending inventory date. Inventory Date: Select this if you want the system to sort the records first by ascending inventory date and then by ascending asset/item number.
Page Break	Select this check box to produce a report that begins a new page each time the selected sort criteria changes. For example, if you select to sort the report by Asset/Item Number, data for each different company begins on a new report page.