In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions GI Duplicate Lines
Generally speaking, when I try to create/modify a GI to get line level detail I am always running into the GI populating duplicate results. Is there a general cause for this or does it vary by GI. Just trying to learn how to correct these types of issues and if there is a common root cause to look into first. As an example below is the Receipt and the PO Receipt by Item GI. You can see the "Pallet" line is listed 9 times for this receipt number.
Duplicate lines have to do with what you have on the RELATIONS tab. I see <SPLIT> in the Location column which should mean there are multiple lines in the LINE DETAILS area. So, I would guess that you're pulling data out of the LINE DETAILS area.
your join to aptran is wrong
you need to join it to the poreceiptline not the poreceipt
this will give you the joins necessary in the outgoing references