![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/a368e426-7f25-42e9-af8c-83d1e130fba7.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/81159d06-b148-43dd-84a9-51ecdbdeb73f.png)
Hi - you are getting this because the SO is the parent of SOLine (One to many) and so if there is more than on line in the SO - you get duplicates.
Try joining the ARTan to the SOLine first - and then to the SO - that way you maintain the one to one with the ARTran - and use the SO as a ‘lookup’
Also - your join is not correct - you need to join SOLine to SO by RefNbr
Hint : Try this in a GI first - you can use the related tables feature to find how to join the tables.
Best
G
Hi
it is still the same after following all the guidance.
Hi
I’m seeing one more on this issue with the joins. Please find the details below.
Please find the screenshot for reference.
Hi
Hi Naveen,
can you please expand more on other areas that need attention?
report preview works when changes above haven’t made.
along with your suggestion above, i also added table relation for ShippedQty. throws same error.
Hi
You made join between ARTran and SOOrder but NOT ARTran and SOLine, hence you are getting that issue.
Add the SOLine with ARTran as suggested abouve and verify.
Here is the screenshot for your reference.
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.