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:
Answer
How to join GLTran and ARTran tables without duplicating
Best answer by bryanb39
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.