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.

Reversal

Note: For Costpoint Cloud, you can choose to opt in to this feature for the Costpoint 8.2.15 release. The ability to opt in is temporary and will be removed when the feature becomes automatically enabled for all users as part of a future Costpoint release. See the Manage Opt-In Features topic for more information.
Field Description
Reverse

Select this checkbox to indicate that the transaction is a settlement reversal. When you select this checkbox, fields in the Filtering Criteria section are disabled.

Settlement Number to Reverse Enter, or click to select, the settlement number of a posted Settlement Journal for which you want to make a reversal.

This field is enabled only if you select the Reverse checkbox.

The Lookup displays records only if you have entered a Fiscal Year and Period, and displays only settlement numbers of journals that have not yet been fully reversed.

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.

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.

If the Reverse checkbox is selected, this table window displays offsetting transactions entered for the Settlement Journal entered in the Settlement Number to Reverse field.

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.

If the Reverse checkbox is selected, the offsetting transactions you add from the Available Transactions table window will display in this table window with reversed amounts (positive to negative and vice versa).

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.