You might need to eliminate intercompany transactions at the target location before you run reports.
The Create Eliminating Entries program creates offsetting journal entries to eliminate automatic intercompany settlements that result from intercompany transactions.
The system reads the Stand Alone Elimination Specification (F1017) table to determine how to process the eliminations. The system creates the offsetting journal entries in the Account Ledger (F0911) table.
You can run this batch program in proof or final mode. In proof mode, the system prints a report that lists the journal entries but does not update the Account Ledger table.
In final mode, the system creates the journal entries in the Account Ledger table. The system prints the report if you set the corresponding processing option.
From Financial Reports (G10), choose Eliminating Entry Creation
From Eliminating Entry Creation (G1021), choose Create Eliminating Entries