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.
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/org/proj eligibility via the accounts, organizations, and projects assigned to the Depr Exp Acct Alloc Codes set up during initialization.)
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 Depr Exp 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/org, 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 Fixed Assets Posting Detail table.
Use the radio buttons in this group box to define how the posted depreciation expense data should be selected. You can select records by asset ("ownership") acct/org/proj, by depreciation expense acct/org/proj, or by depreciation expense account allocation code.
This radio button is selected by default. Select this radio button to select posted depreciation expense data by asset ("ownership") account/organization/project.
If you select this radio button and save the print parameters for this report, "A" will display in the Select Records By column in the Query table.
Select this radio button to select posted depreciation expense data by depreciation expense account/organization/project.
If you select this radio button and save the print parameters for this report, "D" will display in the Select Records By column in the Query table.
Select this radio button to select posted depreciation expense data by depreciation expense account allocation code.
If you select this radio button and save the print parameters for this report, "C" will display in the Select Records By column in the Query table.
Use the radio buttons 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.
This radio button is selected by default. Select this radio button to print a summary report without individual asset/item number data. If you select this radio button, the Depr Exp Acct Alloc Code Column checkbox in the Show group box is disabled. In addition, asset/item numbers are not available as selection criteria or as a sort option.
If you select this radio button and save the print parameters for this report, "S" will display in the Report Option column in the Query table.
Select this radio button to print a detailed report that includes individual asset/item number data.
If you select this radio button, asset/item number selection and sort are permitted and the Depr Exp Acct Alloc Code Column checkbox in the Show group box is also available.
If you select this radio button and save the print parameters for this report, "D" will display in the Sort By column in the Query table.
Use 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. The fields in this group box are available only if you have selected the Detail By Asset radio button in the Report Option 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 report parameter selections, the selected range option will be identified in the Query table in the Asset Range Option column.
Enter the beginning asset/item number for the Range Option or use Lookup to select one. 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 Range Option field, these fields will be inactive.
If you save the report parameter selections, the selected From values, as applicable, will be identified in the Query table in the From Asset No column and From Item No column.
Enter the ending asset/item number for the Range Option or use Lookup to select one. 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 Range Option field, these fields will be inactive.
If you save the report parameter selections, the selected To values, as applicable, will be identified in the Query table in the To Asset No column and To Item No column.
Use this group box to control display preferences for the report.
Select this checkbox to print the depreciation expense account allocation code data for each asset/item number on the report, as applicable.
If you select this checkbox and save the print parameters for this report, "Y" will display in the Show Depr Exp Acct Alloc Code column in the Query table.
This checkbox is unchecked by default. Select this checkbox 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.
Do not select this checkbox 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.
If you select this checkbox and save the print parameters for this report, "Y" will display in the Show Amounts in Whole Numbers column in the Query table.
Use the fields in this group box 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 selected the Asset Acct/Org/Proj radio button in the Select Records By group box, you will select the desired asset ("ownership") account(s). 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 selected the Depr Exp Acct/Org/Proj radio button in the Select Records By group box, you will select the desired depreciation expense account(s). 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 have selected the Depr Exp Acct Alloc Code radio button in the Select Records By group box, you will select the desired depreciation expense account allocation code(s), which contain the depreciation expense account/org/proj 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.
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 selected either the Asset Acct/Org/Proj OR the Depr Exp Acct/Org/Proj radio button in the Select Records By group box and if you save the report parameter selections, the selected range option will be identified in the Query table in the Account Range Option column.
Enter the beginning account number or code in this field, as applicable.
If you have selected either the Asset Acct/Org/Proj OR the Depr Exp Acct/Org/Proj radio button in the Select Records By group box, enter the beginning account number in this field or use Lookup to select one.
If you have selected the Depr Exp Acct Alloc Code radio button in the Select Records By group box, enter the desired depreciation expense account allocation code or select one from those displayed in the drop-down box. (The system will select posted data within the parameters of your other selection criteria for the account(s) that you linked with your depreciation expense account allocation code(s) during initialization.)
If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you have selected either the Asset Acct/Org/Proj OR the Depr Exp Acct/Org/Proj radio button in the Select Records By group box and if you save the report parameter selections, the selected From value, as applicable, will be identified in the Query table in the From Account column.
If you have selected the Depr Exp Acct Alloc Code radio button in the Select Records By group box and if you save the report parameter selections, the selected From value, as applicable, will be identified in the Query table in the From Depr Exp Alc Code column.
Enter the ending account number or code in this field, as applicable.
If you have selected either the Asset Acct/Org/Proj OR the Depr Exp Acct/Org/Proj radio button in the Select Records By group box, enter the beginning account number in this field or use Lookup to select one.
If you have selected the Depr Exp Acct Alloc Code radio button in the Select Records By group box, enter the desired depreciation expense account allocation or select one from those displayed in the drop-down box. (The system will select posted data within the parameters of your other selection criteria for the account(s) that you linked with your depreciation expense account allocation code(s) during initialization.)
If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you have selected either the Asset Acct/Org/Proj OR the Depr Exp Acct/Org/Proj radio button in the Select Records By group box and if you save the report parameter selections, the selected To value, as applicable, will be identified in the Query table in the To Account column.
If you have selected the Depr Exp Acct Alloc Code radio button in the Select Records By group box and if you save the report parameter selections, the selected To value, as applicable, will be identified in the Query table in the To Depr Exp Alc Code column.
Use the fields in this group box 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 selected the Asset Acct/Org/Proj radio button in the Select Records By group box, select the desired asset ("ownership") organization(s). 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 selected the Depr Exp Acct/Org/Proj radio button in the Select Records By group box, select the desired depreciation expense organization(s). 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 selected the Depr Exp Acct Alloc Code radio button 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.
The default option for this field is "Range." 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 report parameter selections, the selected Range Option will be identified in the Query table in the Organization Range Option column.
Enter the beginning organization in this field or use Lookup to select an organization from those displayed. 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 "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the report parameter selections, the selected From value, as applicable, will be identified in the Query table in the From Organization column.
Enter the ending organization in this field or use Lookup to select an organization from those displayed. 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 "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the report parameter selections, the selected To value, as applicable, will be identified in the Query table in the To Organization column.
Use the fields in this group box 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 selected the Asset Acct/Org/Proj radio button in the Select Records By group box, select the desired asset ("ownership") project(s). 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 selected the Depr Exp Acct/Org/Proj radio button in the Select Records By group box, 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 selected the Depr Exp Acct Alloc Code radio button 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.
The default option for this field is "Range." 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 report parameter selections, the selected Range Option will be identified in the Query table in the Project Range Option column.
Enter the beginning project in this field or use Lookup to select a project from those displayed. Because the standard Lookup for the project is to the PROJ table, 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 "All" or "From Beginning" in the Range Option field, this field will be inactive.
If you save the report parameter selections, the selected From value, as applicable, will be identified in the Query table in the From Project column.
Enter the ending project in this field or use Lookup to select a project from those displayed. Because the standard Lookup for the project is to the PROJ table, 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 "All," "One," or "To End" in the Range Option field, this field will be inactive.
If you save the report parameter selections, the selected To value, as applicable, will be identified in the Query table in the To Project column.
In this group box, you can select the way the system organizes the data for the report. Note, however, that 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.)
This radio button is selected by default. Select this radio button to sort the report by asset ("ownership") account or by depreciation expense account.
If you selected the Asset Acct/Org/Proj radio button in the Select Records By group box, report data will be sorted by asset ("ownership") account.
If you selected the Depr Exp Acct/Org/Proj radio button in the Select Records By group box, report data will be sorted by depreciation expense account.
If you selected the Depr Exp Acct Alloc Code radio button 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.
If you select this radio button and save the print parameters for this report, "A" will display in the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by asset ("ownership") organization or by depreciation expense organization.
If you selected the Asset Acct/Org/Proj radio button in the Select Records By group box, report data will be sorted by asset ("ownership") organization.
If you selected the Depr Exp Acct/Org/Proj radio button in the Select Records By group box, report data will be sorted by depreciation expense organization.
If you selected the Depr Exp Acct Alloc Code radio button 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.
If you select this radio button and save the print parameters for this report, "O" will display in the Sort By column in the Query table.
This radio button is unchecked by default. Select this radio button to sort the report by asset ("ownership") account/organization combination or by depreciation expense account/ organization combination.
If you selected the Asset Acct/Org/Proj radio button in the Select Records By group box, report data will be sorted by asset ("ownership") account/organization combination.
If you selected the Depr Exp Acct/Org/Proj radio button in the Select Records By group box, report data will be sorted by depreciation expense account/organization combination.
If you selected the Depr Exp Acct Alloc Code radio button 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.
If you select this radio button and save the print parameters for this report, "AO" will display in the Sort By column in the Query table.
This radio button is unchecked by default. This radio button is available only if you selected the Detail By Asset radio button in the Report Option group box.
Select this radio button 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 checkbox will also be unavailable.
If you select this radio button and save the print parameters for this report, "AI" will display in the Sort By column in the Query table.
Select this checkbox 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 checkbox 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 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.
Use the options in this group box to control print display preferences for the report.
Select this checkbox to print the posted depreciation expense data by accounting period for the selected fiscal year(s). This checkbox is unchecked by default.
If you select this checkbox and save the print parameters for this report, "Y" will display in the Period Data column in the Query table.
Select this checkbox to print subtotals by project for the posted depreciation expense data. This checkbox is unchecked by default.
If you select this checkbox and save the print parameters for this report, "Y" will display in the Project Subtotals column in the Query table.
Select this pushbutton to display additional selection parameters for this report.