wildco
Full Member
 

I love YaBB 1G - SP1!
Posts: 174
|
What I did was call UPS and Fedex and set up appointments with their system integrators. The integrators came out and actually did the work. We had to set up a DSN? on the host machine for pervasive. Then, you can use the integrating programs built into world ship and ship manager to get at the DBA database via the file.ddf file (same one used for Crystal). You then just have to know the correct filename (I believe it is BKARINV, and the ship-to fields in that file), reference them appropriately, and its off to the races. We chose to bring in the data by Sales Order Number, but any identifier could be used (P/S #, Inv #, etc). All in all, it was relatively painless and works quite well. We have not yet tried to write the tracking number back to the SO notes. This is because I don't know the file/field for the first note line in the SO. It would also require training in our office to prevent order entry from using that field ever when entering an order.
|