Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Contents of the Print Current Period Depreciation Report Screen

Use the fields and options to configure the Print Current Period Depreciation Report screen.

Note: The values in this report are derived only from Costpoint Fixed Assets data. Additions or deletions made directly to the General Ledger via Journal Entry will not reflect in this report. (Entries that do not originate in Costpoint Fixed Assets should be discouraged, because they will create out-of-balance conditions between Costpoint Fixed Assets balances and the General Ledger balances.)

All versions of the report, both summary and detail by asset/item number, include the amount posted, amount to post, and current period depreciation for all records with current period activity. These values are derived as follows:

  • The Amt Posted column on the report is the cumulative net value of the total depreciation expense posted during the current Costpoint Fixed Assets accounting period. This value displays for each record in the Amount Posted Curr Pd field in the G/L Book Info tab of the Manage Asset Master Information screen (and in the corresponding fields on the Manage Asset General Ledger Book Information screen). The total value in this column may be the result of multiple postings during the period.
  • The Amt to Post column on the report displays the value of the unposted portion of the Current Pd Depreciation or Current Pd Amortization field in the G/L Book Info tab of the Manage Asset Master Information screen (and in the corresponding fields on the Manage Asset General Ledger Book Information screen). The amounts in the Current Pd Depreciation or Current Pd Amortization fields from the Asset Master records may be the result of system computations, manual entries, and/or edits to system calculations.
  • The Curr Pd Depr column on the report displays the total of the Amt Posted and Amt to Post report fields and is equal to the amount in the Current Pd Depreciation or Current Pd Amortization field in the G/L Book Info tab of the Manage Asset Master Information screen (and in the corresponding fields on the Manage Asset General Ledger Book Information screen).

If you choose to print the FYTD Depreciation column on the report, this value is equal to the FYTD Depreciation or FYTD Amortization field in the G/L Book Info tab of the Manage Asset Master Information screen (and in the corresponding fields on the Manage Asset General Ledger Book Information screen). Values for the FYTD Depreciation field will not print on the report for records (or accounts) which do not have Current Pd Depreciation field values unless you also select the Active Records With No Current Period Depr Activity check box.) The FYTD Depreciation column print option is available only for detail reports by asset/item number.

If you choose to print the Depr Exp Acct Alloc Code and/or the Acct Percentage Allocations columns on the report, data displays from the setup on the Manage Depreciation Expense Acct Allocation Codes screen. This option is available only for detail reports by asset/item number.

Note: Current period depreciation values for books other than the General Ledger book (optional books 2-10) can be printed by creating custom reports or by using the Print Sequential Other Books Depreciation History Rpt standard report.

The Print Current Period Depreciation Report provides a current "snapshot" of the existing period depreciation status. Print this report whenever you want to verify the posted/unposted status of your depreciation expense during the current accounting period.

Print and retain this report as part of your closing procedures on a routine basis. At the end of each accounting period, after all depreciation entries have been posted but before the Costpoint Fixed Assets accounting period has been closed, you can print a detailed report by asset/item number and retain it to support the detail for the "Depreciation" transactions posted from the Fixed Assets Journal to the General Ledger. The balance in the Amt Posted report column should reconcile to the total of all "DEPR" transactions posted to the G/L for the current accounting period.

You can print this report only for the current Fixed Assets accounting period, and you cannot historically re-create it for prior (closed) Fixed Assets periods. After posting, however, you can generate the Print Posted Transactions Detail Report to supply all the detail for previous postings. If you have made no edits to Asset Master records between the time you generate the Print Current Period Depreciation Report from this screen and the time you post the transactions to the G/L, the values on the Print Posted Transactions Detail Report should be identical to the values on this report.

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

Drop-down

Field Description
Select By

Select a group option from the drop-down list. The available options are:

  • Depr Exp Acct Alloc Code: This is the default selection. If you select this, the report will be grouped by the depreciation expense account allocation codes set up on the Manage Depreciation Expense Acct Allocation Codes screen. (A depreciation expense account allocation code must be assigned to each depreciable record in the Acct Info tab of the Manage Asset Master Information screen.)
  • Depr Exp Account/Org: Select this to group your report by depreciation expense account/organization combination. You must assign a depreciation expense account allocation code, which defines one or more account/org combinations (along with the percentage allocation) to which depreciation expense should be posted to each depreciable record in the Acct Info tab of the Manage Asset Master Information screen.
  • Asset/Item No: Select this to group your report by asset/item number.
Option

Select a range option from the drop-down list. The available options are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select, the beginning depreciation expense account allocation code or the beginning depreciation expense account number in this field. Because this is a standard Lookup (based on your selection), you may find that you have made selections in the Lookup for which data do not exist.

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

End

Enter, or click to select, the ending depreciation expense account allocation code or the ending depreciation expense account number in this field. Because this is a standard Lookup (based on your selection), you may find that you have made selections in the Lookup for which data do not exist.

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

Organizations

Use the following fields to select depreciation expense organizations for the report. If you select Depr Exp Acct Alloc Code or Asset/Item No in the Select By drop-down list, the following fields will be disabled.

Field Description
Option

Select a range option from the drop-down list. The options available are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select, the beginning organization number in this field. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations in the Lookup for which data do not exist.

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 this is a standard Lookup to the ORG_ACCT table, you may find that you have selected organizations in the Lookup for which data do not exist.

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

Asset/Item Numbers

Use the following fields to select asset/item numbers for the computation. If you enter a specific asset number, you must also enter a corresponding item number.

Field Description
Option

Select a range option from the drop-down list. The available options are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select, the beginning asset/item number. Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers in the Lookup for which data do not exist.

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. Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers in the Lookup for which data do not exist.

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

Options

Report Option

Field Description
Summary

This option is selected by default.

A summary report includes amount posted, amount to post, and current period depreciation regardless of whether the report is sorted by depreciation expense allocation code or by depreciation expense account/organization. Summary reports do not print values by asset/item number. When you select this option, the check boxes in the Show group box are disabled, because they apply only to detail reports by asset/item number.

Detail

Select this option to print report values by asset/item number. When you select this option, the check boxes in the Show group box are also available.

Note: You can save your sort options and selection criteria for this report with or without printing. After making your selections, click the Save button on the toolbar or click Save in the File menu. Enter an alphanumeric identifying code and a short description to help you recognize the report parameters. Later, you can run Query from this screen to access the print parameters you created, and run the same report without having to enter all the selection screen information again. Stored report parameters are especially useful if you run reports through Process Manager.

If you want to keep these 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, click Copy Record under the Line menu or press CTRL+E. Edit the duplicate record as needed.

Show

Field Description
FYTD Depreciation

This check box is clear by default.

Select this check box to include an FYTD Depreciation column on a detail report that is grouped by asset/item number. (Values for FYTD depreciation will not print if the current period depreciation value is zero unless you also select the Active Records With No Current Period Depr Activity check box.)

The purpose of this column is alert you to any potential problems for the period. If you have FYTD activity for an asset record and no current period depreciation, the condition provides a visual clue that investigation may be required. (Note, however, that there may be an amount in the FYTD Depreciation column but no current period calculation because an asset has reached the end of its useful life and is fully depreciated.) This check box is available only if you have selected Asset/Item No in the Select By drop-down list.

Depr Exp Acct Alloc Codes

This check box is clear by default.

Select this check box to print the depreciation expense account allocation code assigned to each asset. This check box is available for all options in the Select By drop-down list if the Detail report option is selected.

Project Totals

This check box is clear by default.

Select this check box to include project totals on the report. Empty project total lines do not print (for instance, if there has been no activity for a specific project in the current period).

This check box is available for both Detail and Summary report options if you selected the Depr Exp Account/Org or the Depr Exp Acct Alloc Code options in the Select By drop-down list.

Account Percentage Allocations

This check box is clear by default and is available only if the Detail option is selected in the Report Option group box.

When you set up your depreciation expense account allocation codes, you determined the percentage of total depreciation that should be allocated to each depreciation expense account. If you select this check box, these percentages will print as a column on your report.

Include

Field Description
Active Records with No Current Period Depr Activity

This check box is selected by default.

The Current Period Depreciation Report always includes active and inactive depreciable records with current period depreciation activity. Select this check box to include active records that may have had depreciation activity earlier in the fiscal year but which do not have any depreciation activity for the current period. If you select the FYTD Depreciation check box in the Show group box, you may want to select this check box as well.

Print Option

Field Description
Page Break when Code or Acct/Org Changes

This check box is available when the Detail option in the Report Option group box is selected.

Select this check box if you want the report to have a page break each time the code or Account/Organization changes.