PRINT ASSET MASTER DETAIL

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

Four separate pages print per record. (If you use all 10 books, an additional page prints to accommodate data for Books 7-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.

Select Asset Accounts

In this group box, you can select the asset accounts you want to include in the report. The asset account is required in the Account Info for G/L Book subtask of the Maintain Asset Master Info screen and in the Maintain Asset Account Info screen for all property records, and denotes the "ownership" account, such as company-owned balance sheet, project, and so on.

Range Option

Use this drop-down box to select a range option. Range options are "All," "One," "Range," "From Beginning," and "To End." 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 that print.

If you save the selection parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset Account Range column.

From

Enter the beginning asset account in this field or use Lookup to select one. Because this is a standard Lookup to the ACCT table, you may find that you have selected accounts in the Lookup for which asset data does not exist or does not meet your other selection criteria.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the selection parameters for this report, the selected From value, as applicable, will be identified in the Query table in the Asset Account From column.

To

Enter the ending asset account or use Lookup to select one. Because this is a standard Lookup to the ACCT table, you may find that you have selected accounts in the Lookup for which asset data does not exist or does not meet your other selection criteria.

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

If you save the selection parameters for this report, the selected To value, as applicable, will be identified in the Query table in the Asset Account To column.

Select Asset Organizations

In this group box, you can select the organizations that you want to include in the report. The asset organization is required in the Account Info for G/L Book subtask of the Maintain Asset Master Info screen and in the Maintain Asset Account Info screen or all property records.

Range Option

Use this drop-down box to select a range option. Range options are "All," "One," "Range," "From Beginning," and "To End." 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 that print.

If you save the selection parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Organization Range column.

From

Enter the beginning asset organization in this field or use Lookup to select one. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations in the Lookup for which asset data does not exist or does not meet your other selection criteria.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the selection parameters for this report, the selected From value, as applicable, will be identified in the Query table in the Organization From column.

To

Enter the ending organization or use Lookup to select one. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations in the Lookup for which asset data does not exist or does not meet your other selection criteria.

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

If you save the selection parameters for this report, the selected To value, as applicable, will be identified in the Query table in the Organization To column.

Select Asset Projects

In this group box, you can select the asset projects that you want to include in the report. The asset project is optional in the Account Info for G/L Book subtask of the Maintain Asset Master Info screen and in the Maintain Asset Account Info screen for all property records.

Range Option

Use this drop-down box to select a range option. Range options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "All." If you have a large number of asset projects, you may want to consider selecting a different option than "All" to limit the number of records that print.

If you save the selection parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Project Range column.

From

Enter the beginning asset project in this field or use Lookup to select one. Because this is a standard Lookup to the PROJ table, you may find that you have selected projects in the Lookup for which asset data does not exist or does not meet your other selection criteria.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the selection parameters for this report, the selected From value, as applicable, will be identified in the Query table in the Project From column.

To

Enter the ending project or use Lookup to select one. Because this is a standard Lookup to the PROJ table, you may find that you have selected projects in the Lookup for which asset data does not exist or does not meet your other selection criteria.

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

If you save the selection parameters for this report, the selected To value, as applicable, will be identified in the Query table in the Project To column.

Select Asset/Item Numbers

In this group box, you can select 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.

Range Option

Use this drop-down box to select a range option. Range options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "One."

If you save the selection parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset/Item Range column.

From

Enter the beginning asset/item number for the range or use Lookup to select an asset/item number. 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.

If you select "All" or "From Beginning" in the Range Option field, these fields will be inactive.

If you save the selection parameters for this report, the selected From value(s), as applicable, will be identified in the Query table in the Asset No From and Item No From columns.

To

Enter the ending asset/item number for the range or use Lookup to select an asset/item number. 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.

If you select "All," "One," or "To End" in the Range Option field, these fields will be inactive.

If you save the selection parameters for this report, the selected To value(s) as applicable, will be identified in the Query table in the Asset No To and Item No To columns.

Select Record-Added Dates

You can use the fields in this group box to select the record-added dates for the report. The record-added date is the date the asset record was originally created. The record-added date displays in the Date field of the Maintain Asset Master Info main screen and in the Entry Date/Time field in the Maintain Asset Desc Info screen and cannot be edited.

Range Option

Use this drop-down box to select a range option. Range options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "All." If you have a large number of record-added dates, you may want to consider selecting a different option than "All" to limit the number of records that print.

If you save the selection parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Record Added Date Range column.

From

Enter the beginning record-added date in date format. Because there is no system validation of the entered dates, you may find that you have selected dates for which asset data does not exist or does not meet your other selection criteria.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the selection parameters for this report, the selected From value, as applicable, will be identified in the Query table in the Record Added Date From column.

To

Enter the ending record-added date in date format. Because there is no system validation of the entered dates, table, you may find that you have selected dates for which asset data does not exist or does not meet your other selection criteria.

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

If you save the selection parameters for this report, the selected To value, as applicable, will be identified in the Query table in the Record Added Date To column.

Sort Options

In this group box, you can use the drop-down box 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.

Select Depr Status

Use the checkboxes 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 checkbox 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, project, and/or property type ranges.

Depreciable Records

This checkbox is selected by default. Select this checkbox to include depreciable records in your print selection criteria.

If you select this checkbox and save the selection parameters for this report, your selection, as applicable, will be identified in the Query table as "Y" in the Include Depreciable Records column.

Non-Depr Records

This checkbox is unselected by default. Select this checkbox to include non-depreciable records in your print selection criteria.

If you select this checkbox and save the selection parameters for this report, your selection, as applicable, will be identified in the Query table as "Y" in the Include Non-Depreciable Records column.

Select Timing

In this group box you can select the acquisition fiscal years and periods for the report. The acquisition fiscal year and period are required in the Purchase Info subtask of the Maintain Asset Master Info screen and in the Maintain Asset Purchase Info screen for all property records.

Range Option

Use this drop-down box to select a range option. Range options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "One."

If you save the selection parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Acquisition FY/Pd Range column.

From

Enter the beginning acquisition fiscal year and period for the range. 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.

If you select "All" or "From Beginning" in the Range Option field, these fields will be inactive.

If you save the selection parameters for this process, the selected From value(s), as applicable, will be identified in the Query table in the From Acquisition FY and From Acquisition Pd columns.

To

Enter the ending acquisition fiscal year and period for the range. 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.

If you select "All," "One," or "To End" in the Range Option field, these fields will be inactive.

If you save the selection parameters for this process, the selected To value(s), as applicable, will be identified in the Query table in the To Acquisition FY and To Acquisition Pd columns.

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 Info checkbox is the default and, while it remains selected, the other checkboxes will be inactive.

All Info

Select this checkbox to print all available Asset Master record data.

Uncheck this checkbox to enable the checkboxes below (by which you can select specific pages for the report).

If you select this checkbox and save the selection parameters for this report, your selection will be identified in the Query table as "Y" in the Print All Info column.

Desc, Purchase, Cost, Acct, and Location Info

Select this checkbox to print all data fields from the Purchase Info, Cost Info, Account Info for G/L Book, and Location Info subtasks of the Maintain Asset Master Info screen. (The same data also resides in the Maintain Asset Desc Info, the Maintain Asset Purchase Info, the Maintain Asset Cost Info, the Maintain Asset Account Info, and the Maintain Asset Location Info screens.)

If you select this checkbox and save the selection parameters for this report, your selection will be identified in the Query table as "Y" in the Print Desc, Cost, Acct, and Loc Info column.

G/L and Other Book Info

Select this checkbox to print all data fields from the G/L Book Info subtasks of the Maintain Asset Master Info 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-6 from the Other Books Info subtask of the Maintain Asset Master Info screen. If you have entered data for optional books 7-10, an additional page will print. (The same data also resides in the Maintain Asset G/L Book Info and the Maintain Asset Other Books Info screens.)

If you select this checkbox and save the selection parameters for this report, your selection will be identified in the Query table as "Y" in the Print G/L and Other Book Info column.

Govt and Disposal Info

Select this checkbox to print all data fields from the Government Info and Disposal Info subtasks of the Maintain Asset Master Info screen. (The same data also resides in the Maintain Asset Government Info and the Maintain Asset Disposal Info screens.)

If you select this checkbox and save the selection parameters for this report, your selection will be identified in the Query table as "Y" in the Print Govt and Disposal Info column.

User-Defined Field Info

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

If you select this checkbox and save the selection parameters for this report, your selection will be identified in the Query table as "Y" in the Print User-Defined Info column.

Select Record Status

Use the checkboxes in this group box to choose the record status type(s) to include in your print selection criteria. You can print data for active records, inactive records, and/or disposals. You must select at least one checkbox 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

This checkbox is selected by default. Select this checkbox to include active records in your print selection criteria.

If you select this checkbox and save the selection parameters for this report, your selection, as applicable, will be identified in the Query table as "Y" in the Include Active Records column.

Inactive

This checkbox is unselected by default. Select this checkbox to include inactive records in your print selection criteria.

If you select this checkbox and save the selection parameters for this report, your selection, as applicable, will be identified in the Query table as "Y" in the Include Inactive Records column.

Disposals

This checkbox is unselected by default. Select this checkbox to include disposals in your print selection criteria.

Note:  You can enter disposals for active records in the Maintain Single/Multiple Disposal Transactions screens. 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 Disposal Info subtask of the Maintain Asset Master Info screen or the Maintain Asset Disposal Info screen.

If you select this checkbox and save the selection parameters for this report, your selection, as applicable, will be identified in the Query table as "Y" in the Include Disposals column.

Note:  You can save your sort options and selection criteria for this report with or without printing. After making your selections, select the Save button on the toolbar or 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 run Find or 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 reports are to be run through Process Manager.

If you want to keep these parameters but want to run a slightly different report, you can use Clone to copy the parameters and make minor changes to them without changing your saved parameters. Select Clone in the File menu or press [F4]. The Clone window will display on the screen. Enter the parameters ID you want to clone, or select Execute to display a list of parameter IDs from which you can make your selection. When you select the Select pushbutton, the system makes a copy of the parameters, which you can edit as needed.

Table Information

The system stores the Asset Master data displayed in this report in the ASSET Asset), ASSET_OTHER_INFO (Asset Other Info), ASSET_OTH_BK_DEPR (Asset Other Books), and ASSET_BOOKS_DISP (Asset Disposal Info) tables.