PRINT ASSET MASTER DETAIL REPORT

You can use the Print Asset Master Detail Report to view and print data from the Asset Master record(s).

Location

Four separate pages print per record. (If you use all 10 books, an additional page prints to accommodate data for Books 7 to 10.) Data displays on each page as follows:

You can include or exclude active, inactive, and/or disposal records, and select depreciable and/or non-depreciable records.

You can sort by asset/item number, asset account, asset organization, asset project, acquisition fiscal year/period, or record-added date. Regardless of the sort sequence, all selected pages for a single record print before the pages for the next record print.

All pages print in the same format. The asset number, item number, and short description display in the header of each page.

Because the Asset Master Detail Report provides a "snapshot" of your asset data as it currently exists, you can print this report at any time and as frequently as necessary.

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 are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

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 in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in 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 in the screen, you can override the defaults.

Description

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

Selection Ranges

Asset Accounts

In this selection parameter, you can choose the asset accounts you want to include in the report. The asset account is required in the Acct Info tab of the Manage Asset Master Information screen and on the Manage Asset Account Information screen for all property records, and denotes the "ownership" account, such as company-owned balance sheet, project, and so on.

Click in the Start and End fields to select a range of asset accounts that you want to include in the report. Because this is a standard lookup to the ACCT table, you may find that you have selected accounts for which asset data does not exist or does not meet your other selection criteria.

Option

Select the asset account range option from the drop-down list. The available range options are:

The default option for this field is All. If you have a large number of asset accounts, you may want to consider selecting a different option than All to limit the number of records to print.

Start

Enter, or click to select, the beginning asset account in this field.

If you select All or From Beginning in the Option drop-down list, this field will be inactive.

End

Enter, or click to select, the ending asset account in this field.

If you select All, One or To End in the Option drop-down list, this field will be inactive.

Asset Organizations

In this selection parameter, you can choose the organizations that you want to include in the report. The asset organization is required in the Acct Info tab of the Manage Asset Master Information screen and on the Manage Asset Account Information screen or all property records.

Click in the Start and End fields to select a range of asset organizations that you want to include in the report. Because this is a standard lookup to the ORG_ACCT table, you may find that you have selected organizations for which asset data does not exist or does not meet your other selection criteria.

Option

Select the asset organization range option from the drop-down list. The range options that are available are the following:

The default option for this field is All. If you have a large number of asset organizations, you may want to consider selecting a different option than All to limit the number of records to print.

Start

Enter, or click to select, the beginning asset organization in this field.

If you select All or From Beginning in the Option drop-down list, this field will be inactive.

End

Enter, or click to select, the ending organization in this field.

If you select All, One or To End in the Option field, this field will be inactive.

Asset Projects

In this selection parameter, you can choose the asset projects that you want to include in the report. The asset project is optional in the Acct Info tab of the Manage Asset Master Information screen and on the Manage Asset Account Information screen for all property records.

Click in the Start and End fields to select a range of asset projects that you want to include in the report. Because this is a standard lookup to the PROJ table, you may find that you have selected projects for which asset data does not exist or does not meet your other selection criteria.

Option

Select the asset project range option from the drop-down list. The range options that are available are:

The default option for this field is All. If you have a large number of asset project, you may want to consider selecting a different option than All to limit the number of records to print.

Start

Enter, or click to select, the beginning asset project in this field.

If you select All or From Beginning in the Option drop-down list, this field will be inactive.

End

Enter, or click to select, the ending project in this field.

If you select All, One or To End in the Option drop-down list, this field will be inactive.

Asset/Item Numbers

In this selection parameter, you can choose the asset/item numbers that you want to include in the report. If you enter a specific asset number, you must also enter a corresponding item number before you can run the report.

Click in the Start Asset No/Item No and End Asset No/Item No fields to select a range of asset/item numbers that you want to include in the report. Because this is a standard lookup to the ASSET table, you may find that you have selected assets that do not meet your other selection criteria.

Option

Select the range option from the drop-down list. The available options are the following:

The default option for this field is One.

Start Asset No/Item No

Enter, or click to select, the beginning asset/item numbers.

If you select All or From Beginning in the Option drop-down list, these fields will be inactive.

End Asset No/Item No

Enter, or click to select, the ending asset/item numbers.

If you select All, One or To End in the Option drop-down list, these fields will be inactive.

Record-Added Dates

You can use the fields in this selection parameter to choose the record-added dates for the report. The record-added date is the date when the asset record was originally created. The record-added date displays in the Date field of the Manage Asset Master Information screen and in the Entry Date/Time field on the Manage Asset Description Information screen and cannot be edited.

When you enter dates in this selection parameter, you may find that you have selected dates for which asset data does not exist or does not meet your other selection criteria.

Option

Select the record-added date range option from the drop-down list. The available options are the following:

Start

Enter (in date format), or click to select, the beginning record added date.

If you select All or From Beginning in the Option drop-down list, this field will be inactive.

End

Enter (in date format), or click to select, the ending record-added date.

If you select All, One or To End in the Option drop-down list, this field will be inactive.

Acquisition

In this group box you can select the acquisition fiscal years, periods and subperiods for the report. The acquisition fiscal year, period and subperiod are required in the Purch Info tab of the Manage Asset Master Information screen and on the Manage Asset Purchase Information screen for all property records.

Because there is no system validation of the entered data, you may find that you have selected fiscal years/periods for which asset data does not exist or does not meet your other selection criteria.

Option

Select the acquisition period range option from the drop-down list. The available options are the following:

Start Fiscal Year/Period/Subpd

Enter the beginning acquisition fiscal year, period and/or subperiod for the range.

If you select All or From Beginning in the Option drop-down list, these fields will be inactive.

End Fiscal Year/Period/Subpd

Enter the ending acquisition fiscal year, period and/or subperiod for the range.

If you select All, One or To End in the Option drop-down list, these fields will be inactive.

Options

Select Depr Status

Use the check boxes in this group box to choose the depreciation status type(s) to include in your print selection criteria. You can print data for depreciable records or non-depreciable records. You must select at least one check box in this group box. The selection of records from this screen may be modified by your selection of asset/item number, asset account number, organization and/or project ranges.

Depreciable Records

This check box is selected by default. Select this check box to include depreciable records in your report selection criteria.

Non-Depr Records

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

Select Records Status

Use the check boxes in this group box to choose the record status type(s) to include in your print selection criteria. You can print data for active, inactive, and/or disposal records. You must select at least one check box in this group box. The selection of records from this screen may be modified by your selection of asset/item number, asset account number, organization, record-added dates, and/or acquisition fiscal year/period ranges.

Active

Select this check box to include active records in your report selection criteria. This check box is selected by default.

Inactive

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

Disposal

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

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.

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. Enter an alphanumeric identifying code and a short description to help you recognize the report parameters and select OK. Later, you can use Query from this screen to access the print parameters you created and run the same report without re-entering all the screen information again. Stored report parameters are especially useful if you run the report through the Process Manager.

If you want to keep these parameters but want to run a slightly different report, you can use the command, Copy Record to copy the parameters and make minor changes to them without changing your saved parameters. Open the record that you want to copy, and then select Copy Record in the Line menu. A message will display on the screen that confirms that the record has been duplicated. Edit the record as needed.

Print

In this group box, you can select the page or pages to include in the report for each Asset Master record that falls within your selection criteria. The All Asset Information check box is the default and, while it remains selected, the other check boxes will be inactive.

All Asset Information

Select this check box to print all available Asset Master record data.

Clear this check box to enable the other check boxes in this group box (by which you can select specific pages for the report).

Description, Purchase, Cost, Account, and Location Information

Select this check box to print all data fields from the Purch Info, Cost Info, Acct Info, and Loc Info tabs of the Manage Asset Master Information screen.

The same data also resides on the following screens:

G/L Book and Other Book Information

Select this check box to print all data fields from the G/L Book Info tab of the Manage Asset Master Information screen, regardless of whether depreciation is based on years, units of usage, or lease periods. This page also prints all data fields for optional books 2 to 6 from the Other Books Info subtask of the Manage Asset Master Information screen. If you have entered data for optional books 7-10, an additional page will print. The same data also resides on the Manage Asset General Ledger Book Information and the Manage Asset Other Books Information screens.

Government and Disposal Information

Select this check box to print all data fields from the Govt Info and Disp Info tab of the Manage Asset Master Information screen. (The same data also resides on the Manage Asset Government Information and the Manage Asset Disposal Information screens.)

User-Defined Field Information

Select this check box to print user-defined information from the User-Defined Info subtask of the Manage Asset Master Information screen. (The same data also resides on the Manage Asset User-Defined Information screen). Each report page listed above can be printed individually, or you can select the All Asset Information check box to print all detail pages at one time.

Sort By

In this group box, you can use the drop-down list to sort the report by asset/item number, asset account, asset organization, asset project, acquisition fiscal year and period, or record-added date. This report always sorts by asset/item number within the primary sort category you select. Regardless of the sort sequence, all selected pages for a single Asset Master record will print before the next record prints. You can sort the report by only one category at a time.

1st Sort

Select the sort option from the drop-down list. The available options are: