Hi everyone! New to Acumatica here, learning GIs, copying, processing, etc. I’m on my 2nd cycle through the courses, and I need to know what the following warning means:
“The correlation name 'InnerQuery_BAccountR_Customer' is specified multiple times in a FROM clause.”
I have removed, to the best of my knowledge, all traces of Relations & Conditions that would trigger this.
Any help would be appreciated.
Thanks, everyone.
Best answer by BenjaminCrisman
View original
+4
Hi
Once you join in a table as a parent relation then you can use it as a child relation further down.
Example, I have VendorR related as parent relation, then add it as a child:
Double check the relations and make sure there are no instances of something like this, otherwise I would recommend to upload a copy of the GI so we can review.
Benjamin, thanks for this.
How would I upload a copy of the GI?
+4
Export the GI to get the XML file and then upload it into the next comment
The Export button is gray, I can’t use it.
+4
+4
Would you be able to take a look at this one? Struggling with a “The correlation name 'InnerQuery_Vendor_Vendor' is specified multiple times in a FROM clause.” error
+16
Hi
I imported this to my local and saw the first line you had, had no joining tables. I removed that line and moved up the APInvoice > Vendor and it now works.
Here is also the new XML:
+4
Hi
I imported this to my local and saw the first line you had, had no joining tables. I removed that line and moved up the APInvoice > Vendor and it now works.
Wow that was a quick response! And yes, It works!
Another question, it appears I can’t use the search box on the top right. The system will automatically remove whatever I type in. What could be the issue?
+16
Hi
I imported this to my local and saw the first line you had, had no joining tables. I removed that line and moved up the APInvoice > Vendor and it now works.
Wow that was a quick response! And yes, It works!
Another question, it appears I can’t use the search box on the top right. The system will automatically remove whatever I type in. What could be the issue?
I have not seen that before. I’m not sure what could be causing that. I can look at it for you.
+16
HI
Here is the solution, Open the column configuration and add the Use in Quick Search to the columns. Click what you want to allow the system to search. I tested this and it worked because I was having the same issue that you were.
+4
HI
Here is the solution, Open the column configuration and add the Use in Quick Search to the columns. Click what you want to allow the system to search. I tested this and it worked because I was having the same issue that you were.
Perfect, that worked 😀
I’m trying to add another table now, but running into issues again. I think I need a full course on this, lol
+16
Hi
I would suggest going to the Open University and watching the videos along with going through the courses.
Here is the link if you need it:
+4
The error occurs because either you have a table in the Parent table column (left side of the join), but then further down the joins you are trying to use this table as a Child table, which can’t happen.
All the instances of using the table as a Child table need to be above any instance of it being a Parent table, with the exception being the very first join.
This is displayed in your original screenshot as well:
You can join APInvoice to any of the tables as a Parent table, except Vendor because you already used this as a Parent table
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
