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.
How to join two unrelated tables to a custom table
Hi
2020 R2 20.217.0022
Hi
Thanks,
Donna
Hi
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.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/b4f0e4d8-5218-4df1-8224-260ca5aa0f44.png)
Thank you.
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
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/2d757aa5-5fad-4cba-b85e-0335f327e69b.png)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.