Contents of the Revaluation Settlement Screen

Use the fields and options to configure the Revaluation Settlement screen.

Revaluation Settlement

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.
Fiscal Year	Enter, or click to select, the fiscal year for which you want Costpoint to create the settlement entry.
Period	Enter, or click to select, the accounting period for which you want Costpoint to create the settlement entry.
Subperiod	This field displays the last subperiod in the accounting period.
End Date	This field displays the subperiod ending date.
Settlement Number	This field displays the eleven-digit system-generated identification number for the settlement entry.

Processing Options for Posting

Offsetting Account

Use this group box to specify the account that will be used to charge the currency gain/loss for the settlement.

Field	Description
Other Comprehensive Income	Select this option to use the Other Comprehensive Income account indicated on the Configure General Ledger Settings screen.
Realized Gain/Loss	Select this option to use the Realized Gain and Loss accounts indicated on the Manage Multicurrency Accounts screen.

Offset Organization

Use this group box to specify the organization that will be used with the account specified in the Offsetting Account group box. This is the organization where the system can charge the currency gain/loss for the settlement.

Field	Description
Balance Sheet Level Org	Select this option to use the balance sheet level of the organization of the account/organization being charged with the settlement.
Source Org	Select this option to use the same organization as the one used from the account/organization being charged with the settlement.

Revalue Organization

Use this group box to specify the organization to use with the account being revalued. This is the organization that Costpoint will use to charge the amount needed to revalue the account to adjust it to the correct functional balance.

Field	Description
Balance Sheet Level Org	Select this option to use the balance sheet level of the organization from the account/organization being revalued.
Source Org	Select this option to use the same organization from the account/organization being revalued.

Filtering Criteria

Use this section to configure which records you want to display in the Available Transactions table window.

Field	Description
Account	Use this field to enter the account from which you want to retrieve available transactions. You cannot select an account that is entered on the Exclude Accounts from Create Revaluation Entry screen.
Organization	Use this field to enter the organization from which you want to retrieve available transactions.
Project	Use this field to enter the project from which you want to retrieve available transactions.
Currency	Use this field to enter the currency code of the transactions you want to retrieve. You can enter only foreign currency codes and the result set displays only one currency at a time.
Transaction Date >	Use this field to enter or select the transaction date start range. Only records dated after the value you enter in this field and were posted in a fiscal year that is earlier or equal to the value you entered in the Fiscal Year field of the Revaluation Settlement section display on the Available Transactions table window.
Reverse	Select this checkbox to indicate a settlement reversal entry. Note: The settlement reversal feature is under development and will be available in a future Costpoint release.
Settlement Number to Reverse	Use this field to enter the identification number of the settlement entry to be reversed. Note: The settlement reversal feature is under development and will be available in a future Costpoint release.

Available Transactions

This table window displays transaction records pulled from the GL_DETL table based on the parameters you set in the Filtering Criteria section.

Use this table window to select offsetting transactions with matching currencies which when totaled, result in a zero net (0) transaction amount and add them to the Settled Transactions table window.

You can highlight multiple records by holding the Ctrl key while clicking the corresponding checkbox for each record.

You can repeatedly modify the filtering criteria to display different result sets in this table window, but each result set displays only transactions with the same currency at a time.

Field	Description
Query	Click this button to set additional filters or sorting criteria for the records displayed on the table window. The parameters you set in the query do not override the parameters in the Filtering Criteria section.
Select	Click this button to add the highlighted records to the Settled Transactions table window.
Account	This field displays the value you entered in the Account field of the Filtering Criteria section.
Org	This field displays the organization assigned to the transaction.
Project	This field displays the project assigned to the transaction.
FY	This field displays the fiscal year to which the transaction is posted.
Period	This field displays the period to which the transaction is posted.
Description	This field displays the transaction description.
Func Amt	This field displays the transaction amount in your functional currency.
Tran Amt	This field displays the transaction amount.
Tran Currency	This field displays the transaction currency. The result set displays only transactions with the same currency at a time.

Settled Transactions

Use this table to review the offsetting transactions you selected in the Available Transactions table window and add them to the Settlement Journal.

You have the option to add the records in separate groups, provided that the journal entry for the settlement transaction you are modifying has not been posted. In addition, a single Settlement Number can have offsetting transactions in different currencies, but you can add only transactions with the same account/org/currency combination per group, and the total Tran Amt per currency must be zero.

To add more offsetting records, query the Settlement Number of the entry you want to modify on the Revaluation Settlement section.

You can add transactions to the Settlement Journal only if the value of the Balance (Tran) field is zero, the value of the Balance (Func) field is not zero, and there are no unposted settlement entries. Otherwise, an error message displays.

Field	Description
Delete	Click this button to delete a record from this table window.
Query	Click this button to set additional filters or sorting criteria for the records displayed on the table window.
Account	This field displays the value you entered in the Account field of the Filtering Criteria section.
Org	This field displays the organization assigned to the transaction.
Project	This field displays the project assigned to the transaction.
FY	This field displays the fiscal year to which the transaction is posted.
Period	This field displays the period to which the transaction is posted.
Description	This field displays the transaction description.
Func Amt	This field displays the transaction amount in your functional currency.
Tran Amt	This field displays the transaction amount.
Tran Currency	This field displays the transaction currency. The result set displays only transactions with the same currency at a time.
Add to Settlement	Click this button to add the offsetting transactions to the Settlement Journal.