PATCH CTMS P036

From Calidus HUB
Revision as of 13:35, 4 March 2020 by StylesC (talk | contribs)





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS TMS

20th Feb 2020 - 1.0
Reference: P036











































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: WREQ0031228

OBS Log Number: 357997
Summary of Call Empties actual flow.
Detail of Fix Changes to allow Actual empties to be matched and replaced on C-TMS
Set-up and Configuration No set-up/configuration required


Customer Ref: No Ref

OBS Log Number: 361892
Summary of Call Amendments to VDA4987 matches to VDA4933
Detail of Fix Changes to how the 4987 orders find a matching 4933 order
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0036862

OBS Log Number: 367512
Summary of Call New Invoicing development
Detail of Fix Changes to the Invoice processing and Shipment Extract
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0037013

OBS Log Number: 368441
Summary of Call New invoicing extract
Detail of Fix New Invoicing Extract for identifying payment and invoice issues
Set-up and Configuration No set-up/configuration required


Customer Ref: No Ref

OBS Log Number: 369093
Summary of Call HAM-MCS-Part complete despatch
Detail of Fix MCS scanning will be emabled to allow a user to handover scanning to another user for loading an unloading a trip. System parameter MCS_UPDATE_SCAN_IMMEDIATELY will enable this functionality when set to Y. System parameter MCS_RECEIVE_TO_PLAN will enforce the receipt scanning of packages and pallets to the planned trips when set to Y.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0024767 v3.0

OBS Log Number: 356056
Summary of Call GSN:Manifest to be sent to suppliers
Detail of Fix The 'NR Supplier Manifest' report will be made available for use in addition to the 'NR Driver Manifest' report.

The system parameter 'SEND_MANF_TO_SUPP' will be made available at the 'COST_CENTRE' and 'CUSTOMER' levels for configuration: a value of 'Y' will make the active the automatic generation of the 'NR Supplier Manifest' report when the trip status is set to 'ACCEPTED'.

The automatic generation will use the same configuration of the message requests as the existing 'NR Driver Manifest' report for 'TRIP_ACCEPT' for the 'Carrier' of the trip.

The 'NR Supplier Manifest' report will require a message request for the 'Postcode' of a collection location on the trip.

The 'SUPPLIER_MANF' system parameter must be set to 'NR_SUPP_MANF.rep' for the appropriate cost centre of the orders on the trip.

Set-up and Configuration No set-up/configuration required


Customer Ref: Schedule Engine

OBS Log Number: 361806
Summary of Call Scheduling Engine - two customers
Detail of Fix Changes to Zones to allow customers to be specified
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0033532

OBS Log Number: 362756
Summary of Call GSN:Asset Dwell Report-Valid assets
Detail of Fix New export to report asset dwelling
Set-up and Configuration No set-up/configuration required


Customer Ref: PO: 44010895168

OBS Log Number: 364692
Summary of Call HAM - Add Package Number to VANFLEET1
Detail of Fix Changes to the Vanfleet label to include the package number details
Set-up and Configuration No set-up/configuration required


Customer Ref: MCS

OBS Log Number: 365641
Summary of Call HAM Prevent MCS setting Trip status
Detail of Fix Changes to the MCS processing to allow locations to be configured to not set trips status to COMPLETED
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0035190

OBS Log Number: 365701
Summary of Call GSN: Unshedule multiple orders
Detail of Fix Changes to the order screens to allow unscheduling of multiple sched coll orders and searching and filtering based on van fleet field
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0035370

OBS Log Number: 365935
Summary of Call GSN:Create a new HC Delivery Note
Detail of Fix New Van Delivery Note, based on the existing version but producing POD paperwork at child location level.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0035624

OBS Log Number: 366435
Summary of Call GSN:Report changes
Detail of Fix The 'Receipt Scanning' export will include any contents (child assets) for the order items (parent assets). The 'On Time Items' export will include any contents (child assets) for the order items (parent assets). The counts will not include the child assets.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0037056

OBS Log Number: 368669
Summary of Call Modify ZETES/Athena Interface for Items
Detail of Fix The ZETES files will assess the format of the item identifiers based on a new system parameter ZET_INC_SSCC_PREFIX. When this parameter is set to Y for the cost centre of the order the format will be assessed to include a prefix for files from CTMS to ZETES or to exclude a prefix for files from ZETES to CTMS. This format is fixed as 05050210 or 202.
Set-up and Configuration No set-up/configuration required


Customer Ref: WREQ0037626

OBS Log Number: 369353
Summary of Call Modify Trip Sheet
Detail of Fix Changes to the Trip sheet formats, to include additional text
Set-up and Configuration No set-up/configuration required



SUPPORT INCIDENTS

Customer Ref:

OBS Log Number: Reporter:
Summary of Call
Detail of Fix
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
ACC.sql 5.80 Accounts package 369254
AT_ACC_INVOICE_367512.sql 1.1 AT Script 367512
AT_GEO_LOCATION_365641.sql 1.1 AT Script 365641
AT_GEO_LOCATION_ZONE_361806.sql 1.1 AT Script 361806
BDM.fmx 2.100 Business Data Form 361806
CSV.sql 5.118 CSV extract package 365630
CSV.sql 5.119 CSV extract package 368473
CT_TMP_MATCH_REPLACE_361892.sql 1.2 CT Script 361892
DATA_1_ORS_SQL_367012.sql 1.1 Data Script 367012
DATA_10_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_11_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_12_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_13_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_14_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_15_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_16_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_2_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_3_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_4_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_5_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_6_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_7_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_8_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_9_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_99_ORS_MASTER_DATA_367012.sql 1.1 Data Script 367012
DATA_ADM_SYSTEM_PARAM_365701.sql 1.1 Data Script 365701
DATA_ADM_SYSTEM_PARAM_366726.sql 1.1 Data Script 366726
DATA_ADM_SYSTEM_PARAM_367395.sql 1.2 Data Script 367395
DATA_ADM_SYSTEM_PARAM_368474.sql 1.1 Data Script 368474
DATA_ADM_SYSTEM_PARAM_368669.sql 1.1 Data Script 368669
DATA_ADM_SYSTEM_PARAM_368955.sql 1.1 Data Script 368955
DATA_ADM_SYSTEM_PARAM_369066.sql 1.1 Data Script 369066
DATA_ADM_SYSTEM_PARAM_369093.sql 1.1 Data Script 369093
DATA_ADM_SYSTEM_PARAM_CONFIG_368669.sql 1.1 Data Script 368669
DATA_I_1_ADM_SYSTEM_PARAM_356056.sql 1.1 Data Script 356056
DATA_I_2_ADM_SYSTEM_PARAM_CONFIG_356056.sql 1.1 Data Script 356056
DATA_I_3_MSG_RECIPIENT_TYPE_356056.sql 1.1 Data Script 356056
DATA_I_4_MSG_REQ_356056.sql 1.1 Data Script 356056
DATA_I_5_REP_REPORT_356056.sql 1.1 Data Script 356056
DATA_I_6_REP_REPORT_PARAM_356056.sql 1.1 Data Script 356056
DATA_IMP_FIELD_357997.sql 1.1 Data Script 357997
DATA_IMP_FIELD_361806.sql 1.1 Data Script 361806
DATA_ORS_MASTER_DATA_368228.sql 1.2 Data Script 368228
DATA_REP_REPORT_362756.sql 1.1 Data Script 362756
DATA_REP_REPORT_365935.sql 1.1 Data Script 365935
DATA_REP_REPORT_367264.sql 1.1 Data Script 367264
DATA_REP_REPORT_368441.sql 1.1 Data Script 368441
DATA_REP_REPORT_PARAM_362756.sql 1.1 Data Script 362756
DATA_REP_REPORT_PARAM_365935.sql 1.1 Data Script 365935
DATA_REP_REPORT_PARAM_367264.sql 1.1 Data Script 367264
DATA_REP_REPORT_PARAM_368441.sql 1.2 Data Script 368441
DATA_RES_LABEL_FORMATS_364692.sql 1.3 Data Script 364692
DP_CSV_DUN.sql 5.51 Client specific CSV extracts 365686
DP_CSV_DUN.sql 5.52 Client specific CSV extracts 367200
DP_CSV_DUN.sql 5.53 Client specific CSV extracts 368963
DP_CSV_NR.sql 5.56 NR CSV reports 368392
DP_CSV2.sql 5.77 Second CSV extract package 368441
DP_CSV2.sql 5.78 Second CSV extract package 370161
DP_CSV3.sql 5.35 Third CSV extract package 362756
DP_CSV5.sql 1.76 Fifth CSV extract package 367400
DP_CSV6.sql 1.40 CSV Extract package 366435
DP_EPOD_WEB_SERVICE.sql 1.125 EPOD Web Service 367440
DP_IMP_2.sql 1.77 Import Package 361806
DP_INVOICE_XML.sql 1.12 Invoice XML Package 362735
DP_LOGIX_CONFIG.sql 1.16 PTV Interface 361806
DP_LOGIX_DOM.sql 1.13 Logix Procedures 361806
DP_MCS_SCANNING.sql 5.49 MCS Scanning Package 365641
DP_MCS_SCANNING.sql 5.50 MCS Scanning Package 365830
DP_MCS_SCANNING.sql 5.52 MCS Scanning Package 366165
DP_MCS_SCANNING.sql 5.53 MCS Scanning Package 366346
DP_MCS_SCANNING.sql 5.54 MCS Scanning Package 366342
DP_MCS_SCANNING.sql 5.55 MCS Scanning Package 366711
DP_MCS_SCANNING.sql 5.56 MCS Scanning Package 366726
DP_MCS_SCANNING.sql 5.57 MCS Scanning Package 367068
DP_MCS_SCANNING.sql 5.58 MCS Scanning Package 367006
DP_MCS_SCANNING.sql 5.59 MCS Scanning Package 369066
DP_MCS_SCANNING.sql 5.60 MCS Scanning Package 369093
DP_PORTAL.sql 5.18 Portal Package 366424
DP_RDT_FAST_UNLOAD.sql 5.45 RF Unload Package 365686
DP_RDT_PREADVICE.sql 5.8 RDT Pre-advice Package 368474
DP_SCHEDULING_ENGINE.sql 5.157 Scheduling Package 361806
DP_SCHEDULING_ENGINE.sql 5.158 Scheduling Package 367610
DP_SCHEDULING_ENGINE.sql 5.159 Scheduling Package 368907
DP_SHIPMENT.sql 5.25 Shipment Code package 357997
DP_SHIPMENT.sql 5.27 Shipment Code package 361892
DP_SHIPMENT.sql 5.28 Shipment Code package 367512
DP_SHIPMENT.sql 5.29 Shipment Code package 369254
DP_WEB_SERVICE_ORD.sql 1.26 Web Service Package 365630
GEO.sql 5.36 Location Processing 368955
HCR_VAN_DELIVERY_NOTE.rep 1.1 HCR Delivery Note 365935
IMP.sql 5.195 CSV Imports Package 357997
IMP.sql 5.196 CSV Imports Package 367512
IMP.sql 5.197 CSV Imports Package 369369
IMP.sql 5.198 CSV Imports Package 368955
INT_XML_IN.sql 5.194 Order Import Package 357997
INT_XML_IN.sql 5.195 Order Import Package 361892
INT_XML_IN.sql 5.196 Order Import Package 367549
INT_XML_IN.sql 5.197 Order Import Package 368178
INT_XML_IN.sql 5.198 Order Import Package 369128
INT_XML_MIC.sql 5.147 MIC interface 369623
INT_XML_OUT2.sql 5.300 Outbound XML Package 368669
INT_XML_OUT2.sql 5.301 Outbound XML Package 369154
INV.sql 5.47 Invoice Package 367512
INV.sql 5.49 Invoice Package 368441
INVOICES.fmx 2.62 Invoices Screen 367512
LOAD_MAN.fmx 1.27 Load Management Form 368117
LOCATION.fmx 2.192 Location Maintenance 365641
MSG_MAINT.fmx 2.32 Message Maintenance screen 356056
MSG_PROCESSING.sql 5.70 Message Processing package 356056
NR_SUPP_MANF.rep 1.1 NR Supplier Manifest Report 356056
OF_INT.sql 5.59 Oracle Financials interface 357997
OF_INT.sql 5.60 Oracle Financials interface 367512
OF_INT.sql 5.61 Oracle Financials interface 369254
OMS.sql 5.228 Order package 365637
OMS.sql 5.229 Order package 361965
OMS.sql 5.230 Order package 361892
OMS.sql 5.231 Order package 361806
OMS.sql 5.232 Order package 367395
ORDERS.fmx 2.427 Order Screen 361965
ORDERS.fmx 2.429 Order Screen 365701
ORDERS_WIDE.fmx 1.26 Orders Screen 361965
ORDERS_WIDE.fmx 1.28 Orders Screen 365701
PAR.sql 5.107 Paragon Interface 366646
PAYMENTS.fmx 2.50 Payments Screen 367512
PLANNING.fmx 1.109 Planning Screen 357997
PLANNING.fmx 1.110 Planning Screen 365701
PLANNING.fmx 1.111 Planning Screen 367512
PRODUCT.fmx 2.54 Product form to maintain Volumetric data 366709
RATE.sql 5.157 Rates Tariff database package 367512
RATE.sql 5.158 Rates Tariff database package 369254
SHIPMENT_PALLETS.fmx 5.6 Shipment Pallets Form 366131
T_SCH_ORD_AUDIT.sql 5.17 Trigger for SCH_ORD_AUDIT 366240
T_SCH_ORDER_LINE_AUDIT.sql 1.4 Trigger 368406
TRG_SCH_ORD_ITEMS_ACTUALS.sql 1.6 Database Trigger Script 367068
TRG_SCH_ORD_ITEMS_ACTUALS.sql 1.7 Database Trigger Script 369066
TRIP_SHEET_DUNELM_DETAIL.rep 5.26 Driver Trip Sheet 369353
TRIPDTL.fmx 2.226 Trip Debrief 367512
TRM.sql 5.196 Trip manipulation package 361892
TRM.sql 5.197 Trip manipulation package 367610
V_MCS_SITE.sql 1.4 View 362654
WCS_MAINT.fmx 1.11 WCS Maintenance 368117


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

OR

There are no ePOD/T2A changes required.

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_CTMS_P036&oldid=8486’