Docstoc

PRECISION

Document Sample
PRECISION Powered By Docstoc
					           PRECISION 2009 TMS



          Net Change Guide
TMS Service Pack – S31



                    PRECISION 2009

                       October 2010
2       PRECISION — TMS Service Pack S31




Document Control

Conformance Standard
This Statement has three levels of conformance represented by the words:
      Must / shall / will:
      Denotes mandatory requirements.
      Should:
      Denotes requirements, which are preferred but may be waived by Precision, with good reason.
      May:
      Denotes requirements, which are considered useful, but are not mandatory and may be waived with
      discretion.

Change Control
This document is the responsibility of the Precision Project Manager. Prior to the approved release, requests
for change are sent to the Author via the Microsoft Document review process. They are reviewed and either
accepted or rejected by the author. It is subject to formal change control after the initial approved release (i.e.:
version 1.0), and agreed changes are recorded in the Change Summary Section of the document.

Issue Control
Issue     Date      Author    Changes Made




Cross Reference



Abbreviations Used
PRECISION / PSL: Precision Software, a division of QAD Inc.
PEM: Package Exception Management

Change Summary
Change Date             Author                   Changes Made
0.1                     Jack Moloney             Initial Draft
0.2                     Jack Moloney             Revisions prior to release

 2010 Precision Software, a division of QAD Inc.
Precision Software products are copyrighted and all rights are reserved by Precision Software, a division of QAD Inc.
 This document is copyrighted and all rights are reserved. No part of this document may be reproduced, transmitted, adapted,
translated or electronically stored without the prior written consent of Precision Software, a division of QAD Inc.
Progress  is a registered trademark of Progress Software Corporation.
                                                                                                                                        Document Control                              3


                                                                                                                                                                   Contents
Document Control ..............................................................................................................................................2
  Conformance Standard .................................................................................................................................................... 2
  Change Control ............................................................................................................................................................... 2
  Issue Control ................................................................................................................................................................... 2
  Cross Reference .............................................................................................................................................................. 2
  Abbreviations Used ......................................................................................................................................................... 2
  Change Summary ............................................................................................................................................................ 2

Introduction ........................................................................................................................................................5

Application Enhancements ...............................................................................................................................6
  Black Box – Structure, Logging and Performance.......................................................................................................... 6
  Black Box – CreateShipmentBasic message ................................................................................................................... 6
  Black Box – CreateShipment / ShipShipment message .................................................................................................. 6
  Black Box – ConsolidateShipments message ................................................................................................................. 7
  Black Box – ProcessShipmentLines message ................................................................................................................. 7
  Black Box – ProcessShipment message .......................................................................................................................... 7
  Black Box – ProcessSPSResponse message ................................................................................................................... 7
  Black Box – Additional Changes .................................................................................................................................... 8
  End of Day Screen (SPSEOD) ........................................................................................................................................ 8
  Hazardous Materials ....................................................................................................................................................... 9
  LTL – Check Digits Added ............................................................................................................................................. 9
  Rate and Transit Time Maintenance – Fixes and Modifications ..................................................................................... 9
  Rating Screen (Windows) – Fixes and Modifications..................................................................................................... 9
  Routing Guide – Modifications and Fixes ...................................................................................................................... 9
  Shipping Process – Modifications and Fixes ................................................................................................................ 10
  Manual Shipment Creation – Modifications and Fixes ................................................................................................. 11

Technical Enhancements ................................................................................................................................11

Carrier Specific .................................................................................................................................................12
  Bear Tracks (Star Receiver) (First Mile / Last Mile Tracking) ..................................................................................... 12
  Calberson ...................................................................................................................................................................... 12
  Chronopost .................................................................................................................................................................... 12
  Chrono Expres .............................................................................................................................................................. 13
  Ciblex ............................................................................................................................................................................ 13
  City Link ....................................................................................................................................................................... 13
  Dachser ......................................................................................................................................................................... 13
  Danish Post (Post Danmark) ......................................................................................................................................... 14
  DB Schenker (formerly BAX Global) .......................................................................................................................... 14
  DHL – Express (CA Origin) ......................................................................................................................................... 14
  DHL – Express (SAS Version) (US Origin) ................................................................................................................. 14
  DHL – Day Definite (non-US) ...................................................................................................................................... 15
  DHL – Time Definite (non-US) .................................................................................................................................... 16
  DHL – Securicor (UK) .................................................................................................................................................. 17
  DPD .............................................................................................................................................................................. 17
  DSV (formerly Frans Mass) .......................................................................................................................................... 17
  FedEx ............................................................................................................................................................................ 18
  Geodis ........................................................................................................................................................................... 18
  GLS ............................................................................................................................................................................... 18
  Jetpak ............................................................................................................................................................................ 19
  Kiala .............................................................................................................................................................................. 19
  Mory Group .................................................................................................................................................................. 19
  Movianto (formerly Healthcare Logistics) .................................................................................................................... 19
  No Limit ........................................................................................................................................................................ 19
4     PRECISION — TMS Service Pack S31


    Parcelforce .................................................................................................................................................................... 20
    Parceline (and Parceline DPD)...................................................................................................................................... 20
    Purolator (Legacy – US origin) ..................................................................................................................................... 20
    Purolator (New World – CA origin) ............................................................................................................................. 20
    Royal Mail .................................................................................................................................................................... 20
    Swedish Post (Posten) ................................................................................................................................................... 20
    TNT – Express Label and Unicom................................................................................................................................ 21
    TNT – Express Manager version .................................................................................................................................. 21
    TNT – iConnections version ......................................................................................................................................... 21
    TNT Express – France Domestic (formerly called Jet Services) .................................................................................. 22
    TNT Innight .................................................................................................................................................................. 22
    Trans-o-flex................................................................................................................................................................... 22
    UPS ............................................................................................................................................................................... 22
    UPS-SCS (formerly Menlo Forwarding and Emery Forwarding)................................................................................. 24
    USPS ............................................................................................................................................................................. 24
    Wim Bosman ................................................................................................................................................................ 25
                                                                                  Introduction       5


Introduction
This document contains information on the changes between PRECISION TMS Service Pack #S30 (initial
release) and between PRECISION TMS Service Pack #S31
6   PRECISION — TMS Service Pack S31




Application Enhancements


Black Box – Structure, Logging and Performance


       Additional audit functionality added to black-box create shipment program to narrow down any
        possible issues at the time of shipment creation etc. Improve error-capturing during the generation of
        email for black-box response messages, in case particular records are not available for use. For more
        information see:
        Black Box Guide - 808 - Black Box Auditing, Debugging and Performance Tracking.doc



Black Box – CreateShipmentBasic message


       New message type added to the set of supported Black-box messages. This message is the same as a
        CreateShipment message, but it does not initiate the rules or routing guide functionality. For more
        information see:
        Black Box Guide - 214 - Message Overview - ProcessShipmentLines.doc



Black Box – CreateShipment / ShipShipment message


       Additional fields NetWeight and NetNetWeight added to the PackWeight section within the
        Package section. If these fields are not present, then the NetWeight is derived as the Gross Weight
        minus the Tare Weight


       Additional supported party types handled within the Party section
        For more information, see: Black Box Guide - 901 - Message Field Lookups.xls


       Only update XMSITM0.SIAPWTVL (apply weight/volume against) based on the XMPROD0
        record value if the field is already blank. The process was not setting dimensions on items correctly -
        was incorrectly always taking defaults from the PR master record


    
                                                                         Application Enhancements                7


Black Box – ConsolidateShipments message


     Correctly find the group/batch record of the consolidation for shipments (i.e. correct the transaction
      type to use for the search)


     Prevent child shipments from being consolidated twice onto the same shipment



Black Box – ProcessShipmentLines message


     New message type added to the set of supported Black-box messages. This allows the addition /
      deletion / updating of shipment item lines. For more information see:
      Black Box Guide - 214 - Message Overview - ProcessShipmentLines.doc



Black Box – ProcessShipment message


     Added new action ROUTE-ASSIGN to the list of supported actions. This allows a service to be
      assigned to a shipment, using the Routing Assignment functionality, via an action run against an
      existing shipment. For more information, see:
      Black Box Guide - 208 - Message Overview - ProcessShipment.doc


     Correct the usage of the locale for this message (i.e. ensure that it picks up the locale correctly from
      the message input)

Black Box – ProcessSPSResponse message


     Additional field “CarrierRatedStatus” to return the status of the shipment (“Pending”, “Rating”,
      “Interim”, “Rated”, “Posted”)


     Ensure that GlobalCarrierCode and Errors (if any) are returned for QueryShipment message


  For more information see: Black Box Guide - 320 - Message Fields - ProcessSPSResponse.xls
8   PRECISION — TMS Service Pack S31


Black Box – Additional Changes


       Improve the database locking for the LASTPACKNUMBER system value usage, to ensure that
        concurrent processes do not lock the system value


       By default when a shipment is created through the black-box process, the workflow tasks are all reset.
        It may be a requirement by some customers to not reset the workflow tasks.
    Key:        BLACK BOX: RESET WF TASKS
    Value:      NO


       The determination of whether or not Workflow Tasks can be run through the Black-Box process
        during the creation of a shipment has been extended from the “BLACK BOX: RUN WORKFLOW
        TASKS” system value. This can now be overridden by the new system value:
    Key:        BLACK BOX: WF: " + [Shipment Workflow] + "," + [Shipment Transaction Type]
    Value:      YES or NO


       Calculated volume for a pack should only be added once to the overall volume total - if it takes its
        value based on the pack dimensions. Otherwise an incorrect overall volume total was being calculated


       Correction to a mismatch parameter issue in the call to XTRTLKUP.I procedure
        (proc_read_charge_breakdown)


       Allow that a black-box ProcessShipment (or action) which calls a Workflow Task, may now indicate
        that this "task" is the only task to be run (i.e. don't run this task and subsequent tasks). The workflow
        task run will effectively be treated as a "break"task. This is configured by prefixing the workflow
        parameter value in the XML message with "*BREAK"


        Also added a fix to xtwfdotk.r which was called with loop input parameter value of TRUE and the
        process was executing the tasks in the loop twice, once by xtwfdotk.r and second by the xtwfshtk.i
        /xtbbshwf.p.



End of Day Screen (SPSEOD)


       Allow for searching using the shipment reference on the SPSEOD screen to find the applicable batch
        with the shipment attached to it
                                                                          Application Enhancements              9




Hazardous Materials


       If the UNSUBR (subrisk) is filled, but the UNSINO field is not, then allow the Sub Risk field to be
        printed (previously it was dependent on a value being present in the UNSINO field)


       Gather information correctly for Extended Packs - drill down through the child packs to get the
        hazardous materials information for the parent packs

LTL – Check Digits Added
No new additions in this version


For full list of supported LTL check digits, see:
Topic 045 - Supported TL-LTL Carriers.xls



Rate and Transit Time Maintenance – Fixes and Modifications


       Fix to the LTLRTS2 option: If the To country was not filled, then the upload was incorrectly
        defaulting the value of the country from the From postal data instead of the To postal data


       Do not allow Czar Lite rate structures to be updated via RM screen




Rating Screen (Windows) – Fixes and Modifications


       Correction to issue on rating screen re. showing the Accessorial as in use, when "In Use" is set as a
        default and the shipment has already been rated with the accessorial switched off (i.e. should only
        show the "In Use" default when the shipment not yet rated)




Routing Guide – Modifications and Fixes
10       PRECISION — TMS Service Pack S31


         Allow for a new Routing Assignment type on the following basis:
              -    First try to assign the cheapest service that can be delivered within the required delivery date,
              -    Otherwise try to assign the fastest service if there is no cheapest service within the required
                   delivery date


         Add a "view" button to the FRROUT screen, and add permissions functionality to allow users to be
          restricted to add/delete/update functionality


         Routing guide to consider the "SPSNONSHIP" days fully when trying to determine the potential ship
          date. Rather than simply setting the next potential ship date as the next available transit day, also take
          account of whether it's a pickup day (i.e. that it's not a non-ship day)


         Routing rule determination issue due to volume criteria not picked up correctly (need to convert
          UOMs consistently for volume)


          For more information, see:
          Topic040 - Routing Guide and Rate Shopping.doc




Shipping Process – Modifications and Fixes


         Allow that for some carriers, we don't want to create XMBKTS0 records (i.e. the records that make
          shipments eligible for EOD processing). For carriers where EOD will never be run, we can switch off
          their creation of these records using:
          Category:        SPS
          Key:             [global carrier]: DONT CREATE XMBKTS0
          Value:           YES
          This will reduce the number of XMBKTS0 records in the system - which might otherwise slow down
          the EOD process if there's an accumulation of unused XMBKTS0 records


         When EOD has been run already for a carrier for a packing location, we may required to not run any
          further EODs for that carrier for that day - so we need to process all further shipments for this day as
          "future-date" shipments (i.e. for the next day).
          This is managed through the following system value
          Category:        SPS
                                                                      Technical Enhancements               11


      Key:            EOD: SINGLE CLOSEOUT - [packing location]
      (if it doesn't exist, then checks for more generic version of the system value "EOD: SINGLE
      CLOSEOUT")
      Value:          Comma-seperated list of applicable carriers (or ALL, for to indicate that all
                      carriers are applicable)


     Check for AES references that begin "NO" (as in "NOEEI") to ensure these AES types are accounted
      for within the mappings to carriers


     Addition of system value to block particular COD payment methods for a carrier
      Key:            [Global Carrier]: [internal id] - COD PAY DENY
      Value           Comma-seperated list of COD payment methods not allowed


     Ensure that the numeric/date format is American/DMY when storing the transit time information on
      the shipment - this is for consistency across the underlying engines, despite the user session formats


     Allow that EOD buttons/options may be specific to a packing location


      Key:            [Global Carrier]: CARRIER OPTION xx – [pack location]
      Takes precedence over:
      Key:            [Global Carrier]: CARRIER OPTION xx




Manual Shipment Creation – Modifications and Fixes


     Manual shipment create programs modified to allow that if the address is not updated per a selected
      partner code on the screen, then the partner address overrides (XMSNAM0) records are not created.




Technical Enhancements

     Improve performance of black-box message processing by adding further indexes to each of the temp-
      tables used in the black-box programs. Review each of the FIND and FOR EACH statements used
12       PRECISION — TMS Service Pack S31


          against these temp-tables, and also against database tables, to ensure the best possible indexing is
          used


         The EODTRK option now has a fixed text in the URL link for tracking link, as blank text can present
          issues on the receiving end of the email




Carrier Specific

Bear Tracks (Star Receiver) (First Mile / Last Mile Tracking)



Calberson




         Calberson allows for Fixed Date delivery restriction on services - user has to enter a Required
          Delivery Start Date when "Restricted Delivery" is chosen


         New service added - COURSE service. Requires an XML of the RT record and configured rates for
          to enable this service



Chronopost




         Allow separate charge table per service. The CHAxxxxDEX service is no longer applicable


         Correction to check digit algorithm call for tracking number generation
                                                                                      Carrier Specific      13


Chrono Expres




Ciblex




      Addition of +1 and +2 day services (i.e. services with +1 and +2 day delivery after the dispatch).
       These are contract-based services. Configuration request would be required to implement this new
       functionality



City Link




      Allow for integration with City Link’s XTend application



Dachser




      Correct the underline beneath the city name on the label


      Output Special Instructions in the PLD file through “ZU” text type (if configured through system
       value to do so) (optional)
14       PRECISION — TMS Service Pack S31


         Depending on length of tracking number prefix, determine if the maximum tracking number has been
          reached.




Danish Post (Post Danmark)




DB Schenker (formerly BAX Global)




         Charges were not appearing for some shipment transactions as the DB Schenker back-end server
          returns zero rates for Door to Door service. Program changed to pick up the next available service that
          returns charges


         DB Schenker back-end has a limitation of 3 packages for the number of package dimensions that can
          be passed in through the interface for the PickupRequest message. Modification made to not map
          dimensions if the number of packages exceeds 3. The dimensions are still passed for the RateQuote
          portion, so the rates should be calculated ok.




DHL – Express (CA Origin)




         New carrier integration available



DHL – Express (SAS Version) (US Origin)
                                                                                        Carrier Specific    15




      Send only valid characters in the end-of-day file. Also correct usage of carriage-return/linefeed issue
       reported from some sites for EOD file transmission


      AES airport code and flight determination not fully correct
       Note: This requires data-fix also (needs to use DHL SAS routing data from Q3, 2010 onwards)


      Allow for international services for DHL US origin to have transit times based on the ship day and
       the service (doc vs non-doc). PSL file generated based on transit time info provided from DHL


      Allow the description output on the package label to be specific to the package (not to the shipment)


      For Third Party shipping, if user enters 95 or 96 account, then recommend Import Express. For the
       Import Express payment type, force the 95 or 96 account to be present


      Transport Collect Payor Controlled payment method will be blocked during validation from Jan 2011


      Transport Collect Shipper Controlled and COD now removed from payment methods for this carrier


      Allow for a fuel percentage to be held within TH option, outside of the DHL rating structure, to
       override the DHL rating structure’s fuel value.




DHL – Day Definite (non-US)




      Allow rate-per weights, where it's "chunks" of weights - e.g. rate-per-50Kg
16       PRECISION — TMS Service Pack S31


         For Benelux countries, description of service is “EUROPLUS” not “ECONOMY SELECT”


         Output the recipient phone number after the contact name on the label


         Avoid duplication of label in multi-piece shipments when printing PDF version of label


         Use different product code value, per request from DHL, for shipping from NL to Germany


         If short of space on the label for Ship To address, then combine city and country name onto single
          line


         Create PLD file per Collect account number (if applicable)



DHL – Time Definite (non-US)




         Correct the process for finding IATA codes when the postcode for GB destinations is less than 5
          characters long. Previously it was not finding a record for these short postcodes


         Do not output the customs value for child BBX shipments


         DHL detailed manifest to round weights to nearest 0.5 Kg for European origin (not nearest 1 Kg)


         Allow DHL TD / DD to FTP the file to a "build" directory first before moving the file from "build" to
          "work" directory. This is enabled by a system value, when required (provided as content from the
          TMS Content group)


         Allow the Dry Ice information to print for Domestic shipments also


         Allow for Philippines origin shipping and Dubai origin shipping
                                                                                       Carrier Specific      17


     Allow CIF as a valid Terms of Trade (do not block this during the validation of field mapping)


     Allow for rating zone to be determined by city (previously was only for country or country + IATA)


     Round the weights to nearest 0.5 Kg instead of 1 Kg on the manifest, when non-US origin



DHL – Securicor (UK)




     Correct the "date" code in the routing barcode and text - should be 2 digits instead of 1. Also, the
      handling text needs to be display in all instance (was being omitted if the features code was "000")


     Pickup number has a maximum of 999 – if this is reached, then reset back to zero



DPD




     Allow the DPD PLD file to be copied to a “poll” directory – this will allow the file to be seen with the
      same naming convention that was used in the FTP process.


     Allow the calculation of a DPD island surcharge, if available (requires a content request to enable
      this)



DSV (formerly Frans Mass)
18       PRECISION — TMS Service Pack S31


FedEx




         Performance improvements for large multi-pack shipments for FedEx carrier - to reduce the length of
          time it takes to load pack-related information and run the printing process


         Allow FedEx Priority Alert to be set as an "Accessorial" on the Surcharges tab, instead of a virtual
          field in the Additional Info screen. Also allow a longer package description value when Priority Alert
          is used.


         Completed version of integration for FedEx 10.0x for all printer types (Zebra, Intermec, Laser). Now
          allows that PDF0417 barcode version of the labels can be enabled (note: This requires content from
          Precision, and is available on request)


         Don’t map fields 3001 and 3056 together to the FedEx server – this causes an issue for FedEx
          Ground. Use field 3056 only, as this is at package level


         Allow that the AES transaction reference may be updated at the time of confirming an IPD shipment.


Geodis




         Carrier address details now read from a system value (to allow for different inducted carrier addresses
          based on shipping location)

GLS
                                                                     Carrier Specific   19


Jetpak




Kiala




       Addition of new carrier integration for Netherlands origin



Mory Group




Movianto (formerly Healthcare Logistics)




No Limit
20       PRECISION — TMS Service Pack S31




         No Limit carrier integration officially released



Parcelforce




Parceline (and Parceline DPD)




Purolator (Legacy – US origin)




Purolator (New World – CA origin)




Royal Mail




Swedish Post (Posten)
                                                                                       Carrier Specific   21




TNT – Express Label and Unicom




     New integration methods now available. These replace the use of TNT Express Manager, allowing for
      the generation of the labels and EOD files from within the PRECISION application



TNT – Express Manager version




     Logic added for the handling of Lithium batteries (special indicator for these UN types)


     Allow override of dim weight per specific lists of countries using additional values in the
      “ETNT*DIM FACTOR” system values


     Apply correct dim weight when volume is measured in M3


     Only calculate the TNT Clearance fee for non-EU destination countries.


     TNT Fashion added to the TNT Express Manager integration



TNT – iConnections version
22       PRECISION — TMS Service Pack S31




TNT Express – France Domestic (formerly called Jet Services)




         Allow integration for “Relais Colis” service



TNT Innight




Trans-o-flex




UPS




         Apply Duty and Tax Forwarding charge for non-EU countries only for a specified list of carrier
          payment methods
          Key:    UPS: Axxxx EU EXPORT DUTY PM
          Value: Restricted set of carrier payment methods, if applicable
                                                                                      Carrier Specific    23




   Send only valid characters through the UPS PLD file, per the UPS requirements. This change
    applicable to when the cpinternal is set to UTF-8


   UPS Residential shipments were not calculating the rates correctly when customised rates were in use
    - i.e. it was not referencing the basic customised rates if there were no specific customised residential
    rates


   List of state codes for Canada extended to include value of "NF" - and the UPS programs now use the
    base set of state codes


   Jersey and Guersney no longer treated as part of GB for the determination of routing information


   Allow UPS rating for Inbound shipments (held in separate charge tables to those of Outbound rates)


   Allow dry ice text to be customised per a shipper. This could be at the request of UPS, to allow
    omission of additional labels on the box. This text would print instead of "NO AUDIT REQUIRED"
    or "AUDIT REQUIRED"
    Key:    UPS: Axxxx DRY ICE TEXT
    Value: FOR DIAGNOSTIC OR MEDICAL PURPOSES ONLY


   UPS haz mat changes for Oct 1st 2010 - impacts on the PLD file generated and on the Haz Mat label
    printed. Required to output the Emergency Response Registrant info


   For UPS shipping, don't output LPK segment to the PLD file for Large Package for non-US/CA
    countries - instead use the LPS segment


   Allow VAT number output on Worldease Invoice to be configurable based on clearance country


    Key:    UPS: [internal ID] GCC TAX ID:[clearance country]
    Value: VAT number


   Allow ship price on Worldease Invoice to output additional/configurable decimal places
24       PRECISION — TMS Service Pack S31


         UPS manifest to take into account that "Shipper" address for a "Return" is to be taken from "Ship To"


         Correct “array” error when outputting data to PDF-417 barcode for paperless invoice


         Trap errors for UPS Maxicode compression and output this to the label in maxicode area on label


         Print the Shipper country name for domestic shipments for non-US/CA origins


         Allow that validation of phone numbers for UPS integration can be forced to be "Fatal" instead of
          "Warning" for US / CA phone numbers:
          Key:    UPS: PHONE NUMBER FORCE VALID
          Value: YES or NO (default is NO)


         Large package to be treated as 90 Lb or 40 Kg, during rating process



UPS-SCS (formerly Menlo Forwarding and Emery Forwarding)




         Extend the weight field format on the label by an additional digit



USPS




         Correction for registered trademark value printed on labels for P2009 environments
                                                                  Carrier Specific   25


Wim Bosman




     Correct the output for the recipient city name


     Allow for generic manifest to be printed for this carrier


     Revisions to PLD mappings based on feedback from carrier

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:65
posted:8/9/2011
language:Finnish
pages:25