Duplicated quantities and amount when connecting sales order to sales invoice

Hi ​@dreycruz 

Because the joins in your GI are not optimized. Please attach your GI XML file.

Best Regards,

NNT

Here’s the XML file

​@dreycruz 

Can you disable this relations and check this.

Based on the tax lines in the taxes tab it shows the lines, however the GI should by review for qunatites here as well.

Hi ​@dreycruz 

I see that your GI correctly displays the data for the lines on the Invoice (ARTran). The SO Qty and SO Amount lines are correctly repeated from the original SO. However, you are using SUM to sum the SO Qty and SO Amount lines, which doesn't display the desired data.

Try joining with SOShipline and adding the column SOShipline.ShippedQty and creating a function SUM(SOShipline.ShippedQty) to replace SUM(SOline.OrderQty). Then the SO Qty column will be the quantity of the original SO used for reference.
The SO Amount column is handled similarly to the SO Qty column.

Best Regards,

NNT