PRECISION 2012 R01 Release Notes > PRECISION TMS/QAD Freight Management S36
  
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:
http://www.qad.com/documentlibrary.
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