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