Contents of the Print Asset Master Detail Report Screen
Use the fields and options to configure the Print Asset Master Detail Report Screen.
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:
- Description, Purchase, Cost, Account, and Location Information: This page prints 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 Manage Asset Description Information, the Manage Asset Purchase Information, the Manage Asset Cost Information, the Manage Asset Account Information and the Manage Asset Location Information screens.)
- G/L and Other Book Information: This page prints 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 to 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: This page prints all data fields from the Govt Info and Disp Info tabs 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: This page prints 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.
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, 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
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.
| Field | Description |
|---|---|
| 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
If you select All or From Beginning in the Option drop-down list, this field will be inactive. |
| End |
Enter, or click
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.
| Field | Description |
|---|---|
| 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
If you select All or From Beginning in the Option drop-down list, 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. |
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.
| Field | Description |
|---|---|
| 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
If you select All or From Beginning in the Option drop-down list, this field will be inactive. |
| End |
Enter, or click
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.
| Field | Description |
|---|---|
| Option |
Select the range option from the drop-down list. The available options are the following:
|
| Start Asset No/Item No |
Enter, or click
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
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.
| Field | Description |
|---|---|
| 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
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
If you select All, One or To End in the Option drop-down list, this field will be inactive. |
to select, the beginning record added date.
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.
| Field | Description |
|---|---|
| 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.
| Field | Description |
|---|---|
| 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.
| Field | Description |
|---|---|
| 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. 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.
You can save your sort options and selection criteria for this report with or without printing. After making your selections, click
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 you r 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. |
on the toolbar or select
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.
| Field | Description |
|---|---|
| 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.
| Field | Description |
|---|---|
| 1st Sort |
Select the sort option from the drop-down list. The available options are:
|