Skip to Content
0
Former Member
Oct 29, 2008 at 02:28 AM

Link JDT1 and INV1

1275 Views

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