Browse Ask a Question
 
Tools
Rss Categories

RedRook-ShipWorks-Only Some Orders are not Flowing into ShipWorks

Author: Jeff Burge Reference Number: AA-03081 Views: 1093 Created: 02/06/2017 04:03 PM Last Updated: 02/23/2017 11:00 AM 0 Rating/ Voters

Information

 

Only some orders are not flowing into ShipWorks

1.  Query USR_VI_PS_SHIP_IFACE to ensure that the order(s) exist in the view

SELECT * FROM USR_VI_PS_SHIP_IFACE WHERE TKT_NO = 'TICKET#'

a.       If the order does not exist the CP dealer will need to troubleshoot the SQL code of the view to determine why and correct.

b.      If the order does exist retry transferring the order by updating the last modified date on the order

UPDATE PS_DOC_HDR

SET RS_UTC_DT = GETUTCDATE()

WHERE TKT_NO = 'MISSINGORDER#'

                                                               i.      If the order still does not transfer there will need to be an escalation to engineering to perform a code trace

Info Ask a Question