Sage 100

From an associate of mine (not a Sage 100 partner): ""Today I spoke to a customer and he has an issue with tracking UPS tracking numbers. He would like to know if there is a way for incoming tracking numbers from UPS to automatically be updated in their ERP solution. "" Are there tools to do this with Sage 100? Sorry if this is a no brainer question. I sure as heck don't know an answer.

Yes. UPS has a free interface that will do this. FedEx does, too. If the customer does only these two, the interfaces are probably enough to make smartlinc irrelevant.

Thanks Jerry! How much work is it to configure this?

You said incoming. Do you mean outgoing packages? Shipgear has an interface to ups worldship Or they can go the root of starship or smartlinc

Our experience is tracking shipping stuff OUT of Sage. If this is really tracking incoming PO's, then it doesn't do it. If it is outgoing, plan on at least a half-day coordinating with UPS and confirming it works, and training the shipping person on using it. UPS is a PITA to get their attention and follow through. FedEx seems less so.

BTW, My experience has been that Shipgear can be paid for by credits from UPS. ($1500) It definitely works better then using Worldship alone because the writebacks of freight and Tracking numbers much very easier (No VI) and is much easier to configure..

@MyronStevenson has written an interface using BOI and a SQL database to move data from MAS (address, ship method, etc) out of MAS and back into MAS (tracking #, weight, # of cartons etc) which is pretty slick. Two button clicks are required. Probably could be automated even more. It isn't that costly.

Not sure if he's attending, but this would make a good demo for MOTM.

ShipGear from V-Technologies is also a good option. It qualifies cost offset through UPS's and FedEx's CTS programs. Many of my customers get it, along with support, for free.

This is fairly easy to do for both Worldship and UPS. The VI jobs are simple to set up and UPS and FedEx people will do their end as part of their service at no charge. We import tracking numbers and freight charges from both on a regular basis. Works very well. If all you are looking for are the Tracking numbers, and if they have VI, why go to the extra expense?

We have a $1000 solution that does this - pulls tracking and/or freight cost from UPS database back to Sage during Shipping entry or Invoice entry - automatically, behind the scenes. Let me know if you'd like more info.

VI also works great - just not real time, but we have many clients that use VI to import tracking 's and freight charges at the end of day before printing/posting invoices

Done a lot of work over the years integrating UPS WS to Mas90 - very first thing to decide is ... Does the invoice get created before or after the tracking number... If the invoice gets created BEFORE the tracking# then the best you can hope to do is import tracking numbers into AR history and to effectively do this, you will need to know the Mas invoice number that goes with each tracking number. I have had success entering the invoice number into a UPS WS Reference field for later retrieval with the tracking# for the import to history process. If the invoice gets created AFTER the tracking# then other options open up. Making use of UPS WS Reference field again, this time with the SO Order number in it, I created a mod to lookup and import the tracking numbers directly into SO Invoicing at the time the user enters a Sales Order#. Might be possible to import them into the Invoices from VI, but I never tried that. Big advantage I found with this method is, with a little Crystal tweaking, being able to print the tracking numbers directly on the invoice.

Thanks all - this was useful information!

Actually one of our very own, Beth Bowers, wrote a VI job for me that does write back both Freight charges and tracking numbers to the Invoice in SO Invoice Data entry when the Invoice is created before the tracking numbers are imported. Been using very successfully for several years now.

Is that imported into AR Invoice History - or is this importing into SO invoice data entry files? I could see either way working - just curious

SO Invoice Data Entry

If there is time at MOTM conference, I can present a ""paper"" on this. Would take about 15 to 20 minutes. I willl be attending.

If you would like to sponsor an evening of drinking and dancing, we can probably give you 30 - 45 minutes......

You still think you're 30 don't you.