Hello, is there a way to prevent duplicated quantities and amounts for items that are shipped and invoiced multiple times? This is for a single sales order that is invoiced multiple times due to split deliveries.
Solved
Duplicated quantities and amount when connecting sales order to sales invoice
Best answer by nhatnghetinh
Hi
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
+15Hi
Because the joins in your GI are not optimized. Please attach your GI XML file.
Best Regards,
NNT
Translate
Hi
Because the joins in your GI are not optimized. Please attach your GI XML file.
Best Regards,
NNT
Here’s the XML file
Translate
+16
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.
Translate
+15Hi
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
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.