PRINT SEQUENTIAL POSTED DEPRECIATION HISTORY REPORT
Use this report to print historical depreciation expense posted for the G/L Book only. The data prints in a sequential columnar format for user-specified time periods to enable trend analysis, and so on.
Location
Historical depreciation expense for the G/L Book consists of all posted depreciation expense written to the FA_POSTING_DETL table when you post the Fixed Assets Journal.
Posted depreciation (DEPR) entries are automatically included in the data retrieval (per your selection criteria) via the accounts, organizations and projects already linked to your Depreciation Expense Account Allocation Codes and their subsequent assignment to depreciable asset records.
Disposal (DISP), depreciation adjustment (DADJ), and/or transfer (TRF) entries posted to the FA_POSTING_DETL table are also eligible for retrieval if any portion of the entry was posted to a depreciation expense account. (The system determines depreciation expense account/organization/project eligibility via the accounts, organizations, and projects assigned to the Manage Depreciation Expense Acct Allocation Codes set up during initialization.)
For optional Books 2 to 10, historical depreciation expense is all depreciation written to the FA_DEPR_HS table when you run the Close Fixed Assets Accounting Period process. Depreciation expense for optional Books 2 to10 is never posted to the G/L and therefore cannot be printed from this screen. You can, however, use the Print Sequential Other Books Depreciation History Rpt to print this data.
You can print a summary report or a detail report that prints data asset-by-asset. You can print the data for a range of (including one), or all, depreciation expense account allocation codes; asset/item numbers; asset accounts, organizations, and/or projects; and/or depreciation expense accounts, organizations, and/or projects. You can also select the beginning and ending range of fiscal years and periods, print the data by accounting period, and/or include project subtotals.
If you print a detail report, you can also print the Depreciation Expense Acct Alloc Codes column on the report. Depending on your selection criteria, you can sort the report by asset account, by asset organization, by asset account/org, by depreciation expense account, by depreciation expense organization, by depreciation expense account/organization, or by asset no/item no.
This report is designed to emulate spreadsheets that print depreciation history for a fiscal year in a comparative report format with all periods in side-by-side columns. You can print it only on legal-sized paper. You can print data columns per report page using the full decimal values from the posting detail table. If you print posted amounts in whole (rounded) numbers for the report, however, you can print 14 data columns per report page.
Print this report any time after posting to review historical data contained in the Posted Transactions Detail table.
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 are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
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 in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in 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 in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Select By Option
Select Records By
Use the options in this group box to define how the posted depreciation expense data should be selected. You can select records by asset ("ownership") account/organization/project, by depreciation expense account/organization/project, or by depreciation expense account allocation code.
Asset Account/Organization/Project
This option is selected by default. Select this option to select posted depreciation expense data by asset ("ownership") account/organization/project.
Depr Exp Account/Organization/Project
Select this option to select posted depreciation expense data by depreciation expense account/organization/project.
Depr Exp Account Allocation Code
Select this option to select posted depreciation expense data by depreciation expense account allocation code.
Report Type
Use the options 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.
Summary
This option is selected by default. Select this option to print a summary report without individual asset/item number data. If you select this option, the Depreciation Expense Acct Alloc Codes check box in the Show group box is disabled. In addition, asset/item numbers are not available as selection criteria or as a sort option.
Detail by Asset
Select this option to print a detailed report that includes individual asset/item number data.
If you select this option, asset/item number selection and sort are permitted and the Depreciation Expense Acct Alloc Codes check box in the Show group box is also available.
Selection Ranges
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. These fields are available only if you have selected the Detail By Asset option in the Report Type group box.
Option
The default option for this field is All. You can accept the displayed default range option, or select one from the drop-down list. Range options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click 
to select, the beginning asset/item number for the range. Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table 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 this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.
If you select All, One, or To End in the Option field, these fields will be inactive.
Posted Time Periods
Use the following fields to select records for the report from one fiscal year and period, a range of fiscal years and periods, or all fiscal years and periods.
The Lookup in the Fiscal Year fields display only those fiscal years already set up on the Manage Fiscal Years screen in Costpoint General Ledger, beginning with the latest fiscal year. (Fiscal years set up in the General Ledger should always match those set up in Fixed Assets on the Manage Fixed Assets Fiscal Years screen.) Because the displays in the Fiscal Year fields are from a standard Lookup to the Fiscal Year table, you may find that you have selected a fiscal year for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.
The Lookup in the Period fields display only those accounting periods already set up on the Manage Accounting Periods screen in Costpoint General Ledger for the fiscal year specified in the Fiscal Year field. (Accounting periods set up in the General Ledger should always match those set up in Fixed Assets on the Manage Fixed Assets Accounting Periods screen.) Because the displays in the Period fields are from a standard Lookup to the ACCTING_PD table, you may find that you have selected a period for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.
Option
This field is not editable and will always show Range as selection.
Start
Enter, or click to select, the beginning desired fiscal year and period for the range.
End
Enter, or click to select, the ending desired fiscal year and period for the range.
Accounts or Codes
Use the following fields to select records for the report from a range of accounts or codes, as applicable. The asset "ownership" account and depreciation expense account (linked via the depreciation expense account allocation code) are each required for all Asset Master records.
-
If you select the Asset Account/Organization/Project option in the Select Records By group box, enter, or click to select the desired asset ("ownership") account(s) in the Start and/or End fields. Because the standard Lookup for the account is to the ACCT table, you may find that you have selected an account for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.
-
If you select the Depr Exp Account/Organization/Project option in the Select Records By group box, enter, or click to select the desired depreciation expense account(s) in the Start and/or End fields. Because the standard Lookup for the account is to the ACCT table, you may find that you have selected an account for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.
-
If you select the Depr Exp Account Alloc Code option in the Select Records By group box, enter, or click to select, the desired depreciation expense account allocation code(s) (in the Start and/or End fields), which contain the depreciation expense account/organization/project data. Because the standard Lookup for the account is to the DEPR_EXP_ALLOC_CD table, you may find that you have selected a code for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.
Option
The default option for this field is All. You can accept the displayed default range option, or select one from the drop-down list. Range options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, the beginning account number or code in this field, as applicable.
If you select All or From Beginning in the Option field, this field will be inactive.
End
Enter, or click to select, the ending account number or code in this field, as applicable.
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 organizations, as applicable. The asset "ownership" account and depreciation expense organization (linked via the depreciation expense account allocation code) are each required for all Asset Master records.
-
If you select the Asset Account/Organization/Project option in the Select Records By group box, enter, or click to select, the desired asset ("ownership") organization(s) in the Start and/or End fields. Because the standard Lookup for the organization is to the ORG_ACCT table, you may find that you have selected an organization for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.
-
If you select the Depr Exp Account/Organization/Project option in the Select Records By group box, select the desired depreciation expense organization(s) in the Start and/or End fields. Because the standard Lookup for the organization is to the ORG table, you may find that you have selected an organization for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.
-
If you select the Depr Exp Account Allocation Code option in the Select Records By group box, the fields in this group box will not be available. The system will select posted data within the parameters of your other selection criteria for the organization that you linked with your depreciation expense account allocation code(s) during initialization.
Option
Select a range option from the drop-down list. The options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, the beginning organization in this field.
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 in this field.
If you select All, One, or To End in the Option field, this field will be inactive.
Projects
Use the following fields to select records for the report from a range of projects, as applicable. The asset "ownership" project and depreciation expense project (linked via the depreciation expense account allocation code) are each optional for all Asset Master records.
-
If you select the Asset Account/Organization/Project option in the Select Records By group box, enter, or click to select, the desired asset ("ownership") project(s) in the Start and/or End fields. Because the standard Lookup for the account is to the PROJ table, you may find that you have selected a project for which posted transactions do not exist or that do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.
-
If you select the Depr Exp Account/Organization/Project option in the Select Records By group box, enter, or click to select, the desired depreciation expense project(s). Because the standard Lookup for the account is to the PROJ table, in this circumstance you may find that you have selected a project for which posted transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the FA_POSTING_DETL table may not be selected.
-
If you select the Depr Exp Account Allocation Code option in the Select Records By group box, the fields in this group box will not be available. The system will select posted data within the parameters of your other selection criteria for the organization that you linked with your depreciation expense account allocation code(s) during initialization.
Option
Select the range option from the drop-down list. The options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, the beginning project in this field.
If you select All or From Beginning in the Option field, this field will be inactive.
End
Enter, or click to select, the ending project in this field.
If you select All, One, or To End in the Option field, this field will be inactive.
Options
Show
Use this group box to control display preferences for the report.
Depreciation Expense Acct Alloc Codes
This check box is available only if you select the Detail By Asset option in the Report Type group box.
Select this check box to print the depreciation expense account allocation code data for each asset/item number on the report, as applicable.
Amounts as Whole Numbers
Select this check box to print depreciation expense amounts on the report in whole numbers without the display of decimals.
If you display dollars in whole numbers only, data for 13 accounting periods plus a total column (14 total columns) can display on a single report page. If you have more than 13 periods in your fiscal year, the additional columns will print on a second report page.
Clear this check box if you want the report to display in dollars and cents. Because columns are wider to accommodate the decimals, data for only 11 columns will print on the first report page and additional data will print on a second report page.
Print
Use the check boxes in this group box to control print display preferences for the report.
Period Data
Select this check box to print the posted depreciation expense data by accounting period for the selected fiscal year(s).
Project Subtotals
Select this check box to print subtotals by project for the posted depreciation expense data.
Sort By
In this group box, you can select the way the system organizes the data for the report.
However, the report always prints in the same format, regardless of the sort option you select. (The sort option determines how data will be ordered within this format.)
1st Sort
Select the sort option from the drop-down list. The options available are:
-
Account — Select this option to sort the report by asset ("ownership") account or by depreciation expense account.
-
-
If you select the Asset Account/Organization/Project option in the Select Records By group box, report data will be sorted by asset ("ownership") account.
-
If you select the Depr Exp Account/Organization/Project option in the Select Records By group box, report data will be sorted by depreciation expense account.
-
If you select the Depr Exp Account Allocation Code option in the Select Records By group box, report data will be sorted by depreciation expense account, based on the account set up for the depreciation expense account allocation code that was linked to the Asset Master record.
-
Organization — Select this option to sort the report by asset ("ownership") organization or by depreciation expense organization.
-
-
If you select the Asset Account/Organization/Project option in the Select Records By group box, report data will be sorted by asset ("ownership") organization.
-
If you select the Depr Exp Account/Organization/Project option in the Select Records By group box, report data will be sorted by depreciation expense organization.
-
If you select the Depr Exp Account Allocation Code option in the Select Records By group box, report data will be sorted by depreciation expense organization, based on the organization set up for the depreciation expense account allocation code that was linked to the Asset Master record.
-
Account/Org — Select this option to sort the report by asset ("ownership") account/organization combination or by depreciation expense account/ organization combination.
-
-
If you select the Asset Account/Organization/Project option in the Select Records By group box, report data will be sorted by asset ("ownership") account/organization combination.
-
If you select the Depr Exp Account/Organization/Project option in the Select Records By group box, report data will be sorted by depreciation expense account/organization combination.
-
If you select the Depr Exp Account Allocation Code option in the Select Records By group box, report data will be sorted by depreciation expense account/ organization combination, based on the asset and organization combination set up for the depreciation expense account allocation code that was linked to the Asset Master record.
-
Asset No/Item No — This selection is available only if you select the Detail By Asset option in the Report Type group box.
Select this option 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 check box will also be unavailable.
Page Break
Select this check box if you want a page break in the report each time the selected sort parameter changes. For example, if you have selected to sort the data by account, you should select the Page Break check box 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 check box will be disabled.