PRINT POSTED TRANSACTIONS DETAIL
Use this screen to print posted details for one, a range of, or all account/ organization/ project combinations, fiscal year/period/ subperiod combinations, and asset/item numbers. The Print Posted Transactions Detail Report creates the selected contents of the Posted Transactions Detail table for depreciation expense, disposals, and/or depreciation adjustment entries, and includes the detail for all Fixed Assets accounts (such as, Asset, Depreciation Expense, Accumulated Depreciation, and Gain/Loss accounts). You can sort the report by fiscal year/period, account, organization, project, account/organization, or asset/item number.
Because the Posted Transactions Detail table may potentially contain a very large number of records, you can limit the data printed in each report by carefully choosing the selection parameters. If you print this report for ranges of accounts, organizations, projects, and asset/item numbers, rather than for all accounts, the grand total of debits and credits may not equal zero because data may be included only for a portion of the Fixed Assets entries.
Print this report any time after posting to review historical data contained on the Posted Transactions Detail table.
Location
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.
Selection Ranges
Accounts
Use the following fields to select records for 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 any of the check boxes in the Select Entry Types group box may modify which records from the selected account range are actually included in the report.
Option
The default option for this field is Range. You can accept the displayed default range option, or select one from the drop-down list. The options available are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click 
to select, the beginning account number in this field. Because this is a standard Lookup to the ACCT table, you may find that you have selected an account number 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, this field will be inactive.
End
Enter, or click to select, the ending account number. Because this is a standard Lookup to the ACCT table, you may find that you have selected an account number 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, 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.)
Option
The default option for this field is Range. You can accept the displayed default range option, or select one from the drop-down list. The available options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, the beginning organization in this field. Because this is a standard Lookup 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 Option field, this field will be inactive.
End
Enter, or click to select, the ending organization in this field. Because this is a standard Lookup 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 All, One, or To End in the Option field, this field will be inactive.
Post Sequence No
Use the following fields to choose a range of posting sequence numbers for the report. The system assigns the same posting sequence number to all entries posted in the same session. If you limit the data in your report to a range of posting sequence numbers, you should also print the report for only one fiscal year and period. Because posting sequence numbers are renumbered at the beginning of every period, if you print the report for a range of periods and a specified sequence number (3, for example), all entries assigned that sequence number in all the selected periods will print on the report. Therefore, if you select Periods 1 to 4, all entries assigned Sequence Number 3 in Period 1 will print, as well as all entries assigned Sequence Number 3 in Periods 2, 3, and 4.
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. The available options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, the beginning sequence number for the range. Be careful with your entry, because you may find that you have entered selection criteria for which posted transactions do not exist or do not meet your other selection criteria.
If you select All or From Beginning in the Option field, this field will be inactive.
End
Enter, or click to select, the ending sequence number for the range. Be careful with your entry, because you may find that you have entered selection criteria for which posted transactions do not exist or do not meet your other selection criteria.
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 asset ("ownership") projects, as applicable. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
Option
The default option for this field is Range. You can accept the displayed default range option, or select one from the drop-down list. The available options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, the beginning project in this field, if applicable. Because this is a standard Lookup 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 Option field, this field will be inactive.
End
Enter, or click to select, the ending project in this field, if applicable. Because this is a standard Lookup 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 Option field, this field will be inactive.
Time Periods
Use the following fields to select records for the report from a range of fiscal years, periods, and subperiods.
Option
The default option for this field is Range. You can accept the displayed default range option, or select one from the drop-down list. The available options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
The Lookup in the Fiscal Year field display only those fiscal years already set up on the Manage Fiscal Years screen, beginning with latest fiscal year. (Fiscal years set up on the General Ledger should always match those set up in Fixed Assets on the Manage Fixed Assets Fiscal Years screen.) Because the display in the Fiscal Year field is a standard Lookup to the FY 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 field display only those accounting periods already set up the Manage Accounting Periods screen in the General Ledger module for the fiscal year specified in the Fiscal Year field. (Accounting periods set up on the General Ledger should always match those set up in Fixed Assets on the Manage Fixed Assets Accounting Periods screen.) Because the display in the Period field is 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.
If you want to limit the data in your report to a range of posting sequence numbers, print the report for only one fiscal year and period.
Start
Enter, or click to select, the beginning fiscal year, period, and subperiod for the range.
If you select All or From Beginning in the Option field, these fields will be inactive.
End
Enter, or click to select, the ending fiscal year, period, and subperiod for the range.
If you select All, One, or To End in the Option field, these fields will be inactive.
Asset/Item Numbers
Use the following fields to select a range of 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. The selection you make in any of the check boxes in the Select Entry Type group box may modify which records from the selected asset/item number range are actually included in the report.
Option
The default option for this field is Range. You can accept the displayed default range option, or select one from the drop-down list. The following options are available:
-
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.
Options
Select Entry Types
Use the options in this group box to select the type(s) of posting entries to include in the report. Select as many check boxes as desired. You must select at least one check box to run the report.
DEPR
Select this check box to include depreciation expense entries within the range of entries selected for the report. This check box is selected by default. If this check box is clear, the system automatically excludes all depreciation expense entries.
DISP
Select this check box to include disposal entries within the range of entries selected for the report. If this check box is clear, the system automatically excludes all disposal entries.
DADJ
Select this check box to include depreciation adjustment entries associated with disposals within the range of entries selected for the report. This check box is clear by default. If this check box is clear, the system automatically excludes all depreciation adjustment entries.
RDEP
Select this check box to include reversing depreciation expense entries within the range of entries selected for the report. If this check box is clear, the system automatically excludes all reversing depreciation expense entries.
RDIS
Select this check box to include reversing disposal entries within the range of entries selected for the report. If this check box is clear, the system automatically excludes all reversing disposal entries.
RDAD
Select this check box to include reversing depreciation adjustment entries associated with disposals within the range of entries selected for the report. If this check box is clear, the system automatically excludes all reversing depreciation adjustment entries.
TRF
Select this check box to include transfer entries within the range of entries selected for the report. If this check box is clear, the system automatically excludes all transfer entries.
Although transfers are currently posted in the same Post Fixed Assets Journal screen as depreciation and disposals, you cannot perform reversing transfer entries. To achieve the same effect as a "reversal" of a transfer entry previously made in the current period, you must change the data back to its "pre-change" status in the Asset Account/Organization/Project/Reference1/Reference2 fields and/or the Accum Depr Acct/Organization/Project/Reference1/Reference2 fields (via the Accum Depr Acct Code), either manually on the Asset Master screens or via the Global Change functions. Because change details are stored in the ASSET_AUDIT_LOG table, posting a second transfer entry in this manner effectively creates a "reversing" transfer entry.
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 the parameters without changing your saved parameters. To use Copy Record, open the record you want to copy, and then go to the Line menu and click Copy Record (or press CTRL+E). Edit the record as needed.
You can save your sort options and selection criteria for this report with or without printing. Enter an alphanumeric identifying code and a short description to help you recognize the report parameters. After making your selections, click the Save button on the toolbar (or press F5). You can also go to the File menu and click Save. Later, you can use 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 the reports through Process Manager.
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 should be ordered within this format.)
1st Sort
Select the sort option from the drop-down list. The available options are:
-
Posting FY/Pd — This option is the system default. Select this option to organize the report by fiscal year/period. Within this primary sort category, data will be further sorted by subperiod, sequence number, entry type, and asset/item number, respectively.
-
Account — Select this option to sort the report by account. Within this primary sort category, data will be further sorted by fiscal year/period/subperiod, sequence number, entry type, and asset/item number, respectively.
-
Organization — Select this option to sort the report by organization. Within this primary sort category, data will be further sorted by fiscal year/period/subperiod, sequence number, entry type, and asset/item number, respectively.
-
Project — Select this option to sort the report by project. Within this primary sort category, data will be further sorted by fiscal year/period/subperiod, sequence number, entry type, and asset/item number, respectively.
-
Acct/Org — Select this option to sort the report by the account/organization combination. Within this primary sort category, data will be further sorted by fiscal year/period/subperiod, sequence number, entry type, and asset/item number, respectively.
-
Asset/Item No — Select this option to sort the report by asset/item number. Within this primary sort category, data will be further sorted by fiscal year/period/subperiod, sequence number, entry type, and account, respectively.
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 Fiscal Year/Period, you should select the Page Break check box if you want data for each fiscal year/period combination to print on a separate page.
This check box is disabled if you have selected to sort by Asset/Item No.