COMPUTE/POST UNREALIZED GAINS/LOSSES

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 the voucher or invoice was entered to the current daily rate (exchange rates were entered in the Exchange Rates menu). 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.

You must first run the Update Open A/P Exchange Rates or Update Open A/R Exchange Rates 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 no vouchers (in the Select Vouchers screen in Costpoint Accounts Payable) 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. 

Period To Post

Fiscal Year

Enter the fiscal year or use the drop-down box to select one.

Period

Enter the period or use the drop-down box to select one.

Subperiod

This field automatically displays the subperiod number.

Ending Date

This field automatically displays the ending date.

Journal Status

This field displays the journal status (printed or not printed).

Unrealized G/L for

Accounts Payable

Select this radio button to compute and post unrealized gains and losses for accounts payable.

Accounts Receivable

Select this radio button to compute and post unrealized gains and losses for accounts receivable.

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/Post Unrealized Gains/Losses

Select this button on the toolbar to print the report and then post unrealized gains/losses.

Table Information

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