PATCH C-TMS 11.0 P026

From Calidus HUB
Revision as of 13:36, 20 September 2017 by StylesC (talk | contribs)





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS TMS

12th September 2017 - 1.0
Reference: P026











































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: New Screen/Billing

OBS Log Number: 342512
Reporter: Hayley Keegan
Summary of Call CR: New Screen/Billing Tab For Transport
Detail of Change/Fix New Warehouse module to allow warehouse and adhoc charges to be recorded, invoiced and exported to CARGOWISE. New cost types, payment types, services to be created by the user as per functional spec.
Set-up and Configuration No set-up/configuration required


Customer Ref: Customer Label

OBS Log Number: 343745
Reporter: Hayley Keegan
Summary of Call Add full address to label for customer
Detail of Change/Fix Added new cost centre parameter SHOW_FULL_ADDRESS which will allow printing of the full delivery address on labels, also the SHOW_CONTACT parameter to show contact details on the label, also a customer flag that will allow that customers orders to show the full delivery address on labels
Set-up and Configuration No set-up/configuration required


Customer Ref: CR- HS TV Screen

OBS Log Number: 340225
Reporter: Dave Meir
Summary of Call Portal Despatch Board for TV in HS
Detail of Change/Fix Overload T2A to be at item level.
Set-up and Configuration No set-up/configuration required


Customer Ref: DS-ALBGDV

OBS Log Number: 342369
Reporter: Denis Starodubov
Summary of Call Integrate with new customer
Detail of Change/Fix The customer carrier will be integrated into C-TMS. The gazetteer import process will need to be setup and imported using the customer format name. Both the Postcode and Service files must be present for a new gazetteer to be imported successfully. The new system parameter CARR_GAZ_POSTCODE_FORMAT will need to store the gazetteer format(s) that provide the postcode without distinction between the outer and inner sections of the postode. The new tab pages, import processes and report will need to be authorised for the appropriate user groups. The customer carrier will need to be configured for its label and manifest formats, and tracking references.
Set-up and Configuration
Registry/Rules Settings
Path & Name Setting Value Result
CARR_GAZ_POSTCODE_FORMAT SYSTEM

Description:

'For which carrier gazetteer formats will the postcode in the file exclude spaces. (List delimited with semi-colons)'

Result:

If the gazetteer import format name is listed in this system parameter it means that the gazetteer file from the carrier will not include a space in the postcode to distinguish between the outer and inner sections of the postcode. This system parameter is expected to be used for ‘Gazetteer DHL ESD’ but it could apply to ‘Gazetteer Polarspeed’ too in the future. This system parameter will not apply to the ‘Gazetteer UKMail’ and ‘Gazetteer Yodel’ import format names because they include their own internal logic.


Customer Ref: SCR-335287-26

OBS Log Number: 343102
Reporter: Mike Heslop
Summary of Call DOM Label Format Report
Detail of Change/Fix The system parameter TRIP_LABELS will be used to enable a menu option called Print Labels in the trip tree in the Planning screen. When the value is not N for the cost centre of the trip, the menu option will not be visible. The system parameter will be used to specify the Oracle Report to be run to print the labels. The Oracle Report will also need to be authorised for the user groups for use in the Reports screen.
Set-up and Configuration
Registry/Rules Settings
Path & Name Setting Value Result
TRIP_LABELS COST_CENTRE Specifies which Oracle Report will be run from the Planning screen to print the labels for the trip.

A report will not be run should this system parameter not specify a report and the 'Print Labels' menu option will not be visible in the trip tree.


Customer Ref: SCR-335287-56

OBS Log Number: 343117
Reporter: Mike Heslop
Summary of Call DOM CTMS-EPOD Send Item Description
Detail of Change/Fix Send item description to EPOD
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-335287-53 & 10

OBS Log Number: 343123
Reporter: Mike Heslop
Summary of Call Message to Customer
Detail of Change/Fix New SMS and Email messages for Customer
Set-up and Configuration No set-up/configuration required


Customer Ref: CR-31

OBS Log Number: 343127
Reporter: Dave Meir
Summary of Call Modify the Trip Sheet
Detail of Change/Fix Reconfigure heading section and allow multiple reference lines.
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-335287-28

OBS Log Number: 343377
Reporter: Tony Walker
Summary of Call Manifest POD Report
Detail of Change/Fix New bespoke Manifest Report including delivery and collection notes.
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-335287-31

OBS Log Number: 343378
Reporter: Tony Walker
Summary of Call Invoicing Report
Detail of Change/Fix New extract for exports with the required order and payment information included
Set-up and Configuration No set-up/configuration required


Customer Ref: 8CR-335287-46A & 46B

OBS Log Number: 343380
Reporter: Tony Walker
Summary of Call Trunk Schedule Changes
Detail of Change/Fix Trunk Scheduling changes to the scheduling engine
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-335287-57

OBS Log Number: 343382
Reporter: Tony Walker
Summary of Call CR: SMS Notification
Detail of Change/Fix New web service to handle SMS replies from customers to accept or decline an offered delivery slot.
Set-up and Configuration No set-up/configuration required


Customer Ref: DS-ANXH4Z

OBS Log Number: 344228
Reporter: Denis Starodubov
Summary of Call RIO: Add data fields to Extract Suite
Detail of Change/Fix New Carrier Manifest ORS extract
Set-up and Configuration No set-up/configuration required


Customer Ref: JA-AP7DY4

OBS Log Number: 344363
Reporter: Jakub Adamski
Summary of Call RIO: Additional fields to extract suite
Detail of Change/Fix Changes to ORS to allow reporting on order references
Set-up and Configuration No set-up/configuration required


Customer Ref: DS-APPFGS

OBS Log Number: 344686
Reporter: Denis Starodubov
Summary of Call RIO: Additional logic for Prospero 2
Detail of Change/Fix Allows specific planning regions to be excluded from scheduling engine, using parameter TRM_EXCL_REG_AUTO
Set-up and Configuration No set-up/configuration required


Customer Ref: DOM-PORTAL:ADD-1

OBS Log Number: 345205
Reporter: Graham Rothwell
Summary of Call Site ID required in Portal Package
Detail of Change/Fix New function to determine EPOD site for a given order based on delivery trips carrier.
Set-up and Configuration No set-up/configuration required


SUPPORT INCIDENTS

Customer Ref: 343877

OBS Log Number: 343877
Reporter: Peter Blackburn
Summary of Call Customer DU query
Detail of Change/Fix Amendment to Cust RPE tab on Resources screen so save button does not cause duplication of the record.
Set-up and Configuration No set-up/configuration required


Customer Ref: 344107

OBS Log Number: 344107
Reporter: Tina Kinsella
Summary of Call Problem amending RPI in contract
Detail of Change/Fix Update index calculation if contract has been generated and the index record is amended
Set-up and Configuration No set-up/configuration required


Customer Ref: 344322

OBS Log Number: 344322
Reporter: Matthew Tipping
Summary of Call Release of CUST_COST
Detail of Change/Fix Release of form and script
Set-up and Configuration No set-up/configuration required


Customer Ref: 344480

OBS Log Number: 344480
Reporter: Hayley Keegan
Summary of Call Issue from Route - To Route trip screen
Detail of Change/Fix Amendment to population of the unscheduled order well to put the radial route code for the from/to locations into the correct fields in the display block.
Set-up and Configuration No set-up/configuration required


Customer Ref: 344518

OBS Log Number: 344518
Reporter: Michelle Naumovski
Summary of Call Can't access carrier rules maintenance
Detail of Change/Fix Carrier rules maintenance to correct for build of data selection query when user has multiple cost centres in their user parameters.
Set-up and Configuration No set-up/configuration required


Customer Ref: 344681

OBS Log Number: 344681
Reporter: Emily Collins
Summary of Call Add audit to print queue control
Detail of Change/Fix Audit button press in print control
Set-up and Configuration No set-up/configuration required


Customer Ref: INC19069223

OBS Log Number: 344711
Reporter: Damian Jackson
Summary of Call CTMS Location Export version
Detail of Change/Fix Location export . country now an optional parameter
Set-up and Configuration No set-up/configuration required


Customer Ref: 344805

OBS Log Number: 344805
Reporter: Emily Collins
Summary of Call Location Export
Detail of Change/Fix Location export - country code optional.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC19149299

OBS Log Number: 344836
Reporter: Daniel Hammond
Summary of Call Different info displayed on reports
Detail of Change/Fix Amendment to HCR format delivery note to sequence in correct stop sequence
Set-up and Configuration No set-up/configuration required


Customer Ref: INC19264281

OBS Log Number: 345056
Reporter: Lucy Brough
Summary of Call Rebook option is not working
Detail of Change/Fix Amendment to order copy procedure called when re-booking an order to generate and populate the order id correctly in situations where the OMS reference has reached 7 digits long.
Set-up and Configuration No set-up/configuration required


Customer Ref: 345130

OBS Log Number: 345130
Reporter: Paul Roscoe
Summary of Call Scheduling engine changes for SG - NZ
Detail of Change/Fix Changes to network routing for international orders to use cost centre of carrier instead of order.

Assess the delivery zone of the TRUNK and LINEHAUL routes for when there are multiple valid airport routes and to ensure that orders can be transported to a non-local airport for the delivery depot.

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


Customer Ref: 345244

OBS Log Number: 345244
Reporter: Matthew Tipping
Summary of Call Multi airport leg changes
Detail of Change/Fix Changes to the network routing for trunk trips to account for airports not only being used for their local deliveries but also to transit orders to other depots via their local airports. The assessment at the AIRPORT locations will search for an onward flight route if the order has been last at an RDC, or an airport collection route if the order has been last at another airport. The road hubs are setup as AIRPORT locations and they will behave the same way for ROAD transport. LINEHAUL between airports and between road hubs; TRUNK between airports and depots, and between road hubs and depots; RELAY between parks and depots; RADIAL for deliveries and collections.
Set-up and Configuration No set-up/configuration required


Customer Ref: 345281

OBS Log Number: 345281
Reporter: Ian Gaunt
Summary of Call Indexation factor not being included
Detail of Change/Fix Correct adjusted base cost on Supplier Invoice
Set-up and Configuration No set-up/configuration required


Customer Ref: INC19444290

OBS Log Number: 345379
Reporter: Daniel Hammond
Summary of Call Orders unscheduling from collection
Detail of Change/Fix Amendment to Paragon import process for the HCR environment to procedure at the end of the file load that does not leave any paragon orders at sched_coll status. If order is a not a collection from an RDC, i.e. a collection from a BRANCH for a return to a depot then the order is retained on the radial trip.
Set-up and Configuration No set-up/configuration required


Customer Ref: Jersey Manifest

OBS Log Number: 345162
Reporter: sew
Summary of Call Jersey Manifast main version
Detail of Change/Fix Add Jersey Manifest branch code back into main code
Set-up and Configuration No set-up/configuration required


Customer Ref: Jersey Manifest

OBS Log Number: 345182
Reporter: Suzanne Woodcock
Summary of Call Jersey Manifest following Invoice run
Detail of Change/Fix Changes to finance process to allow multiple VAT codes
Set-up and Configuration No set-up/configuration required


Customer Ref: INC18645743

OBS Log Number: 344034
Reporter: Karolina Mirga Danek
Summary of Call Shuttle order
Detail of Change/Fix Amendment to the database trigger that generates the control record that sends data to LOTS so the REN message is sent to LOTS when the customer reference is changed from Null to a value on an order generated from a template.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC19112898

OBS Log Number: 344775
Reporter: DAMIAN JACKSON
Summary of Call Re-book function not working
Detail of Change/Fix Amendment to Order re-book function to pre-populate the from location consistently using the from location of the latest load trip.
Set-up and Configuration No set-up/configuration required


Customer Ref: 344482

OBS Log Number: 344482
Reporter: Michelle
Summary of Call Portal Import NOT working
Detail of Change/Fix Remove check on last field as might not be applicable.
Set-up and Configuration No set-up/configuration required


Customer Ref: LABEL print

OBS Log Number: 344484
Reporter: Michelle
Summary of Call LABEL print / printing label issue
Detail of Change/Fix Both PDF and Zebra Labels amended to allow multiple contacts on the system and pick the main contact to display on the label
Set-up and Configuration No set-up/configuration required


Customer Ref: 344618

OBS Log Number: 344618
Reporter: Michelle
Summary of Call Genesearch outbound query
Detail of Change/Fix Allow audit of FTP send.
Set-up and Configuration No set-up/configuration required


TID CHANGES

OBS Log Number: 344225

Customer Ref: NO REF
Reporter: Hiren Patel
Summary of Call MSD POD files
Detail of Change/Fix Add headers to celesio POD files
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344329

Customer Ref: NO REF
Reporter: Jez
Summary of Call CTMS Extract using incorrect DATE
Detail of Change/Fix Change to OTM extract to use correct date
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344332

Customer Ref: NO REF
Reporter: Jez
Summary of Call CTMS Group Name to LOTS
Detail of Change/Fix Change to Lots message to omit TMS group name
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344497

Customer Ref: NO REF
Reporter: Jez
Summary of Call CTMS Import Audit not showing fail
Detail of Change/Fix Trap for invalid customer and report as failure in counts and file.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344547

Customer Ref: NO REF
Reporter: Denis Starodubov
Summary of Call Customer Labels
Detail of Change/Fix The customer ID will be set when the files are imported and the latest version will be available for selection when configuring the carrier label format. The manifest and label will display the customer reference of the CTMS order and not the delivery point reference.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344555

Customer Ref: NO REF
Reporter: Denis Starodubov
Summary of Call Paragon re-spin leaving blank drops
Detail of Change/Fix Even when the trip in C-TMS already matches the paragon route then still delete any empty stops and update times. Empty trips will be deleted when the system parameter PAR_SET_ALL_FROM_NEW is set to Y.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344740

Customer Ref: NO REF
Reporter: Denis Starodubov
Summary of Call DS - APPFUV Auto Scheduling
Detail of Change/Fix Changes to auto scheduling
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344851

Customer Ref: NO REF
Reporter: Jez
Summary of Call OTM Import Failure
Detail of Change/Fix Validiate vehcile type in import
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344921

Customer Ref: NO REF
Reporter: Denis Starodubov
Summary of Call Customer Label DS-ALBGDV
Detail of Change/Fix The customer labels and electronic manifests will be consistent:

Weight has been rounded up to the next highest whole number.

Collection date is the previous working day before the delivery date for the service level of the order.

The account postcode is from the originating depot of the order and not the despatching depot should the order be crossdocked.

The 2D barcode text does not mention customer name. The 2D barcode will contain the same data that is printed on the label.

The Customer Express tracking number for the shipment can be based on a 9 or 10 digit number:

The tracking number will always be 9 digits left padded with zeroes and with the 10th digit as a check digit.

The check digit will replace the 10th digit of the tracking number range should there be more than 9 digits.

Note that the collection date for customer electronic manifests will be stored in the STOP_PLANNED_ARRIVAL_DATE and STOP_PLANNED_DEPARTURE_DATE tags in the file for mapping.

The changes to the outbound EDI files will only present for electronic manifests for carriers that have a customer specific label format.

The other files for LOTS, LOAD, CITD, Microlise, etc. will not be changed.

The WEIGHT in the electronic manifest files will not be rounded up at the DU type level because the weights will be subtotalled and rounded up to the next highest whole number by external mapping.

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


OBS Log Number: 345082

Customer Ref: NO REF
Reporter: Suzanne Woodcock
Summary of Call CR: New Screen/billing Tab For Transport
Detail of Change/Fix The WAREHOUSE screen has been changed to include new functionality:

1. A 'Save Quantities' button exists in the 'Bulk Orders' page to save the monthly quantities without generating the payment for the customer service.

2. The 'Generate Services' button in the 'Bulk Orders' page will generate the payment for the customer service if the monthly quantity is first entered or updated or unchanged - the Generate Services button will not be dependent on changes being made to the monthly quantities for the payments to be created.

3. A 'Delete Service' button exists in the 'Customer Services' page to delete the current service provided that that service has not been included in an invoice. Any payments will also be deleted for the customer service.

4. Various changes have been made to ensure that the customer services are updated with the correct charges and that the selected records are those that are processed when the popup menus are used.

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


OBS Log Number: 345085

Customer Ref: NO REF
Reporter: Denis Starodubov
Summary of Call DS-ANXH4Z
Detail of Change/Fix Change to DU Tracking details in CARR MANF ORS extract
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345135

Customer Ref: NO REF
Reporter: Denis Starodubov
Summary of Call Customer 2D barcode
Detail of Change/Fix Update to customer label format to fix the 2d barcode
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345147

Customer Ref: NO REF
Reporter: Denis Starodubov
Summary of Call DS-ANXH4Z export data
Detail of Change/Fix Use child locations in carr manf extract where required
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345177

Customer Ref: NO REF
Reporter: Denis Starodubov
Summary of Call Customer label printing SQL error
Detail of Change/Fix Fix to enable the customer label to work for paragon trips
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345192

Customer Ref: NO REF
Reporter: Denis Starodubov
Summary of Call Import orders
Detail of Change/Fix Update for order import to fix line weight not being set
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345305

Customer Ref: NO REF
Reporter: Denis Starodubov
Summary of Call Customer 1D barcode
Detail of Change/Fix Customer 1D barcode additional space fix
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345306

Customer Ref: NO REF
Reporter: Denis Statodubov
Summary of Call DS-ANXH4Z extract
Detail of Change/Fix Change to qty calculation on CARR_MANF ORS extract
Set-up and Configuration No set-up/configuration required


OBS Log Number: 343881

Customer Ref: NO REF
Reporter: Rob Merrill
Summary of Call Issue with Stairwalker functionality
Detail of Change/Fix Set stair walker flag on collection or delivery tripd only. Display warning only when not enough stair walkers.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344606

Customer Ref: NO REF
Reporter: Paul Roscoe
Summary of Call Resource maintenance - Gazeteer deletion
Detail of Change/Fix The unused gazetteer versions can be deleted for the different label formats.

The current version of the routing data will be obtained from the mapped format should it differ to the label format for the carrier.

This current version will be used to obtain the routing data for the carrier labels and manifest reports.

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


OBS Log Number: 345040

Customer Ref: NO REF
Reporter: Rob Merrill
Summary of Call Manifest POD report
Detail of Change/Fix Fix part calculation and also re-prints.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345375

Customer Ref: ST-002 Domestic
Reporter: Dave Meir
Summary of Call TID - Planning Screen
Detail of Change/Fix Calculate total distance in miles for Planning form when appropriate parameter is set.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345376

Customer Ref: ST-003 Domestic
Reporter: Dave Meir
Summary of Call TID - Manifest Print
Detail of Change/Fix Add role so can be run from Planning form for all users.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345377

Customer Ref: ST-004
Reporter: Dave Meir
Summary of Call TID - Import of Trips from RO
Detail of Change/Fix Accumulate breaks, waits and layovers for next trip stop.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345393

Customer Ref: ST-005
Reporter: Dave Meir
Summary of Call TID - Manifest Print formatting fields
Detail of Change/Fix Correct printed time on report
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345415

Customer Ref: ST-008
Reporter: Dave Meir
Summary of Call TID - Schedule Engine
Detail of Change/Fix The Home Delivery Network Schedule version of the scheduling engine has been changed to calculate the next available date and time of the order and its early delivery date and time when it reaches its delivery depot based on the 'SCHED_ENG_DELIVERY' system parameters.

The current available date and time of the order will be used in the assessment based on when the order will arrive at the delivery depot.

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


OBS Log Number: 345503

Customer Ref: ST-009
Reporter: Dave Meir
Summary of Call TID - Access to SMTP server
Detail of Change/Fix Remove & characters from message processing package
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344644

Customer Ref: Direct Email
Reporter: Michelle Naumovski
Summary of Call International Auto-scheduling
Detail of Change/Fix Changes to the scheduling engine to check the delivery location when identifying a crossdock location in a collection zone
Set-up and Configuration No set-up/configuration required


OBSL PRODUCT DEVELOPMENT

OBS Log Number: 342642

Reporter: Dave Meir
Summary of Call Banned DU's and customer collections DPS
Detail of Change/Fix New restrictions of DU Types on Trailer Types for conrolling banned vehicles for PTV interface.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 342264

Reporter: Colin Lowe
Summary of Call MCS Despatch supress Completion of Trip
Detail of Change/Fix Suppress completion of a trip by MCS based on flags on location
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344770

Reporter: Peter Hill
Summary of Call Error with blank stop ID's
Detail of Change/Fix Fix for Microlise Direct Blank stop id errors
Set-up and Configuration No set-up/configuration required


OBS Log Number: 342696

Reporter: Murray Middleton
Summary of Call Customer Services Portal - CTMS Packages
Detail of Change/Fix New customer services functions and database views.

A new system parameter called ASSEMBLY_DU_TYPE can be configured by cost centre to store a default DU type for assembly.

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


OBS Log Number: 342739

Reporter: Tony Walker
Summary of Call Enhanced DPS Integration
Detail of Change/Fix Changes to PTV Route Optimiser for customer including Revenue, Priority and Banned Days. Need to manually configure vehicle types and groups, delivery zones and schedules etc.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344445

Reporter: Tony Walker
Summary of Call PROD: Display Revenue on all Trips
Detail of Change/Fix Allow revenue to be displayed on all trips, collection only or delivery trips only.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344668

Reporter: Matthew Tipping
Summary of Call Route Code to be sent to Microlise
Detail of Change/Fix New parameter to enable microlise direct to send route code in journey alias
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344498

Reporter: Matthew Tipping
Summary of Call V3 Testing - RTD Functionality
Detail of Change/Fix Epod V3 RTD jobs change
Set-up and Configuration No set-up/configuration required


OBS Log Number: 344862

Reporter: Matthew Tipping
Summary of Call Microlise - Arrive and Depart problems
Detail of Change/Fix Fix for Microlise incorrect stop times
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345060

Reporter: Matthew Tipping
Summary of Call Pallet ID not populating Item Entry
Detail of Change/Fix The order items for the orders that are created via Portal will be updated to have an identifier and a pallet/asset based on the OMS reference and a count of the number of items.

This functionality will be controlled by the system parameters ORD_CREATE_PORTAL_ITEMS_IDS and EPOD_PREVENT_ASSET_TRACKING when they are both set to Y and active for the cost centre of the order.

The new wide Order Details screen will be used to generate items for the order lines when the system parameter OMS_STD_ITEMS is set to Y and active for the cost centre of the order.

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


OBS Log Number: 344325

Reporter: Peter Hill
Summary of Call DP_scheduling_engine version control
Detail of Change/Fix f_assess_sched_rules changed to ensure derived windows are returned
Set-up and Configuration No set-up/configuration required


OBS Log Number: 345528

Reporter: Phil Harding
Summary of Call WMS/TMS Data Interaction development
Detail of Change/Fix WMS TMS Interface
Set-up and Configuration No set-up/configuration required


MODULES DELIVERED

Module Name Version No Description Log Number
ACC.sql 5.67 Accounts package 345082
ACC_MAINT.fmx 2.81 Accounts Maintenance 342512
ACC_MAINT.fmx 2.83 Accounts Maintenance 345082
AGREEMENTS.fmx 2.39 Agreements Screen 344107
AT_ACC_PAYMENT_TYPE_342512.sql 1.1 Alter Table Script 342512
AT_ACC_SERVICES_342512.sql 1.1 Alter Table Script 342512
AT_GAZ_UKMAIL_POSTCODE_344547. 1.1 Alter Table Script 344547
AT_GEO_LOCATION_342264.sql 1.1 Alter Table Script 342264
AT_ORG_CUSTOMER_327668.sql 1.1 Alter Table Script 345528
AT_ORG_CUSTOMER_342512.sql 1.1 Alter Table Script 342512
AT_ORG_CUSTOMER_343745.sql 1.1 Alter Table Script 343745
AT_SCH_ORD_343000.sql 1.1 Alter Table Script 343123
AT_SCH_ORD_TRACKING_327668.sql 1.1 Alter Table Script 345528
CARRIER_MANIFEST_DHLEXP.rep 1.16 Carrier Manifest 344606
CARRIER_MANIFEST_UKMAIL.rep 1.2 Carrier Manifest Report 342369
CARRIER_MANIFEST_UKMAIL.rep 1.4 Carrier Manifest Report 344547
CARRIER_RULES.fmx 1.14 Carrier Rules Maintenance Screen 344518
CT_1_INT_TMS_WMS_CONTROL_32766 1.1 Create Table Script 345528
CT_2_INT_TMS_WMS_MAINT_327668. 1.1 Create Table Script 345528
CT_3_INT_TMS_WMS_PARAMS_327668 1.1 Create Table Script 345528
CT_4_INT_TMS_WMS_CONTACTS_3276 1.1 Create Table Script 345528
CT_6_INT_TMS_WMS_PARAMS_CUST_3 1.1 Create Table Script 345528
CT_8_SEQ_INT_TMS_WMS_CONTROL_3 1.1 Create Table Script 345528
CT_9_SEQ_INT_TMS_WMS_MAINT_327 1.1 Create Table Script 345528
CT_ACC_ADHOC_SERVICES_342512_1 1.1 Create Table Script 342512
CT_ACC_BULK_PACKAGING_342512.s 1.2 Create Table Script 342512
CT_ACC_BULK_PACKAGING_CHARGES_ 1.4 Create Table Script 342512
CT_ACC_SERVICE_CONTAINERS_3425 1.1 Create Table Script 342512
CT_ACC_SERVICE_SLIDING_CHARGES 1.2 Create Table Script 342512
CT_GAZ_UKMAIL_342369.sql 1.1 Create Table Script 342369
CT_GAZ_UKMAIL_POSTCODE_342369. 1.1 Create Table Script 342369
CT_GAZ_UKMAIL_SERVICE_342369.s 1.1 Create Table Script 342369
CT_ORG_CUST_DEL_INSTR_344322.s 1.1 Create Table Script 344322
CT_RES_TRAILER_DU_RESTRICT_342 1.1 Create Table Script 342642
CT_SEQ_ACC_ADHOC_SERVICES_3425 1.1 Create Table Script 342512
CT_SEQ_GAZ_ID_UKMAIL_342369.sq 1.1 Create Table Script 342369
CT_SEQ_SO_BOOK_REF_342696.sql 1.1 Create Table Script 342696
CT_SEQ_SRA_ID_343382.sql 1.1 Create Table Script 343382
CT_SLOT_REPLY_AUDIT_343382.sql 1.1 Create Table Script 343382
CUST_COST.fmx 2.118 Customer Maintenance form 344322
CUST_COST.fmx 2.119 Customer Maintenance form 343745
CUST_COST.fmx 2.120 Customer Maintenance form 342512
CUST_COST.fmx 2.121 Customer Maintenance form 343378
CUST_COST.fmx 2.122 Customer Maintenance form 345528
DATA_1_IMP_IMPORT_TYPE_342369. 1.1 Data Script 342369
DATA_2_IMP_FIELD_342369.sql 1.1 Data Script 342369
DATA_ADM_FORM_TAB_327668.sql 1.1 Data Script 345528
DATA_ADM_FORM_TAB_342369.sql 1.1 Data Script 342369
DATA_ADM_LOG_PROG_NAME_327668. 1.1 Data Script 345528
DATA_ADM_LOG_PROG_NAME_343382. 1.2 Data Script 343382
DATA_ADM_SYSTEM_PARAM_342369.s 1.1 Data Script 342369
DATA_ADM_SYSTEM_PARAM_342696.s 1.1 Data Script 342696
DATA_ADM_SYSTEM_PARAM_342739.s 1.1 Data Script 342739
DATA_ADM_SYSTEM_PARAM_343102.s 1.1 Data Script 343102
DATA_ADM_SYSTEM_PARAM_343117.s 1.1 Data Script 343117
DATA_ADM_SYSTEM_PARAM_343123.s 1.1 Data Script 343123
DATA_ADM_SYSTEM_PARAM_343380.s 1.1 Data Script 343380
DATA_ADM_SYSTEM_PARAM_343745.s 1.1 Data Script 343745
DATA_ADM_SYSTEM_PARAM_344668.s 1.1 Data Script 344668
DATA_ADM_SYSTEM_PARAM_344686.s 1.1 Data Script 344686
DATA_ADM_SYSTEM_PARAM_344740.s 1.1 Data Script 344740
DATA_ADM_SYSTEM_PARAM_CONFIG_3 1.1 Data Script 343745
DATA_ADM_SYSTEM_PARAM_CONFIG_3 1.1 Data Script 343102
DATA_ADM_SYSTEM_PARAM_CONFIG_3 1.1 Data Script 343117
DATA_ADM_SYSTEM_PARAM_CONFIG_3 1.1 Data Script 343123
DATA_ADM_SYSTEM_PARAM_CONFIG_3 1.1 Data Script 344740
DATA_ADM_SYSTEM_PARAM_CONFIG_3 1.1 Data Script 343380
DATA_ADM_SYSTEM_PARAM_CONFIG_3 1.1 Data Script 344686
DATA_ADM_SYSTEM_PARAM_CONFIG_3 1.1 Data Script 342696
DATA_AUTO_SCHEDULING_ENGINE_34 1.1 Data Script 343380
DATA_DP_INT_TMS_WMS_IN_327668. 1.1 Data Script 345528
DATA_IMP_DECODE_327668.sql 1.1 Data Script 345528
DATA_IMP_DECODE_ENTRY_327668.s 1.1 Data Script 345528
DATA_IMP_DECODE_ENTRY_342696.s 1.1 Data Script 342696
DATA_IMP_DECODE_TYPE_327668.sq 1.1 Data Script 345528
DATA_IMP_FIELD_327668.sql 1.1 Data Script 345528
DATA_MSG_SMS_FORMAT_343123.sql 1.1 Data Script 343123
DATA_MSG_SMS_VALUES_343123.sql 1.1 Data Script 343123
DATA_ORS_MASTER_DATA_344228.sq 1.1 Data Script 344228
DATA_ORS_MASTER_DATA_344363.sq 1.1 Data Script 344363
DATA_ORS_MASTER_DATA_345085.sq 1.1 Data Script 345085
DATA_ORS_MASTER_DATA_345306.sq 1.1 Data Script 345306
DATA_ORS_SQL_344228.sql 1.1 Data Script 344228
DATA_ORS_SQL_345147.sql 1.1 Data Script 345147
DATA_REP_REPORT_342369.sql 1.1 Data Script 342369
DATA_REP_REPORT_343102.sql 1.1 Data Script 343102
DATA_REP_REPORT_343377.sql 1.1 Data Script 343377
DATA_REP_REPORT_344711.sql 1.1 Data Script 344711
DATA_REP_REPORT_PARAM_342369.s 1.1 Data Script 342369
DATA_REP_REPORT_PARAM_343102.s 1.1 Data Script 343102
DATA_REP_REPORT_PARAM_343377.s 1.1 Data Script 343377
DATA_REP_REPORT_PARAM_344547.s 1.1 Data Script 344547
DATA_RES_CARRIER_FORMATS_34236 1.1 Data Script 342369
DATA_RES_CARRIER_FORMATS_MAP_3 1.1 Data Script 342369
DATA_RES_LABEL_FORMATS_342369. 1.2 Data Script 342369
DATA_RES_LABEL_FORMATS_343745. 1.1 Data Script 343745
DATA_RES_LABEL_FORMATS_343921. 1.1 Data Script 344921
DATA_RES_LABEL_FORMATS_345135. 1.1 Data Script 345135
DOM_MANIFEST_POD.rep 1.2 Manifest Report 343377
DOM_MANIFEST_POD.rep 1.3 Manifest Report 345040
DOM_MANIFEST_POD.rep 1.4 Manifest Report 345376
DOM_MANIFEST_POD.rep 1.6 Manifest Report 345393
DP_CARRIER.sql 1.58 Carrier Management 343745
DP_CARRIER.sql 1.59 Carrier Management 342369
DP_CARRIER.sql 1.60 Carrier Management 344484
DP_CARRIER.sql 1.61 Carrier Management 344547
DP_CARRIER.sql 1.63 Carrier Management 344606
DP_CARRIER.sql 1.64 Carrier Management 344921
DP_CARRIER.sql 1.65 Carrier Management 345177
DP_CARRIER.sql 1.66 Carrier Management 345305
DP_CSV_DHL.sql 1.19 Export Package 344329
DP_CSV_POD.sql 1.4 CSV Package 344225
DP_CSV2.sql 5.75 Second CSV extract package 344805
DP_CUST_SERV.sql 1.1 Customer Service Package 343382
DP_CUST_SERV.sql 1.2 Customer Service Package 342696
DP_EPOD_WEB_SERVICE.sql 1.98 EPOD Web Service 343117
DP_EPOD_WEB_SERVICE.sql 1.99 EPOD Web Service 344498
DP_IMP_2.sql 1.65 Import Package 344482
DP_IMP_2.sql 1.67 Import Package 344497
DP_IMP_2.sql 1.68 Import Package 344851
DP_IMP_4.sql 4.2 Imports Package 345528
DP_IMP_GAZ.sql 1.7 Gazetteer Import Package 342369
DP_IMP_GAZ.sql 1.8 Gazetteer Import Package 344547
DP_INT_TMS_WMS_IN_STUB.sql 1.2 Inbound WMS/TMS Interface Package 345528
DP_INT_XML_CARPOD.sql 5.4 Database Package 342369
DP_INT_XML_MIC2.sql 1.18 CTMS to MIC Interface 344668
DP_INT_XML_MIC2.sql 1.19 CTMS to MIC Interface 344770
DP_INT_XML_MIC2.sql 1.20 CTMS to MIC Interface 344862
DP_LOGIX_DOM.sql 1.3 Logix Procedures 342642
DP_LOGIX_DOM.sql 1.4 Logix Procedures 342739
DP_LOGIX_DOM.sql 1.5 Logix Procedures 342696
DP_LOGIX_DOM.sql 1.6 Logix Procedures 345377
DP_MCS_SCANNING.sql 5.40 MCS Scanning Package 342264
DP_ORS_FUNCS.sql 5.25 Change to DOOD status function 344228
DP_ORS_FUNCS.sql 5.26 Change to DOOD status function 345306
DP_PORTAL.sql 5.16 Portal Package 340225
DP_PORTAL.sql 5.17 Portal Package 345205
DP_REPORTS.sql 5.44 Reports package 342369
DP_SCHEDULING_ENGINE.sql 5.114 Scheduling Package 344325
DP_SCHEDULING_ENGINE.sql 5.115 Scheduling Package 344644
DP_SCHEDULING_ENGINE.sql 5.117 Scheduling Package 344740
DP_SCHEDULING_ENGINE.sql 5.118 Scheduling Package 343380
DP_SCHEDULING_ENGINE.sql 5.120 Scheduling Package 344686
DP_SCHEDULING_ENGINE.sql 5.121 Scheduling Package 345130
DP_SCHEDULING_ENGINE.sql 5.122 Scheduling Package 345244
DP_SCHEDULING_ENGINE.sql 5.123 Scheduling Package 345415
DP_SCHEDULING_ENGINE.sql 5.124 Scheduling Package 345528
HCR_DELIVERY_NOTE.rep 1.25 HCR Delivery Note 344836
IMP.sql 5.152 CSV Imports Package 343123
IMP.sql 5.153 CSV Imports Package 345192
IMPORTS_EXEC.fmx 10.20 Import executions 342369
IMPORTS_MAINT.fmx 1.21 Import Maintenance Form 345528
INT_ERR.fmx 1.103 Interface Errors 345528
INT_XML_OUT2.sql 5.254 Outbound XML Package 342369
INT_XML_OUT2.sql 5.255 Outbound XML Package 344332
INT_XML_OUT2.sql 5.256 Outbound XML Package 344618
INT_XML_OUT2.sql 5.259 Outbound XML Package 344921
INV.sql 5.28 Invoice Package 343378
INV.sql 5.29 Invoice Package 342512
INV.sql 5.30 Invoice Package 345162
INVOICE_CUST_DUN.rep 1.21 Customer Invoice Report 345182
INVOICES.fmx 2.49 Invoices Screen 343378
INVOICES.fmx 2.50 Invoices Screen 342512
ITEM_LABELS_DOM.rep 1.5 Label Report 343102
LFS_LABEL.rep 1.20 Label Report 343745
LFS_LABEL.rep 1.21 Label Report 344484
LFS_LABEL_MULTI.rep 1.8 Label Report 343745
LFS_LABEL_MULTI.rep 1.9 Label Report 344484
LOCATION.fmx 2.180 Location Maintenance 342264
LOCATION.fmx 2.181 Location Maintenance 345528
LOCK_MONITOR.fmx 2.21 Lock Monitor 344681
MSG_PROCESSING.sql 5.55 Message Processing package 343123
MSG_PROCESSING.sql 5.56 Message Processing package 345503
NHSBT_MANIFEST.rep 1.5 Client specific manifest report 343127
OF_INT.sql 5.37 Oracle Financials interface 343378
OF_INT.sql 5.38 Oracle Financials interface 342512
OF_INT.sql 5.39 Oracle Financials interface 345182
OMS.sql 5.191 Order package 343117
OMS.sql 5.192 Order package 343123
OMS.sql 5.193 Order package 343380
OMS.sql 5.194 Order package 345060
OMS.sql 5.195 Order package 345056
OMS.sql 5.196 Order package 342696
ORDERS.fmx 2.389 Order Screen 344775
ORDERS_WIDE.fmx 1.8 Orders Screen 345060
ORION.mmx 1.44 Orion Menu 342512
ORS.sql 5.10 Oracle Reporting suite 344363
PAR.sql 5.83 Paragon Interface 344555
PAR.sql 5.84 Paragon Interface 345379
PAYMENTS.fmx 2.44 Payments Screen 342512
PLANNING.fmx 1.60 Planning Screen 342642
PLANNING.fmx 1.61 Planning Screen 343881
PLANNING.fmx 1.62 Planning Screen 343102
PLANNING.fmx 1.63 Planning Screen 343377
PLANNING.fmx 1.64 Planning Screen 345528
PLANNING.fmx 1.65 Planning Screen 345040
PLANNING.fmx 1.67 Planning Screen 345375
RATE.sql 5.132 Rates Tariff database package 344445
RESOURCE.fmx 2.181 Resource Maintenance form 342642
RESOURCE.fmx 2.182 Resource Maintenance form 343877
RESOURCE.fmx 2.186 Resource Maintenance form 342369
RESOURCE.fmx 2.187 Resource Maintenance form 344606
ROUTES_MAINT.fmx 2.46 Fixed Routes Maintenance 343380
SCHED_RULES.fmx 1.34 Scheduling Screen 342739
SUPPLIER_INVOICE.rep 2.20 Supplier Invoice Report 345281
TIU_TRIP_STATUS.sql 5.47 Trigger on SCH_TRIP for status change 343123
TRG_CNT_AGREEMENT_INDEX_BIU.sq 1.1 Trigger 344107
TRG_GAZ_UKMAIL_BIU.sql 1.1 Trigger 342369
TRG_GAZ_UKMAIL_POSTCODE_BIU.sq 1.1 Trigger 342369
TRG_GAZ_UKMAIL_SERVICE_BIU.sql 1.1 Trigger 342369
TRG_INT_TMS_WMS_CONTACTS_BIU.s 1.1 Trigger 345528
TRG_INT_TMS_WMS_CONTROL_BIU.sq 1.1 Trigger 345528
TRG_INT_TMS_WMS_MAINT_BIU.sql 1.1 Trigger 345528
TRG_INT_TMS_WMS_PARAMS_BIU.sql 1.1 Trigger 345528
TRG_INT_TMS_WMS_PARMS_CUST_BIU 1.1 Trigger 345528
TRG_SCH_ORD_DEL_TRP.sql 5.4 Trigger 345528
TRG_SCH_ORD_EARLY_DEL.sql 1.1 Trigger 343380
TRG_SCH_ORD_LOTS.sql 5.13 Trigger 344034
TRG_SCH_TRIP_XML_GEN.sql 5.11 Trigger 345528
TRG_SHA_LOAD_TRIPS.sql 1.3 Trigger 343123
TRG_SHA_XML_GEN.sql 5.9 Trigger 345528
TRG_SO_BOOK_STATUS.sql 1.1 Trigger 342696
TRG_SRA_BI.sql 1.1 Trigger 343382
TRG_STS_XML_GEN.sql 5.7 Trigger 345528
TRIPSUM.fmx 2.430 Trip Manipulation screen 344480
TRM.sql 5.160 Trip manipulation package 343881
V_BDM_REQUIREMENT_CS.sql 1.1 View 342696
V_ORD_BOOKING_STATUS.sql 1.1 View 342696
V_ORD_ORDER_CONTACT.sql 1.2 View 342696
V_ORD_ORDER_HEADER.sql 1.2 View 342696
V_ORD_ORDER_LINE.sql 1.1 View 342696
V_ORD_ORDER_LINE_ITEM.sql 1.1 View 342696
V_ORD_ORDER_LINE_ITEM_PROD.sql 1.1 View 342696
V_ORD_ORDER_STATUS.sql 1.1 View 342696
V_ORD_POSS_TRIP.sql 1.2 View 342696
V_ORD_REQUIREMENT.sql 1.1 View 342696
V_ORG_CUSTOMER.sql 1.1 View 342696
V_TRP_TRIP_STOP.sql 1.1 View 342696
WAREHOUSE.fmx 2.6 Warehouse Screen 342512
WAREHOUSE.fmx 2.8 Warehouse Screen 345082


ADDITIONAL CHANGES

WCS

There are no WCS changes required.


EPOD/T2A

An ePOD/T2A change is required for the following logs:

  • 343117
  • 344498


MCS

There are no MCS changes required.


PORTAL/TTM

A Portal change is required for the following logs:

  • 345205


EDI

An EDI change is required for the following logs:

  • 342369


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