How to link MPA, GL, and Invoice distributions in one report without duplicates?

Summary:

Duplicate Records Due to Lack of Direct Link Between MPA and GL Tables in Invoice Accounting Report

Content (please ensure you mask any confidential information):

In our current report design, both invoice distribution accounts and GL distribution accounts are being fetched.
Since there is no direct relationship between the invoice distribution lines and GL lines, they are being joined using AE_HEADER_ID or Invoice_ID, which is resulting in a cross join and causing duplicate records in the output.

We attempted to remove the invoice distribution section and instead tried linking MPA tables with GL line tables, but we found that there is