Craig,
Why don't you use the ITD segment to ask for the dates instead of the DTM segment? That is what it was put there for. The Terms Discount Due date is ITD04 and the Terms Net Due Date is ITD06. If there is no discount you just get a Terms Net Due Date. Each Invoice gets its own Terms Discount Percent (if Applicable) in ITD03. Allan Bennett EDI Coordinator Gorilla Glue P: (513) 527-3756 F: (513) 527-5013 E: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> The Gorilla Glue Company This e-mail is intended for the sole use of the individual(s) to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. You are hereby notified that any dissemination, duplication, or distribution of this transmission by someone other than the intended addressee or its designated agent is strictly prohibited. If you receive this e-mail in error, please notify me immediately by replying to this e-mail. ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Dunham Sent: Friday, October 26, 2007 2:54 PM To: [email protected] Subject: [EDI-L] mapping question - Trusted Link i-Series - 810 invoice DTM segments Well, I've got a support request with Inovis on this question - but figured I'd hit up this knowledge base for more ideas.... Using TL-i 6.1.4 Creating the 810 Invoice map/translation format. We're a large retailer. We buy from many mfgs and suppliers. In some cases, we have a vendor that we get a discount due date AND a net due date on the invoice - i.e. 3% 40, net 41 (where we get 3% off if we pay within 40 days and the net is due on the 41st day). And in some cases, we only have a NET due date, no discount (i.e. net 60). I'm using the DTM segment to provide the due date information - with the DTM 1.0 qualifier establishing the due date in the DTM 2.0 element. For example, if a vendor is sending us a NET DUE DATE invoice, it should show as: DTM*013*20071101~ (the due date for the net invoice). If the vendor is sending us a DISCOUNT TERMS invoice, it would show as this: DTM*012*20071031~ (the due date for the discount) DTM*013*20071101~ (the due date for the net invoice). However, what if a vendor has invoices (due to different divisions and purchases of existing vendors) that we can receive both net AND discountable invoices. So, for ABC Company, we can receive invoice 123 that is just a NET 60 invoice and receive invoice 124 that is discountable 3%, 30 days, net 60. With the discount invoice, I get both segments (as above) with dates in the DTM 2.0 element. The problem, however, is that the vendor is sending both segments (as above) but the DTM 2.0 element is blank. So they're sending Me both segments/elements. My translation then populates the user file with blank data - so it's shown as 00010101 instead of the due date associated with the DTM 1.0 - 013 element. HELP! Craig Dunham EDI Coordinator Big 5 Sporting Goods [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/
