Contents of the Print Posted Transactions Details Screen

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.

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

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.

Field	Description
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.

Field

Description

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.)

Field	Description
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.

Field

Description

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.

Field	Description
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.

Field

Description

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.)

Field	Description
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.

Field

Description

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.

Field	Description
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. Note: 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.

Field

Description

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.

Note: 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.

Field	Description
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.

Field

Description

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.

Field	Description
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. Note: 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.

Note:

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.)

Field	Description
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. Note: This check box is disabled if you have selected to sort by Asset/Item No.

Field

Description

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.

Note: This check box is disabled if you have selected to sort by Asset/Item No.

Costpoint Online Help

Contents of the Print Posted Transactions Details Screen

Identification

Selection Ranges

Accounts

Organizations

Post Sequence No

Projects

Time Periods

Asset/Item Numbers

Options

Select Entry Types

Sort By