Hi,
I try to link JDT1 and INV1 in Query through OINV. However, there was some duplication due to one more one more join. There seems no direct linkage between JDT1 and INV1. Is there anyway that can eliminate the duplication? I would like to create a table account code and amount of JDT1 and the sum the quantity by referring to INV1. I have added Account=AcctCode but there still a few duplication.
Can you advise?
Thanks.
Raymond