PATCH C-TMS P034
From Calidus HUB
OBS Logistics Ltd
Release Notes
CALIDUS TMS
22nd Aug 2019 - 1.0
Reference: P034
Contents
- 1 SUMMARY INTRODUCTION
- 2 CHANGE REQUESTS
- 3 SUPPORT INCIDENTS
- 3.1 Customer Ref: VDA4987
- 3.2 Customer Ref: Trip Stops
- 3.3 Customer Ref: Invoice totals
- 3.4 Customer Ref: Trips
- 3.5 Customer Ref: Invoice totals
- 3.6 Customer Ref: Stop types
- 3.7 Customer Ref: Dedicated import
- 3.8 Customer Ref: DU Type
- 3.9 Customer Ref: PROD
- 3.10 Customer Ref: Trunking
- 3.11 Customer Ref: VDA4987
- 3.12 Customer Ref: VDA4987
- 3.13 Customer Ref: Invoice format
- 3.14 Customer Ref: INC29331313
- 3.15 Customer Ref: CON
- 3.16 Customer Ref: 356851
- 3.17 Customer Ref: Tariffs
- 3.18 Customer Ref: Doubled Quantities
- 3.19 Customer Ref: VDA4933
- 3.20 Customer Ref: Importing
- 3.21 Customer Ref: Trunk trips
- 3.22 Customer Ref: Invoicing
- 3.23 Customer Ref: Location Imports
- 4 TID CHANGES
- 5 OBSL PRODUCT DEVELOPMENT
- 6 MODULES DELIVERED
- 7 ADDITIONAL CHANGES
SUMMARY INTRODUCTION
INTRODUCTION
The main aim of this document is to provide CALIDUS TMS 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
| 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 |
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: CR-39
| OBS Log Number: | 357263 |
| Summary of Call | Despatch Page - Changes |
| Detail of Fix | T2A change to allow despatch search by buff tag. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: PO No RE-BOOK
| OBS Log Number: | 357921 |
| Summary of Call | Re-book facility |
| Detail of Fix | Changes to re-book to set the status of the original orders to DEL_FUTILE |
| Set-up and Configuration |
| New Parameters | |||
|---|---|---|---|
| Parameter Name | Config Level | Setting Value | Result |
| OMS_RE_BOOK_STATUS | SYSTEM | Y | |
Customer Ref: WREQ0030039
| OBS Log Number: | 358065 |
| Summary of Call | GSN:Bespoke extract required |
| Detail of Fix | New extract for IPN Order update. Also suppress text conversion. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031019
| OBS Log Number: | 358817 |
| Summary of Call | GSN:Amend order_items_POD_Debriefed |
| Detail of Fix | Add contents to order_items_POD_Debreifed. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031406
| OBS Log Number: | 358988 |
| Summary of Call | GSN: Delivery from different depot |
| Detail of Fix | Allow a delivery to be picked up en-route from an alternative depot rather than requiring a trunk. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: WREQ0031408
| OBS Log Number: | 358989 |
| Summary of Call | GSN:start and finish at different sites |
| Detail of Fix | New rule TRM_CHECK_DRIVER_CARRIER to control whether to use carrier hubs when driver hubs in use but specific driver is not switched on. |
| Set-up and Configuration |
| Registry/Rules Settings | ||
|---|---|---|
| Path & Name | Setting Value | Result |
| TRM_CHK_DRIVER_CARRIER | Y | Use driver hub if set otherwise carrier. |
Customer Ref: Pickup Date
| OBS Log Number: | 358135 |
| Summary of Call | Match with Pickup Date |
| Detail of Fix | The matching process was based on the delivery windows of the orders, the process has been amended to look at the collection windows instead |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Trunking
| OBS Log Number: | 358222 |
| Summary of Call | Implement trunking |
| Detail of Fix | Amendments to the Route Optimiser to select sched coll orders and use current depot |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: OMS
| OBS Log Number: | 358130 |
| Summary of Call | OMS Reference Changes |
| Detail of Fix | Change PARCEL mode to not send OMS_REF as JOB_ID |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: VDA4987
| OBS Log Number: | 358745 |
| Summary of Call | VDA4987 and Invoice queries |
| Detail of Fix | VDA4987 orders not applied to trips |
| Set-up and Configuration | No set-up/configuration required |
SUPPORT INCIDENTS
Customer Ref: VDA4987
| OBS Log Number: | 357797 |
| Summary of Call | Amendments to VDA4987 |
| Detail of Fix | Changes for VDA4987 |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Trip Stops
| OBS Log Number: | 357812 |
| Summary of Call | Collecton time window calculation |
| Detail of Fix | Issue with dates and times on trip stops |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Invoice totals
| OBS Log Number: | 357841 |
| Summary of Call | VAT less than zero not calculated |
| Detail of Fix | Changes to the Invoice totals procedure to look at non zero VAT rather than greater than zero VAT |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Trips
| OBS Log Number: | 357843 |
| Summary of Call | Dedicated Trips Elapsed time not updated |
| Detail of Fix | Using system parameter TRM_RECALC_ELAPSED_TIME to always update the elapsed time when validating a trip |
| Set-up and Configuration |
| New Parameters | |||
|---|---|---|---|
| Parameter Name | Config Level | Setting Value | Result |
| TRM_RECALC_ELAPSED_TIME | COST CENTRE | Y/N | Forces elapsed time recalculation during trip validation |
Customer Ref: Invoice totals
| OBS Log Number: | 357922 |
| Summary of Call | Invoice Values Check 10/6/19 |
| Detail of Fix | Changes to the invoice totals process to include negative VAT in addition to to VAT over 0 |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Stop types
| OBS Log Number: | 357972 |
| Summary of Call | Multi-Depot Paragon |
| Detail of Fix | Changes to Stop types when setting stop times |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Dedicated import
| OBS Log Number: | 358098 |
| Summary of Call | Scheduling engine not creating Dedicated |
| Detail of Fix | Changes to the Dedicated import for Tour id |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: DU Type
| OBS Log Number: | 358454 |
| Summary of Call | Add DU_TYPE - 'S' |
| Detail of Fix | Add DU TYPE to 'S' item records for STS flow |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: PROD
| OBS Log Number: | 358572 |
| Summary of Call | Column too narrow in 'Add Refs' tab |
| Detail of Fix | Increase display size of sub reference name |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Trunking
| OBS Log Number: | 358612 |
| Summary of Call | Trunking in scheduling engine |
| Detail of Fix | The available date for the order for use in the scheduling engine will be updated to match the latest available date when the 'Amend Day Offset' functionality is used for a batch of orders in the order well in the Planning screen for trip planning.
The available date will be updated to match the new early available date of UNSCHEDULED orders but will remain the planned arrival time of the latest trip stop for the SCHED_COLL orders. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: VDA4987
| OBS Log Number: | 358932 |
| Summary of Call | Issues reported with linking 4987 to 33 |
| Detail of Fix | Multiple 4987 orders not being applied to trips |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: VDA4987
| OBS Log Number: | 359291 |
| Summary of Call | VDA4987 not matching |
| Detail of Fix | Issue with SCHED_COLL orders for VDA4987 |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Invoice format
| OBS Log Number: | 359823 |
| Summary of Call | Incorrect Invoice extract format |
| Detail of Fix | Changes to Invoicing procedure following UAT |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: INC29331313
| OBS Log Number: | 359976 |
| Summary of Call | HC booking in form export |
| Detail of Fix | Amendment to HC Booking in Form extract so query behind the totals section for each location is the same as the orders query. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: CON
| OBS Log Number: | 360098 |
| Summary of Call | Outbound XML flows |
| Detail of Fix | Correct selection of trips for outbound XML |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: 356851
| OBS Log Number: | 357862 |
| Summary of Call | Log to release 356851 |
| Detail of Fix | Changes to the triggers for creating service records for charging |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Tariffs
| OBS Log Number: | 358043 |
| Summary of Call | Copy tariff option does not restrict |
| Detail of Fix | Add cost centre retsrictions to copy tariff. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Doubled Quantities
| OBS Log Number: | 358395 |
| Summary of Call | OMS Ref. 1056952 - doubled quantities |
| Detail of Fix | Remove dimensions when grouping items into lines for customer orders |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: VDA4933
| OBS Log Number: | 358596 |
| Summary of Call | TST database issue |
| Detail of Fix | An amendment has been made to a query for the VDA4933 function to update the order items with a new external reference as a replacement. |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Importing
| OBS Log Number: | 358446 |
| Summary of Call | Issues with importing back into logix |
| Detail of Fix | Comment out the Domestic Delivery date settings when using the Domestic Sheduling engine |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Trunk trips
| OBS Log Number: | 358668 |
| Summary of Call | Order status for trunk trips |
| Detail of Fix | For PARCEL mode only set order to DELIVERED at final delivery location |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Invoicing
| OBS Log Number: | 359031 |
| Summary of Call | Invoicing needs to take schedule date |
| Detail of Fix | Changes to rating following UAT |
| Set-up and Configuration | No set-up/configuration required |
Customer Ref: Location Imports
| OBS Log Number: | 358802 |
| Summary of Call | Location imports - contacts issues |
| Detail of Fix | Amendment to C-TMS import process for the Location load to allow line to include contact name/phone/email details. Additional parameters added for fields against the location details. |
| Set-up and Configuration | No set-up/configuration required |
TID CHANGES
OBS Log Number:: 357903
| Customer Ref: | POD Interface |
| Summary of Call | FCA POD interface file data |
| Detail of Fix | Amendment to the outbound Click POD to ensure the correct assets are sent across |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number:: 358381
| Customer Ref: | Stop times |
| Summary of Call | Paragon upload |
| Detail of Fix | Ensure paragon stop times are correctly updated by updating trip with cost centre. |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number:: 359072
| Customer Ref: | ASN2 |
| Summary of Call | ASN2 changes the status of order |
| Detail of Fix | Do not check context for webserver user (new param WEB_SERVICE_USER) when validating the order. |
| Set-up and Configuration |
| Registry/Rules Settings | ||
|---|---|---|
| Path & Name | Setting Value | Result |
| WEB_SERVICE_USER | <USER> | Match user so ignores context in OMS |
OBS Log Number:: 360118
| Customer Ref: | 359072 |
| Summary of Call | ASN2 changes the status of order (part2) |
| Detail of Fix | Change supplier confirm trigger to check leave as new parameter. |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number:: 357984
| Customer Ref: | Shift charges |
| Summary of Call | Extended shift charges for Dedicated |
| Detail of Fix | Use system parameter SHIFT_ADDITIONAL_HOURS to calculate additional shift charges |
| Set-up and Configuration |
| New Parameters | |||
|---|---|---|---|
| Parameter Name | Config Level | Setting Value | Result |
| SHIFT_ADDITIONAL_HOURS | COST CENTRE | NUMERIC VALUE OF HOURS | THE NUMBER OF HOURS BEFORE ADDITIONAL SHIFT CHARGES ARE APPLIED |
OBS Log Number:: 358029
| Customer Ref: | NO REF |
| Summary of Call | Copy contract not working |
| Detail of Fix | Fix issue with pop list on counter party when copying contracts. |
| Set-up and Configuration | No set-up/configuration required |
OBSL PRODUCT DEVELOPMENT
OBS Log Number:: 357599
| Summary of Call | Update tractor in tomtom when change tms |
| Detail of Fix | Changing tractor on a trip already Accepted will send a delete for old tractor and an insert for new tractor to TomTom. |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number:: 358527
| Summary of Call | Trunk trips at accepted status update |
| Detail of Fix | The trunk trips that are assessed in the Home scheduling engine will be made available when they are ACCEPTED as well as PLANNED or TENDERED.
The capacity checks for the carrier will assess a null order weight as 0 against the shipment weights. |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number:: 352358
| Summary of Call | CTMS-WCS location enquiry |
| Detail of Fix | |
| Set-up and Configuration | No set-up/configuration required |
OBS Log Number:: 358593
| Summary of Call | Scheduling engine - performance |
| Detail of Fix | |
| Set-up and Configuration | No set-up/configuration required |
MODULES DELIVERED
| Module Name | Version No | Description | Log Number |
|---|---|---|---|
| AT_PAR_TRIP_DTL_358988.sql | 1.1 | Alter Table Script | 358988 |
| ACC.sql | 5.76 | Accounts package | 359823 |
| CNT.sql | 5.51 | Contracts package | 359031 |
| CONTRACT.fmx | 2.71 | Contracts Form | 358029 |
| CONTRACT.fmx | 2.72 | Contracts Form | 358043 |
| DATA_ADM_SYSTEM_PARAM_357843.sql | 1.1 | Data Script | 357843 |
| DATA_ADM_SYSTEM_PARAM_357921.sql | 1.1 | Data Script | 357921 |
| DATA_ADM_SYSTEM_PARAM_357984.sql | 1.1 | Data Script | 357984 |
| DATA_ADM_SYSTEM_PARAM_358989.sql | 1.1 | Data Script | 358989 |
| DATA_ADM_SYSTEM_PARAM_CONFIG_357843.sql | 1.1 | Data Script | 357843 |
| DATA_ADM_SYSTEM_PARAM_CONFIG_357984.sql | 1.1 | Data Script | 357984 |
| DATA_IMP_FIELD_358802.sql | 1.1 | Data Script | 358802 |
| DATA_IMP_FIELD_358988.sql | 1.1 | Data Script | 358988 |
| DATA_ORS_MASTER_DATA_358065.sql | 1.1 | Data Script | 358065 |
| DATA_ORS_SQL_358065.sql | 1.1 | Data Script | 358065 |
| DATA_SCH_ORD_STATUS_357921.sql | 1.1 | Data Script | 357921 |
| DP_ASSET_SCANNING.sql | 5.47 | Tag to Asset Scanning | 357263 |
| DP_CSV_GEN.sql | 1.5 | Generic CVS package | 358817 |
| DP_CSV5.sql | 1.75 | Fifth CSV extract package | 359976 |
| DP_EPOD_WEB_SERVICE.sql | 1.120 | EPOD Web Service | 358130 |
| DP_EPOD_WEB_SERVICE.sql | 1.121 | EPOD Web Service | 358668 |
| DP_INVOICE_XML.sql | 1.11 | Invoice XML Package | 357922 |
| DP_LOGIX.sql | 1.10 | Package for LOGIX Interfaces | 358222 |
| DP_RDT_INTERNAL.sql | 5.7 | Interface to WCS | 352358 |
| DP_REPORTS.sql | 5.58 | Reports package | 357903 |
| DP_REPORTS.sql | 5.59 | Reports package | 358065 |
| DP_SCHEDULING_ENGINE.sql | 5.146 | Scheduling Package | 358222 |
| DP_SCHEDULING_ENGINE.sql | 5.147 | Scheduling Package | 358446 |
| DP_SCHEDULING_ENGINE.sql | 5.148 | Scheduling Package | 358527 |
| DP_SCHEDULING_ENGINE.sql | 5.149 | Scheduling Package | 358593 |
| DP_SHIPMENT.sql | 5.10 | Shipment Code package | 357797 |
| DP_SHIPMENT.sql | 5.12 | Shipment Code package | 358135 |
| DP_SHIPMENT.sql | 5.13 | Shipment Code package | 358596 |
| DP_SHIPMENT.sql | 5.14 | Shipment Code package | 358745 |
| DP_SHIPMENT.sql | 5.15 | Shipment Code package | 358932 |
| DP_SHIPMENT.sql | 5.16 | Shipment Code package | 359031 |
| DP_SHIPMENT.sql | 5.17 | Shipment Code package | 359291 |
| DP_SHIPMENT.sql | 5.18 | Shipment Code package | 359823 |
| DP_TOMTOM.sql | 1.33 | TomTom Package | 357599 |
| IMP.sql | 5.190 | CSV Imports Package | 358098 |
| IMP.sql | 5.191 | CSV Imports Package | 358988 |
| IMP.sql | 5.192 | CSV Imports Package | 358802 |
| INT_XML_IN.sql | 5.192 | Order Import Package | 357797 |
| INT_XML_IN.sql | 5.193 | Order Import Package | 358395 |
| INT_XML_OUT2.sql | 5.290 | Outbound XML Package | 358454 |
| INT_XML_OUT2.sql | 5.291 | Outbound XML Package | 360098 |
| INV.sql | 5.42 | Invoice Package | 357841 |
| INV.sql | 5.43 | Invoice Package | 359823 |
| INVOICES.fmx | 2.60 | Invoices Screen | 359823 |
| LOGIX_INT.fmx | 10.4 | Form for LOGIX Interface | 358222 |
| OF_INT.sql | 5.51 | Oracle Financials interface | 359823 |
| OMS.sql | 5.220 | Order package | 357921 |
| OMS.sql | 5.221 | Order package | 358446 |
| OMS.sql | 5.222 | Order package | 359072 |
| ORDERS.fmx | 2.420 | Order Screen | 357921 |
| ORDERS.fmx | 2.421 | Order Screen | 358572 |
| ORDERS_WIDE.fmx | 1.23 | Orders Screen | 357921 |
| PAR.sql | 5.102 | Paragon Interface | 357972 |
| PAR.sql | 5.103 | Paragon Interface | 358381 |
| PAR.sql | 5.104 | Paragon Interface | 358988 |
| PLANNING.fmx | 1.107 | Planning Screen | 358612 |
| RATE.sql | 5.153 | Rates Tariff database package | 357984 |
| SHIPMENT_INVOICE.rep | 1.2 | Shipment Invoice Report | 359823 |
| TRG_DRY_ICE.sql | 1.19 | Trigger | 357862 |
| TRG_GEL_PACKS.sql | 1.14 | Trigger | 357862 |
| TRG_SCH_ORD_EQUIP_SERVICES.sql | 5.6 | Database Trigger Script | 357862 |
| TRG_SCH_ORD_LABOUR_SERVICES.sql | 5.5 | Database Trigger Script | 357862 |
| TRG_SCH_ORD_SERVICES.sql | 5.8 | Database Trigger Script | 357862 |
| TRG_SCH_TRIP_XML_INT.sql | 5.31 | Trigger | 357599 |
| TRG_SOM_SUPP_CONF.sql | 5.20 | Trigger | 360118 |
| TRIPDTL.fmx | 2.223 | Trip Debrief | 357921 |
| TRM.sql | 5.186 | Trip manipulation package | 357843 |
| TRM.sql | 5.187 | Trip manipulation package | 357921 |
| TRM.sql | 5.188 | Trip manipulation package | 357812 |
| TRM.sql | 5.189 | Trip manipulation package | 358989 |
| TRM.sql | 5.190 | Trip manipulation package | 359823 |
ADDITIONAL CHANGES
WCS
A WCS change is required for the following logs:
- Log
OR
There are no WCS changes required.
EPOD/T2A
An ePOD/T2A change is required for the following logs:
- Log 357263: T2A change v3.0.0.8
MCS
An MCS change is required for the following logs:
- Log
OR
There are no MCS changes required.
PORTAL/TTM
A Portal change is required for the following logs:
- Log
OR
There are no Portal changes required.
EDI
An EDI change is required for the following logs:
- Log
OR
There are no EDI changes required.
