Steven, You don't say what mapping software you are using.
When I ran into a problem like this, I created a multi-dimensioned array to store the quantities, UPC, UOM, price, etc., then unspooled the array to create the target file. I was using a very powerful mapper called Delta, supplied by Softshare, Inc. If your mapping software has the ability to create arrays, this may be helpful. If your PO1 are truly unwanted duplicates, you could check the array to see of the UPC has already been used, and if so suppress creation of the line. If your PO1s are multiple lines that should be added together, then simply accumulate the amounts in the quantity bucket of the array for each UPC. <Shameless_sales_pitch>If your mapping software can't do this, call me - you need new software. </Shameless_sales_pitch> Art Douglas Chief Consultant Blackwater Network 877-464-8915 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Bell Sent: Friday, April 06, 2007 10:19 AM To: [email protected] Subject: [EDI-L] SDQ Orders and repeating PO1 Segment We have a customer that sends in the SDQ segments for each distibution center. With that there is a duplicate PO1 segment written out with the same data (UPC). Our internal system can not handle duplicate UPCs on the same order. Is there a to write out the first PO1 and not write out the second and third PO1 segments if they repeat the same UPCs? If any one wants to contact me directly please do so. I have an example of the data if this scenario was not clear... Thanks, Steve ... 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/
