Tracking number lookup and link to web site ship24

SOLVED

Do to the fact that iShip is no longer working, I've created an invoice tracking number script, but it is not returning the tracking number.  What am I doing wrong?

Thanks,

John

Here is the script.

'******* 1/13/2023 Tracking number lookup and link to web site ship24 *******

If oSession.CompanyCode = "ABC" Then

retval = oSession.AsObject(oSession.UI).Messagebox("""Tracking fired")

Div=""
Order=""
InvoiceNo=""
Package=""
TrackingNo=""

retVal = oBusObj.GetValue("InvoiceNo$",InvoiceNo)


msgbox "Invoice=" & Invoiceno


' **** Open Tracking Business Object *********

oTrackingBus = oSession.GetObject("SO_InvoiceTracking_bus")

if oTrackingBus<> 0 then

Set oTrackingBus = oSession.AsObject(oTrackingBus)
retval = oSession.AsObject(oSession.UI).Messagebox( "","oTrackingBus fired")

retval = oTrackingBus.SetKeyValue("InvoiceNo$",InvoicenNo)
retval = oTrackingBus.SetKeyValue("PackageNo$","0001")
retVal = oTrackingBus.SetKey()

retVal = oTrackingBus.GetValue("TrackingID$",TrackingNo)

msgbox "Invoice No = "& InvoiceNo & " Tracking No =" & TrackingNo

TrackingNo="1z91076x0362409304"        '***** testing

Link = "">www.ship24.com/tracking & TrackingNo & ""

msgbox Link

CreateObject("WScript.Shell").Run(Link)
else

retval = oSession.AsObject(oSession.UI).Messagebox( "","oTrackingBus failed")

end if


End if 'Close if not ABC company

Parents
  • 0

    I'm getting the following error at the line CreateObject("WScript.Shell").Run(Link) when running on the server.  The button is configured to Execute Script on Server.

    OLE Error Number : -2147023741
    Description :
    Language : VBScript

    Script Line : 52
    Script Column : 0

    Does anyone know why?

    Thanks

  • +1 in reply to jryals
    verified answer

    Hi everyone,

    Sage has implemented a replacement package tracking for iShip.  This new implementation is now live and is used in both Sage 100 and Sage 500.  The new implementation will now use the tracking id, to determine which carrier it belongs to and re-direct to the appropriate site.  The carriers that this will handle automatically will be USPS, UPS, Fedex, DHL, and Ontrac.  If the package id is not determined to be one of the aforementioned carriers, it will be re-directed to a google search with that package id.

    In Sage 100, this will work from any package tracking buttons (ie Shipping Entry) and for paperless emails that use the embedded tracking token [TrackingNo]

    Thanks

Reply
  • +1 in reply to jryals
    verified answer

    Hi everyone,

    Sage has implemented a replacement package tracking for iShip.  This new implementation is now live and is used in both Sage 100 and Sage 500.  The new implementation will now use the tracking id, to determine which carrier it belongs to and re-direct to the appropriate site.  The carriers that this will handle automatically will be USPS, UPS, Fedex, DHL, and Ontrac.  If the package id is not determined to be one of the aforementioned carriers, it will be re-directed to a google search with that package id.

    In Sage 100, this will work from any package tracking buttons (ie Shipping Entry) and for paperless emails that use the embedded tracking token [TrackingNo]

    Thanks

Children
No Data