PATCH C-TMS P041: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 96: Line 96:
|'''Set-up and Configuration''' ||
|'''Set-up and Configuration''' ||
|}
|}


{| class="wikitable" border="1" width="100%"
{| class="wikitable" border="1" width="100%"
Line 247: Line 246:
|width="30%"|'''Summary of Call'''|| Invoicing is slow to complete
|width="30%"|'''Summary of Call'''|| Invoicing is slow to complete
|-
|-
|'''Detail of Fix''' || The new system parameter ‘INV_ACT_PMNTS_DAYS’ can be used to specify a number of days prior to the period end date or the current date to assess the payments for the next invoice.
|'''Detail of Fix''' || The new system parameter 'INV_ACT_PMNTS_DAYS' can be used to specify a number of days prior to the period end date or the current date to assess the payments for the next invoice.


For example, 31 days may be specified to reduce the number of payments to assess for the next invoice.
For example, 31 days may be specified to reduce the number of payments to assess for the next invoice.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' ||  
|}
|}
{| class="wikitable" border="1" width="100%"
|- bgcolor="silver"
!colspan="4" | New Parameters
|-
!Parameter Name !! Config Level !! Setting Value !! Result
|-
|INV_ACT_PMNTS_DAYS
|SYSTEM
|Y
|Payments for all days prior to the period end date or the current date will be considered for the invoice.
|-
|INV_ACT_PMNTS_DAYS
|SYSTEM
|N
|Payments for a set number of days prior to the period end date or the current date will be considered for the invoice.
|}

Revision as of 18:06, 24 January 2022




Aptean Logo.png










Release Notes

CALIDUS TMS

14th Jan 2022 - 1.0
Reference: P041











































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


DEVELOPMENT

Log Number: 01781678

Summary of Call CFX Location names
Detail of Fix A field called EXT_LOCATION_NAME is available for files for the LOC_UDPATE import type.

This field of the locations will be used in outbound CFX files when the new system parameter CFX_EXT_LOCATION_NAME is set to Y.

It will then replace the location name for the STOP_LOCATION_NAME and the ADDRESSEE_NAME of the orders at the location.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
CFX_EXT_LOCATION_NAME SYSTEM Y A value of 'Y' will enable the new functionality for the CFX message to include the extra location name
CFX_EXT_LOCATION_NAME SYSTEM N A value of 'N' will disable the new functionality for the CFX message to include the extra location name


Log Number: 01800565

Summary of Call Connected View Changes
Detail of Fix A new EDI process will be created for an 'OFDC' message for 'Connected View'.

This message will include orders to advise the external system when the orders have been despatched for delivery.

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


Log Number: 01846914

Summary of Call WREQ0065972 Brexit Report Amendment
Detail of Fix 4 new fields added to the WMS_PRODUCT_XREF table, import amended to allow the fields to be populated and the new fields added to the Brexit ORS report
Set-up and Configuration No set-up/configuration required


Log Number: 00266107

Summary of Call Manual payment adjustment
Detail of Fix Allow Manual Payments to be added to a Trip cost using a new screen
Set-up and Configuration No set-up/configuration required



SUPPORT INCIDENTS

Log Number: 01898272

Summary of Call Auto-scheduling
Detail of Fix The network scheduling engine will also assess ACCEPTED trips for radial delivery trips.
Set-up and Configuration No set-up/configuration required


Log Number: 00264620

Summary of Call Web Service Order Processing Changes
Detail of Fix Amendments for the web service orders:

1. Writes to EPOD_WEB_SERVICE_AUDIT using an autonomous function.

2. Writes to EPOD_WEB_SERVICE_AUDIT at the start with a status of REC for the received message - ACK and NAK will also be stored later.

3. Excludes CANCELLED orders from the queries.

4. Includes NOWAIT on FOR UPDATE actions and reports locked records when creating and updating orders at all levels, booking manifests, trunk trips, click & collect.

5. Commits or rolls back the data for the orders and generates an ACK or a NAK message accordingly.

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



BUGS

Log Number: 00246275

Summary of Call TMS Error codes not informative
Detail of Fix Added validation to all numeric datatypes for Inbound EDI orders
Set-up and Configuration No set-up/configuration required


Log Number: 00248627

Summary of Call Report invalid file formats for inbound EDI files
Detail of Fix The files with invalid formats are reported and are then moved to Failed directory.

Added validation to the Fields 'LENGTH, WIDTH, HEIGHT' wrt case 00246275.

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


Log Number: 01833551

Summary of Call Invoicing is slow to complete
Detail of Fix The new system parameter 'INV_ACT_PMNTS_DAYS' can be used to specify a number of days prior to the period end date or the current date to assess the payments for the next invoice.

For example, 31 days may be specified to reduce the number of payments to assess for the next invoice.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
INV_ACT_PMNTS_DAYS SYSTEM Y Payments for all days prior to the period end date or the current date will be considered for the invoice.
INV_ACT_PMNTS_DAYS SYSTEM N Payments for a set number of days prior to the period end date or the current date will be considered for the invoice.


Log Number: 01839826

Summary of Call Invoices not generated
Detail of Fix The new system parameter INV_SET_PERIOD can be set to Y to enable the invoice to have default values for the period based on the current date and to generate multiple invoices per day for the same accounts.

If this system parameter is not set to Y, the invoices will calculate the period for the invoice based on the previous invoice.

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


Log Number: 01832615

Summary of Call Missing data from Tablet solution
Detail of Fix Comments will be added for the reason codes other than 'SC' to indicate the actual departure date and time and the user name for a collection.

Comments will be added for the reason code 'SC' to indicate the actual departure date and time and the user name for a collection.

Comments will be added for the reason code 'SD' to indicate the planned arrival date and time and the user name for an automatic delivery.

Trips and orders will be updated as delivered when assets are scanned for collection and the carrier requires auto-debriefing of deliveries.

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


Log Number: 01841755

Summary of Call ORS Report - not using timezones
Detail of Fix A database script is created to amend EX_ORDHEAD, to modify the dates to use Local time zones for CHANGED_DATE, POD_DATE and PACKED_DATE
Set-up and Configuration No set-up/configuration required


Log Number: 00246967

Summary of Call End session dropping it early session
Detail of Fix The Three forms TRIPSUM, TRIP_PLAN, and PLANNING are modified so that the trip stops will be found for the matching Load and Unload locations and the planned times for the stops and the orders. Any empty stops then will be assessed and used only when they match the planned times, the functionality depends on this system parameter 'UPDATE_ORDERS_TO_TRIP' set to 'Y' for NHSBT.
Set-up and Configuration No set-up/configuration required


Log Number: 01834724

Summary of Call Two trips having the same consignment
Detail of Fix A new system parameter 'WCS_SPLIT_ORDER_BY_TRIP' can be set to 'Y' to allow an order to be split when its items are loaded on different trips for delivery.

Multiple new orders then will be used to store the items as they are loaded on separate trips for delivery.

The same new order will be used when this system parameter is set to 'N' to retain the existing functionality.

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


Log Number: 01784809

Summary of Call Orders not rating for account ACC when landing in C-TMS
Detail of Fix Consolidated payments can be created by DU category or DU Type for the order revenue.

Orders can be consolidated and rated when not all their DU categories or DU Types require rating.

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


Log Number: 01924442

Summary of Call Web service orders
Detail of Fix Amendments for the web service orders:

1. Writes to EPOD_WEB_SERVICE_AUDIT using an autonomous function

2. Writes to EPOD_WEB_SERVICE_AUDIT at the start with a status of REC for the received message - ACK and NAK will also be stored later

3. Excluded CANCELLED orders from the queries

4. Included NOWAIT on FOR UPDATE in one place

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


Log Number: 01896927

Summary of Call Incorrect POD data
Detail of Fix The EDI parameter 'ALLOW_INCREMENT_DSPD' will control if an order can include further despatches from a 'DSPD' message.

The default value will be 'N'.

If this parameter is 'Y', the order can be incremented with further despatch information.

If this parameter is 'N', the order can be updated with despatch information.

This parameter will only be active for orders that have not been packed to generate carrier labels.

Orders that have not been packed or that have been updated manually only with packed and despatched quantities can be incremented or updated as per the value of the parameter.

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


Log Number: 01910732

Summary of Call Paragon import failing
Detail of Fix The Paragon import process includes extra auditing for clearer analysis of the problem.

If an order fails to be added to a radial trip, the attempt will be reversed and the user will be informed in the audit message.

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


Log Number: 01932657

Summary of Call Order Import for NRHEAVY_Order_Import
Detail of Fix Sequence number updated correctly

The format of the child locations will be validated before a new location is created with a new address for the customer for the imported order.

For example, the next location will be 'LONDON/01450' when exists 'LONDON/01449' as the highest sequential number for that 12-character format.

'LONDON/147' will be excluded from that formatting should it exist.

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


Log Number: 00251450

Summary of Call WMS Params do not show in Location Maintenance for the first location that is found
Detail of Fix The WMS Params records will be getting display whenever a location has any parameters.
Set-up and Configuration No set-up/configuration required



MODULES DELIVERED

Module Name Version No Description Log Number
AT_GEO_LOCATION_01781678.sql 1.1 AT Script 01781678
AT_WMS_PRODUCT_XREF_01846914.sql 1.1 AT Script 01846914
DATA_ADM_LOG_PROG_NAME_00264620.sql 1.1 Data Script 00264620
DATA_ADM_SYSTEM_PARAM_01781678.sql 1.2 Data Script 01781678
DATA_ADM_SYSTEM_PARAM_01833551.sql 1.1 Data Script 01833551
DATA_ADM_SYSTEM_PARAM_01834724.sql 1.1 Data Script 01834724
DATA_ADM_SYSTEM_PARAM_01839826.sql 1.1 Data Script 01839826
DATA_ADM_SYSTEM_PARAM_CONFIG_01834724.sql 1.1 Data Script 01834724
DATA_IMP_FIELD_01781678.sql 1.1 Data Script 01781678
DATA_IMP_FIELD_01846914.sql 1.2 Data Script 01846914
DATA_ORS_MASTER_01841755.sql 1.1 Data Script 01841755
DATA_ORS_MASTER_DATA_01846914.sql 1.1 Data Script 01846914
DP_ASSET_SCANNING.sql 5.58 Tag to Asset Scanning 01832615
DP_EXPORT_EVENTS.sql 5.1 Database Package 00266107
DP_IMP_2.sql 1.80 Import Package 01932657
DP_INT_XML_CFX.sql 1.5 CFX Interface Database Package 01781678
DP_RDT_FAST_LOAD.sql 5.31 Load confirmation message procedure 01834724
DP_SCHEDULING_ENGINE.sql 5.176 Scheduling Package 01898272
DP_WEB_SERVICE_ORD.sql 1.27 Web Service Package 01924442
DP_WEB_SERVICE_ORD.sql 1.28 Web Service Package 00264620
IMP.sql 5.205 CSV Imports Package 01781678
IMP.sql 5.206 CSV Imports Package 01846914
INT_XML_IN.sql 5.228 Order Import Package 00246275
INT_XML_IN.sql 5.230 Order Import Package 00248627
INT_XML_IN.sql 5.231 Order Import Package 01896927
INT_XML_OUT.sql 5.41 XML Order Interface with CTMS 00264620
INT_XML_OUT2.sql 5.320 Outbound XML Package 01800565
INV.sql 5.53 Invoice Package 01833551
INV.sql 5.54 Invoice Package 01839826
INVOICES.fmx 2.64 Invoices Screen 01833551
LOCATION.fmx 2.196 Location Maintenance 00251450
PAR.sql 5.114 Paragon Interface 01910732
PLANNING.fmx 1.121 Planning Screen 00246967
PLANNING.fmx 1.122 Planning Screen 00266107
RATE.sql 5.161 Rates Tariff database package 01784809
TRG_EPOD_WEB_SERVICE_AUDIT.sql 1.2 Trigger 00266107
TRG_SCH_TRIP_XML_GEN.sql 5.23 Trigger 01800565
TRG_SHA_XML_GEN.sql 5.15 Trigger 01800565
TRG_STS_XML_GEN.sql 5.13 Trigger 01800565
TRG_TRIP_COST.sql 1.2 Trigger 00266107
TRIP_PLAN.fmx 1.281 Trip Planning Screen 00246967
TRIPSUM.fmx 2.447 Trip Manipulation screen 00246967



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_C-TMS_P041&oldid=9840’