8 replies to this topic

[caseydockry]

I'm a technician for UPS and I'd like to integrate UPS Worldship with MOM via a FoxPro ODBC Driver. I was wondering if there is a table within MOM that contains all the ship-to information as well as a sales order number? All the information I'm looking for would most likely be contained on the packing slip - invoice: Sales order number, Customer name, Address, City, State, Zip, Shipping method (ground, next day air, 2nd day air). Is there a table that contains all this info or am I going to have to link multiple tables using Access? Thanks your time and help.

-Casey

[Videoflicks2004]

I'm a technician for UPS and I'd like to integrate UPS Worldship with MOM via a FoxPro ODBC Driver.  I was wondering if there is a table within MOM that contains all the ship-to information as well as a sales order number?  All the information I'm looking for would most likely be contained on the packing slip - invoice: Sales order number, Customer name, Address, City, State, Zip, Shipping method (ground, next day air, 2nd day air).  Is there a table that contains all this info or am I going to have to link multiple tables using Access?  Thanks your time and help.

-Casey

Hi Casey,

EXPORT.DBF is the table you are looking for. You client will have to export their invoices first then you will be able to access the data.

Cons : You will lose the data on each export.

Pros : You can map the data easily using UPS ODBC mapping utility.

Best,

Videoflicks2004

[ypf1258]

Cons : You will lose the data on each export.

David


Please explain this line

[caseydockry]

Hi Casey,

EXPORT.DBF is the table you are looking for.  You client will have to export their invoices first then you will be able to access the data.

Cons : You will lose the data on each export.

Pros : You can map the data easily using UPS ODBC mapping utility.

Best,

Videoflicks2004

The customer I am working with does not have the import / export module installed. Is there another file I could link to that would contain all the information I'm looking for?

[notehead]

If you can be more specific as to what you need. The CMS.DBF file is the order header. The CUST.DBF file contains customer info. The Box.DBF contains the shipping information by box. Based on your question you want box, linked with cust to get you the info you need. ODBC should work fine depending on how you do it.

n

[Videoflicks2004]

David
Please explain this line

Hi YPF1258,

The EXPORT.DBF table did not append the data with each export of invoices from MOM. Instead, I found that the table acted more as a temporary holding place for the current set of export material.


** Note: This is based on exporting invoices from MOM with a parameter like DATE RANGE that did not include the previous set.

IE. If I export January 10, 2005 invoices to EXPORT.DBF and then proceed to export January 11, 2005 invoices, the data from first export was marked deleted.

This is based on my personal experience with UPS and MOM 4.3

Best,

David

[steveweissmusic]

Casey,
I am presently trying to accomplish the same task of integrating MOM 5.4 with Worldship 8.0. Please keep me updated on what you find, or contact me directly at "webmaster at steveweissmusic.com". Hopefully I can work with a local UPS technician using whatever you find out.

Thanks.

[caseydockry]

notehead,

The exact information I'm looking for is everything that shows up on the invoice:
Invoice number, ShipTo Company, ShipTo Address, ShipTo City, ShipTo State, ShipTo Zip and Shipping Method (Ground, NDA, 2ND Air).

I am now able to link multiple tables within Worldship's new version 8.0. So if you could tell me what table each one of these fields is located in, I should be good to go.

Also, is there a reference document that I can download that tells me each table within MOM, and a description of the fields within these tables? That would make my life so much easier! Thanks for all your help on this!

P.S. Steve email me at "cdockry at ups.com" and I should be able to find you a local UPS Tech. to help you out.

[notehead]

SELECT cms.order, cms.custnum, cms.shipnum, cms.odr_date
FROM cms
WHERE (((cms.odr_date)=Date()));


this will give you all of today's orders. If shipnum <> 0 then shipnum is the shipto else custnum is.

you would then need a conditional join on custnum or shipnum to cunstnum in:

SELECT cust.custnum, cust.altnum, cust.custtype, cust.lastname, cust.firstname, cust.company, cust.addr, cust.addr2, cust.city, cust.county, cust.state, cust.zipcode, cust.country
FROM cust;

let me know if you need more info. Please note that this does not take into consideration using MOMs shipto by line feature.

n