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.
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 ,
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
order by a.SEQUENCE
In the above query, replace
<order_no> with the order number.
Updating the query will now prevent duplicated items from appearing.
Please sign in to leave a comment.