Thanks to all who offered up suggestions (both on and off group). I'm using the DTM segments to keep the data just a bit cleaner looking as it comes in - a simpler format for non-EDI people that may need to view the data - and something that they're more accustomed to.
It truly ended up as a problem with the trading partner and they have fixed the issue on their side. And for the CONDITIONAL MAPPING suggestions - that's where I was and working with - but the particular condition I was working with can't be solved by conditional mapping. I'd need to be able to condition on the DTM 2.0 segment/element, not on the DTM 1.0 segment/element. Thanks again to all that replied. Craig Dunham EDI Coordinator Big 5 Sporting Goods --- In [email protected], "Craig Dunham" <[EMAIL PROTECTED]> wrote: > > 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! ... 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/
