PRECISION TMS/QAD Freight Management S36
PRECISION TMS/QAD Freight Management Version: S36
Release Date: May 2013
Related Documentation
The following documents have been created for this release:
User Guide: TMS (item 70-3263-4.6)
The documents are available in the QAD Document Library:
Application Enhancements
Black Box Message Changes
• ShipShipment/CreateShipment
• ReprintShipment
• ProcessSPSResponse
• ProcessShipment
End of Day (EOD) Process
• Rate any consolidated shipments that are generated as part of the EOD batches
• Auto EOD Process, to allow multiple EOD packing locations to be consolidated as a unit for closing as part of the Scheduled EOD process
• Add audit logic for timings of calls in black box, add performance improvement for cache of XMBKTS0 records
• Use a system value generated by the PRECISION application automatically in the background to prevent two users from running EOD at the same time for the same carrier and location combination
• When clearing down the consolidation records during EOD process, only consider the batch constraints relevant to the carrier selected
• Windows UI SPSEOD screen to show the number of packages on a shipment
LTL — Check Digits Added
• Added FXNL
• Added QXXP
• Added STDF (Standard Forwarding)
• Use procedure xtgettrk.p program to get a new tracking number to reduce transaction scope
• Check digit calculation correction for AACT carrier
For a full list of supported LTL check digits, see Topic045 - Non-SPS Service Configuration.xls.
LTL — Generic Label and Manifest
• Ability to print the shipper phone number on the label
• The Shipper Contact Name was always printed in previous versions. It is now possible to switch this behavior on or off
• PRECISION + system-value Category: SPS, Key: SPS VERSION (prefixed with S) now prints on the bottom right of the label, replacing SYSTEM: TRAXi3 V7.0, which was printed in earlier versions
• On the label, the UOM value of KGS or LBS is based on shipper origin country. The document parameters WEIGHT-LBS-OVERRIDE and WEIGHT-KGS-OVERRIDE can now override these values
• To disable the round up function that was always present on the label previously, use document parameters WEIGHT-KGS-ROUNDUP-0.5KG and WEIGHT-LBSS-ROUNDUP-1LB
• On the label, see document parameters WEIGHT-KGS-ROUNDUP-0.5KG and WEIGHT-LBSS-ROUNDUP-1LB to disable the round up function that was always present previously
• To specify a return address on the label use system value Category: SPS, Key: LTL: Axxxx RETURN ADDRESS
• Exclude return shipments from the manifest.
LTL - Processing
• Delete temp charge records if rating has generated an error, so errors are returned for each service in Rate Shop. This practice ensures that if multiple LTL carriers use the same base charge table, with discounts off of this charge table, then each one should fail, where applicable
Rate and Transit Time Maintenance - Fixes and Modifications
• Round up the hundred-weight value
• Add check for divide by zero before trying calculation on weights
• The QFUELS are now calculated based on the total combined amount of appropriate charge types as defined by the system value FUEL UPLIFT
Rating Legacy Engine (TH structure)
• The TH Excel File upload now allows for a Pack-factor/Colli-factor calculation method
• The TH Excel File upload now allows for more columns, addition of indexes to the temp-tables, the addition of empty-temptable instead of delete temptable. Caching of xmctry0 and xmuomd0. Improved performance when uploading the file
• The TH Excel File upload now allows for Pack cut-off factor calculation method
Rating Screen (Windows) - Fixes and Modifications
• Return an error if the system value SPSROUTE category SPSNONSHIP is set such that all weekdays are set as non-shipping days
• For Routing Assignment, the dynamic field assignment needs to go through all items. Accessorials that are set on the shipment prior to assigning a new service can be retained. Prevent the original shipment route being overridden by using workflow parameters
For more information on the Routing Guide, see Topic040 - Routing Guide and Rate Shopping.doc
Technical Enhancements
• Support for Data Matrix barcode for ZPL and IPL
• Resolved some performance issues in the black box process
Carrier-Specific Enhancements
• Addition of the Affretement service, which requires an additional RT record
• Support for a specific Return To address to be output to the label Category SPS, Key: GEO: Axxxx RETURN ADDRESS)
• The ability to specify a polling directory for the EOD process
• In the new FTP structure, the filename can now contain the date and time, and the destination directory does not have to contain the date
• Additional logic to handle the EOD criteria when determining the consolidation for this carrier
• Replaces special characters with nearest equivalent alphanumeric character before searching the routing data for a match
• Supports the use of XTGETTRK.P to get the tracking numbers to reduce the transaction scoping and prevent locking
Canada Post
• New carrier integration added. See the functionality document for this carrier.
Canpar
• New carrier integration added. See the functionality document for this carrier.
Chronopost
• Supports the Standard Health services, which require new RT records
• Ability to add a specific Return To address to the label using the Category: SPS, Key: CHRN: Axxxx RETURN ADDRESS system value
• If a POLL folder is available, the PLD file can be output to this folder also
Chrono Express
• The Julian Date and a Pickup Number sequence can now be included in the PLD file name convention
Ciblex
• The Contact Name can be output to the PLD file through the Recipient Address fields of the file
City Link
• To avoid old files causing conflicts for repeated processing of the same shipment, the old file is renamed when a subsequent interface process completes
Danish Post (Post Danmark)
• EOD EDI file to be encoded as ISO8859-1
• Small amendments to the EDI file output; RFF+CU segment is mandatory; UNB segment can have different Party ID; NAD+CZ segment must always have DK as the country
DHL - Express (SAS Version, US Origin)
• Support for GS1 Piece IDs when they are provided from an external application.
• Support for DHL Breakbulk (BBX) service
• Option to print appropriate lithium battery text when necessary
• Paperless Clearance. This draft is the first draft of this feature; the testing has yet to be completed with DHL
• Determination of Airline information for AES validation has been corrected to resolve an issue regarding the time format, when more than one entry existed in DHL routing information for the same date
• Removal of spaces from post codes provides improved search results relating to Remote Area Surcharges. Compatibility with shipments of Puerto Rican origin
• Handling of new VAS codes provided as part of DHL rate structures, to ensure appropriate additional charges are calculated
DHL - Day Definite (Non-US)
• Supports a PDF-417 barcode label for non-Benelux destinations
• A new macro 710413 instead of 710403, to be more like the PDF-417 version, prints DD Dest Code and Facility
• A package count can be printed on labels for consolidation shipments as 1/x, 2/x, and so on
• IATA determination procedure is now in place for Day Definite services
• There is now a warning when the reference value length exceeds the maximum length allowed
• JE and GG translate to country code of GB for the EDI file or PDF-417 file
• An option to output the RFF+CU segment for the DHI carrier
• The TOD values for Expresser service are 2-character codes
DHL - Express (Non-US, Legacy integration)
• PLD File transmission uses PASSIVE or ACTIVE during FTP transmission, and uses WININET or MSINET as the transmission usage=
DHL - Global Mail (US origin)
• New carrier integration added. See the functionality document for this carrier
DHL - Time Definite (non-US)
• Support for shipments of Australian origin, including the generation of a different standard of paper manifest and an archive label
• Omission of the letter S on the label for a Saturday Delivery when PDF-417 barcode is in use
• Ability to add the exchange rate procedure to the label program to support rate conversion
• Printing of the third party account and third party duty account on the label, when applicable
• A dummy BBX Master shipment number is not printed on labels
• BBX master shipments might not be created until EOD for some packing locations. The master shipment is created during PLD file creation as part of the EOD process
• The group or batch header is updated during the EOD file generation process, in case its context is lost during calls to other programs
• Fixed issues related to validation of Account number when the Freight Payment Method is Third Party or Collect
• A maximum free text value of thirty five characters for FTX+AAA segment for GB origin
• The post code is now optional for Vietnam and Ireland
• Add logic to output second and third shipper address lines if available
• There is a warning when the reference value length exceeds the maximum length allowed
• Delivery Terms validation based on origin and destination pairings
• Supports the concatenation of the consolidation or 39 or value for the TOD segment
• Irish shipment post code field mapping is always blank
• Shipments within a consolidation can share a single waybill number
• A transit time location id system value enables sharing of transit times across a country
• Improved IATA determination for GB post codes
DHL - XML PI Integration
• New carrier integration added. See the functionality document for this carrier
DPD
• Ability to print the Damage Text in the local language on a label of NL origin
• Spaces and hyphens removed from post codes used in the composition of the barcode
DPD UK (formerly Parceline)
• Revised integration based on new specifications
Endicia
• Secondary manifest document produced to handle the processing of Registered Mail shipments.
• The SubmissionID returned from the SCAN request can be stored against the EOD batch in the Pickup Number field
• Support for Letter processing, which required some changes to the field mappings in the integration
• Support for the VALIDATE-CARRIER and VALIDATE-SERVICE request types
• Removal of reference to proc_create_error_log in the field mapping procedure
• US Territory check for customs form now includes 1lb weight in addition to greater than 1lb weight.
• Merchandise information is output if the customs form is required; it is not based on the destination
• RegisteredMail setting in mapping to Endicia back-end
• Item weight contains two decimal places
• If CustomsID is returned with same value as PIC number, it is not sent in the RefundRequest
• If CustomsID is returned with same value as PIC number, it is not sent in the SCANRequest
• The Ship From address can be overridden for the ScanRequest
• The full postal code length now maps correctly for US territories; it maps to ZIP+4 when applicable
• CostCenterAlphanumeric is used when sending the request label
• Issue with incorrect reading of system value SPS / ENDC: LABEL PRINTER resolved
• The MailPieceDimensions node is only mapped if there is at least one volume dimension present; otherwise the node is not required
• Handles HTTP requests & responses that are beyond the OpenEdge CHAR length limit
• Corrections for the handling of requests to the Endicia back-end, taking into account Proxy information, and other details
• Allows the merging of If more than one ZPL file is returned for the current shipment, it is possible to merge the files. The encoded files are output only if Endicia debug mode is turned ON. The printer control string is added to the received ZPL file
• Conversion from PDF to PCL using a batch file that calls Ghostscript
• When printing Endicia PDF files and DP field 'Device or OS Command' starts with pdfprnt or device=pdfprnt the PDF file is not returned
FedEx
• Flag for Third Party Consignee service prints on label when applicable
• Shipper phone number can now be output on the label for Ground and Home services
• Include HAZ on labels for Ground packages that are hazardous only
• If shipper account is output for Duty and the freight account number is set to hidden, then the shipper account is printed on the label as ******
• Smartpost processing is allowed, whereby the label is generated by the FedEx server, and captured by the PRECISION application to direct to a printer
• Only the first five digits of a post code are output to PDF-417 on a label for US origin, to avoid outputting the - character
• The content of a PDF417 barcode on a label is normalized using new procedure
• If there are space restrictions on the label, recipient address lines can be concatenated
• Outputs the appropriate lithium battery text on a label
• The Query request is now optional in the EOD Close Meter process; the request is not run by default.
• IPD processing has been amended to ensure that two master shipments are not created if multiple requests are set at the same time for the first instance of a child shipment being created for a packing location
• For Transborder Distribution (TD), set the UOM of the master package to KG instead of LB
• It is now possible to override the Rate Currency via a system value that is set at the packing location level
• Fields 3002 and 3003 are mapped with reference field entries 4 and 5 of the FEDEX: SHIP REFERENCES system value
• Ability to handle ORMD products on FedEx version >=11
• Removal of the mapping of the field 499, Tracking Number Type
• Mapping of 1 instead of 3 to the field 1234 for MX origin, to prevent rating issues
• Dubai domestic shipping does not return rates; these rates are not requested in the message to the server
• Mapping of the Transborder Return Country field
• Mapping of additional fields for the QueryMeter request relating to ETD process
• The Shipper country code is no longer changed to US for a shipment with a ship from field value of Puerto Rico
• The IPD customs value now includes the required freight uplifts for charges calculated by shipper
• A number of charge codes for surcharges have been updated and are now more appropriate to their purpose, for example QDLCFS replaces QFRT
• The Standard, Priority, and First services can be used for shipments of Mexican origin
• The FedEx Ground service is restricted from using the Residential Delivery flag; it must use HOME service instead
• Previously, the storage level impacted the rating process for the Ground service; this behavior has been corrected to behave properly for the storage level of the package
Hermes (Germany origin)
• New carrier integration added. See the functionality document for this carrier
Loomis (formerly DHL Canada integration)
• Ability to output V for Registered ACS shippers
• The PLD File Transmission method can use MSINET instead of WININET when required
• If the tracking number range goes below a specific threshold, an email notification can be sent
PostNL (formerly TNT Post)
• Addition of EPS service for Consumers
• Addition of Post NL COD service for Italy
• Correction to the RENAME process for the files uploaded to the FTP site
• The PLD Filename can be Unique per Packing Location
• Validation of NL post codes for correct format
Purolator (Legacy - US origin)
• Returns now appear as 1 of <N> on the label
• PDF labels are now output with the correct barcode width
• In the PLD file mapping returns are treated as separate shipments per package
• Returns are not eligible for consolidation processing
Purolator (New World - CA origin)
• Seconds and milliseconds are now included in the file name to make it more unique and reduce conflicts on the Purolator back-end
• Correctly recalculates the charge amounts for PLD file mapping after consolidation
• Only the first five digits of US zip code are applicable for searches on Routing data
• The default processing level indicator in the PLD file is P even if there is no recipient email address is available
• The Cross Border IATA and Destination IATA fields are no longer mandatory in the EOD file
• The values retrieved from the Routing data, for example, agent ID, are truncated so that if the value is only one character long, the correct information is available for subsequent searches
Royal Mail
• Label macros have been updated to a newer format
• Additional logic to determine package type, to validate rules for sizes etc.
• Additional logic handles rating functionality
TNT - Express Label and Unicom
• HAZARDOUS is printed on the shipping label when the option description contains the string 'DGHZ'
• The correct marker is now used on the label when printing a large Postcode or Cluster code
• Special instructions can be set on the label for Express Label macro
• The printing of TNT xRay text on a label can be blocked when it is not applicable
• On the Connote, if the Recipient account variable is not set, then it is picked up from the Receiver account field. This behavior ensures that the appropriate account number is printed on the Connote
• On the Connote, the Special Instructions value is now output correctly
• The TNT Connotes can now be printed as part of the EOD batch process
• Support for TNT Integrated Direct Express (IDE) service (contract service); this draft is the first draft of functionality only, and is subject to future TNT testing
• Reorganized NFF file order of sections 02,04,05 as recommended by TNT
• CollectionDateTime can be taken from the system value for Express Label
• New facility to suppress the UTNT validation that checks total item weight within a pack against the weight specified for the pack
• For NL origin, PS is mapped instead of ED for Origin Sys ID
• Handles countries where post code should not be provided when calling the TNT COM component
• Checks for Limited Quantity products and maps accordingly
• Correctly handles lithium batteries as hazardous materials when special instructions are not specified
• For Express label message mapping the pack dimensions are set in meters
• Implements service G48N for SG origin
• Freight Payment method of Collect requires entry of a carrier account
• Maps the Collection Address to NFF file, when required by TNT
• Added validation to ensure that only valid services are chosen for Domestic NL shipping
• Sets the pack counter to zero, and references the correct pack counter when outputting article lines
• Avoids fax validation issues due to the length of the fax number
• Increases allowed packages for Express Label integration to 99. This format has changed from 1 to 2.
• If the Customs reference is set on a child shipment, then on the NFF file and on the TNT Connote, multiple MRNs are output
• Round dimensions that are converted to meters to four decimal places to avoid mapping issues for long values
• Support for shipping from Malaysia
• Correctly traps all errors from Express label response
• Automatically prints the Connote document when using Express Label integration
• The City-based zone takes precedence over Country-based zone
TNT - Express Manager version
• No longer supported for new implementation of accounts
• Implements service G48N for SG origin
• Resolves issue with system value SPS / ETNT: SPECIALCHARACTER CONVERT when cpinternal is UTF-8
• Allows call to caching process after rating to allow mapping of rates data to the Express Manager server also
TNT - iConnections version
• No longer supported
Trans-o-flex
• The ship-ref marker on the label is taken from the configurable field LongReferenceNumber
• Outputs the Service code on the label
• Determines correctly if the shipment is domestic with respect to the account number in use
• Supports a post-2012 version of the EOD file
• Support for a Recipient address line 1 that is longer than 30 characters
• Special instructions can be output to EOD file
• If the reference field is too long for EOD file mapping, it is truncated
• The account in use can be exclusively for Thermomed
• Shipments from a DE account are restricted from shipping to NL; shipments from NL account are restricted from shipping to DE
• Maps to the Alternative Reference fields, when values are available
• Different logic is used for the determination of the rating zone for a non-DE destination
• Uses XTGETTRK.P to get the tracking numbers to reduce transaction scope and prevent locking
UPS
• Fixes to the UPS Summary Manifest for shipments of a non-US origin to be in line with current EU origin requirements
• UPS Hazmat Manifest has a new transport mode column added
• The Paperless Invoice label can be printed ahead of the Package label
• Supports consolidation of shipments originating from EU to an EU address
• There is now a first draft of the UPS Mail Innovations service available; the testing has yet to be completed with DHL
• There is now a first draft of the UPS Surepost services available; the testing has yet to be completed with DHL
• Determines if the Terms and Conditions should be printed on the label for US origin
• Blocks invalid characters from being output to PDF417 content on Paperless Invoice label
• Normalizes the characters that are output to the Maxicode string on the label
• On the COD label, the COD amount values for Europe are now output in European numeric format
• Support for GB and CA post codes on the label. The six characters of the post code can be output to postal barcode for 203dpi printers
• Limits the post code on postal barcode on the label to six characters
• New Terms and Conditions appear on the label for shipments of EU origin
• Support for outputting the third line of shipper address on the label
• On the Paperless Invoice, the output of AP and AQ segments in PDF-417 barcode are not compatible
• On the label, it is now possible to print the appropriate hazmat information for non-US origin
• Resolves issues with the postal barcode output for a Worldease label
• Prints the appropriate lithium battery text on a label
• When Express Early AM is the service, then the shipper contact is only output on the label if either Emergency phone or Shipper Instructions are blank, due to space restrictions
• Allows the Carbon Neutral text to be in the local language, where the shipment is domestic, or the packing location has been configured to allow for this for destination country
• If the file submission fails, due to no response from UPS, then automatically make a further attempt to transmit the file
• Additional validation to determine when a paperless invoice is allowed
• If a letter is over eight ounces (1/2 lb), then it is considered to be a package.
• There was an issue with the conversion of the dimensional UOM, and it was not updated to reflect the conversion of the weight UOM. This issue had been resolved.
• Support for IL (Israel) origin
• Support for JP (Japan) origin
• Shipping to a PO Box can result in a fatal error
• Support for DK (Denmark) origin
• Support for CR (Costa Rica) origin
• Support for BR (Brazil) origin
• Truncates the output of the phone number to the PLD file if the value is too long
• If the Freight Third Party account and the Duty Third Party account are the same, then the Duty Third Party address info can be used
• Maps the value for the reason for export from the master table in PRECISION, instead of defaulting to Sale
• It is possible to set Carbon Neutral on for all shipments per a specified Pack Location, using system values Category: SPS, Key: UPS: Axxxx CARBON NEUTRAL
• Supports auto invoice printing for non-paperless invoice applicable shipments
• The first four digits are used in the search for NL post codes for routing data
• Removes the constraint that the Worldease child shipment has to be the last child in the overall shipment
• Allows for consolidation of shipments originating from EU to an EU address
• Charge table names for MX origin have changed to allow for full MX origin rating functionality (domestic and international)
• New naming convention for charge tables for Canada origin to resolve conflicts when there are customized charges
• If no routing data is found based on the postal code, then if postal code !!!!!! exists in data provided by UPS, this may provide an entry for the destination country
• UPS Transit Time API integration changes: Some defaults for shipment value for US, CA, GB, and some EU countries. If no weight mapped, then default 0.5 as weight, to bypass validation. Set transit time debug file extension as log
UPS-SCS (formerly Menlo Forwarding and Emery Forwarding)
• Use of the Third Party freight payment method is allowed when the Third Party address country is the same as the Shipper or Recipient country
• Issue resolved regarding the PROVERSION referenced in the integration program
USPS
• MAC Certification retired; no longer supported. Use Endicia integration instead
Wim Bosman
• Support for the System Plus services