RE: UPS/ FedX

[Bud Roble <BRoble@xxxxxxxxxxxxxxxxxxxxxxxxxx>]

Ted,

Here's what I used.....

Join file using MBCNREP, MBDEREP and MBALREP

MBCNREP joined to MBDEREP on   (CNAENB/DEAENB), (CNCANB/DECANB),
(CNB9CD/DEB9CD)
MBDEREP joined to MBALREP on    (DEAENB/ALAENB), (DECANB/ALCANB),
(DECUCD/ALCUCD)

Key field is CNKZNB (Pick List Number)

You may need to do something different based on your needs.    We wanted to
access the Name/Address by entering Pick List#
Be sure to build the Join Logical in a separate Library from your Mapics
file library then setup the ODBC connection for that library.    If you use
the Mapics file library, the UPS Worldship program will timeout.

Bud

 -----Original Message-----
From:   Ted Hendricks [mailto:ted.hendricks@flukebiomedical.com]
Sent:   Tuesday, May 28, 2002 8:25 AM
To:     mapics-l@midrange.com
Subject:        UPS/ FedX

Hello.  I am getting started on the task to integrate UPS worldship and
MAPICS.  I am pretty sure I understand most of the issues as mentioned in
the list.  I am curious as to what files others have used to create the join
file used by the shipping software.  Thank you in advance.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.