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
...
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/
