You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!