Use this screen to determine your company's unrealized gains or losses and post them to the General Ledger. This screen compares the exchange rate used when you entered the voucher or invoice to the current daily rate. You can also use this screen to reverse any accidental or incorrect postings of unrealized gains or losses.
When you first select the Print/Post Unrealized Gains/Losses button on the toolbar, the system generates a message warning you that posting should be done only once as part of the period close. If you continue with the print/post process, the system will calculate the gain or loss for the current period, then post that gain or loss in summary format to the current month. If you print/post a second time, the system will reverse the prior period entry. It will then create a new entry to be posted.
The Compute/Post Unrealized Gains/Losses screen consists of the Identification, Selection Ranges, and Options blocks.
You must first run the Update Open A/P Exchange Rates or the Update Open A/R Exchange Rates (Administration\Process\Multicurrency) screens before running this process. If you fail to do this, the system will not have an updated rate to compare to the historical rate and will not be able to accurately calculate unrealized gains or losses.
You should run this process at the end of the accounting period to accurately measure the gains and losses on foreign exchange. Before running this process, verify that none of the vouchers in the Select Vouchers screen (Accounting\Process\Pay) are on pay status, or they will not be included in this calculation. Also, ensure that you have completed and posted to the G/L all of the vouchers, checks, billings, and cash receipts postings for a particular period before running this process for that period.
Note: Never run this process for a prior period after you have already run it for a later period. If you do this, the unrealized gains/losses could be misstated, especially if you are using the Net Change method of posting unrealized gains/losses. |
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. Once 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. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen.
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 produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this block to specify the range in which you want to determine your company's unrealized gains or losses and post them to the General Ledger.
This non-editable field displays a value of "One."
Enter the fiscal year or use Lookup to select one.
Period *
Enter the period or use Lookup to select one.
This field automatically displays the subperiod number.
This non-editable field automatically displays the ending date.
Use the fields in this block to specify for which accounts you want to determine your company's unrealized gains or losses. You can also use the fields in this block to specify the course of action you wish to take in the event of an invalid account/organization or an invoice with missing account information.
Select this radio button to compute and post unrealized gains and losses for accounts payable.
Select this radio button to compute and post unrealized gains and losses for accounts receivable.
Select this radio button to stop the printing and/or Posting process if the system encounters an invalid account and organization.
Continue validation to see other invalid Account/Organization
Select this radio button to continue with the validation process so that the system may encounter other invalid accounts and organizations.
Continue validating and posting
Select this radio button to continue with the validation and posting process, even if the system encounters an invoice with missing account information.
Skip validating and continue posting
Select this radio button to have the system to skip the validation process and continue posting if it encounters an invoice with missing account information.
Select this radio button to have the system to stop processing invoices if it encounters an invoice with missing account information.
Post Compute/Post Unrealized Gains/Losses
Select this button on the toolbar to post unrealized gains/losses. This button is not available until you print the report.
Print and Post Compute/Post Unrealized Gains/Losses
Select this button on the toolbar to print the report and then post unrealized gains/losses.
* A red asterisk denotes a required field.
Changes to this screen update the following tables:
FS_SUM
REF_SUM
GL_DETL
AP_UNREAL_G_L_HS
AR_UNREAL_G_L_HS
OPEN_AP
AR_HDR_HS
JE_HDR
JE_TRN
LAST_JE_NO
GL_POST_SUM