Use the Schedule of Asset Activity Report screen to print the asset "ownership" account cost activity from a selected beginning point in time to a selected ending point in time. This report includes the beginning cost balance, additions, disposals, transfers, and the ending balance.
Although you can print cost data for the G/L Book and all optional books, you can print the data for only one book at a time.
You can print a detail report that prints data asset-by-asset or a summary report that rolls all asset data up to account/org/proj, as applicable, per the selection parameters. You can also print the data for a range of (including one), or all, asset/item numbers, asset accounts, organizations, and/or projects, and for one or a range of fiscal years and periods. Sort options are by account, by organization, by project, by account/org, by org/account, or by asset no/item no. You can also use the page break option for all sorts other than by asset/item number.
You can print data for depreciable and/or non-depreciable assets, and active records, inactive records, and/or disposals. If you include disposals in the report, you must also choose whether to include data from manual disposal entries.
You can capture changes to asset cost components (unit price, sales tax, and so on) made manually in Asset Master records or via global functionality in the Asset Audit Log if you have enabled this function for the cost fields in the Asset/Template Change Settings screen (in the Asset/Template Field/Column Names subtask).
You can also include changes to the cost fields as positive or negative values in the Additions column on the report.
This report prints in landscape mode. Because all the fields already exist in decimal format, you cannot print the data on the report in whole (rounded) numbers.
To remind you that this report may not include the all the transfer data you expect, the system displays the following "soft" warning message under certain circumstances:
Transfer data may be missing from this report because you have not enabled the ability to track transfers of asset "ownership" accounts, organizations and/or projects in the Asset/Template Change Settings screen.
Because data for this report can be retrieved and computed for historical fiscal years/periods, you can print this report whenever necessary to assist you in reconciling the asset cost accounts in Costpoint General Ledger to the balances in Costpoint Fixed Assets or in re-creating the activity in your asset accounts.
Use the radio buttons in this group box to specify either a summary report that omits individual asset/item number data or a detailed report that prints data for each asset/item number (within the parameters of your selection criteria).
This radio button is selected by default. Select this radio button to print a summary report without individual asset/item number data.
If you select this radio button, you cannot select records by asset/item number. In addition, you cannot access the Asset No/Item No radio button or the Page Break checkbox in the Sort By group box.
If you select this radio button and save the print parameters for this report, "S" will be inserted into the Report Option column in the Query table.
Select this radio button to print a detailed report that includes data by individual asset/item number.
If you select this radio button and save the print parameters for this report, "D" will be inserted into the Report Option column in the Query table.
Use this drop-down box to select the desired book for which to print asset activity information. Although you can only select one book at a time, you can print this report for any book.
"G/L Book" is the default for the drop-down box. Also included in the drop-down box are the labels that you assigned to each optional book during initialization in the Fixed Assets Settings screen, as applicable.
If you save the report parameter selections, the selected book number will be identified in the Query table in the Select Book column.
Use the fields in this group box to select the asset/item number(s) for which to print asset activity data. The fields in this group box are available only if you have selected the Detail by Asset radio button in the Report Option group box.
If you enter an asset number, you must also enter a corresponding item number.
Use this drop-down box to select a range option. Options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "Range."
If you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset/Item No Range column.
Enter the beginning asset/item number for the range option or use Lookup to select one. Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers for which asset activity data does not exist or does not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected From values, as applicable, will be identified in the Query table in the From Asset No and From Item No columns.
Enter the ending asset/item number for the range option or use Lookup to select one. Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers for which asset activity data does not exist or does not meet your selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected To values, as applicable, will be identified in the Query table in the To Asset No and To Item Number columns.
Use the required fields in this group box to select records for the report from a specified beginning fiscal year and period to an ending fiscal year and period.
The Fiscal Year drop-down boxes display only those fiscal years already set up in the Maintain FA Fiscal Years screen in descending order, beginning with the latest fiscal year. Because the displays in the Fiscal Year drop-down boxes are standard Lookups to the FA_FY_INFO table in Fixed Assets, you may find that you have selected a fiscal year for which asset activity does not exist or does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
The Period drop-down boxes display only those accounting periods already set up in the Maintain FA Accounting Periods screen for the fiscal year specified in the corresponding Fiscal Year drop-down box. Because the displays in the Period drop-down boxes are standard Lookups to the FA_PD_INFO table in Fixed Assets, you may find that you have selected a period for which asset activity does not exist or does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
Enter the beginning desired fiscal year and period from the drop-down box in each field.
If you save the print parameters for this report, the selected From values will be identified in the Query table in the From Fiscal Year and From Period columns.
Enter the ending desired fiscal year and period from the drop-down box in each field.
If you save the print parameters for this report, the selected To values will be identified in the Query table in the To Fiscal Year and To Period columns.
Use this group box to select records for the report from one asset ("ownership") account, a range of asset ("ownership") accounts, or all asset ("ownership") accounts. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
The default option for this field is "All." You can accept the displayed default range option, enter a different 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 print 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 ("ownership") account number in this field or use Lookup to select an account number from the G/L Account table. Because this is a standard Lookup to the ACCT table, you may find that you have selected accounts for which asset activity data does not exist or that does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Account column.
Enter the ending asset ("ownership") account number or use Lookup to select an account number from the G/L Account table. Because this is a standard Lookup to the ACCT table, you may find that you have selected accounts for which asset activity data does not exist or which does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Account column.
Use this group box to select records for the report from one asset ("ownership") organization, a range of asset ("ownership") organizations, or all asset ("ownership") organizations. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
The default option for this field is "All." You can accept the displayed default range option, enter a different 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 print 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 ("ownership") organization in this field or use Lookup to select an organization from those displayed. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations for which asset activity data does not exist or which does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Organization column.
Enter the ending ("ownership") organization in this field or use Lookup to select an organization from those displayed. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations for which asset activity data does not exist or which does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Organization column.
Use this group box to select records for the report from one asset ("ownership") project, a range of asset ("ownership") projects, or all asset ("ownership") projects, as applicable. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
The default option for this field is "All." You can accept the displayed default range option, enter a different 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 print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Project Range column.
Enter the beginning ("ownership") project in this field, as applicable, or use Lookup to select a project from those displayed. Because this is a standard Lookup to the PROJ table, you may find that you have selected projects for which asset activity data does not exist or which does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Project column.
Enter the ending ("ownership") project in this field, as applicable, or use Lookup to select a project from those displayed. Because this is a standard Lookup to the PROJ table, you may find that you have selected projects for which asset activity data does not exist or which does not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Project column.
In this group box, you can determine how the system organizes the data for the report and whether you want a page break in the report each time the selected sort parameter changes.
Note, however, that the report always prints in the same format, regardless of the sort option you select. (The sort option determines how data should be ordered within this format.)
This radio button is selected by default. Select this radio button to sort the report by asset ("ownership") account.
If you save the print parameters for this report, this sort option will be identified as "A" in the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by asset ("ownership") organization.
If you save the print parameters for this report, this sort option will be identified as "O" in the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by asset ("ownership") project.
If you save the print parameters for this report, this sort option will be identified as "P" in the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by asset ("ownership") account/organization.
If you save the print parameters for this report, this sort option will be identified as "AO" in the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by asset ("ownership") organization/account.
If you save the print parameters for this report, this sort option will be identified as "OA" in the Sort By column in the Query table.
This radio button is unchecked by default. This radio button is available only if the Detail by Asset radio button is selected in the Report Option group box.
Select this radio button to sort the report by asset/item number. Account and/or organization data will not print on the report for this sort option and the Page Break checkbox is also unavailable.
If you save the print parameters for this report, this sort option will be identified as "AI" in the Sort By column in the Query table.
This checkbox is unchecked by default and will be available only if you selected a Detail by Asset report. Select this checkbox if you want a page break in the report each time the selected sort parameter changes. For example, if you chosen to sort the data by account, select the Page Break checkbox if you want the data for each different account to begin printing on a separate page. If you choose Asset No/Item No as the sort option, this checkbox is disabled.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Page Break column in the Query table.
Use the options in this group box to choose the record status type(s) to include in your report selection criteria. You can include active records, inactive records, and/or disposals. You must select at least one checkbox in this group box.
This checkbox is selected by default. Select this checkbox to include active records in the report selection criteria. If this checkbox is unchecked, the system automatically excludes all active records.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Select Active Records column in the Query table.
Select this checkbox to include inactive records in the report selection criteria. This checkbox is unchecked by default. If this checkbox is unchecked, the system automatically excludes all inactive records.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Include Inactive Records column in the Query table.
This checkbox is selected by default. Select this checkbox to include disposals in the report selection criteria. If this checkbox is unchecked, the system automatically excludes all disposals.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Include Disposal Records column in the Query table.
Select this pushbutton to display additional selection parameters for this report.