I am trying to add the PO# and PO Creator to the Bills and Adjustmetns GI but am getting duplicate rows. I have added the APTran table and linked it to APInvoice. I was hoping to get the PO# from the APTran table but now I am getting duplicate rows. Any suggestions would be much appreciated!
APtran contains many rows for one bill hence why u get duplicates.
You can have multiple PO’s per bill as you can imagine, so only way is to add grouping to your inquiry which will make it run slower and put MAX for the PO number. It will become rather slow, so perhaps add a separate inquiry tan use the one they add bills from.
OR
under your join for ARInvoice to Artran only grab one line, so set LineNbr equals 1, so u just get the first line on each bill
Thank you. I used option 2 and that worked!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
