I am writing a GI to show all sales order lines and any time we have created a shipment on a order that does not ship all the lines on the order the rest of the order lines are duplicated by the same number as the number of shipments we have made.
Below we have made three shipments on this sales order and the remaining line on the order shows up 3 times.
We made three shipments off of the order below. one shipment for line 1 and line two split between two shipments.
Shipments are below
In the GI i am using the following tables and Relation to get the Data requested.
I think it is somewhere in the shipment tables but on of the requests is to see the Shipment Status and i had to go to the SO Shipment to get Confirmed or Completed off of the shipment.
Best answer by travislawson
I think this is going to be a little difficult for us to solve with a quick answer. Typically the joins will cause your duplicate data. I would uncheck all of your relationships down to the top one, SOLine and SOOrder. Also undo any checks on your conditions, results, and row style that contain any of the unchecked relationship fields.
Look at the data, see if duplicates exist. If they do not, then move on to the next relationship. See which relationship creates the duplication. From that point then you’ll need to look at the DAC and determine how you can further refine the relationship parameters to give you only the data you need. Also play with the left and inner join on the relationship to see if that changes the data where it’s duplicated.
Thank you, below is the GI. in order to get the Shipment Status i joined the SOOrderShipment table to the SOLine Table then Jooin the SOShipment Table to the SOOrderShipment Table.
I am fairly new at this and i originally joined them SOShipment joined left to the SOOrderShipment table and then SOOrderShipment table joined left to the SOLine table. it did not seem to matter if i Joined left or inner the same duplication occured.
I think this is going to be a little difficult for us to solve with a quick answer. Typically the joins will cause your duplicate data. I would uncheck all of your relationships down to the top one, SOLine and SOOrder. Also undo any checks on your conditions, results, and row style that contain any of the unchecked relationship fields.
Look at the data, see if duplicates exist. If they do not, then move on to the next relationship. See which relationship creates the duplication. From that point then you’ll need to look at the DAC and determine how you can further refine the relationship parameters to give you only the data you need. Also play with the left and inner join on the relationship to see if that changes the data where it’s duplicated.
