Can you share the XML of your Generic Inquiry? Since you are new to Acumatica, go to the GI> Export as XML and attach it. I would be more than happy to look at it for you.
Can you share the XML of your Generic Inquiry? Since you are new to Acumatica, go to the GI> Export as XML and attach it. I would be more than happy to look at it for you.
I downloaded your xml and imported it to my demo. I see the duplicates are caused by multiple contact names being included in the results:
I updated the Relations to use Primary Contact Only and the duplicates are gone.
Please Join on second fields shown, Primary Contact only.
Laura
Hey Laura, thanks for taking the time on this...I see no duplicates now, but the query went from like 8000+ records to only 12. So now I am only showing 12 Vendors only...weird. Anything else we can do?
When we see duplicates, too many records or too few records in a GI, the cause is nearly always improper JOIN on the Relations tab. Your GI originally shows above, Left join to 1099 and Inner join to Contact.
Should the contact join be LEFT? So all records from vendor table on the left are Included, whether or not human names are attached as Contacts?
Experiment with the join types and see how it works out.
When we see duplicates, too many records or too few records in a GI, the cause is nearly always improper JOIN on the Relations tab. Your GI originally shows above, Left join to 1099 and Inner join to Contact.
Should the contact join be LEFT? So all records from vendor table on the left are Included, whether or not human names are attached as Contacts?
Experiment with the join types and see how it works out.
Laura
OK so still add the relatioship by the primarycontactID as you suggested but play with the Join then?
Yes, please try the left Join so vendors with no contacts will still appear in your list.
Thank you Laura, I think I got it down to minimum duplicates now, there are still some for some reason...I wish I could know why...but this is good enough.
If you have any more suggestions, please chime in.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.