ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Problem importing emails to Worldship
http://www.istechforum.com/YaBB.pl?num=1458333071

Message started by David Waldmann on 03/18/16 at 13:31:11

Title: Problem importing emails to Worldship
Post by David Waldmann on 03/18/16 at 13:31:11

I am using a one-way map to pull Name, Address, Phone and Email from Evo to UPS Worldship. I initially was using the email from BKARCUST, but that is not updated any more(?) so I went to BKCMACCN. It's working but I sometimes get a strange result.

After entering the SO number in the Import Key box to pull in the data, I'll get a message like "[some number] records found for the key value [so number]. Using data from the first record found". Doesn't always happen, and the number varies - I've seen between 3 and 8.

My Primary Key is
BKAR_INV_SONUM.

I have Foreign Key Relationships of
BKARINV:BKAR_INV_CUSCOD --> BKARCUST:BKAR_CUSTCODE
BKARINV:BKAR_INV_CUSCOD --> BKCMACCN:BKCM_ACCN_CODE

I suspect it has something to do with the FKRs, as when I was first adding the BKCMACCN email I had the second FKR set as
BKARCUST:BKAR_CUSTCODE --> BKCMACCN:BKCM_ACCN_CODE
and would get that message on every SO, and then every time the number of records found was 1297(!)

The only thing I'm currently using from BKARCUST is the Telephone #. Unfortunately not all BKCMACCN records have a phone, so we can't use just that table.

Any ideas?

Title: Re: Problem importing emails to Worldship
Post by Lynn_Pantic on 03/18/16 at 20:39:38

There can be multiple BKCMACCN records per customer because you can have many contact people at a customer.

Title: Re: Problem importing emails to Worldship
Post by David Waldmann on 03/19/16 at 03:40:28

Ok, I see.

Is there a better way to get an email address into UWS?