Hello - I am trying to join GLTran, Batch, ARInvoice and ARTran tables, but my records are duplicating. Is there a way to join these so that only 1 line per GL account appears? Here is what I have currently:
Page 1 / 1
You need to join GLTran to ARTran:
My left/right is reversed compared to yours.
Module = ‘AR’ speeds up the query, vs using a condition afterwards, these are large tables so every little bit helps.
Thank you so much! This was super helpful!!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.