Sage 100

Does anyone have clients using Worldship that writes back the tracking info to MAS? I believe they have to have a different ODBC connection but I could be wrong.

I think @LouisAraiza does a lot of this at the company he works at.

Yes, we've done it before using the ODBC, but if I recall the client had to have VI. Someone here can confirm, I'm sure :-) Patrick J. Anson Sage ERP Project Manager panson@bheconsulting.com T: (781) 340-5871 Ext. 345 F: (781) 340-5872 C: (315) 569-6886

We use crossware and it is excellent. Very fast.

Myron has a nice solution involving a version of SQL Express and some scripting. Though there is a fee involved, it is a very powerful solution.

This is actually a very simple thing to do. We use the UPS add-on, Crossware. When the shipper prints out the label in WorldShip the Crossware program takes over and pulls back up the Shipping Data Entry panel and writes back not only the tracking number but also comments, weight and freight and it does it very fast. We rarey have issues with it. It just runs with no issues. Note that this is NOT by ODBC. The SOTAMAS90 ODBC driver is READ ONLY. You can contact me direct if you like to discuss more. John de la Cruz at jdelacruz@ups.com can help you get in touch with the proper people at UPS and Crossware to get started.

Let me add that the best solution would be to have someone like Dan or Dawn write a BOI script. You could then have any software such as World Ship Crossware or Fed Ex Ship Manager execute the script. You could use the script on any install.

Another option is to use BOI (4.30) or Advanced Scripting in 4.40+. Dawn provided some clues how to do this. Give credit were it is due. The attached PDF illustrates a 4.30 scripint assigned to a button in Shipping Data Entry that pulls in tracking from a SQL table. The key here is that the shipping software writes shipment information to a database as shipments are processed so it can be pulled back into MAS is real-time. By clicking on the button, tracking data and freight billed can be pulled into the appropiated fields and tables. Advantages here are that this works with either Fedex or Worldship. Also you have flexibiilty of addinig ""handling"" or giving free freight depending on perhaps a UDF on the order. I have clients shipping over 500 packages per day with this method without hiccups.

For MAS 500 customers we had a temp table that the UPS software writes to upon shipment and a trigger in that temp table runs a stored procedure that writes the data to the real MAS 500 table and archives the temp table records to an archive table.