Items get duplicated in the Sales Order when a shipping label is created for FedEx.

Overview

When we try to create shipping notifications and work with our FedEx client we have noticed that certain Sales Orders provide us duplicate line items and we can't track down where the duplicate line items are occurring. FedEx is receiving duplicate line items from the Sales order, but only on certain Sales Orders.

Solution

The ship manager uses a set of queries to pull the line items. It is possible the Sales Order provided FSM duplicate line items.

To solve this issue, you have to reach the FedEx support team to identify where you can change the query. Use the query below to retrieve the correct transaction information:

Select a.ITEM_CODE, a.ITEM_QTY, a.QTY_SHIP, a.AMOUNT, a.SEQUENCE, a.AMOUNT, a.X_INVOICE_ID,
 b.PT_DOC_NO, b.QTY_PICKED, c.ITEMNO, c.CUSTCHAR1 , 
 c.custchar19, 
 c.DESCRIPT,
 d.CUSTMEMO1, 
 b.SHIPPED
from X_INVOIC as a, X_PICK_TICKET as b, ITEMS as c, INVOICES as d
 Where a.ORDER_NO = d.ORDER_NO and 
 a.STATUS = d.STATUS and 
 a.X_INVOICE_ID = b.X_INVOICE_ID and
 a.ITEM_CODE = c.ITEMNO and
 b.QTY_PICKED <> '0' and 
 a.ORDER_NO ='<order_no>' and
 a.STATUS =8
order by a.SEQUENCE 

In the above query, replace <order_no> with the order number.

Testing

Updating the query will now prevent duplicated items from appearing.