View source for PATCH C-TMS 11.0 P032

<div class="noprint">
{{#vardefine:Client|CTMS}}
{{#vardefine:ClientName|OBS Logistics Ltd}}
{{#vardefine:System|''CALIDUS'' TMS}}
{{#vardefine:Doc_Title|Release Notes}}
{{#vardefine:Version|1.0}}
{{#vardefine:Date|28th March 2019}}
{{#vardefine:Reference|032}}
{{#vardefine:Year|2019}}
</div>
{{Doc_Title
|Client={{#var:ClientName}}
|System={{#var:System}}
|Title={{#var:Doc_Title}}
|Reference=P{{#var:Reference}}
|Version={{#var:Version}}
|Date={{#var:Date}}
|Year={{#var:Year}}
}}
<!-- TOC --> 

= SUMMARY INTRODUCTION =
== INTRODUCTION ==
The main aim of this document is to provide {{#var:System}} users with the level of detail required to accurately test all software included in the patch.  The document also contains set-up and configuration details to enable the user to configure the system correctly for the new functionality to work.


=== GLOSSARY OF TERMS ===

{| border="1"
|- bgcolor="silver"
!Term !! Meaning
|-
|C-TMS || Transport Management System
|-
|C-WMS || Warehouse Management System
|-
|CR || Change Request
|-
|C-WCS || Warehouse Control System
|-
|C-ePOD || Electronic Proof of Delivery 
|-
|C-MCS || Mobile Control System
|-
|C-TTM || Track and Trace Management
|-
|EDI || Electronic Data Interchange
|-
|TID || Testing Issue Development, or Log
|}


<!-- NEW PAGE --> 
== TESTING PROCESS ==

===TIDs AND RESOLUTION===
If there are any areas of the functionality that are not acceptable or do not meet the requirement specified in the Change Request then these should be expressed by raising a TID.


=== FINAL 'END TO END' TESTING ===
Prior to release to a production database, a full 'End to End' test is required on the test system by all sites using the database. Once this is signed off, a release date can be arranged.


=== AUTHORISATION ===
Authorisation from nominated release personnel only will be required when requesting a release to a production environment



= CHANGE REQUESTS =
<!--
== Customer Ref:  ==
{| width="100%"
|- 
|width="30%"|'''OBS Log Number:'''  || '''Reporter:''' 
|-
|'''Summary of Call'''|| 
|-
|'''Detail of Fix''' ||
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
-->

==	Customer Ref:	Seal Number	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355995
|-
|'''Summary of Call'''||	Seal number within waterfall screen
|-
|'''Detail of Fix''' ||	Add seal number to trip level views and  allow amendment on tab canvases.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}


==	Customer Ref:	Seal Number	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	356137
|-
|'''Summary of Call'''||	Amendments to seal number development
|-
|'''Detail of Fix''' ||	Changes to the waterfall screen to prevent errors when seal no is not selected
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}


==	Customer Ref:	WREQ0020105	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	353064
|-
|'''Summary of Call'''||	Bag Rate Increase
|-
|'''Detail of Fix''' ||	Changes to allow DU types to be added to the system and automatically used in contracts, extracts and paragon export
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}


==	Customer Ref:	Dedicated Haulage	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	353068
|-
|'''Summary of Call'''||	Dedicated Haulage
|-
|'''Detail of Fix''' ||	Customer dedicated haulage, using system parameter SHIFT_DISTANCE
|-
|'''Set-up and Configuration''' ||
|}


{| class="wikitable" border="1" width="100%"
|- bgcolor="silver"
!colspan="4" | New Parameters
|-
!Parameter Name !! Config Level !! Setting Value !! Result
|-
|SHIFT_DISTANCE
|COST CENTRE
|NUMERIC VALUE
|Indicates the max distance a shift can travel before additional charges are incurred
|}


==	Customer Ref:	WREQ0024759	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355276
|-
|'''Summary of Call'''||	GSN: Modification is required on CIPD xml
|-
|'''Detail of Fix''' ||	The EDI parameter 'RETAIN_REFS' will retain all order references except the 'PRINTER_NAME' for the pack files prior to the new order references being uploaded.

The labels will be printed to the advised printer name or the default printer name should one not be advised.

The despatched quantity of the order lines will not be set for the pack files when the EDI parameter 'OMIT_DU_DESP_QTY' is 'Y'.

Any order lines that are not being packed will still be set to 0.

The despatched quantity for the orders that contain items will be set for the order lines to match the quantity to deliver of their order items after packing.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 
 
==	Customer Ref:	Email Notification	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355545
|-
|'''Summary of Call'''||	En-route email notification
|-
|'''Detail of Fix''' ||	Make en route email more configurable
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	Customer Ref:	WREQ0025624	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355743
|-
|'''Summary of Call'''||	GSN:Pack orders at status NEW
|-
|'''Detail of Fix''' ||	Pack Orders at status NEW
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 
<!-- NEW PAGE --> 

==	Customer Ref:	Order Import	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	356061
|-
|'''Summary of Call'''||	New Order Import format
|-
|'''Detail of Fix''' ||	default order windows if not provided in csv import
|-
|'''Set-up and Configuration''' ||	
|}


{| class="wikitable" border="1" width="100%"
|- bgcolor="silver"
!colspan="4" | New Parameters
|-
!Parameter Name !! Config Level !! Setting Value !! Result
|-
|IMP_RESET_ORD_WINDOWS
|CUSTOMER
|Y/N
|Set order windows based on current date
|}


= SUPPORT INCIDENTS =
<!--
== Customer Ref:  ==
{| width="100%"
|- 
|width="30%"|'''OBS Log Number:'''  || '''Reporter:''' 
|-
|'''Summary of Call'''|| 
|-
|'''Detail of Fix''' ||
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
-->

==	Customer Ref:	INC26564424	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355341
|-
|'''Summary of Call'''||	Rebook Option not working
|-
|'''Detail of Fix''' ||	Amendment to copy order processing used when re-booking an order to include the pallet id on the order items.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	Customer Ref:	INC26564611	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355342
|-
|'''Summary of Call'''||	Inactive assets are showing on the asset
|-
|'''Detail of Fix''' ||	Exclude in-active assets from the asset status extract and change date format to DD-MM-YY on the detail lines.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	Customer Ref:	INC26582045	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355381
|-
|'''Summary of Call'''||	Allocate resource for trailer is locked
|-
|'''Detail of Fix''' ||	Trailer allocation amended in the trip resource screen in line with planning screen options.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	Customer Ref:	INC26612001	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355404
|-
|'''Summary of Call'''||	Unknown item when load scanning
|-
|'''Detail of Fix''' ||	Amendment has been made to the processing behind the  save button to commit the changes and trigger the interface to WCS
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	Customer Ref:	Not Supplied	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355688
|-
|'''Summary of Call'''||	No Quantity on Collections
|-
|'''Detail of Fix''' ||	Amendment to Logix export file production for population of the DU type array for collection orders to correctly accumulate into the array points when more than 1 DU type has been allocated the same point in the array.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	Customer Ref:	PRB0117192	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355773
|-
|'''Summary of Call'''||	RCA requested for 355765/INC26845511
|-
|'''Detail of Fix''' ||	Amendment made to processes that generate and send the order-preadvice to WCS to add further auditing and error exception handling.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	Customer Ref:	XML Ord	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355776
|-
|'''Summary of Call'''||	XML Ord: upshift postcode & remove space
|-
|'''Detail of Fix''' ||	Upshift postcode for new locations and remove any extra spaces in the middle.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	Customer Ref:	FTP	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355863
|-
|'''Summary of Call'''||	Issue with Transfer to Shared-FTP
|-
|'''Detail of Fix''' ||	Changes to the FTP funtion for AS2.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	Customer Ref:	INC27062745	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	356121
|-
|'''Summary of Call'''||	Asset report query
|-
|'''Detail of Fix''' ||	Amendment to the Asset status extract to report the asset id as a text field. When the generated CSV file was opened in Excel, numeric asset id were being re-formatted as a number, either losing leading zeros or appearing in scientic format.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	Customer Ref:	INC27127621	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	356212
|-
|'''Summary of Call'''||	Error message when load scanning
|-
|'''Detail of Fix''' ||	Extended the array strings held in the load release message type 442 to handle the location codes on trips with over 25 stops.
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}


==	Customer Ref:	Record Lock	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355312
|-
|'''Summary of Call'''||	ITINC0134424: T2A record lock
|-
|'''Detail of Fix''' ||	Changes to the locking process on T2A to prevent issues when Pulse is running
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}


==	Customer Ref:	Actuals	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355745
|-
|'''Summary of Call'''||	Prevent setting actuals using up arrow
|-
|'''Detail of Fix''' ||	Prevent the setting of actuals by up and down arrows based on system parameter TRM_PREVENT_ALL_DEBRIEF
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}


==	Customer Ref:	#TINC0136237	==
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''||	355698
|-
|'''Summary of Call'''||	Planning screen unable to enter customer
|-
|'''Detail of Fix''' ||	Correct customer Drop down on create pickup/delivery screen
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}



= TID CHANGES =
<!-- 
== OBS Log Number:  ==
{| width="100%"
|- 
|width="30%"|'''Cust Ref:'''  || '''Reporter:''' 
|-
|'''Summary of Call'''|| 
|-
|'''Detail of Fix''' ||
|-
|'''Set-up and Configuration''' || 
|}
-->

==	OBS Log Number:	355607	==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||	Not Supplied
|-
|'''Summary of Call'''||	Prevent Set all actuals
|-
|'''Detail of Fix''' ||	Based on the setting of system pararmeter TRM_PREVENT_ALL_DEBRIEF stop double click on actuals
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	OBS Log Number:	355738	==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||	Location Screen
|-
|'''Summary of Call'''||	Unable to close screen
|-
|'''Detail of Fix''' ||	Issue when closing non Modal window in Location screen
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	OBS Log Number:	356004	==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||	Not Supplied
|-
|'''Summary of Call'''||	TRIP unavailable to unload
|-
|'''Detail of Fix''' ||	Additional events to generate scans to WCS
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	OBS Log Number:	356049	==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||	Date Extract
|-
|'''Summary of Call'''||	Items not scanned by Date
|-
|'''Detail of Fix''' ||	Changes to the date extract to exclu  HW scans as an outbound or inbound scan
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	OBS Log Number:	356197	==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||	Dedicated Haulage
|-
|'''Summary of Call'''||	Scheduling Engine incompatibility
|-
|'''Detail of Fix''' ||	Issue with dedicated haulage scheduling engine process
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}
 

==	OBS Log Number:	356206	==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||	Tracking
|-
|'''Summary of Call'''||	FCA asset tracking issues
|-
|'''Detail of Fix''' ||	Changes to FCA asset scanning following UAT
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}


==	OBS Log Number:	355495	==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||	Depot reset Paragon
|-
|'''Summary of Call'''||	Depot reset on outbound export
|-
|'''Detail of Fix''' ||	Reset the depot to null, preventing records from inheriting the depot from the previous record
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}


==	OBS Log Number:	356087	==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||	Microlise Upload
|-
|'''Summary of Call'''||	Microlise upload issue
|-
|'''Detail of Fix''' ||	Exclude resource tag if driver not present on trip
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}


==	OBS Log Number:	354680	==
{| width="100%"
|-
|width="30%"|'''Customer Ref:'''||	Ref 353264
|-
|'''Summary of Call'''||	Create new manifest for each store order
|-
|'''Detail of Fix''' ||	Web Service audit screen not allowing access to other open screens
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}



= OBSL PRODUCT DEVELOPMENT =
<!-- 
== OBS Log Number:  ==
{| width="100%"
|- 
|width="30%"| '''Reporter:''' || 
|-
|'''Summary of Call'''|| 
|-
|'''Detail of Fix''' ||
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
-->

==	OBS Log Number:	356314	==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''||	TMSDEM2 -actuals in C-TMS
|-
|'''Detail of Fix''' ||	Add missing trip audit records
|-
|'''Set-up and Configuration''' ||	No set-up/configuration required
|}



= MODULES DELIVERED =
<!--
{| border="1" width="100%"
|- bgcolor="silver"
!Module Name !! Version No !! Description !! Log Number
|-
|MOD1 || 1.2.3.4 || Mod 1 description  || 123456
|-
|  ||  ||  || 
|}
-->
{| border="1" width="100%"
|- bgcolor="silver"
!Module Name !! Version No !! Description !! Log Number
|-
|	ACC.sql	||	5.73	||	Accounts package	||	353068	
|-
|	ACC_MAINT.fmx	||	2.90	||	Accounts Maintenance	||	353068	
|-
|	ACC_MAINT.fmx	||	2.91	||	Accounts Maintenance	||	353064	
|-
|	AT_ACC_PAYMENT_TYPE_353068.sql	||	1.1	||	Alter Table Script	||	353068	
|-
|	AT_CNT_CHARGE_PARAM_353064.sql	||	1.1	||	Alter Table Script	||	353064	
|-
|	CONTRACT.fmx	||	2.70	||	Contracts Form	||	353064	
|-
|	CSV.sql	||	5.109	||	CSV extract package	||	355495	
|-
|	CSV.sql	||	5.111	||	CSV extract package	||	353064	
|-
|	DATA_ADM_MSEL_FORM_PARAM_355995.sql	||	1.1	||	Data Script	||	355995	
|-
|	DATA_ADM_SYSTEM_PARAM_353068.sql	||	1.1	||	Data Script	||	353068	
|-
|	DATA_ADM_SYSTEM_PARAM_356061.sql	||	1.1	||	Data Script	||	356061	
|-
|	DATA_ADM_SYSTEM_PARAM_CONFIG_353068.sql	||	1.1	||	Data Script	||	353068	
|-
|	DATA_ADM_SYSTEM_PARAM_CONFIG_356061.sql	||	1.1	||	Data Script	||	356061	
|-
|	DATA_AUTO_SCHEDULING_ENGINE_353068.sql	||	1.1	||	Data Script	||	353068	
|-
|	DATA_CNT_CHARGE_PARAM_353068.sql	||	1.2	||	Data Script	||	353068	
|-
|	DATA_CNT_DEL_TYPE_353068.sql	||	1.1	||	Data Script	||	353068	
|-
|	DATA_IMP_FIELD_353068.sql	||	1.1	||	Data Script	||	353068	
|-
|	DP_ASSET_SCANNING.sql	||	5.46	||	Tag to Asset Scanning	||	355312	
|-
|	DP_CSV_DUN.sql	||	5.41	||	Client specific CSV extracts	||	356049	
|-
|	DP_CSV_DUN.sql	||	5.42	||	Client specific CSV extracts	||	353064	
|-
|	DP_CSV6.sql	||	1.37	||	CSV Extract package	||	355342	
|-
|	DP_CSV6.sql	||	1.38	||	CSV Extract package	||	356121	
|-
|	DP_IMP.sql	||	5.37	||	Imports Package	||	355743	
|-
|	DP_INT_XML_MIC2.sql	||	1.30	||	CTMS to MIC Interface	||	356087	
|-
|	DP_INVOICE_XML.sql	||	1.7	||	Invoice XML Package	||	355863	
|-
|	DP_LOGIX.sql	||	1.9	||	Package for LOGIX Interfaces	||	355688	
|-
|	DP_RDT_AUTO.sql	||	5.45	||	Client specific RDT funtions	||	355773	
|-
|	DP_RDT_AUTO.sql	||	5.46	||	Client specific RDT funtions	||	356206	
|-
|	DP_RDT_FAST_LOAD.sql	||	5.30	||	Load confirmation message procedure	||	356212	
|-
|	DP_REPORTS.sql	||	5.57	||	Reports package	||	355545	
|-
|	DP_SCHEDULING_ENGINE.sql	||	5.144	||	Scheduling Package	||	353068	
|-
|	DP_SCHEDULING_ENGINE.sql	||	5.145	||	Scheduling Package	||	356197	
|-
|	DP_WCS_IF.sql	||	5.25	||	WCS Package	||	356206	
|-
|	DP_WEB_SERVICE_ORD.sql	||	1.15	||	Web Service Package	||	354680	
|-
|	DP_WEB_SERVICE_ORD.sql	||	1.16	||	Web Service Package	||	356004	
|-
|	DUN_DAILY_STORE_ASN.rep	||	1.8	||	Customer Report	||	353064	
|-
|	EPOD_WSA.fmx	||	1.7	||	EPOD Web Service Audit Form	||	354680	
|-
|	IMP.sql	||	5.175	||	CSV Imports Package	||	353068	
|-
|	IMP.sql	||	5.176	||	CSV Imports Package	||	356061	
|-
|	INT_XML_IN.sql	||	5.183	||	Order Import Package	||	355276	
|-
|	INT_XML_IN.sql	||	5.184	||	Order Import Package	||	355776	
|-
|	INT_XML_IN.sql	||	5.185	||	Order Import Package	||	355743	
|-
|	INT_XML_OUT2.sql	||	5.282	||	Outbound XML Package	||	355743	
|-
|	LOAD_MAN.fmx	||	1.26	||	Load Management Form	||	355404	
|-
|	LOCATION.fmx	||	2.189	||	Location Maintenance	||	355738	
|-
|	OMS.sql	||	5.216	||	Order package	||	355341	
|-
|	PAR.sql	||	5.100	||	Paragon Interface	||	355743	
|-
|	PLANNING.fmx	||	1.102	||	Planning Screen	||	355698	
|-
|	RATE.sql	||	5.149	||	Rates Tariff database package	||	353068	
|-
|	ROUTES_MAINT.fmx	||	2.48	||	Fixed Routes Maintenance	||	353068	
|-
|	T_SCH_TRIP_STOP_BIU.sql	||	5.6	||	Trigger	||	356314	
|-
|	TRIP_OVERVIEW.fmx	||	1.60	||	Trip Waterfall	||	355995	
|-
|	TRIP_OVERVIEW.fmx	||	1.61	||	Trip Waterfall	||	356137	
|-
|	TRIP_RES.fmx	||	1.24	||	Resource Allocation	||	355381	
|-
|	TRIP_SHEET_DUN_DETAIL.rep	||	5.25	||	Driver Trip Sheet	||	353064	
|-
|	TRIP_SHEET_DUN_NEW.rep	||	1.22	||	Driver Trip Sheet	||	353064	
|-
|	TRIPDTL.fmx	||	2.220	||	Trip Debrief	||	355607	
|-
|	TRIPDTL.fmx	||	2.221	||	Trip Debrief	||	355745	
|-
|	TRIPSUM.fmx	||	2.438	||	Trip Manipulation screen	||	355698	
|-
|	TRM.sql	||	5.180	||	Trip manipulation package	||	353068	
|-
|	V_TRIP_OVERVIEW.sql	||	1.15	||	Trip View	||	355995	
|-
|}



= ADDITIONAL CHANGES =
== WCS ==

A WCS change is required for the following logs: 

* Log 356212
* Log 356206


== EPOD/T2A ==

There are no ePOD/T2A changes required.


== MCS ==

There are no MCS changes required.


== PORTAL/TTM ==

There are no Portal changes required.


== EDI ==

There are no EDI changes required.



</div>
[[Category:{{#var:Client}} PATCH]]