Use this screen to print limited data from the basic asset information you entered in the Maintain Asset Master Info screen and its subtasks and/or in the individual entry screens. Use this report to create different lists by including or excluding active/inactive records, depreciable/non-depreciable records, and/or disposals.
Depending on the sort option you select, you can also print the Asset Master List with different formats. Regardless of the sort option you select, each report includes the asset/item number, short description, acquisition fiscal year and period, cost, and record-entry details (including the user ID, the type of record, and the date and time the record was added). For all sort options, you can also choose to print the Total Cost amount from the G/L Book Info subtasks of the Maintain Asset Master Info screen and from the Maintain Asset G/L Book screen.
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.
Use the fields in this group box to select records from one, a range of, or all asset accounts for the report. The asset account is a required field 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 "ownership" (such as company-owned balance sheet, project, and so on) Selecting any of the checkboxes in the Select Record Status and Select Depr Status group boxes may modify which records print from the selected asset account(s).
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 box. Range options are "All," "One," "Range," "From Beginning," and "To End." If you have a large number of asset accounts, you may want to select a different option other than "All" to limit the number of records that print on the list.
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.
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.
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.
Use the fields in this group box to select one, a range of, or all organizations for the report. Selecting any of the checkboxes in the Select Record Status and Select Depr Status group boxes may modify which records print from the selected organization(s).
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 box. Range options are "All," "One," "Range," "From Beginning," and "To End."
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.
Enter the beginning 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.
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.
Use the fields in this group box to select any range of record-added dates for the report. The record-added date is the date on which the record was originally created. (The record-added date displays in a non-editable field on the Maintain Asset Master Info main screen.) Selecting any of the checkboxes in the Select Record Status and Select Depr Status group boxes may modify which records print from the selected record-added date range.
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 box. Range options are "All," "One," "Range," "From Beginning," and "To End." If you have a large number of asset accounts, you may want to select a different option other than "All" to limit the number of records that print in the list.
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.
Enter the beginning record-added date in date format.
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.
Enter the ending record-added date in date format.
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.
Use the fields in this group box to select any range of asset/item numbers for the report. If you enter a specific asset number, you must also enter a corresponding item number before you can run the report. Selecting any of the checkboxes in the Select Record Status and Select Depr Status group boxes may modify which records are included from the selected asset/item number range.
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 box. Range options are "All," "One," "Range," "From Beginning," and "To End."
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.
Enter the beginning asset/item number for the range or use Lookup to select one.
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.
Enter the ending asset/item number for the range or use Lookup to select one.
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.
In this group box, you can choose to sort the report by asset/item number, asset account, asset organization, acquisition fiscal year and period, record-added date, or entry type. You can only sort the report by one category at a time. This report always sorts by asset/item number within the primary sort category you select.
This sort option is the system default, and the radio button for this selection is selected.
If you choose a different sort option, the data will be sorted first by the selected sort option and then by asset/item number in ascending order. If you choose this sort option, the Page Break checkbox will be disabled.
If you select this radio button and save the selection parameters for this report, your selection will be identified in the Query table as "ASSET" in the Sort Option column.
Select this radio button to sort the report by account. When you print the report using this sort option, the account description also prints in the header of the report. For each different asset account, the data sorts by asset/item number in ascending order.
If you select this radio button and save the selection parameters for this report, your selection will be identified in the Query table as "ACCT" in the Sort Option column.
Select this radio button to sort the report by asset organization. When you print the report using this sort option, the organization description also prints in the header of the report. For each different organization, the data sorts by asset/item number in ascending order.
If you select this radio button and save the selection parameters for this report, your selection will be identified in the Query table as "ORG" in the Sort Option column.
Select this radio button to sort the report by acquisition fiscal year and period. For each different acquisition fiscal year and period combination, the data sorts by asset/item number in ascending order.
If you select this radio button and save the selection parameters for this report, your selection will be identified in the Query table as "FY/PD" in the Sort Option column.
Select this radio button to sort the report by the date the record was added. For each different record-added date, the data sorts by asset/item number in ascending order.
If you select this radio button and save the selection parameters for this report, your selection will be identified in the Query table as "DATE" in the Sort Option column.
Select this radio button to sort your report by asset record entry type. An asset record can be manually entered, autocreated, or imported. The "Entry Type" displays in a non-editable field on the first screen of each Asset Master record. For each entry type, the data sorts by asset/item number in ascending order.
If you select this radio button and save the selection parameters for this report, your selection will be identified in the Query table as "ENTRY" in the Sort Option column.
Select this checkbox if you want a page break each time the selected sort parameter changes. For example, if the information is sorted by Asset Account, you should select the Page Break checkbox if you want data for each different asset account to begin printing on a separate page. If you choose Asset/Item Number as the sort option, this checkbox will be disabled.
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 Page Break column.
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 Purchase Info subtask of the Maintain Asset Master Info screen and in the Maintain Asset Purchase Info screen for all property records.)
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 box. Range options are "All," "One," "Range," "From Beginning," and "To End."
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.
Enter the beginning acquisition fiscal year and period for the range.
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.
Enter the ending acquisition fiscal year and period for the range.
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.
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.
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 print parameters for this report, your selection, as applicable, will be identified in the Query table as "Y" in the Include Active Records column.
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 print parameters for this report, your selection, as applicable, will be identified in the Query table as "Y" in the Include Inactive Records column.
This checkbox is unselected by default. Select this checkbox to include disposals in your print selection criteria.
If you select this checkbox and save the print parameters for this report, your selection, as applicable, will be identified in the Query table as "Y" in the Include Disposals column.
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 actual 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.
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 print parameters for this report, your selection, as applicable, will be identified in the Query table as "Y" in the Include Depreciable Records column.
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 print 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 this checkbox to print the Asset Total Cost column for the G/L Book on the report. This checkbox is unchecked by default.
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 Show Asset Cost Column column.
The systems stores the Asset Master data displayed in this report in the ASSET (Asset) table.