EDI with Trendset
From UG
| Line 1: | Line 1: | ||
[[Category:Projects]] | [[Category:Projects]] | ||
| + | [[Category:AccMisc]] | ||
== Info == | == Info == | ||
Revision as of 15:19, 2 August 2011
Contents |
Info
- 0002996: [EDI with Trendset] .... <project>
! Please note that there are a lot of useful email communication posted into Mantis notes under 2996
Requirements
Core requirements
Core requirements are summarized in the following letter from Arden.
Letter from Tammy
From: Mowbray, Tammy M [1]
Sent: Friday, June 24, 2011 4:59 PM
To: Robert Link; Marc Selter; Philippe Delorme; Denise Guastella
Cc: Falls, Jessie
Subject: FREIGHT BILL AUDIT AND PAYMENT TRANSITION TO TRENDSET
All,
As many of you are aware, EA will be transitioning our freight bill audit and payment process to Trendset, a 3rd party freight bill payment company. We will be transitioning the business in phases and Elizabeth Arden would like for Jaguar invoices for imports, domestic inland and non Zug export (Australia, New Zealand, South Africa and Puerto Rico) to transition on 8/1/11 via EDI. Elizabeth Arden requests that Jaguar work directly with Trendset to start EDI testing immediately and the direct contact information is listed below. Trendset has also sent EDI specifications to Jaguar.
Since Jaguar is one of EA's biggest carriers and therefore will have a largest impact on this transition, I wanted to advise of a few key elements that need to be taken into consideration to ensure the transition is seamless.
1. Paper Invoices: Will continue to be sent to EA until Jaguar can complete EDI testing with Trendset and receive final approval to start from EA.
2. Inland Domestic Invoices: Will need to receive one per shipment vs current consolidated invoices (or have the two IT teams work out). EA will need to have a record of each shipment and cost per each shipment to be visible in TS, no exceptions. This is required for EA financial reporting.
3. Main reference fields: Will need Jaguar to transmit the "load number" as the bill of lading number for domestic inbound shipments, and the "ct ref. number" as the bill of lading number for both imports and exports.
4. Invoice Timing: Need invoices sent asap to avoid gaps in accrual process. Please advise how this works for each type of shipment (imports, exports and domestic inland). When will the EDI transmission be sent, at shipment time, receipt time or when?
Please advise of any questions or concerns regarding the 8/1 go live EDI date.
TRENDSET INFORMATION:
TRENDSET EDI CONTACT: Lisa Shampine at 864-297-9255, or email lisa.shampine@trendsetinc.com.
Once the EDI process starts, your contact person at Trendset for questions concerning freight payments will be Trendset Carrier Services at 864-527-4395 or carriersupport@trendsetinc.com.
Payment information is also available upon registration, on their carrier website www.trendsetcarriers.com <http://www.trendsetcarriers.com/> [^] .
Regards,
Tammy Mowbray Director of Transportation
Implementation requirements from Trendset
Implementation requirements from Trendset are very well summarized in the following letter from Lisa.
From: Lisa Shampine [2]
Sent: Wed 6/15/2011 1:58 PM
To: Alex Dobrovolsky
Subject: EDI with Elizabeth Arden
Hello from the E-Commerce team at Trendset, Inc. Trendset would like to receive EDI for our mutual client Elizabeth Arden. Attached you will find a list of valid EDI locations for Elizabeth Arden and Trendset's 210 specifications.
Receiver ID - TRN200115
Receiver ID Qualifier - ZZ
Location Code - See attached
Location Code Qualifier - ZZ (Location codes should be placed in the N104 of the shipper segment for prepaid and 3rd party shipments, and in the N104 of the consignee segment for collect shipments)
Type of invoices to be sent EDI - Prepaid, Collect, 3rd Party
If you have round trip or multi stop shipments please include those in your test files.
Segment Terminator - "~" (HEX 7E)
During testing the ISA15 should be a "T". Once approved for production it should be changed to a "P".
- All invoices transmitted during testing will not be loaded into the Trendset production database unless otherwise notified by the carrier to do so. Please continue to send paper until all testing has been completed and a production notification has been sent.
We will need the following information prior to receiving your first test file.
1. Your company's SCAC Code 2. Name and email of person to received EDI Rejection notices 3. Transmission method (VAN, FTP)
4. Will you have any multi stop invoices?
5. Your sender id and qualifier
Please let us know if you have any questions. Thanks and Have a Great Day!
Lisa Shampine
EDI Analyst
Trendset Inc
864-527-4392
lisa.shampine@trendsetinc.com<mailto:brian.adams@trendsetinc.com>
Detailed requirements
TBD
Implementation
Implementation Plan
Project Plan
See xls attached to http://ct.jaguarfreight.com/mantis/view.php?id=3042
