Contents of the Print Asset Master List Screen
Use the fields and options to configure the Print Asset Master List Screen.
Since there are more than 280 fields in an Asset Master record (excluding the unlimited number of user-defined fields), this report only lists a handful of basic Asset Master data. If you need to print a quick list that contains different data, you will need to create a custom report to meet your specific requirements.
You can print the Asset Master List with different formats and a number of different sort options. For all sort options, you can also choose to print the Total Cost amount (from the G/L Book Info tab on the Manage Asset Master Information screen or from the Manage Asset Cost Information screen.
Use this report to create different lists by including or excluding active/inactive records, depreciable/non-depreciable records, and/or disposals.
This report selection screen contains four blocks, as follows:
- Identification: Use the fields in this block to create a new parameter ID or to retrieve a previously-saved parameter ID.
- Selection Ranges: Use the fields in this group box to specify the asset account, organization, record-added dates, asset/item numbers, and/ or timing selection criteria for the report.
- Options: Use the check boxes in this group box to specify the depreciation and record status type(s) as selection criteria for the report, as well as whether to print the asset's cost for the G/L book on the report.
- Sort By: Use this fields in this group box to specify the field by which to sort the records (by asset/item number, asset account, asset organization, acquisition fiscal year/period, date record added, or entry date, as well as to choose whether there should be a page break each time the selected sort criteria changes.
You can run the report on this screen only for your login company. If you have multiple companies, you cannot run the report from this screen for any company other than your company of login.
The Asset Master List provides a "snapshot" of existing asset data at the time you run the report. You can print this report at any time.
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
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 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.
Selection Ranges
Use the fields in this group box to specify the asset account, asset organization, record-added date, asset/item number, and acquisition FY/period selection criteria for the report.
Asset Account
Select the asset account(s) for which you want the report to generate. 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, record-added date, and/or acquisition FY/period range, inventory date type range, as well as by your check box selections in the Select Record Status and Select Depreciation Status group boxes.
| Field | Description |
|---|---|
| Option |
Select the asset account range option from the drop-down list. The following selection options are available:
|
| Start |
Enter, or click
If you select All or From Beginning in the Option field, this field will be inactive. |
| End |
Enter, or click If you select All, One, or To End in the Option field, this field will be inactive. |
to select, the starting asset account, as applicable.
Organization
Select the asset organization(s) for which you want the report to generate. 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, record-added date, and/or acquisition FY/period range, as well as by your check box selections in the Select Record Status and Select Depreciation Status group boxes.
| Field | Description |
|---|---|
| Option |
Select the asset organization range option from the drop-down list. The following selection options are available:
The default option for this field is All. You can accept the displayed default organization option, enter a different valid organization option, or select one from the drop-down list. |
| Start |
Enter, or click
If you select All or From Beginning in the Option field, this field will be inactive. |
| End |
Enter, or click
If you select All, One, or To End in the Option field, this field will be inactive. |
Record Added Dates
Select the record-added date(s) for which you want the report to generate.
The system may modify your records selection from within this record-added date range by your choice of account, organization, asset/item number, and/or acquisition FY/period range, as well as by your check box selections in the Select Record Status and Select Depreciation Status group boxes.
| Field | Description |
|---|---|
| Option |
Select the range option for the record-added dates from the drop-down list The following selection options are available:
|
| Start |
Enter, or click
If you select All or From Beginning in the Option field, this field will be inactive. |
| End |
Enter, or click
If you select All, One, or To End in the Option field, this field will be inactive. |
to select, the starting inventory date, as applicable.
Asset/Item Numbers
Select the asset/item numbers for which you want the report to generate.
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 check box selections in the Select Record Status and Select Depreciation Status group boxes.
| Field | Description |
|---|---|
| Option |
Select the range option for the asset/item numbers from the drop-down list. The following selection options are available:
|
| Start Asset No/Item No |
Enter, or click
If you select All or From Beginning in the Option field, these fields will be inactive. |
| End Asset No/Item No |
Enter, or click
If you select All, One, or To End in the Option field, these fields will be inactive. |
Timing
Use the fields in this group box to select one, a range of, or all acquisition fiscal years and periods for the report. (The acquisition fiscal year and period are required fields in the Purch Info tab of the Manage Asset Master Information and on the Manage Asset Purchase Information screens for all property records.)
| Field | Description |
|---|---|
| Option |
The default option for this field is All. You can accept the displayed default range option, enter a valid range option, or select one from the drop-down list. The following are the range options:
|
| Start Acq FY/Acq Pd |
Enter the beginning acquisition fiscal year and period for the range. If you select All or From Beginning in the Option field, these fields will be inactive. |
| End Acq FY/Acq Pd |
Enter the ending acquisition fiscal year and period for the range. If you select All, One, or To End in the Option field, these fields will be inactive. |
Options
Select Record Status
Use the check boxes in this group box to select the record status type(s) for which you want the report to generate.
The system requires that you assign an 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.
| Field | Description |
|---|---|
| Active Records |
This check box is selected by default. 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. Note: You can enter disposals for active records on the Manage Disposal Transactions screen. Once the disposal is posted to the General Ledger, the system changes the record's status from Active to Disposal. In the rare circumstance that you need to enter disposal data for historical asset records, you can use the Disp Info tab of the Manage Asset Master Information screen or the Manage Asset Disposal Information screen.
|
Select Depreciation Status
Use the check boxes in this group box to select the depreciation status type(s) for which you want the report to generate.
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.
| Field | Description |
|---|---|
| Depreciable Records |
This check box is selected by default. Select this check box to include depreciable records in your selection criteria. |
| Non-Depreciable Records |
Select this check box to include non-depreciable records in your selection criteria. |
Show
| Field | Description |
|---|---|
| Asset Cost Column - G/L Book |
Select this check box to print the Asset Total Cost column for the G/L Book on the report. This check box is clear by default. Note: You can save your sort options and selection criteria for this report with or without printing. After making your selections, click
 on the toolbar or select
Save in the File menu.
|
Sort By
Use the fields in this group box to specify sort and page break options.
| Field | Description |
|---|---|
| 1st Sort |
Select the primary sort from the drop-down list that you want to use for the report. You can choose to sort the inventory data records by the following:
Sort details:
When you print the report, the system automatically creates column header labels from the information in the category you sort by. For instance, if you sort by either Asset Account or Asset Organization, the system will print each account/organization number combination as a header label and all its associated information will print in rows beneath it. |
| 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 No, data for each different company begins on a new report page. |