Emery Jensen EDI Integration
Summary
Emery Jensen Distribution is an EDI source integration in Flxpoint that connects over a custom FTP connection. It brings in three inbound EDI documents: shipments and tracking via 856, purchase order acknowledgements via 855, and invoices via 810. Configure the FTP connection plus the EDI sender/receiver qualifiers, IDs and remote folders, then build a mapping template per operation to align Emery Jensen's EDI fields with Flxpoint's.
Emery Jensen connects over a single custom FTP connection with EDI settings. Add an Emery Jensen source, choose Emery Jensen Distribution from Standard/Custom Integrations for the process you're configuring, then enter the Connection Name, FTP Protocol, Host, Port, User and Password, click Test Connection → Save Connection, and set the EDI qualifiers/IDs and remote folders before building a field mapping template.
| Field | What to enter |
|---|---|
Connection NameRequired | A name for this FTP connection. |
FTP ProtocolRequired | The FTP protocol to use, as provided by Emery Jensen. |
HostRequired | The Emery Jensen FTP server hostname. |
PortRequired | The FTP port for the connection. |
UserRequired | Your Emery Jensen FTP username. |
PasswordRequired | Your Emery Jensen FTP password. |
Outbound Remote FolderRequired | The remote folder path Flxpoint sends outbound EDI files to. |
Inbound Remote FolderRequired | The remote folder path Flxpoint reads inbound EDI files from. |
Our Sender/Receiver QualifierRequired | Your EDI qualifier, as agreed with Emery Jensen. |
Our Sender/Receiver IDRequired | Your EDI sender/receiver ID, as agreed with Emery Jensen. |
Their Sender/Receiver QualifierRequired | Emery Jensen's EDI qualifier. |
Their Sender/Receiver IDRequired | Emery Jensen's EDI sender/receiver ID. |
support@flxpoint.com.Cancellations depend on the ACK code
R4 cancels line items. If all items are cancelled the order is treated as fully cancelled; if only some are, Flxpoint marks it a partial cancellation.
Unknown ACK codes default to Acknowledged
If an 855 carries a status code beyond the common ones, Flxpoint defaults it to Acknowledged so orders keep processing: review acks to catch silent changes.
FTPS 534 error has a fix
For secure FTPS connections that return 534 Policy requires SSL, enable Use Unbuffered Private Data Channel in Advanced Settings.
Qualifiers and IDs must match on both sides
Get Shipments, Acks, and Invoices each need the correct Our/Their Sender/Receiver Qualifier and ID plus inbound/outbound folders, or files will not exchange.
Downloads EDI 810 invoice files from Emery Jensen and creates Flxpoint invoices.
| Field | Maps To: Notes |
|---|---|
| Total Amount | → Invoice → Total Cost. Required. Read from the EDI invoice summary (implied 2-decimal amount). |
| vendorsNumber | → Invoice Item → Product Match (Vendor Item Number). Configured via your mapping template. |
| upc | → Invoice Item → Product Match (UPC). Configured via your mapping template. |
| quantity | → Invoice Item → Quantity. Configured via your mapping template. |
| unitPrice | → Invoice Item → Unit Cost. Configured via your mapping template. |
| unitMeasurementCode | → Invoice Item → Unit of Measure. Configured via your mapping template. |
| Line Item Charges | → Invoice Item → Cost / Title / Item Type. Additional charge lines (e.g. freight) from the invoice summary, added as extra invoice items. |
Downloads EDI 856 shipment files from Emery Jensen - tracking and ship confirmations - into Flxpoint.
| Field | Maps To: Notes |
|---|---|
| itemNumber | → Shipment Item → Product Match. Required. Read from the LIN03 element. Emery Jensen must send it with a VN (vendor part number) or UP (UPC) qualifier in LIN02; lines carrying any other qualifier are skipped. |
| quantity | → Shipment Item → Quantity. Required. Read from SN102. Only lines with EA (each) in SN103 are imported. |
| unitMeasurementCode | → Shipment Item → Unit of Measure. Always EA for Emery Jensen. |
| trackingNumber | → Shipment → Tracking Number. Read from REF02 where REF01 is 2I, at shipment level and per item when the item loop carries its own reference. |
| Ship date | → Shipment → Shipped At. Read from the DTM segment with qualifier 011. |
Flxpoint only reads a shipment loop when the 856 marks it as a shipment (HL03 = S) and the carrier detail is present (TD502 = 2). Shipments that do not meet both conditions are ignored, so a file that looks delivered but imports nothing is usually missing one of them.
Downloads EDI 855 purchase-order acknowledgements confirming how Emery Jensen will act on each order.
| Field | Maps To: Notes |
|---|---|
| acceptanceCode | → Acknowledgement Item → Status. Required. Read from ACK01. R4 cancels the line item; unknown codes default to Acknowledged. |
| quantity | → Acknowledgement Item → Quantity. Required. Read from ACK02, the quantity Emery Jensen confirms for that line. |
| vendorsPartNumber | → Order Item → Product Match (Vendor Item Number). Used when the line identifier carries the VN qualifier. |
| customerPartNumber | → Order Item → Product Match (Customer Item Number). Used on the IN qualifier. |
| upc | → Order Item → Product Match (UPC). Used on the UP qualifier. |
| Purchase Order Number | → Acknowledgement → Purchase Order. Required. Read from the BAK segment and used to match the acknowledgement back to the originating fulfillment request. |
| Acknowledgement date | → Acknowledgement → Acknowledged At. Read from the BAK segment in yyyyMMdd format. |