Sage 100

 View Only
  • 1.  Printing Tracking Numbers on SO Invoice

    Posted 02-05-2024 09:57

    Is there a limit to the total number of UPS tracking #'s that can be displayed on the SO invoice?  See below.  The invoice has a total of five for the shipment.



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------


  • 2.  RE: Printing Tracking Numbers on SO Invoice

    Posted 02-05-2024 10:02

    You don't really get a say in the matter.  All I know for sure is the field can only hold 132 characters, and that Sage programming automatically concatenates Tracking #'s into that field up to a certain (hidden programmed) character limit.



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



  • 3.  RE: Printing Tracking Numbers on SO Invoice

    Posted 02-05-2024 10:18

    Insert a subreport with the SO_InvoiceTracking table that has the PackageNo and TrackingID fields .  Link by InvoiceNo.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 4.  RE: Printing Tracking Numbers on SO Invoice

    Posted 02-05-2024 10:20

    For that you need two sub-reports, to have consistent output when printing an invoice from History.



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



  • 5.  RE: Printing Tracking Numbers on SO Invoice

    Posted 02-05-2024 10:57

    Thanks to both of you for the quick replies and suggestions.  I will monitor the frequency of shipments exceeding three packages.  On the same but slightly different topic, any ideas on a formula to create a hyperlink to allow the user to click on the number in the PDF?



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 6.  RE: Printing Tracking Numbers on SO Invoice

    Posted 02-05-2024 11:04
    Edited by Kevin Moyes 02-05-2024 11:07

    Getting a link to work through the Paperless conversion to PDF is very limited.  AFAIK the best you can do is extract the first tracking #, then use that in a white text field that has the full URL, which becomes click-able automatically.  (If you've ever customized an APS / Repay form for click-to-pay, that is the technique).

    Edit:

    To be clear, Crystal Reports has many features for creating clickable links... but none survive the Paperless / Amyuni print driver.  (At least this was true the last time I tried).

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



  • 7.  RE: Printing Tracking Numbers on SO Invoice

    Posted 02-06-2024 08:57

    Great conversation and information.  



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------