How to link between General Ledger, Subledger and Receivables tables in BI Publisher
Summary:
I'm trying to add information from the Receivables tables to a General Ledger query on income when a transaction has come from the receivables ledger. But I am getting duplicate rows returned as the join with receivables aren't distinct enough, and can't work out how to fix this
Below are the SQL that I am currently using for the joins in the query, which go from the General Ledger to the Sub Ledger to Receivables. The duplicates look to be because of joining ra_customer_trx_lines_all which we need for a description field. I have also tried using tables xla_events and ra_cust_trx_line_gl_dist_all for the connection between Subledger and Receivables and get the same result
Tagged:
0