SL 2011/2015 Duplicate EDI 850

(0) Share

Report

Posted on by Mark E

6,431

Running into situations where a trading partner has sent duplicate 850 documents (on different dates). Using eCommerce Connector (EDI Gateway), the first one gets picked up and correctly processed to a Sales Order. The second 850 is not being seen as a duplicate EDI PO, and also creates a new Sales Order, causing issues with potential over commitment of products and shipments.

Does the eCommerce module not have the ability to identify potential duplicate 850's and not process the second one as a Sales Order?

*This post is locked for comments

All responses (2)

Answers (0)

Lus 5 on at

Like (0)

Report

RE: SL 2011/2015 Duplicate EDI 850

Is the following stored procedure (ED850Header_DupeChk) placed in the database by default? Are there other similar procedures for the 830's and 862'?
Mark E 6,431 on at

Like (1)

Report

RE: SL 2011/2015 Duplicate EDI 850

In reviewing this in more detail, there is a proc (ED850Header_DupeChk) that executes during the "Process Inbound EDI Purchase Orders" (44.400.00) screen. It checks on the fields CpnyID, PONbr, GSNbr, STNbr, and ISANbr. In my cases where the PONbr was the same, the GSNbr, STNbr and ISANbr fields were different, so it allowed the EDI PO to be imported. These EDI PO's were indeed duplicates (one PO even showed 07 as the Purpose Code, which is defined as Duplicate). Not sure the rationale behind validating on the additional GSNbr, STNbr, and ISANbr fields. Not sure of the best way to identify to the user that these EDI PO's are potential duplicates, and to evaluate before importing to a Sales Order.

I guess I could put some warning or notation on the EDI PO Received report, and hope the user picks up on it. Any help on how to better evaluate potential duplicates would be helpful.