I would like to create a GI showing all the AP Invoices and AR Invoices for a custom table having a field called Housebill. I can get it to work showing only AP invoices or only AR invoices, but not both at the same time. I attached screenshots of the existing GI. Any help would be appreciated.
Answer
How to join two unrelated tables to a custom table
Best answer by Naveen Boga
Hi
But here is my suggestion, could you please change your joins like below. Since I have verified in my local instance, I cannot say 100% this will fix the issue.
Recap → Left Join → ARInvoice
ARInvoice → Inner Join → AP Invoice
+19Hi
Hi
Thanks,
Donna
+19Hi
Naveen - I have attached a XML file and the correct Word document. Here is a ‘close’ example of the end result. I want to open this GI from another GI that is a simple list of Date and HAWB. If I have a condition set in the AR AP by HAWB GI for a specific HAWB, I get immediate results. If I remove the condition, I get a time out message. Please let me know where I need to go from here.
Thank you.
+19Hi
But here is my suggestion, could you please change your joins like below. Since I have verified in my local instance, I cannot say 100% this will fix the issue.
Recap → Left Join → ARInvoice
ARInvoice → Inner Join → AP Invoice
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.