Sage 100

 View Only

  • 1.  Shipping in the UK

    Posted 07-23-2020 16:16
    Not really hopeful about this one but thought I'd ask anyway. Customer has a warehouse in the UK and uses Sage100 here in the USA via remote desktop. They want to do a simple integration with the UK shipping carrier. Doesn't need to be as complicated as Starship. A simple back and forth of shipping addresses and tracking numbers would suffice. I did something for them with VI but they are saying it's too many steps and too cumbersome and want something more integrated into Shipping Data Entry. I called Starship but they are saying they can't do it. They don't support integration with UK carriers. Maybe someone wrote a script or knows of something out there. TIA.

    ------------------------------
    Kenny Daniel
    Technoclarity, Inc.
    ------------------------------


  • 2.  RE: Shipping in the UK

    Posted 07-23-2020 16:27
    For Canadian carriers the query of addresses can be by ODBC (depending on what the shipping software can do), then a day end file is exported by the shipping software, then used to import tracking #'s... The complicated part is when the shipping software only has the SO#, not the invoice #, but a script can help with that (ODBC query to look up the invoice number for that date / SO#, and add it to the file) before the VI import.​
    If the shipping software has ODBC data, you might be able to query the tracking information in a button script, but we have not seen that as a possibility.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Shipping in the UK

    Posted 07-23-2020 17:07
    Thank you @Kevin Moyes. What makes it even harder is they are using the web version of the shippers software. I don't know if they have a desktop version. I'll have to check into that and possibly use an ODBC connection. Currently they trigger VI after each order is entered into Shipping Data Entry, then their web software grabs the file and creates a label and exports a file back. They then trigger an import to bring in the tracking and freight. Sounds simple but all that takes about 3 or 4 minutes per order.   ​

    ------------------------------
    Kenny Daniel
    Technoclarity, Inc.
    ------------------------------

    Original Message


  • 4.  RE: Shipping in the UK

    Posted 07-23-2020 17:23
    You could probably create a PreWrite script that auto-creates a CSV for you.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content