6Intercompany Processing
Option 3Intercompany Transactions Report
This report lists, by intercompany code, all transactions with non-blank intercompany codes that have been posted to the YTD Postings file. This report is used to determine all intercompany transactions os that they may be backed out when consolidated financial statements are to be produced. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the YTD Postings information, this step provides you with a default sequencing of data records by Intercompany, Intercompany Reference, Account Component, Fiscal Year, and Fiscal Month, with the option to change modifiable parameters at run time. Selection of data records is provided by Intercompany, Intercompany Reference, Account Component, Fiscal Year, and Fiscal Month, 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 Intercompany Transactions Report, this step formats the YTD Postings information. The following data items are shown: Intercompany Reference, Account, Fiscal Month Fiscal Year, Journal Code, Transaction Date, Description, Currency Code, Currency Rate, Home Amount, and Amount. As appropriate, group headings appear whenever a change occurs in Account Component.
A sample output is shown below.
Expert Computing, Inc.
11/03/94 17:12 LGG Page: 1
Intercompany Transactions Report
Fisc
Account Mo/Yr Jrnl Trx Date Description Currency Home Amount Amount
=================================================================================================================================
Intercompany 001 Expert Sales Outlet
Account 1090001000MA Finished Goods N
EY88 1090001000MA EY 88 GL 06/10/88 Inventory Entry 62449.70-
8901 1090001000MA 04 89 GL 09/30/88 Inventory Transfers at Cost 78149.56-
8902 1090001000MA 07 89 GL 12/30/88 Inventory Transfer at Cost 66582.17-
8903 1090001000MA 11 89 GL 04/30/89 Inventory Transfer at Cost 89870.25-
____________ ___________
— Account Totals —> 0.00 297051.68-
============ ============
Account 1100001001WH Resale Inventory, Sales Outlet N
EY88 1100001001MA EY 88 GL 06/10/88 Inventory Entry 62449.70
8901 1100001001MA 04 89 GL 09/30/88 Inventory Transfers at Cost 78149.56
8902 1100001001MA 07 89 GL 12/30/88 Inventory Transfer at Cost 66582.17
8903 1100001001MA 11 89 GL 04/30/89 Inventory Transfer at Cost 89870.25
____________ ___________
— Account Totals —> 0.00 297051.68
============ ============
____________ ___________
— Intercompany Totals —> 0.00 0.00
============ ============
Intercompany 002 Expert Subsidiary 1
Account 1030001000 Accts Receiv, Intercompany N
9001 1030001000 01 90 GL1 06/30/89 Inventory Sale to Subsidiary 32429.80
____________ ___________
— Account Totals —> 0.00 32429.80
============ ============
9001 1030001000MA 01 90 GL1 06/30/89 Inventory Sale to Subsidiary 32429.80-
____________ ___________
— Account Totals —> 0.00 32429.80-
============ ============
____________ ___________
— Intercompany Totals —> 0.00 0.00
============ ============