Foreign Balances History Report | General Ledger System Administration Manual

This report prints the start-of-year, end-of-year, and monthly balances for foreign accounts 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 Account.

A sample output is shown below.

                                                      Expert Computing, Inc.
11/07/94 11:35                                                                                                     LGG Page:    1
                                                 Foreign Balances History Report
=================================================================================================================================


Currency Code CANADA C. DOLLAR Canadian 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

Option 10Foreign Balances History Report