PATCH C-TMS 11.0 P028: Difference between revisions

From Calidus HUB
No edit summary
No edit summary
Line 1,731: Line 1,731:
|
|


 
|}


= ADDITIONAL CHANGES =
= ADDITIONAL CHANGES =

Revision as of 18:08, 26 February 2018





Aptean Logo.png







OBS Logistics Ltd

Release Notes


CALIDUS TMS

21st Feb 2018 - 1.0
Reference: P028












































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: Trip Barcode

OBS Log Number: 347527
Reporter: Matthew Tipping
Summary of Call Add Trip Barcode to Trip Sheet
Detail of Fix A barcode for the Trip ID will be displayed for scanning the trip onto a vehicle.
Set-up and Configuration No set-up/configuration required


Customer Ref: Temp at Desp

OBS Log Number: 347904
Reporter: Matthew Tipping
Summary of Call Trailer and Pallet Temp at Desp CTMS WCS
Detail of Fix Added functionality for trailer temperatures at despatch
Set-up and Configuration No set-up/configuration required


Customer Ref: Carrier in group name

OBS Log Number: 348431
Reporter: Matthew O'Grady
Summary of Call Microlise groupname - cust not Carrier
Detail of Fix Send Customer instead of carrier in group name for microlise direct.

New Parameter MIC_DIRECT_SEND_CUSTOMER

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

Customer Ref: KH-AP7C7D

OBS Log Number: 344948
Reporter: Kelly Hembling
Summary of Call RIO:Location ID's
Detail of Fix Do not inherit lat long information from parent address
Set-up and Configuration No set-up/configuration required


Customer Ref: CR-34

OBS Log Number: 346717
Reporter: Dave Meir
Summary of Call Alert Missing PO
Detail of Fix Add alert on trip status change if trip requires a PO Number
Set-up and Configuration No set-up/configuration required


Customer Ref: CR-35

OBS Log Number: 346721
Reporter: Dave Meir
Summary of Call Courier Booking FRM245
Detail of Fix Courier Booking electronic FRM245
Set-up and Configuration No set-up/configuration required


Customer Ref: KB-AVMHHX

OBS Log Number: 347277
Reporter: Dave Meir
Summary of Call FCA Inbound Shipment File
Detail of Fix New order item import for Fiat in fixed length file.
Set-up and Configuration No set-up/configuration required


Customer Ref: KB-AVMHNH

OBS Log Number: 347393
Reporter: Dave Meir
Summary of Call FCA Outbound POD File
Detail of Fix New outbound process for CLICK POD
Set-up and Configuration No set-up/configuration required


Customer Ref: KB-AVMHS4

OBS Log Number: 347394
Reporter: Dave Meir
Summary of Call FCA PCL Carrier Labels Print
Detail of Fix PCL carrier labels print screen
Set-up and Configuration No set-up/configuration required


Customer Ref: DS-ATBEB8

OBS Log Number: 347514
Reporter: Denis Starodubov
Summary of Call RIO:Paragon interface update-Prospero 2
Detail of Fix Changes to the outbound paragon file and inbound file and processing
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-335287-70

OBS Log Number: 347535
Reporter: Dave Meir
Summary of Call SCR: Zebra Label Changes B&W Logo
Detail of Fix The logo will be obtained for the 'Print Labels' menu option in the trip tree in the 'Planning' screen from the new system parameter called 'LOGO_FILE_BW' in preference to the existing system parameter 'LOGO_FILE' for when a black & white logo is preferred for printing.

The new system parameter will need to be updated from blank to the appropriate logo file when one has been identified for the system.

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


Customer Ref: KB-AVMHVF

OBS Log Number: 347574
Reporter: Dave Meir
Summary of Call UKMail Integration
Detail of Fix Amendments to allow FCA integration with UK Mail
Set-up and Configuration No set-up/configuration required


Customer Ref: KB-AVMHY5

OBS Log Number: 347604
Reporter: Dave Meir
Summary of Call Processing DEL with partial del failures
Detail of Fix Create CD reason for clean deliveries by Microlise when no reason provided.
Set-up and Configuration No set-up/configuration required


Customer Ref: KB-AVMHHX

OBS Log Number: 347707
Reporter: Dave Meir
Summary of Call 347277 - additional requirement
Detail of Fix Allow files longer than 256 characters, extract first 2 characters and ignore any lines not 'SP' and adjust some values (implied decimal places rather than being provided).
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-335287-66

OBS Log Number: 347713
Reporter: Mike Heslop
Summary of Call SMS Confirmation to Recipient
Detail of Fix Send SMS confirmation of processing of slot reply.
Set-up and Configuration No set-up/configuration required


Customer Ref: KB-AVMJ4A

OBS Log Number: 347749
Reporter: RMerrill
Summary of Call RIO:CSV Upload for Placement Orders
Detail of Fix Changes to TI_ORDER csv import for FIAT.
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-335287-65

OBS Log Number: 347766
Reporter: Mike Heslop
Summary of Call SCR: Booking Confirmation Email
Detail of Fix Domestic Order Confirmation Email
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-335287-67

OBS Log Number: 347769
Reporter: Mike Heslop
Summary of Call SCR: Failure handling and emailing
Detail of Fix Changes to the rebook functionality for Failed orders
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-335287-68

OBS Log Number: 347771
Reporter: Mike Heslop
Summary of Call SCR: Assembly applies only to Plat Plus
Detail of Fix The Account Maintenance screen has a new tick box and button to maintained services with Restricted Service Levels.

The 'Rstr Svce' box must be ticked to allow the restricted service levels to be maintained in a new screen.

Multiple active service levels may be listed for a service and they will be restricted in the Customer Service screen.

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


Customer Ref: 335287-69

OBS Log Number: 347874
Reporter: Dave Meir
Summary of Call SCR: Label changes for Supplier Portal
Detail of Fix Allow labels to be printed at stop level
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-335287-70

OBS Log Number: 348135
Reporter: Dave Meir
Summary of Call SCR: Zebra Label Changes Resizing
Detail of Fix Resized item labels report to fit zebra labels
Set-up and Configuration No set-up/configuration required


Customer Ref: SCR-355287-72

OBS Log Number: 348253
Reporter: Dave Meir
Summary of Call DEV: Print labels by supplier & schedule
Detail of Fix New Item labels report to run by schedule
Set-up and Configuration No set-up/configuration required


Customer Ref: PP-AUNLHU

OBS Log Number: 348273
Reporter: Piotr Plusa
Summary of Call RIO: Validate the invoice run every week
Detail of Fix New extract to report orders which have not generated payments. Extract to be generated automatically and emailed out to list of addresses.
Set-up and Configuration No set-up/configuration required


SUPPORT INCIDENTS

Customer Ref: Location Snapshop

OBS Log Number: 347094
Reporter: Matthew Tipping
Summary of Call WCS Location Snapshop incorrect Items
Detail of Fix Format item identifier in WCS extracts
Set-up and Configuration No set-up/configuration required


Customer Ref: Distribution charges

OBS Log Number: 347234
Reporter: Dave Meir
Summary of Call Not rating fully for orders
Detail of Fix Allowing distribution charges when carrier is not rating by contract
Set-up and Configuration No set-up/configuration required


Customer Ref: INC0365356

OBS Log Number: 347466
Reporter: Peter Blackburn
Summary of Call Rebook function is creating original
Detail of Fix On order import process remove trailing spaces on the customer order reference
Set-up and Configuration No set-up/configuration required


Customer Ref: Double mileage

OBS Log Number: 347504
Reporter: Suzanne Woodcock
Summary of Call Double mileage
Detail of Fix Amendment to look at actual distance first then planned in all scenarios
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20523262

OBS Log Number: 347591
Reporter: Simon Shearburn
Summary of Call Incorrect drive time displayed
Detail of Fix Amendment to customer trip sheet to calculate the total drive time from the sum of the time taken between stops.
Set-up and Configuration No set-up/configuration required


Customer Ref: Send driver name

OBS Log Number: 347974
Reporter: Matthew O'Grady
Summary of Call Microlise Interface sending driver name
Detail of Fix System parameter to control sending of driver id to Microlise
Set-up and Configuration No set-up/configuration required


Customer Ref: EDI Failure

OBS Log Number: 347982
Reporter: Michelle Naumovski
Summary of Call EDI Failure notifications in Production
Detail of Fix Additional content when records fail with an exception
Set-up and Configuration No set-up/configuration required


Customer Ref: MNX Import

OBS Log Number: 348059
Reporter: Michelle Naumovski
Summary of Call Issue with MNX import
Detail of Fix Allow locations to be loaded without the cust group and the default on the process to be used
Set-up and Configuration No set-up/configuration required


Customer Ref: INC21284577

OBS Log Number: 348089
Reporter: Denis Starodubov
Summary of Call Orders not being removed from well
Detail of Fix The validation of the order will write an audit record for the setting of the delivery type ('Delivery type set ...') and this audit record will have the latest order status.

This type of audit record will be written for 'Prospero' customers when the cost centre of the order has system parameter 'OMS_SET_DELIVERY_TYPE' set to 'Y'.

The order status must be the latest order status should the order audit record be assessed to determine the order status when the order is reset from status 'NEW' after being referred for Paragon planning but the order is not included on a changed route/trip.

The order will then not appear in the order well for trip planning if the order does have an actual status of 'SCHEDULED'.

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


Customer Ref: ORS report

OBS Log Number: 348268
Reporter: Michelle
Summary of Call Automated ORS report ENVER_DAILY
Detail of Fix Amendment to process called by EDI job running reporting suite reports so correctly handled sum and count columns in the extract.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC21502403

OBS Log Number: 348353
Reporter: Peter Blackburn
Summary of Call Log to Release fix for Import 348325
Detail of Fix Amendment to configurable EDI order import for line/item validation of product type on the supplied items.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC21629834

OBS Log Number: 348516
Reporter: Piotr Plusa
Summary of Call Wrong DU count number
Detail of Fix Amendment to invoicing package to correctly sum the breakdown by DU type on the invoice header sheet
Set-up and Configuration No set-up/configuration required


Customer Ref: ORS report

OBS Log Number: 348524
Reporter: Michelle Naumovski
Summary of Call ORS report issue
Detail of Fix Initialise variable data field used when generating the extract suite data query, so data select statement is correct.
Set-up and Configuration No set-up/configuration required


Customer Ref: Interface issues

OBS Log Number: 348613
Reporter: Dave Meir
Summary of Call Microlise interface issues
Detail of Fix Microlise interface sending wrong journey start
Set-up and Configuration No set-up/configuration required


Customer Ref: Export file

OBS Log Number: 348824
Reporter: Robert Kendrick
Summary of Call Missing data from export
Detail of Fix Amendment to Logix export file production for population of the DU type array to correctly accumulate into the array points when more than 1 DU type has been allocated the same point in the array.
Set-up and Configuration No set-up/configuration required


Customer Ref: Direct email

OBS Log Number: 348957
Reporter: Hayley Keegan
Summary of Call ADHOC Supporting Documents
Detail of Fix Reference the correct procedure for supporting documents when sending ADHOC exports
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20452865

OBS Log Number: 347428
Reporter: Piotr Plusa
Summary of Call CTMS invoice report to be changed
Detail of Fix Amendment to invoice for non-standard VAT
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20664526

OBS Log Number: 347853
Reporter: PIOTR PLUSA
Summary of Call CTMS amendment
Detail of Fix Amendment to address Zero VAT calculation issue and to allow Minimum Collection charges to inherit correct VAT code
Set-up and Configuration No set-up/configuration required


Customer Ref: INC20704112

OBS Log Number: 347929
Reporter: J Mismanos
Summary of Call Scanners find aged routes for 2015/2016
Detail of Fix Ensure delete template deletes all data.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC21831722

OBS Log Number: 348844
Reporter: Ignace Nunez
Summary of Call Delivery note issue
Detail of Fix Remove Special instructions from Delivery Note report
Set-up and Configuration No set-up/configuration required


TID CHANGES

OBS Log Number: 347335

Customer Ref: Order Consolidation
Reporter: Nev Robinson
Summary of Call TID - Consolidation of Genome orders
Detail of Fix Consolidate collections when pick up is at x-dock location
Set-up and Configuration No set-up/configuration required

OBS Log Number: 347496

Customer Ref: Child record update
Reporter: S Maskery
Summary of Call WCS unload scan not updating child asset
Detail of Fix Ensure assets are updated for child records
Set-up and Configuration No set-up/configuration required

OBS Log Number: 348416

Customer Ref: Export run
Reporter: Piotr Plusa
Summary of Call Unable to run export as overnight job
Detail of Fix Allow exports to run via EDI with blank parameters.
Set-up and Configuration No set-up/configuration required

OBS Log Number: 348621

Customer Ref: Order Consolidation
Reporter: Dan Hammond
Summary of Call CTMS rates
Detail of Fix Do not re-rate consolidated orders based on order status
Set-up and Configuration No set-up/configuration required

OBS Log Number: 348993

Customer Ref: DH - AHXKWF V1
Reporter: Daniel Hammond
Summary of Call Ref Rio DH - AHXKWF
Detail of Fix Remove payments for previously consolidated orders, if orders no longer rate
Set-up and Configuration No set-up/configuration required


OBSL PRODUCT DEVELOPMENT

OBS Log Number: 348299

Reporter: Tony Walker
Summary of Call TID: Import Decodes Carrier Lookup
Detail of Fix Add a look up to the carrier type decode and prevent a look up when there is not data available
Set-up and Configuration No set-up/configuration required

OBS Log Number: 348300

Reporter: Tony Walker
Summary of Call TID: TMS Interface Errors screen
Detail of Fix Update interface errors screen to catch errors for returned from executed block
Set-up and Configuration No set-up/configuration required

OBS Log Number: 348303

Reporter: Tony Walker
Summary of Call TID: Interface Errors on MAR msg
Detail of Fix Change labels to show correct use of error fields.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 346769

Reporter: Tony Walker
Summary of Call TID: Import Decodes fixes
Detail of Fix The WCS_IN import decode type will have a list of values in the Imports Maintenance screen based on the reason codes of type ITEM_NON_CON to validate the entries.
Set-up and Configuration No set-up/configuration required

OBS Log Number: 346772

Reporter: Tony Walker
Summary of Call TID: UNLOAD message
Detail of Fix A database script will alter a database table to extend the length of the event type for the TMS-WMS interface control records.
Set-up and Configuration No set-up/configuration required

OBS Log Number: 346777

Reporter: Tony Walker
Summary of Call TID: WMS Parameters and Contacts
Detail of Fix New message events for WMS_INT_FAIL for the WMS-TMS interface records.

Message requests can be setup in TMS:

Message type: WMS_INT_FAIL Medium: SMS or EMAIL Trigger: ORD, ORDA, ALC, PLIST, LOA, PACK or MAR Subject: Order Creation, Order Amendment, Allocation, Pick List, Pick Confirmation, Pack Confirmation or Despatch Confirmation Format: <ERR_MSAGE> (this will insert the error message in the EMAIL or SMS)

Triggers can also be setup for DBAI (database connectivity problems between WMS and TMS) or DBAO (database connectivity problems between TMS and WMS).

Each message trigger is optional.

These message events can be reviewed in the Medium Audit page in the Messaging Maintenance screen where the message events will also be setup in TMS.

The interface records themselves can be reviewed in the TMS-WMS and WMS-TMS pages in the Interface Errors screen as usual.

The owner in WMS can be setup to have an email address per interface message type and these addresses will be used to send emails for failed processes in WMS should they exist.

If they do not exist the equivalent message requests in TMS will be used (excepting database connectivity problems which must be generated out of the processing database).

If email or SMS are not setup a user will not be informed of any problems with the processing of the interface records.

Note that the database connectivity problems will require the message to be setup for MTS_OWNER user to control the message request and the recipients.

For this reason the WMS Params page in the Location Maintenance screen can be used to store the contacts for new 199 (WMS to TMS) and 299 (TMS to WMS) message types.

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


OBS Log Number: 346778

Reporter: Tony Walker
Summary of Call TID: Booking Reference in TMS
Detail of Fix The booking reference will be updated from TMS to WMS as well as from WMS to TMS.
Set-up and Configuration No set-up/configuration required

OBS Log Number: 346789

Reporter: Tony Walker
Summary of Call TID: PACK message
Detail of Fix Changes have been made to the TMS-WMS interface including:

1. Include parameter DEFAULT_PACKAGE_TYPE for PACK messages when the package type is not known.

2. Include parameter INC_MANDATED_CARRIER to orders to have a mandated carrier from the carrier of the sales order. Uses import decode WMS_CARRIER_MAPPING.

3. Set the actual weight not the planned weight an added item at pick/pack.

4. Set the actual despatched quantity of order lines for pick/pack to then calculate the actual despatched RPE quantity.

5. Only sets the order unpacked order lines to be zero packed if the order has been updated with actual pick containers.

6. An order line with zero planned quantity will be deleted for ORD/ORDA messages.

7. An order line with zero planned and packed quantity will be deleted for LOA messages.

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


OBS Log Number: 347517

Reporter: Dave Meir
Summary of Call TID - SMS reply webservice case sensitive
Detail of Fix Accept sms replies in upper and lower case
Set-up and Configuration No set-up/configuration required

OBS Log Number: 347576

Reporter: Dave Meir
Summary of Call TID - CSV Import with commas
Detail of Fix Import orders files will fail the set of data for the advised order reference across the ORDER_AND_LINE and LINE row types should the data be invalid at either level.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 347580

Reporter: Dave Meir
Summary of Call TID - CSV Import not setting PRECALL
Detail of Fix Change order validation so NOT BOOKED booking status can be changed to PRECALL id appropriate.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 347612

Reporter: Dave Meir
Summary of Call TID - Schedule Engine - Order Audit
Detail of Fix Changes to prevent additional audit records from being created
Set-up and Configuration No set-up/configuration required


OBS Log Number: 347650

Reporter: Dave Meir
Summary of Call TID - release from CS - dates problem
Detail of Fix Only update the delivery windows for Domestic if current windows are a slot.
Set-up and Configuration No set-up/configuration required

OBS Log Number: 347653

Reporter: Dave Meir
Summary of Call TID - Save in CS generates audit records
Detail of Fix Treat NULL as no change and 0 as delete. Also ensure audit changes only.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 347654

Reporter: Dave Meir
Summary of Call TID - ORA error from view
Detail of Fix Return maximum values in view when bigger than CAST size.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348000

Reporter: Dave Meir
Summary of Call TID: Labels long customer name
Detail of Fix Ensure labels do not wrap to a second page when name is too long.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348012

Reporter: Dave Meir
Summary of Call TID: PRECALL issue with release / offer
Detail of Fix Add PRECALL status to SMS/EMAIL process
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348056

Reporter: Dave Meir
Summary of Call TID-Additional audit for CS visibility
Detail of Fix Additional auditing for CS
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348072

Reporter: Suzanne Woodcock
Summary of Call TID: Collection failure on multi-trip
Detail of Fix Testing development plus amendments following Daves testing
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348084

Reporter: Dominic Murphy
Summary of Call TID: Manifest Barcode size change
Detail of Fix Changed barcorde encoding to enabled scanning
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348143

Reporter: Dave Meir
Summary of Call TID: X-Dock Planning - 1 day rule
Detail of Fix Allow cross dock process to update delivery windows as required for final scheduling
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348158

Reporter: Dave Meir
Summary of Call TID: manual X-Dock Planning-Form Change
Detail of Fix Changes to Manual cross docking to allow dates to be set based on schedules and delivery windows to be updated
Set-up and Configuration No set-up/configuration required


OBS Log Number: 347510

Reporter: Paul Jones
Summary of Call Populate booking_status column (issue)
Detail of Fix Don't set booking status if booking offered messages not active
Set-up and Configuration No set-up/configuration required


OBS Log Number: 347790

Reporter: Dave Meir
Summary of Call 405 Messages not being generated.
Detail of Fix Write all outbound Rf messages to msg log.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 347862

Reporter: Dave Meir
Summary of Call Issues with Label Printing
Detail of Fix Changes to label
Set-up and Configuration No set-up/configuration required


OBS Log Number: 347880

Reporter: Dave Meir
Summary of Call Label date is in the past
Detail of Fix The collection/job date for UKMail consignments will be offset by the required number of days:

The greatest value of the new system parameter 'CARR_SRVCE_LEVEL_OFFSET_DAYS' for the cost centre of the order and the carrier service level of the route for the trip.

Note that if the system parameter is not set, a default value of 1 day will be used to compare to the carrier service level.

The calculated collection/job date will be moved backwards to the previous working day of the route.

AAM is expected to set the carrier service level to 0 and the system parameter to 0: the collection/job date will then match the planned trip stop date for their overnight deliveries.

HCR is expected to set the carrier service level to 0 but not set the system parameter and thus use the existing default value of 1 for the system parameter that will not be configured: the collection/job date will then be the previous date to the planned trip stop date for their next day deliveries.

Therefore, not setup changes will be requried for HCR.

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


OBS Log Number: 347881

Reporter: Dave Meir
Summary of Call Issues with HB3 Item Interface
Detail of Fix The 'PROC_ITEM_FIX' import process has been changed to enable dealerships to be identified based on a decoded location when the file is first processed and when the failed file is reprocessed.

The dealership must exist decoded to a location for the order to the identified. The dealership can be stored up to 15 characters in length and decoded to a location up to 12 characters in length.

The OMS reference will be stored for the interface audit file when the order is created or updated successfully when the file is first processed or the file is reprocessed.

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


OBS Log Number: 347908

Reporter: Dave Meir
Summary of Call Planning configure layout no oversize
Detail of Fix Add Oversize to the Order well in the Planning screen
Set-up and Configuration No set-up/configuration required

OBS Log Number: 347910

Reporter: Dave Meir
Summary of Call LOTS message trigger/CSV upload
Detail of Fix Prevent updates of the external reference on existing orders which then trigger LOTS messages.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348536

Reporter: Dave Meir
Summary of Call TID - Webservice status return to spec
Detail of Fix Use Trip status for web service calls based on the value of system parameter WS_USE_TRIP_STATUS
Set-up and Configuration No set-up/configuration required


OBS Log Number: 348282

Reporter: Matthew Tipping
Summary of Call Loading Mgt screen. Hardcoded Trip sheet
Detail of Fix Add additional menu item to print a trip sheet, specified in the TRIP_SHEET system parameter
Set-up and Configuration No set-up/configuration required


OBS Log Number: 347849

Reporter: Paul Roscoe
Summary of Call Control records for manifests for trips
Detail of Fix A control record for the electronic manifest will be generated for the trip when the first order is assigned to the trip.

Any change of trip status or addition of an order to the trip will then generate a new electronic manifest with any changes.

The file will be generated if the PROCESS_INTERVAL is set to a number of minutes, no minutes or the EDI parameter does not exist (assessed as no minutes).

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


MODULES DELIVERED

| ACC_MAINT.fmx || 2.87 || Accounts Maintenance || 347771 |- | AT_ACC_SERVICES_347771.sql || 1.1 || Alter Table Script || 347771 |- | AT_INT_TMS_WMS_CONTROL_346772.sql || 1.2 || Alter Table Script || 346772 |- | AT_INT_TMS_WMS_MAINT_346789.sql || 1.1 || Alter Table Script || 346789 |- | AT_MSG_SMS_FORMAT_347769.sql || 1.1 || Alter Table Script || 347769 |- | AT_ORG_CUSTOMER_347574.sql || 1.1 || Alter Table Script || 347574 |- | AT_PAR_TRIP_DTL_347514.sql || 1.2 || Alter Table Script || 347514 |- | AT_SCH_ORD_AUDIT_ARCHIVE_348056.sql || 1.1 || Alter Table Script || 348056 |- | AT_SCH_ORD_NON_CONFORM_348072.sql || 1.1 || Alter Table Script || 348072 |- | AT_SCH_ORD_TRACKING_347394.sql || 1.1 || Alter Table Script || 347394 |- | AT_SCH_TRIP_346717.sql || 1.1 || Alter Table Script || 346717 |- | AT_SCH_TRIP_347904.sql || 1.1 || Alter Table Script || 347904 |- | BATHSTORE_MANIFEST.rep || 1.10 || Manifest Report || 347591 |- | CSV.sql || 5.102 || CSV extract package || 347514 |- | CT_ACC_SERVICES_SERVICE_LEVEL_347771.sql || 1.1 || Create Table Script || 347771 |- | CT_INT_XML_PACKAGE_CONTROL_347393.sql || 1.1 || Create Table Script || 347393 |- | CT_SEQ_INT_XML_PACKAGE_CONTROL_347393.sql || 1.1 || Create Table Script || 347393 |- | CUST_COST.fmx || 2.124 || Customer Maintenance form || 347574 |- | DATA_1_MSG_EVENT_TYPE_346777.sql || 1.1 || Data Script || 346777 |- | DATA_2_MSG_TYPE_346777.sql || 1.1 || Data Script || 346777 |- | DATA_3_MSG_REQ_346777.sql || 1.1 || Data Script || 346777 |- | DATA_4_MSG_SMS_VALUES_346777.sql || 1.2 || Data Script || 346777 |- | DATA_ADM_LOG_PROG_NAME_347277.sql || 1.1 || Data Script || 347277 |- | DATA_ADM_SYSTEM_PARAM_344948.sql || 1.1 || Data Script || 344948 |- | DATA_ADM_SYSTEM_PARAM_346717.sql || 1.1 || Data Script || 346717 |- | DATA_ADM_SYSTEM_PARAM_346721.sql || 1.1 || Data Script || 346721 |- | DATA_ADM_SYSTEM_PARAM_347094.sql || 1.1 || Data Script || 347094 |- | DATA_ADM_SYSTEM_PARAM_347277.sql || 1.1 || Data Script || 347277 |- | DATA_ADM_SYSTEM_PARAM_347394.sql || 1.1 || Data Script || 347394 |- | DATA_ADM_SYSTEM_PARAM_347535.sql || 1.2 || Data Script || 347535 |- | DATA_ADM_SYSTEM_PARAM_347604.sql || 1.1 || Data Script || 347604 |- | DATA_ADM_SYSTEM_PARAM_347713.sql || 1.1 || Data Script || 347713 |- | DATA_ADM_SYSTEM_PARAM_347749.sql || 1.1 || Data Script || 347749 |- | DATA_ADM_SYSTEM_PARAM_347769.sql || 1.1 || Data Script || 347769 |- | DATA_ADM_SYSTEM_PARAM_347880.sql || 1.1 || Data Script || 347880 |- | DATA_ADM_SYSTEM_PARAM_347974.sql || 1.1 || Data Script || 347974 |- | DATA_ADM_SYSTEM_PARAM_348158.sql || 1.2 || Data Script || 348158 |- | DATA_ADM_SYSTEM_PARAM_348282.sql || 1.2 || Data Script || 348282 |- | DATA_ADM_SYSTEM_PARAM_348431.sql || 1.1 || Data Script || 348431 |- | DATA_ADM_SYSTEM_PARAM_348536.sql || 1.1 || Data Script || 348536 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_344948.sql || 1.1 || Data Script || 344948 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_346717.sql || 1.1 || Data Script || 346717 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_346721.sql || 1.1 || Data Script || 346721 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_347277.sql || 1.1 || Data Script || 347277 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_347394.sql || 1.1 || Data Script || 347394 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_347749.sql || 1.1 || Data Script || 347749 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_347769.sql || 1.1 || Data Script || 347769 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_347880.sql || 1.1 || Data Script || 347880 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_347974.sql || 1.1 || Data Script || 347974 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_348158.sql || 1.1 || Data Script || 348158 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_348282.sql || 1.2 || Data Script || 348282 |- | DATA_ADM_SYSTEM_PARAM_CONFIG_348536.sql || 1.1 || Data Script || 348536 |- | DATA_IMP_1_IMPORT_TYPE_347277.sql || 1.1 || Data Script || 347277 |- | DATA_IMP_DECODE_TYPE_346769.sql || 1.1 || Data Script || 346769 |- | DATA_IMP_FIELD_347277.sql || 1.3 || Data Script || 347277 |- | DATA_IMP_FIELD_347514.sql || 1.1 || Data Script || 347514 |- | DATA_IMP_FIELD_347707.sql || 1.1 || Data Script || 347707 |- | DATA_IMP_FIELD_347749.sql || 1.1 || Data Script || 347749 |- | DATA_MSG_EVENT_TYPE_347769.sql || 1.1 || Data Script || 347769 |- | DATA_MSG_SMS_VALUES_347769.sql || 1.1 || Data Script || 347769 |- | DATA_ORS_MASTER_DATA_347904.sql || 1.1 || Data Script || 347904 |- | DATA_REP_REPORT_347766.sql || 1.1 || Data Script || 347766 |- | DATA_REP_REPORT_348253.sql || 1.1 || Data Script || 348253 |- | DATA_REP_REPORT_348273.sql || 1.1 || Data Script || 348273 |- | DATA_REP_REPORT_PARAM_347766.sql || 1.1 || Data Script || 347766 |- | DATA_REP_REPORT_PARAM_347874.sql || 1.1 || Data Script || 347874 |- | DATA_REP_REPORT_PARAM_348253.sql || 1.1 || Data Script || 348253 |- | DATA_RES_LABEL_FORMATS_347394.sql || 1.1 || Data Script || 347394 |- | DATA_SCH_SOURCE_SYSTEM_347277.sql || 1.2 || Data Script || 347277 |- | DELIVERY_NOTE_HCR.rep || 1.3 || Delivery Note || 348844 |- | DOM_MANIFEST_POD.rep || 1.9 || Manifest Report || 348084 |- | DOM_ORD_CONF.rep || 1.1 || Order Confirmation || 347766 |- | DOM_ORD_CONF.rep || 1.2 || Order Confirmation || 348000 |- | DP_AQ.sql || 5.6 || RDT Queue controller || 347790 |- | DP_ASSET_SCANNING.sql || 5.38 || Tag to Asset Scanning || 346721 |- | DP_CARRIER.sql || 1.68 || Carrier Management || 347394 |- | DP_CARRIER.sql || 1.69 || Carrier Management || 347862 |- | DP_CARRIER.sql || 1.70 || Carrier Management || 347880 |- | DP_CSV_DUN.sql || 5.31 || Client specific CSV extracts || 348273 |- | DP_CSV2.sql || 5.76 || Second CSV extract package || 347094 |- | DP_CUST_SERV.sql || 1.26 || Customer Service Package || 347517 |- | DP_CUST_SERV.sql || 1.27 || Customer Service Package || 347653 |- | DP_CUST_SERV.sql || 1.28 || Customer Service Package || 347713 |- | DP_CUST_SERV.sql || 1.29 || Customer Service Package || 348143 |- | DP_FIXED_IMPORT.sql || 1.2 || Fixed Import || 347277 |- | DP_FIXED_IMPORT.sql || 1.3 || Fixed Import || 347707 |- | DP_FIXED_IMPORT.sql || 1.4 || Fixed Import || 347881 |- | DP_IMP_2.sql || 1.73 || Import Package || 344948 |- | DP_IMP_2.sql || 1.74 || Import Package || 348353 |- | DP_INT_TMS_WMS_IN_STUB.sql || 1.3 || Inbound WMS/TMS Interface Package || 346789 |- | DP_INT_TMS_WMS_IN_STUB.sql || 1.5 || Inbound WMS/TMS Interface Package || 346777 |- | DP_INT_XML_CARPOD.sql || 5.6 || Inbound EDI Carrier POD Interface || 347574 |- | DP_INT_XML_MIC2.sql || 1.21 || CTMS to MIC Interface || 347974 |- | DP_INT_XML_MIC2.sql || 1.22 || CTMS to MIC Interface || 348431 |- | DP_INT_XML_MIC2.sql || 1.23 || CTMS to MIC Interface || 348613 |- | DP_LOGIX.sql || 1.8 || Package for LOGIX Interfaces || 348824 |- | DP_RDT_FAST_UNLOAD.sql || 5.39 || RF Unload Package || 347496 |- | DP_REPORTS.sql || 5.47 || Reports package || 347393 |- | DP_REPORTS.sql || 5.48 || Reports package || 348268 |- | DP_REPORTS.sql || 5.49 || Reports package || 348416 |- | DP_REPORTS.sql || 5.50 || Reports package || 348524 |- | DP_SCHEDULING_ENGINE.sql || 5.133 || Scheduling Package || 347849 |- | DP_WEB_SERVICE_INT.sql || 5.3 || Web Service Package || 348536 |- | GENERATE.fmx || 2.13 || Fixed Schedule Form || 347929 |- | HCR_DELIVERY_NOTE.rep || 1.27 || HCR Delivery Note || 348844 |- | IMP.sql || 5.160 || CSV Imports Package || 347466 |- | IMP.sql || 5.161 || CSV Imports Package || 347576 |- | IMP.sql || 5.162 || CSV Imports Package || 347749 |- | IMP.sql || 5.163 || CSV Imports Package || 347612 |- | IMP.sql || 5.164 || CSV Imports Package || 347910 |- | IMP.sql || 5.166 || CSV Imports Package || 347514 |- | IMPORTS_MAINT.fmx || 1.22 || Import Maintenance Form || 346769 |- | IMPORTS_MAINT.fmx || 1.23 || Import Maintenance Form || 348299 |- | IMPORTS_MAINT.fmx || 1.24 || Import Maintenance Form || 347514 |- | INT_ERR.fmx || 1.105 || Interface Errors || 347277 |- | INT_ERR.fmx || 1.106 || Interface Errors || 348300 |- | INT_ERR.fmx || 1.107 || Interface Errors || 348303 |- | INT_XML_IN.sql || 5.172 || Order Import Package || 344948 |- | INT_XML_IN.sql || 5.173 || Order Import Package || 347982 |- | INT_XML_IN.sql || 5.174 || Order Import Package || 348059 |- | INT_XML_MIC.sql || 5.142 || MIC interface || 347604 |- | INT_XML_OUT2.sql || 5.264 || Outbound XML Package || 347849 |- | INV.sql || 5.32 || Invoice Package || 347853 |- | INV.sql || 5.33 || Invoice Package || 348516 |- | INV.sql || 5.35 || Invoice Package || 348957 |- | INVOICE_CUST_DUN.rep || 1.23 || Customer Invoice Report || 347428 |- | ITEM_LABELS_DOM.rep || 1.10 || Labels report || 348000 |- | ITEM_LABELS_DOM.rep || 1.11 || Labels report || 348135 |- | ITEM_LABELS_DOM.rep || 1.8 || Labels report || 347535 |- | ITEM_LABELS_DOM.rep || 1.9 || Labels report || 347874 |- | ITEM_LABELS_DOM_SCHED.rep || 1.1 || Item Labels Report || 348253 |- | LOAD_MAN.fmx || 1.22 || Load Management Form || 348282 |- | LOCATION.fmx || 2.184 || Location Maintenance || 346777 |- | MSG_JOB.sql || 5.11 || Message job functionality || 347769 |- | MSG_MAINT.fmx || 2.30 || Message Maintenance screen || 347769 |- | MSG_MAINT.fmx || 2.31 || Message Maintenance screen || 348072 |- | MSG_MONIT.fmx || 2.18 || Message Monitor || 347766 |- | MSG_MONIT_ARCHIVE.fmx || 1.12 || Message Monitor Archive || 347766 |- | MSG_PROCESSING.sql || 5.63 || Message Processing package || 346777 |- | MSG_PROCESSING.sql || 5.64 || Message Processing package || 347766 |- | MSG_PROCESSING.sql || 5.65 || Message Processing package || 347713 |- | MSG_PROCESSING.sql || 5.66 || Message Processing package || 347769 |- | MSG_PROCESSING.sql || 5.67 || Message Processing package || 348072 |- | OF_INT.sql || 5.46 || Oracle Financials interface || 347428 |- | OF_INT.sql || 5.47 || Oracle Financials interface || 348957 |- | OMS.sql || 5.203 || Order package || 347580 |- | OMS.sql || 5.204 || Order package || 347650 |- | OMS.sql || 5.205 || Order package || 348056 |- | OMS.sql || 5.206 || Order package || 348089 |- | OMS.sql || 5.207 || Order package || 348143 |- | OMS.sql || 5.208 || Order package || 348158 |- | ORDERS.fmx || 2.403 || Order Screen || 347574 |- | ORDERS.fmx || 2.404 || Order Screen || 347769 |- | ORDERS.fmx || 2.405 || Order Screen || 348072 |- | ORDERS_WIDE.fmx || 1.17 || Orders Screen || 347769 |- | ORDERS_WIDE.fmx || 1.18 || Orders Screen || 348072 |- | PAR.sql || 5.87 || Paragon Interface || 347514 |- | PLANNING.fmx || 1.75 || Planning Screen || 347574 |- | PLANNING.fmx || 1.78 || Planning Screen || 347394 |- | PLANNING.fmx || 1.79 || Planning Screen || 346717 |- | PLANNING.fmx || 1.82 || Planning Screen || 347862 |- | PLANNING.fmx || 1.83 || Planning Screen || 347908 |- | PLANNING.fmx || 1.84 || Planning Screen || 347874 |- | PLANNING.fmx || 1.85 || Planning Screen || 348158 |- | RATE.sql || 5.139 || Rates Tariff database package || 347504 |- | RATE.sql || 5.140 || Rates Tariff database package || 347234 |- | RATE.sql || 5.141 || Rates Tariff database package || 347853 |- | RATE.sql || 5.143 || Rates Tariff database package || 348621 |- | RATE.sql || 5.144 || Rates Tariff database package || 348993 |- | T_MSG_EVENT_IUD.sql || 1.2 || Trigger || 346777 |- | T_SCH_ORD_AUDIT.sql || 5.15 || Trigger for SCH_ORD_AUDIT || 347612 |- | T_SCH_ORD_AUDIT.sql || 5.16 || Trigger for SCH_ORD_AUDIT || 348056 |- | TI_SCH_ORD_STATUS.sql || 1.17 || Trigger on SCH_ORD for status change || 347766 |- | TIU_TRIP_STATUS.sql || 5.51 || Trigger on SCH_TRIP for status change || 347510 |- | TIU_TRIP_STATUS.sql || 5.52 || Trigger on SCH_TRIP for status change || 348012 |- | TRG_PACKAGES.sql || 1.3 || Trigger || 347393 |- | TRG_SCH_ORD_DEL_TRP.sql || 5.6 || Trigger || 346778 |- | TRG_SCH_TRIP_CARRIER_UPD.sql || 1.1 || Trigger || 346717 |- | TRG_SHA_LOAD_TRIPS.sql || 1.8 || Trigger || 347510 |- | TRG_SHA_LOAD_TRIPS.sql || 1.9 || Trigger || 348012 |- | TRG_SO_BOOK_STATUS.sql || 1.4 || Trigger || 347612 |- | TRG_SO_BOOK_STATUS.sql || 1.5 || Trigger || 348056 |- | TRG_STOP_TIMES.sql || 1.3 || Trigger || 347393 |- | TRIP_SHEET_MORAN.rep || 1.2 || Customer Trip Sheet || 347527 |- | TRIPDTL.fmx || 2.215 || Trip Debrief || 347904 |- | TRIPSUM.fmx || 2.432 || Trip Manipulation screen || 346717 |- | TRM.sql || 5.164 || Trip manipulation package || 347335 |- | TRM.sql || 5.165 || Trip manipulation package || 348158 |- | TRM.sql || 5.166 || Trip manipulation package || 346721 |- | V_ACC_SERVICE_LEVEL.sql || 1.1 || View || 347771 |- | V_ORD_AUDIT.sql || 1.3 || View || 348056 |- | V_ORD_POSS_TRIP.sql || 1.6 || View || 347654 |- | V_T2A_BOOKING_ORDERS.sql || 1.3 || View || 346721 |- | V_TRIP.sql || 1.3 || View || 346717 |

|}

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.