Thanks for all the great responses. The issue we have is that we generally only get the UPC from the customer. Since a UPC can relate to different Product ID's, we do a look-up into the ERP system from the EDI translator to get the product ID. If the UPC is bad, or the product ID is inactive, we get a null returned from the look-up. Currently we handle those errors in the translator (strip line or fix UPC) and remap.
We are thinking of sending in the UPC as the Product ID when the result is NULL. At that point, the line would get stuck in our order load process (since the UPC is not a valid Product ID) and require intervention in the ERP system. Does that seem to jive with what is best practice around the EDI ordering process? Thanks again! Thorsten ________________________________ From: Thorsten Evans <[email protected]> To: "[email protected]" <[email protected]> Sent: Tuesday, February 14, 2012 9:58 AM Subject: [EDI-L] Inactive/invalid Item on inbound order I am trying to get a feel from this group what the best business practice is around receiving and processing an inbound order that was sent with an invalid item (assuming you are the supplier). Where do you deal with the item? Translator? Staging tables? ERP? Other? How do you deal with the item? Delete the line? Change to active/valid item? Have a non-inventoried item that indicates a bad item was sent? Other? Who is responsible for fixing the item? EDI person? Other IT person? Order management person? Other? How do you notify the customer? Auto email? Return EDI doc (like 855)? Phone call? Don't notify? Other? Based on how you handle inactive items, how would you handle it differently? Thanks in advance for feedback on this. Thorsten Evans EDI Developer GMCR [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
