7Foreign Currency Processing
Option 5Foreign Balances History Report
This report prints the start-of-year, end-of-year, and monthly balances for foreign accounts in fiscal year order. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the Foreign Balances information, this step provides you with a default sequencing of data records by Currency Code, Foreign Account, and Fiscal Year, with the option to change modifiable parameters at run time. Selection of data records is provided by Currency Code, Account Component, and Fiscal Year, with the option to enter user-specified comparisons at run time.
- Step 2This disposition type is used for all standard General Ledger reports.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Foreign Balances History Report, this step formats the Foreign Balances information. The following data items are shown: Fiscal Year, SOY, Month Descriptor, Monthly Balances, and EOY. As appropriate, group headings appear whenever a change occurs in Foreign Account.
A sample output is shown below.
Expert Computing, Inc.
11/04/94 13:17 LGG Page: 1
Foreign Balances History Report
=================================================================================================================================
Currency Code CANADA Canadian Dollar C. DOLLAR .83840000
Account 1020002000 Cash, Canadian Corporate
Fiscal Year 88
SOY 0.00 Dec 0.00
Jun 0.00 Jan 0.00
Jul 0.00 Feb 0.00
Aug 0.00 Mar 0.00
Sep 0.00 Apr 0.00
Oct 0.00 May 0.00
Nov 0.00
EOY 645,925.38
Fiscal Year 89
SOY 645,925.38 Dec 1,475,597.56
Jun 659,450.15 Jan 1,593,298.83
Jul 673,384.75 Feb 1,700,795.80
Aug 959,467.21 Mar 1,762,539.07
Sep 1,156,857.41 Apr 1,859,131.31
Oct 1,287,324.04 May 1,944,521.72
Nov 1,355,297.20
EOY 1,944,521.72
Fiscal Year 90
SOY 1,944,521.72 Dec 0.00
Jun 2,003,734.27 Jan 0.00
Jul 2,074,601.53 Feb 0.00
Aug 2,074,601.53 Mar 0.00
Sep 0.00 Apr 0.00
Oct 0.00 May 0.00
Nov 0.00
EOY 0.00
Account 1020002001 Cash, Canadian Sales Outlets
Fiscal Year 88
SOY 0.00 Dec 0.00
Jun 0.00 Jan 0.00
Jul 0.00 Feb 0.00
Aug 0.00 Mar 0.00
Sep 0.00 Apr 0.00
Oct 0.00 May 0.00
Nov 0.00
EOY 450,442.28