Contents of the Print Asset Book Value Report Screen
Use the fields and options to configure the Print Asset Book Value Report screen.
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 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. 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 description of up to 30 alphanumeric characters. |
Selection Ranges
Asset Accounts
Use the following fields 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.
When you select the Inactive Records, Disposals, and/or Non-Depreciable Records check boxes in the Select Record Status and Select Depreciation Status group boxes may modify which records from the selected asset account range are actually included in the report.
Field | Description |
---|---|
Option |
Select the asset account range option from the drop-down list. The options available are:
If you have a large number of asset accounts, you may want to select a different option aside from All. |
Start |
Enter, or click to select, the beginning asset account number in this field 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 Option field, this field will be inactive. |
End |
Enter, or click to select, the ending asset account number 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 Option field, this field will be inactive. |
Organizations
Use the following fields 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.
When you select the Inactive Records, Disposals, and/or Non-Depreciable Records check boxes in the Select Record Status and Select Depreciation Status group boxes, you may have also modified which records from the selected organization range are actually included in the report.
Field | Description |
---|---|
Option |
Select the range option from the drop-down list. The options available are:
|
Start |
Enter, or click to select, the beginning asset organization number in this field. 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 Option field, this field will be inactive. |
End |
Enter, or click to select, the ending organization number in this field. 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 Option field, this field will be inactive. |
Book
Field | Description |
---|---|
Start |
To print data for a book, enter or click to select a book. The system also displays the labels that you assigned to each optional book in the Lookup during initialization on the Configure Fixed Assets Settings screen, as applicable. You can print data for only one book at a time. |
Asset/Item Numbers
Use the following fields 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. When you select the Inactive Records, Disposals, and/or Non-Depreciable Records check boxes in the Select Record Status and Select Depreciation Status group boxes, you may have also modified which records from the selected asset/item number range are actually included in the report.
Field | Description |
---|---|
Option |
Select a range option from the drop-down list. The options available are:
|
Start |
Enter, or click to select, the beginning asset/item number for the range. 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 do 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 Option field, these fields will be inactive. |
End |
Enter, or click to select, the ending asset/item number for the range. 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 do 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 Option field, these fields will be inactive. |
Options
Select Record Status
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 check box 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.
Field | Description |
---|---|
Active Records |
Select this check box to include active records in your print selection criteria. |
Inactive Records |
Select this check box to include inactive records in your print selection criteria. |
Disposals |
Select this check box to include disposals in your print selection criteria. Note: You can enter disposals for active records on the Manage Disposal Transactions screens. Once the disposal is posted to the General Ledger, the system automatically 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.
|
Select Depreciation Status
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 check box 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.
Field | Description |
---|---|
Depreciable Records |
Select this check box to include depreciable records in your print selection criteria. |
Non-Depreciable Records |
Select this check box to include non-depreciable records in your print selection criteria. |
Include
Field | Description |
---|---|
Current Pd Depreciation in Accum Depr Column |
Select this check box to include or exclude the current period depreciation amount in/from the displayed accumulated depreciation value on the report. |
Show
Field | Description |
---|---|
Percent Depreciated Column |
Select this check box 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. |
Sort By
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.
Field | Description |
---|---|
1st Sort |
Select the primary sort to use in the report from the drop-down list. The available options are:
|
Page Break |
Select this check box 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 check box 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 check box will be disabled. |
Print Totals by Asset No |
Select this check box to print totals by asset number for the Total Cost, Accum Depreciation, and Book Value columns. This check box is available only if you select the Asset/Item Number sort option. If you select this check box and the Asset/Item Number sort option, 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. Note: If you want to use most of the same report selection parameters but want to run a slightly different report, you can use
Copy Record to copy the parameters and make minor changes to them without changing your saved parameters. To use
Copy Record, open the record you want to duplicate through
Query (F11), select the line that you want to duplicate, and then go to the Line menu and select
Copy Record (or press CTRL+E). The system makes a copy of the parameters, which you can edit and save as desired.
|