Use this report to review current period depreciation expense for the General Ledger book by depreciation expense account, depreciation expense account allocation code, or by asset/item number. You can print summary reports of current period depreciation at the account/organization level or you can print detail reports of current period depreciation by asset/item number. You can also print report versions that include fiscal year-to-date depreciation, project totals, and/or the percentage of the asset's total depreciation allocated to each expense account. You can also print active records with no current period activity on the report.
The system only posts values for the General Ledger book to the General Ledger. This report, therefore, prints data only for the General Ledger book.
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 (Years, Units, and Leases) subtasks of the Maintain Asset Master Info screen (and in the corresponding fields in the Maintain Asset G/L Book Info 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 field in the G/L Book Info (Years or Units) subtask of the Maintain Asset Master Info screen or the Current Pd Amortization field in te G/L Book Info (Leases) subtask of the Maintain Asset Master Info screen (and in the corresponding fields in the Maintain Asset G/L Book Info 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 field in the G/L Book Info (Years or Units) subtask of the Maintain Asset Master Info screen or the amount in the Current Pd Amortization field in the G/L Book Info (Leases) subtask of the Maintain Asset Master Info screen (and in the corresponding fields in the Maintain Asset G/L Book Info screen).
If you choose to print the FYTD Depreciation column on the report, this value is equal to the FYTD Depreciation field in the G/L Book Info (Years or Units) subtask of the Maintain Asset Master Info screen or the FYTD Amortization field in the G/L Book Info (Leases) subtask of the Maintain Asset Master Info screen (and in the corresponding fields in the Maintain Asset G/L Book Info 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 Curr Pd Activity checkbox.) The FYTD Depreciation column print option is available only for detail reports by asset/item number.
If you choose to print the Depr Exp Act Alloc Codes and/or the Acct Percentage Allocations columns on the report, data displays from the setup in the Depr Exp Acct Alloc Codes screen. This option is available only for detail reports by asset/item number.
The 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 print 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 printed the Current Period Depreciation Rpt 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.
Use these radio buttons to select a primary sort for the report.
This radio button is selected by default.
If you select this radio button, the report will be grouped by the depreciation expense account allocation codes set up in the Depr Exp Acct Alloc Codes screen. (A depreciation expense account allocation code must be assigned to each depreciable record in the Account Info for G/L Book subtask of the Maintain Asset Master Info screen.)
If you select this radio button and save the print parameters for this report, your selection will display as "ALLOC_CD" in the Select By column in the Query table.
Select this radio button 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 Account Info for G/L Book subtask of the Maintain Asset Master Info screen.
If you select this radio button and save the print parameters for this report, your selection will display as "ACCT_ORG" in the Select By column in the Query table.
Select this radio button to group your report by asset/item number.
If you select this radio button and save the print parameters for this report, your selection will display as "ASSET_ID" in the Select By column in the Query table.
Use the fields in this group box to select depreciation expense account allocation codes or depreciation expense accounts/organizations to include in your report. Depending on which radio button you selected in the Select By group box, using Lookup in the From and To fields will display a list of depreciation expense account allocation codes or a list of depreciation expense account numbers. Fields in this group box will be disabled if you selected Asset/Item No in the Select By group box.
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 Account Range column.
Enter the beginning depreciation expense account allocation code or the beginning depreciation expense account number in this field, or use Lookup to select one from those displayed Because this is a standard Lookup (based on your selection), you may find that you have made selections in the Lookup for which data does not exist.
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 Account From column.
Enter the ending depreciation expense account allocation code or the ending depreciation expense account number in this field, or use Lookup to select one from those displayed. Because this is a standard Lookup (based on your selection), you may find that you have made selections in the Lookup for which data does not exist.
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 From value, as applicable, will be stored in the Query table in the Account To column.
Use the fields in this group box to select depreciation expense organizations for the report. If you select Depr Exp Acct Alloc Code or Asset/Item No in the Select By group box, the fields in this group box will be disabled.
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 organization number 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 in the Lookup for which data does not exist.
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 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 in the Lookup for which data does not exist.
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.
Use the fields in this group box to select asset/item numbers for the computation. If you enter a specific asset number, you must also enter a corresponding item number.
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 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 an 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 does not exist.
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(s), as applicable, will be stored in the Query table in the Asset From and Item From columns.
Enter the ending asset/item number for the range or use Lookup to select an 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 does not exist.
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(s), as applicable, will be stored in the Query table in the Asset To and Item To columns.
This checkbox is selected by default.
The Current Period Depreciation Report always includes active and inactive depreciable records with current period depreciation activity. Select this checkbox 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 Column checkbox in the Show group box, you may want to select this checkbox as well.
If you select this checkbox and save the print parameters for this report, "Y" will display in the No Curr Pd Act column in the Query table.
This checkbox is unchecked by default.
Select this checkbox to include a 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 selected the Active Records With No Curr Pd Activity checkbox.)
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 checkbox is available only if you have selected Asset/Item No in the Select By group box.
If you save the print parameters for this report and this checkbox is selected, "Y" will display in the FYTD Depr column in the Query table.
This checkbox is unchecked by default.
Select this checkbox 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 checkbox is available for both Detail and Summary report options if you selected the Depr Exp Account/Org radio button OR the Depr Exp Acct Alloc Code radio button in the Select By group box.
If you select this checkbox and save the print parameters for this report, "Y" will display in the Project Total column in the Query table.
This checkbox is unchecked by default.
Select this checkbox to print the depreciation expense account allocation code assigned to each asset. This checkbox is available for all options in the Select By group box if the Detail report option is selected.
If you save the print parameters for this report and this checkbox is selected, "Y" will display in the Depr Alloc Code column in the Query table.
This checkbox is unchecked by default and is available only if the Detail radio button 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 checkbox, these percentages will print as a column on your report.
If you select this checkbox and save the print parameters for this report, "Y" will display in the Acct % Allocate column in the Query table.
This radio button 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 radio button, the checkboxes in the Show group box are disabled, because they apply only to detail reports by asset/item number.
If you select this radio button and save the print parameters for this report, "Summary" will display in the Report Option column in the Query table.
Select this radio button to print report values by asset/item number. When you select this radio button, the checkboxes in the Show group box are also available.
If you select this radio button and save the print parameters for this report, "Detail" will display in the Report Option column in the Query table.
This report prints data stored in the ASSET (Asset) table.
Lookup accesses data from the ASSET (Asset), ACCT (ACCOUNT), ORG_ACCT (Organization/Account), PROJ (Project), DEPR_EXP_ALLOC_CD (Depreciation Expense Allocation Code), and DEPR_EXP_ALC_ACCT (Depreciation Expense Allocation Account) tables.