Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Josh Kandiko]

We are trying to map a partner who sends in codes for the shipping agent / agent service in one value.  For instance, they would send in FGHM and we would like that to map to FedEx Ground Home Delivery and UGM would be mapped to US POSTAL Priority. 

Using Lanham’s E-Ship, we have set up the General Cross Reference table with the values for Shipping Agent Code and E-Ship Agent Service. 

We map the value to Sales Header – Ship Agent Code and that pulls in correctly.  But how would I map the same value to the Ship Agent Service?  If I put two lines with the same Segment / Element, only the last one gets mapped.

Are there recipes somewhere on how to accomplish this seemingly common task?

——————————
Josh Kandiko
Saris Cycling Group
Madison WI
——————————

[Justin Falconer]

Can you use a Conditional and store the value in 2 different fields?  I have not tried this with shipping agents but it should work.

Attached is a print screen of an element we store in more then one field using conditionals

——————————
Justin Falconer
IT Manager
Tender Corporation
Littleton NH
————————————————————————-

[Josh Kandiko]

Hi Justin,

Thanks!  That put me on the right track.  Here’s a screenshot for anyone else facing this issue.

——————————
Josh Kandiko
Saris Cycling Group
Madison WI
————————————————————————-

[Tim Lecander]

Hi Josh,

It seems you’re on the right path. I’ve done something similar for a client, where when GROUNDPOBOX is sent in FOB05, there’s a General Cross Reference entry to map this to Shipping Agent USPS, Service <whatever>. Then if the keyword GROUND is sent in FOB05, this is mapped to Shipping Agent UPS, Service GROUND, etc.

The map for FOB05 does have the conditions like Justin mentioned, mapping to the Shipping Agent and E-Ship Service respectively. Admittingly the condition doesn’t look like it does anything if it weren’t for the underlying general cross reference.

One key thing is the Cross Reference field on the General Cross References table needs to be set to “1”. This hooks into the logic to populate the fields you want. Other General Cross Reference Types are for Payment Terms, Shipment Methods, etc.

——————————
Tim Lecander
Developer
ArcherPoint Inc.
Decorah IA
————————————————————————-