Peter,
Epicor Custom Programming is working on our upgrade to 5.1 now. It should be
ready soon. Your program sounds very interesting, we may use it. Thad Jacobs
had a similar program, but his is for exporting entire table fields.
I created a button in Shipping Header VB Form which copies information from
Shipping Header screen into Windows Clipboard. Then it executes a Visual
Basic program which reads the Clipboard information and breaks down into
information needed and writes the data through ADO into a MDB file. Then the
packing slip is created and printed. WorldShip pulls the record from MDB
using Packing Slip #. Then I wrote browser program in Visual Basic which
views the data that WorldShip outputs after each shipment. With help of this
program we find the tracking numbers by searching the SO numbers. We have
cases when a customer wants all of their orders for that day to be shipped
in one package. We use WorldShip Reference #5 for entering all the SO#. The
browser will find those SO# also.
The problem with this is that we can only copy information which is visible
on Shipping Header screen. We wanted to include Customer notification
through UPS e-mail system I had ask custom programming to include those
fields to Shipping Header. Your program will help to get any information we
want to output. Also looking foreword to inputting the info back to Vantage.
Mike Tonoyan / MIS Manager
All American Products Co.
1135 Aviation Place
San Fernando, CA 91340
USA
Tel.: 818-361-0059 Ext.: 246
Fax 818-898-2236
E-mail: miket@...
Web: www.allamericanproducts.com
Epicor Custom Programming is working on our upgrade to 5.1 now. It should be
ready soon. Your program sounds very interesting, we may use it. Thad Jacobs
had a similar program, but his is for exporting entire table fields.
I created a button in Shipping Header VB Form which copies information from
Shipping Header screen into Windows Clipboard. Then it executes a Visual
Basic program which reads the Clipboard information and breaks down into
information needed and writes the data through ADO into a MDB file. Then the
packing slip is created and printed. WorldShip pulls the record from MDB
using Packing Slip #. Then I wrote browser program in Visual Basic which
views the data that WorldShip outputs after each shipment. With help of this
program we find the tracking numbers by searching the SO numbers. We have
cases when a customer wants all of their orders for that day to be shipped
in one package. We use WorldShip Reference #5 for entering all the SO#. The
browser will find those SO# also.
The problem with this is that we can only copy information which is visible
on Shipping Header screen. We wanted to include Customer notification
through UPS e-mail system I had ask custom programming to include those
fields to Shipping Header. Your program will help to get any information we
want to output. Also looking foreword to inputting the info back to Vantage.
Mike Tonoyan / MIS Manager
All American Products Co.
1135 Aviation Place
San Fernando, CA 91340
USA
Tel.: 818-361-0059 Ext.: 246
Fax 818-898-2236
E-mail: miket@...
Web: www.allamericanproducts.com
----- Original Message -----
From: "pile_of_34" <peter.paasch@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, June 25, 2002 6:40 AM
Subject: [Vantage] Re: UPS Tracking numbers into Vantage Database!
> Mike,
>
> In version 5.1 their is a tracking number field available. I did not
> plan for my app to work with any earlier versions since 5.1 is what
> we are on. However, we use to enter data into the log field manually
> and with a few mods to the source code you could make that work if
> you are using versions before 5.1.
>
> For your second question about when it runs. I started out with the
> app monitoring transactions in the UPS database. Then updating
> Vantage in near real-time, but for our needs one end of day batch
> update works and produced fewer headaches on the coding side. So
> it's meant to run after you transmit at the end of day. Canceled
> shipments don't get pulled over into vantage.
>
> As far a the info that is ignored we sometimes type notes or comments
> after the packing slip number # into Worldship. The config file for
> my app allows you to modify the format and number of charactors in
> the packing slip. The only stipulation is that the packing slip
> number come first in the Worldship reference field.
>
> Did I understand that you are using something to transfer the
> information already? I would be interesting in hearing more about
> what you are doing and getting more input from you.
>
> Peter Paasch
> Ace Precision Machining Corp
> http://www.aceprecision.com
> peter.paasch@...
> 262-252-4003 ext. 174
>
>
>
>
> --- In vantage@y..., "Mike Tonoyan" <miket@a...> wrote:
> > Where do you plan do save the tracking numbers in Vantage? When is
> it saving
> > the tracking number, at the end of the day or as soon as it is
> created, if
> > so, what if you cancel the shipment and reenter it with another
> tracking
> > number in WorldShip?
> > What following info is ignored?
> > We are using our version of data transfer to Worldship for a couple
> of
> > years. We had to use "P" prefix before the Packing Slip Number in
> order not
> > to confuse it with the SO #.
> > By the way UPS supplied us with Laser Scanner so we don't have to
> key in the
> > PS#'s by hand.
> >
> > Mike Tonoyan / MIS Manager
> > All American Products Co.
> > 1135 Aviation Place
> > San Fernando, CA 91340
> > USA
> > Tel.: 818-361-0059 Ext.: 246
> > Fax 818-898-2236
> > E-mail: miket@a...
> > Web: www.allamericanproducts.com
> >
> >
> > ----- Original Message -----
> > From: "pile_of_34" <peter.paasch@a...>
> > To: <vantage@y...>
> > Sent: Monday, June 24, 2002 12:27 PM
> > Subject: [Vantage] UPS Tracking numbers into Vantage Database!
> >
> >
> > > A while back I asked if anyone had a 4GL piece of code that could
> > > bring the tracking numbers from UPS WorldShip into Vantage. No
> one
> > > seemed to have one so I wrote one. I have completed a number of
> > > successful tests, but would like some input on how other vantage
> > > users would need it to work. Currently we use a Worldship
> reference
> > > field to type our packing slip number along with other information
> > > into the WorldShip database. The first 5 charactors in this field
> > > must be the packing slip number. The program ignores all the
> > > following info, and creates a Progress query and a recordset using
> > > ADO all in 4GL . Would this senario work for other vantage users?
> > >
> > > To keep this short I am looking for a list of variables I need to
> add
> > > to my config file so that the program is customizable enough for
> the
> > > majority of people to use, as well as to make changes for internal
> > > use. I have a number of them already selected, but could use a
> > > little help with the ones I haven't thought of yet.
> > >
> > > Don't worry about Variables like server name or IP address. My app
> > > uses a startup file to connect to the Vantage database, and ODBC
> to
> > > find the Worldship database.
> > >
> > > I will post source code once I add all my comments. I don't plan
> to
> > > support the program, but I will try to help out as much as
> possible.
> > >
> > > peter.paasch@a...
> > >
> > >
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > have already linked your email address to a yahoo id to enable
> access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report
> Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>