To find where the error took place, look at the Transformation code.
- SendPOToAcct_USA: 850 (PO)
- trn_POAckToTP: 855 (POAck)
- trn_WhseShpOrdToTP: 940 (WSO)
- trn_WhseStkXferShpmntToTP: 943
- trn_WhseShipAdviceToDMSAsn: 945 (WSA)
- trn_ShipNoticeToTP: 856 (ASN)
Then search the required document by Data Key on VP.
The result will give you either the PO# or the SO#.
With that, you can find the rest of the order info (PO#, SO#, IN#) from SQL (see attached documents for list of helpful queries).
Add a note with the customer name, followed by the order info for each of the errors.
Next, check the error descriptions to determine the specifics.
Here are the known error messages and their fixes:
| Document # | Error Description | Cause | Solution |
| 855 | Empty Token Parameters: 637690(@POA_DOC.po_id) | Missing address segment (N03_01/ST) in PO on VP. | Add the missing segment and re-generate the 855. You can find the segment value on the 850 EDI document. |
| 2. Rejection code does not exist on POAckCodes table | POAckCode either does not exist or is misspelled. | If code does not exist, add it to the POAckCodes table. If the code is misspelled, correct the spelling on VP. Re-sent the 855. | |
| 940 | <NULL TOKEN: @VARS.EngDesc> <NULL TOKEN: CustItemIDAllPOOnly> Parameters: 9058212111CH(@VARS.TP_PartID), SK(@VARS.TP_ItemQualifier), 65291(@WSO_ITEM.itemid), 565400(@303v850h.PO_ID), SK <NULL TOKEN: CustItemIDAllPOOnly> Parameters: 9058212111CH(@VARS.TP_PartID), SK(@VARS.TP_ItemQualifier), 65291(@WSO_ITEM.itemid), 565400(@303v850h.PO_ID), UP | Cannot find 940. Usually because OF purges it and re-generates one after correcting some errors on the order. | Verify that a new 940 for the same order was generated and sent. Confirm with OF if they purged the 940 and generated a new one. If this is the case, no further action is required. |
| 943 | <NULL TOKEN: @STS_SHIPFROM.add1> | Missing Ship From information. | Ask Jen to add the missing information. Then purge the old 943, bring in the new one and send it. |
| <NULL TOKEN: SCAC> Parameters: (@STS_DOC.shipviaid) Empty Token Parameters: (@STS_DOC.shipviaid) | Missing Ship VIa ID. | Ask Jen to correct the PO, The purge the old 943, bring in the new one and send it. | |
| 945 | <NULL TOKEN: @VARS.shipvia> | Missing carrier cross-reference OR new carrier. | Create the new carrier (if necessary) and add the cross-reference to the customer. Generate the ASN and send-it. |
| <NULL TOKEN: @VARS.boxid> | Quantity shipped is 0. This means order was cancelled OR there was no stock in the warehouse. | Set 945 to complete. | |
| 856 | <NULL TOKEN: EDIPO_EDILineNoByIntItemNo> Parameters: 8006280525CH(@Trade.TP_PartID), VN(@Trade.TP_ItemCode), 01321(@LoopItemsInPack.Int_Item_No), 560664(@303v850h.PO_ID) | Wrong item number in PO in VP. Usually missing the leading 0 (i.e. 1320 instead of 01320). | Correct the item number on VP and re-send the ASN. |
| <NULL TOKEN: @OrderL.User1> | Missing ARN# segment (Amazon orders). | Send Wiptec (warehouse) an email asking them to fill in that segment and re-send us the 945. | |
| <NULL TOKEN: ShipViaCust_User5> Parameters: (@vars.Cust_SV_ID) | Failed ASN because PO was renamed (usually an added R or -1). | Remove the added characters on the PO on VP and re-send ASN. | |
| SQL Query has no data (zero rows) | Empty 945. This means either order was cancelled OR there was no stock in the warehouse. | Set 945 and ASN to complete. |
Confluence page with several error codes: https://globe-electric.atlassian.net/wiki/spaces/BIGlobe/pages/10059842/Vantage+Point+Error+Codes