PATCH C-TMS P034: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 228: Line 228:
|}
|}
-->
-->
== Customer Ref: ==
 
 
 
== Customer Ref: VDA4987 ==
{| width="100%"
{| width="100%"
|-
|width="30%"|'''OBS Log Number:'''  || '''Reporter:'''
|-
|-
|'''Summary of Call'''||  
|width="30%"|'''OBS Log Number:'''|| 357797
|-
|-
|'''Detail of Fix''' ||
|'''Summary of Call'''|| Amendments to VDA4987
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Detail of Fix''' || Changes for VDA4987
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
 
== Customer Ref: Trip Stops ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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''' || No set-up/configuration required
|}
 
== Customer Ref: Invoice totals ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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 ==
{| width="100%"
|-
|width="30%"|'''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
|}
|}


Revision as of 12:02, 23 August 2019





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS TMS

22nd Aug 2019 - 1.0
Reference: P034











































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 No set-up/configuration required


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 No set-up/configuration required


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 No set-up/configuration required


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:

Cust Ref: Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration


OBSL PRODUCT DEVELOPMENT

OBS Log Number:

Reporter:
Summary of Call
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.


Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=PATCH_C-TMS_P034&oldid=7816’