What is link between ra_customer_Trx_all with gl_je_lines
Hi,
I want to make reconciliation report between GL and AR Sales. I fill description field with trx_number on gl_je_lines so I Use it as A link between ra_customer_trx_all and gl_lines_all. but some of data on description field is Journal Import created so I can't link it with ra_customer_trx table. I checked to Reference 5,6,7 from gl_lines_all since those 3 field filled with number, I link it to xla_distribution_links get source_distribution_id_numI to link it to RA_CUST_TRX_LINE_GL_DIST_ALL table then to ra_customer_trx_all, but it not return anything, even if they return a row, it's not the right data.