ISTech Support Forum - Shipment Tracking Numbers

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 634 Gender:	Shipment Tracking Numbers 11/05/03 at 13:17:10 We often ship multiple boxes against a given Sales order. Is there any provision at this time to enter a tracking number for each box shipped against a given sales order?
Back to top	Kevin Damke Spectronics Corporation ISTECH 2004.1 7/26/13 SP1 - 20 user Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user (Prev version was 2004.1 10/24/12) (All Patches Installed as of 7/26/13) Pervasive 2000i SP4 - Crystal Reports V10 IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1919 Gender:	Re: Shipment Tracking Numbers Reply #1 - 11/05/03 at 13:53:26 Doesn't appear to be, but if you're shipping UPS, tracking a single number that is part of a multi-package shipment will find all of them.
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

kevind

Active Member

I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male

Re: Shipment Tracking Numbers
Reply #2 - 11/05/03 at 14:25:00

Thanks for the reminder David. I totally forgot about that.

I was thinking more from the standpoint of our shipping software. We use a Package called CPS. With CPS, we scan the Sales Order Barcode on the Packing list and all the shipping data is read directly from the DBA datafiles into CPS on the shipping department PC.

When the label is printed for a package, the shipping cost and tracking number data can be written back to a data table. This means that I will have x records for a given sales order when x boxes are shipped against it.

I now see that when I process this data to plug in shipping cost and tracking information, I will want to total all the shipping costs, but only use the first tracking number.

Back to top

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10

IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1919 Gender:	Re: Shipment Tracking Numbers Reply #3 - 11/12/03 at 08:20:35 Kevin, If you don't mind, a few questions - How do you like CPS? Does it integrate well with DBA? What method are you using to transfer the info? Thnaks,
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

kevind

Active Member

I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male

Re: Shipment Tracking Numbers
Reply #4 - 11/12/03 at 09:11:26

David,
CPS Works great. I use ODBC to grab all Shipping information directly from the DBA data files (This should not suprise you! Grin

.

I modified the Packing Slip report to include Barcode for the Shipper # and Sales Order #. We have a CCD Barcode reader on the CPS shipping Computer so that the Shipping people only need to scan the shipper # and Sales order number to get all the shipping info.

A couple of weeks ago, I changed CPS to access the shipping information through a View instead of directly from BKARINV. Boy, this worked great!!

This allowed me to specifiy a SELECT statement that uses IF logic to pass a ShipElert Email address to CPS.

I now have 3 ways that a Shipelert Email address is selected:

1. If an email address exists on SO Note Line #1, then it is used.
2. If an email address exists on AR Contact #5, then it is used.
3. If an email address exists on AR Contact #1, then it is used.

With this select logic, Everybody that we had an email address on started getting ShipElerts. Some of them called and said that they wanted shipElerts to go to a different address, so we enter that one in Contact #5. This still allows a specific order from a customer to use a unique email (like a drop ship request). The highest priority email address is the one in the SO Note.

Back to top

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10

IP Logged

Lenette Senior Member That's why they call it work!! Posts: 459 Gender:	Re: Shipment Tracking Numbers Reply #5 - 11/19/03 at 15:10:03 Kevin, This "CPS" sounds like what we need. Where did you get it? Was it hard to implement? Feel free to call me toll-free at 888-735-5607. Lenette
Back to top	Version: Current (always current on patches) Build - 05/21/19 T7-7iR11 Pervasive 12.00 - EVO seats 15 DC seats 5 DBA since 2002 Lenette Egan McDantim Inc Helena, Montana IP Logged

Lenette

Senior Member

That's why they call
it work!!

Posts: 459
Gender: female

Re: Shipment Tracking Numbers
Reply #6 - 11/20/03 at 08:34:31

Kevin,

I spoke with an ex-ups software tech that is now working at a manufacturing company. He indicated that UPS World Ship software (which we already have) has similar features as CPS (without the cost). Did you try UPS World Ship prior to CPS? Does anyone use UPS World Ship and DBA with a barcode scanner for importing items into UPS?

Lenette

Back to top

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana

IP Logged

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 634 Gender:	Re: Shipment Tracking Numbers Reply #7 - 11/20/03 at 11:02:37 I did not use World Ship. We have been a CPS user now for about 4 years. I would not trade this smaller company service and support for anyhing.
Back to top	Kevin Damke Spectronics Corporation ISTECH 2004.1 7/26/13 SP1 - 20 user Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user (Prev version was 2004.1 10/24/12) (All Patches Installed as of 7/26/13) Pervasive 2000i SP4 - Crystal Reports V10 IP Logged