I have found these treads interesting. I do remember when the NRMA, now called NRF, proposed the SDQ in X12 and it was not received well the first time. Then we explained how merchandisers wrote their orders on spread sheets, i.e. one item per row and the stores across the top with the individual quantity in the intersection of the row and column. They would literally spread the total order quantity across the stores. X12 finely understood; remember there were not that many people in the retail supply chain back then. Why am I telling you this?
Ken's comments that SAP seems to have heartburn with duplicate PO numbers strikes me as strange since the SDQ has been around for some time. I would think that a reasonable system would look at other attributes to determine a true duplicate. When I was with a well known manufacturer we did process spread sheet EID orders (prior to 1990). Our order processing system "keyed" off of order number so the PO was just information that we used to search on and put on response messages (ASN, Invoice, etc). Since we processed and shipped orders we broke apart the SDQ orders after translation and before input to the order processing system; that isolated both applications. This resulted in an invoice and ASN per supplier order which did cause some concerns with some retailers; however after some discussions it was relatively simple process to match received shipments with Pos. The original reason for the SDQ segment was to decrease the size of transaction for VAN costs and then current telecommunication capabilities. So I don't know how much of that is relevant in the AS2 world. I do know this if one is flexible and offer options to accommodate different needs then it adds value. Based on the original question / concern I would suggest offering two options one for spread sheet and one for single location order. Please remember a spread sheet can represent multiple ship-to locations or multiple mark-for locations. Let the business trading partners work out what formats work best for their relationship. As Forest Gump would say "that's all I have to say about that"! James D. Sykes II Argolis, Inc. 1740 Pine St. Martinez, CA 94553 [EMAIL PROTECTED] Cell: 01.510.502.3333 _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of KenCox(EDI) Sent: Tuesday, October 24, 2006 5:10 PM To: Jayne Gillette; [email protected] Subject: Re: [EDI-L] To SDQ or not SDQ... Our SAP system is configured to reject duplicate PO numbers. Also, while in theory SAP will support multi-ship-point orders, it is not a friendly thing to manage, therefore the business decision was made not to allow this. So far we only have one customer sending SDQ orders (and a low volume of these), with only two ship-points, so our solution is to have manual intervention on this one. In the past, I have dealt with customers that would send an SDQ which we split into individual orders, adding a sequence code for uniqueness (which would be stripped off on outbound documents). In that system this meant we sent an outbound Invoice and ASN for each order created in our system. Fortunately, our TPs (customers) were O.K. with this or it would have been a headache to combine those documents back into 1. Ken ----- Original Message ----- From: andrew anderson To: Jayne Gillette ; [EMAIL PROTECTED] <mailto:EDI-L%40yahoogroups.com> com Sent: Wednesday, October 18, 2006 9:17 PM Subject: Re: [EDI-L] To SDQ or not SDQ... HI Jayne, I have worked for a couple of footwear/apparel manufactuers and none of their systems could handle the same PO for different orders coming in. Once a sales order has been created from a PO and then another PO comes in with the same number trying to create a new sales order, it would go into error status. Unless your TP is using a system that was written 10 years ago and not kept up to date, it should be able to handle the SDQ with no problem. I know that SAP, Jesta IS, JD Edwards can all handle it. Andy Anderson PUMA North America Jayne Gillette <[EMAIL PROTECTED] <mailto:jgillette%40edi-partners.com> partners.com> wrote: Dear Group: Due to the upcoming implementation (next summer) of a new merchandising system, we are reviewing the current format of our 850s and 860s (as well as several other EDI documents) to determine where changes are needed. Under the current system, we issue purchase orders with a unique PO number for each ship-to location (i.e., 1 PO number = 1 ship-to location). In the new world, the same purchase order number could be used for multiple ship-to locations. We know we could change our 850 / 860 EDI format to utilize the SDQ format like this: BEG segment: PO #12345 LIN segment: Item #ABC, Total Quantity 4000 SDQ segment: Ship-to Location 1, quantity 2000; Ship-to Location 2, quantity 1500; Ship-to Location 3, quantity 500 ...but, we are hoping to minimize the impact to our EDI trading partners as much as possible, so as not to jeopardize the go-live date for the new merchandising system. Since we do not currently issue SDQ-format 850s and 860s, we are considering sending the documents in the same EDI format we send today, which for the same order described above would look like this: 850 TRANSACTION #1: ------------------------------------------------- BEG segment: PO #12345 N1 segment: Ship-to Location 1 LIN segment: Item #ABC, Quantity 2000 850 TRANSACTION #2: ------------------------------------------------- BEG segment: PO #12345 (same PO number as transaction #1) N1 segment: Ship-to Location 2 LIN segment: Item #ABC, Quantity 1500 850 TRANSACTION #3: ------------------------------------------------- BEG segment: PO #12345 (same PO number as transactions #1 and #2) N1 segment: Ship-to Location 3 LIN segment: Item #ABC, Quantity 500 The EDI format is the same as what we send today, but the difference is the same purchase order number could now appear in multiple 850s / 860s, for individual ship-to locations. We are being told we really can't consider doing this because manufacturers can't process "duplicate" PO numbers such as that described above. Based on your experience / knowledge, is it true that "duplicate" PO numbers like this will cause major problems in manufacturers' order entry / shipping / invoicing / etc. systems? As always, thanks for all your help and advice! Jayne --------------------------------- Stay in the know. Pulse on the new Yahoo.com. Check it out. [Non-text portions of this message have been removed] [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: mailto:[EMAIL PROTECTED] mailto:[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/
