A *duplicate unique identifier* is not possible, hence the word "unique".
Seems like you need to add another element to make your identifier truly
unique.
Ask your TP to send you a "firm code" in the PO in a data element not
currently used.
I realize this is obvious, so I must be missing something.
Lee
-----Original Message-----
From: Electronic Data Interchange Issues
[mailto:[EMAIL PROTECTED]]On Behalf Of Mary Scanlan
Sent: Wednesday, January 03, 2001 5:04 PM
To: [EMAIL PROTECTED]
Subject: Needing Advice
Our application system receives a flat file provided by translating the
EDI transaction to produce an order. A unique identifier for each line
is created using a combination of the PO #, Part Number, Shipping
Location and Ship Date. This works fine except when a customer has
multiple firms for the same part number, from the same po, for a
shipping location and has the same ship date. Because this creates a
duplicate unique identifier our application system kicks out the order
and produces an error. We manually have to add the quantities together
and refeed the order file into our application system.
I'm sure others must receive multiple ship requests and wonder how you
handle this. Do you combine them when creating a flat file from the EDI
translator, combine them when adding into application system, or do you
have another way of creating a unique identifier for your application
system?
Thanks,
Mary Scanlan
[Hello William - Thanks for the Christmas Card - I'm posting again]
=======================================================================
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
