Need to create SQL script from Gl that will provide AP and AR details in the same script
Have created a sql script from the gl_je_lines table that joins to AP table to pull invoice and supplier detail. I also have a similar script that joins the gl_je_lines table to Ar tables and pulls ar details info. I need to create a script that can pull both AP and AR detail within the same SQL script. Could this be accomplished by using a union of the two scripts or is there another solution?
Thanks
Dennis
0