help multiple data showing

[qlikmpate0]

I'm trying to create an aged trial balance as a qlikview document where for each collector display customers they are responsible for and the customers credit limit and outstanding balance across different buckets.

I have managed to get all the data but I'm seeing duplicate rows where sometimes the currency at invoice level and credit level are different, when a check the same currency I still get rows where the legal entity is missing.

this is the sql I'm working off:-

SELECT

  a.cust_account_id,

  b.cust_account_id,

  c.customer_number,

         c.customer_name,

         g.party_site_number,

         d.location,

         a.overall_credit_limit,

         d.site_use_id,

         SUM (e.amount_due_remaining) credit_balance

    FROM HZ_CUST_PROFILE_AMTS    a,

         HZ_CUST_ACCOUNTS        b,

         ar_customers            c,

         hz_cust_site_uses_all   d,

         ar_payment_schedules_all e,

         hz_cust_acct_sites_all  f,

         hz_party_sites          g

   WHERE     overall_credit_limit IS NOT NULL

         AND a.cust_account_id = b.cust_account_id

         AND b.account_number = c.customer_number

         AND a.site_use_id = d.site_use_id

         AND c.customer_id = e.customer_id

         AND d.site_use_id = e.customer_site_use_id

                  and c.customer_number = 'FR301758'

         AND d.cust_acct_site_id = f.cust_acct_site_id

         AND g.party_site_id = f.party_site_id

         AND e.org_id = 364

GROUP BY a.cust_account_id,

         b.cust_account_id,

         c.customer_name,

         c.customer_number,

         d.site_use_id,

         d.location,

         a.overall_credit_limit,

         g.party_site_number

ORDER BY CUSTOMER_NAME

can anyone help please.

I have attached my qlikview document and this is one example I only want to see the highlighted row, I think I may have a connection missing somewhere not sure where. thanks in advance.

regards

M