Use this screen to print asset book value data for each book in Costpoint Fixed Assets, including the G/L book and any additional books set up for use in the Fixed Assets Settings screen. This report always includes active, depreciable records, but you can create asset book value reports with different data by including or excluding inactive records, non-depreciable records, and/or disposals.
The report displays total cost, accumulated depreciation, and book value data, as well as an option to print a column that displays the percentage of the asset that has already been depreciated. In addition, you can choose whether to include or exclude the current period depreciation amount in the displayed accumulated depreciation value. Five different sort options (asset account, asset account/organization, organization, organization/asset account, and asset/item no) are also available to organize the data differently.
The Asset Book Value Report provides a current "snapshot" of book value data at the time you run the report and can be printed at any time. Because you cannot print data from previous periods in this report, you should retain this report to use when performing G/L reconciliations.
Use the fields in this group box to select records for the report from a range of asset ("ownership") accounts. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
Selecting the Inactive Records, Disposals, and/or Non-Depreciable Records checkboxes in the Select Record Status and Select Depr Status group boxes may modify which records from the selected asset account range are actually included in the report.
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 have a large number of asset accounts, you may want to select a different option.
If you save the print parameters for this report, the selected Range Option, as applicable, will be stored in the Query table in the Asset Account Range column.
Enter the beginning asset account number in this field or use Lookup to select one from the asset accounts already associated with your property records. Because the standard Lookup for the account is to the ACCT table, you may find that you have selected accounts for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR, as applicable, 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 stored in the Query table in the Asset Account From column.
Enter the ending asset account number or use Lookup to select one from the asset accounts already associated with your property records. Because the standard Lookup for the account is to the ACCT table, you may find that you have selected accounts for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR, as applicable, 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 stored in the Query table in the Asset Account To column.
Use this group box to select records for the report from a range of asset ("ownership") organizations. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
Selecting the Inactive Records, Disposals, and/or Non-Depreciable Records checkboxes in the Select Record Status and Select Depr Status group boxes may modify which records from the selected organization range are actually included in the report.
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 stored in the Query table in the Organization Range column.
Enter the beginning asset organization number in this field or use Lookup to select one from those displayed. Because the standard Lookup for the organization is to the ORG_ACCT table, you may find that you have selected organizations for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR, as applicable, 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 stored in the Query table in the Organization From column.
Enter the ending organization number or use Lookup to select an organization from those displayed. Because the standard Lookup for the organization is to the ORG_ACCT table, you may find that you have selected organizations for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, 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 stored in the Query table in the Organization To column.
To print data for a different book, select a book from the drop-down box. The system also displays the labels that you assigned to each optional book during initialization in the Fixed Assets Settings screen, as applicable.
The system default for this field is "G/L Book." You can print data for only one book at a time.
If you save the print parameters for this report, the label for the selected book will be stored in the Query table in the Book Label column.
Use the fields in this group box to select 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 the Inactive Records, Disposals, and/or Non-Depreciable Records checkboxes in the Select Record Status and Select Depr Status group boxes may modify which records from the selected asset/item number range are actually included in the report.
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 stored 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. Because the standard Lookup for the asset/item number is to the ASSET table, you may find that you have selected asset records for which book value data does not exist or records that do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK table, as applicable, may not be selected.
If you select "All" or "From Beginning" in the Range Option field, these fields will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be stored 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. Because the standard Lookup for the asset/item number is to the ASSET table, you may find that you have selected asset records for which book value data does not exist or records that do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK table, as applicable, may not be selected.
If you select "All," "One," or "To End" in the Range Option field, these fields will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be stored in the Query table in the Asset No To and Item No To columns.
Use 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 actual 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 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.
Use the single checkbox in this group box to include or exclude the current period depreciation amount in/from the displayed accumulated depreciation value on the report. This checkbox is selected by default, automatically including the current period depreciation amount will in the Accum Depreciation value displayed on the report. (Use this option to obtain useful values from the report whenever you run it, both before and after you have computed depreciation.)
This checkbox is selected by default. If you want to include current period depreciation in the Accum Depreciation value displayed on the report, leave this checkbox checked. If you uncheck this checkbox, the Accumulated Depreciation column will display only the total of the fiscal year-to-date and prior fiscal year depreciation, and will exclude any current period depreciation. (Use this option to obtain useful values from the report whenever you run it, both before and after you have computed depreciation.)
If you select this checkbox and save the print parameters for this report, "Y" will display in the Include Current Period Depreciation column in the Query table.
In this group box, you can choose to sort the report by asset account, asset account/ organization, organization, organization/asset account, or asset/item number. You can sort by only one category at a time. Reports are always sorted by asset/item number within the primary sort category you select.
This radio button is selected by default. Select this radio button to sort the report by asset account ("ownership" account, such as balance sheet, project, and so on). When you print the report using this sort option, the asset account number and name print in the header of the report. For each different asset account, data will be sorted by asset/item number in ascending order.
If you select this radio button and save the print parameters for this report, "ACCT" will display in the Sort Option column in the Query table.
Select this radio button to sort the report first by asset account number and then by organization number. For each different organization, data will be sorted by asset/item number in ascending order.
If you select this radio button and save the print parameters for this report, "ACCT/ORG" will display in the Sort Option column in the Query table.
Select this radio button to sort the report by organization. When you print the report using this sort option, the organization number and description print in the header of the report. For each different organization, data will be sorted by asset/item number in ascending order.
If you select this radio button and save the print parameters for this report, "ORG" will display in the Sort Option column in the Query table.
Select this radio button to sort the report first by organization and then by asset account number. For each different asset account, data will be sorted by asset/item number in ascending order.
If you select this radio button and save the print parameters for this report, "ORG/ACCT" will display in the Sort Option column in the Query table.
Select this radio button to sort the report by asset/item number. If you select this radio button, the Page Break checkbox is disabled.
If you select this radio button and save the print parameters for this report, "ASSET" will display in the Sort Option column in the Query table.
Select this checkbox to print totals by asset number for the Total Cost, Accum Depreciation, and Book Value columns.
This checkbox is available only if you select the Asset/Item Number sort option. If you select this checkbox and the Asset/Item Number radio button, the report prints data for each asset/item number, but also displays totals for all items associated with each asset number. This option provides standard component reporting as an alternative to other system reports in Costpoint Fixed Assets.
If you select this checkbox and save the print parameters for this report, "Y" will display in the Print Totals by Asset No column in the Query table.
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, 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 print parameters for this report, "Y" will display in the Page Break column in the Query table.
Select this checkbox to print a column on the report that displays the percentage of the asset that has already been depreciated. The system calculates this value by dividing accumulated depreciation by the total cost and prints it as a percentage in the % Depreciated column.
If you select this checkbox and save the print parameters for this report, "Y" will display in the Show % Depreciated Column column in the Query table.
This report accesses data stored in the ASSET (Asset) table and the ASSET_OTH_BK_DEPR (Asset Other Books) tables.
Lookups and drop-down boxes access data from the following tables:
ASSET (Asset)
ACCT (Account)
ORG_ACCT (Organization\Account)
FA_BOOK_SETTINGS (Fixefd Assets Book Settings0