PATCH WMS 810 P037

From Calidus HUB
Revision as of 09:52, 28 July 2020 by StylesC (talk | contribs)





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS WMS

23rd July 2020 - 1.0
Reference: P037











































SUMMARY INTRODUCTION

INTRODUCTION

The main aim of this document is to provide CALIDUS WMS 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: Batch validation

OBS Log Number: 360665
Summary of Call Batch validation when picking
Detail of Fix Populate new 'original line type' field in RF 121 'pick' message
Set-up and Configuration No set-up/configuration required


Customer Ref: Order Upload

OBS Log Number: 372122
Summary of Call EST - Order Upload EDI Format required
Detail of Fix Create new PRC format EDI upload
Set-up and Configuration No set-up/configuration required


Customer Ref: Outbound Messages

OBS Log Number: 372763
Summary of Call Dheg outbound message change
Detail of Fix Ensure email and phone no are not defaulted to be '.' when blank.
Set-up and Configuration No set-up/configuration required


Customer Ref: 354845/367920

OBS Log Number: 371348
Summary of Call EDI GRN pallets not showing on Report
Detail of Fix Ensure customer rotation no of WGEP is populated with '+' when blank.
Set-up and Configuration No set-up/configuration required



SUPPORT INCIDENTS

Customer Ref: INC31993485

OBS Log Number: 370288
Summary of Call Discrepancy on Stock Demand control
Detail of Fix Amend updates to summary cases; increase auditing
Set-up and Configuration No set-up/configuration required


Customer Ref: Performance

OBS Log Number: 371152
Summary of Call System Slowing
Detail of Fix Performance improvements
Set-up and Configuration No set-up/configuration required


Customer Ref: Movements

OBS Log Number: 371316
Summary of Call Pallet Movement enquiry is slow
Detail of Fix The query for the records in the Pallet Movement Enquiry screen will be performed to check that records exist using all parameters.
Set-up and Configuration No set-up/configuration required


Customer Ref: Gen testing

OBS Log Number: 371655
Summary of Call Reason Code Maint
Detail of Fix Send 24 hour time in 251 message to WCS
Set-up and Configuration No set-up/configuration required


Customer Ref: Despatch Conf

OBS Log Number: 372038
Summary of Call Despatch confirmation
Detail of Fix Additional autit trail comment added in pick comfirmation to aid in tracing of cause behind despatch confirmation issue when the selected pick pallet is set to 0.
Set-up and Configuration No set-up/configuration required


Customer Ref: Locations

OBS Log Number: 372204
Summary of Call Locations showing full when not
Detail of Fix Amendment to Ad-hoc stock moves in WCS to correct for second update of the number of pallets in a location, which caused locations to show as full when there was spaces physically available.
Set-up and Configuration No set-up/configuration required


Customer Ref: Stock Creation

OBS Log Number: 372414
Summary of Call Stock creation
Detail of Fix When adding barcodes, the UOM list is for the owner of the product displayed
Set-up and Configuration No set-up/configuration required


Customer Ref: Stock Validation

OBS Log Number: 372579
Summary of Call Update products to redundant
Detail of Fix Extension to stock validation on units_per_case, case_layers and layers_pallet if fields not supplied in the import file e.g.when makng stock 'R'edundant
Set-up and Configuration No set-up/configuration required


Customer Ref: Pallet Labels

OBS Log Number: 372620
Summary of Call Label reprint
Detail of Fix Ensure pallet label (POD format) will work for any individual pallet on the receipt.
Set-up and Configuration No set-up/configuration required


Customer Ref: Performance

OBS Log Number: 372739
Summary of Call WMS working slow
Detail of Fix Improve speed when retrieving orders.
Set-up and Configuration No set-up/configuration required


Customer Ref: Catch Weight validation

OBS Log Number: 372822
Summary of Call Unable to carry out pallet moves
Detail of Fix Amendment to catch weight validation for stock codes that have catch weight flag set to 'N'
Set-up and Configuration No set-up/configuration required


Customer Ref: Loading Dispatch

OBS Log Number: 372831
Summary of Call Loading Dispatch
Detail of Fix Improve performance of despatch - ensure the supplier code is written to the journals
Set-up and Configuration No set-up/configuration required


Customer Ref: ASN upload

OBS Log Number: 372865
Summary of Call Unable to upload ASN
Detail of Fix

A new owner rule ECDA ("Extra checks for duplicate advice to create GRNs") will be available to configure.

This rule can be set to Y when the owner of the pre-advised receipt has used the same advice note number for a GRN to perform extra validation to ensure that the user is informed that there are existing order lines for different SKUs that cannot be recreated.

The user can upload a pre-advised receipt using the Update action in a fixed-length file format to update these existing order lines instead of the default Create action.

Note that the POD format not include this extra validation so that they can generate new GRNs for each advice note.

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


Customer Ref: INC33186927

OBS Log Number: 372875
Summary of Call Pick Wave maintenance issue
Detail of Fix Change generation of load number in Pick Wave to ensure it is unique
Set-up and Configuration No set-up/configuration required


Customer Ref: Pick Replen

OBS Log Number: 373386
Summary of Call Bulk to Pick Replen
Detail of Fix Create new package DP_WHS0610.

Moved bulk to pick functionality from screen to package.

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


Customer Ref: Pick List

OBS Log Number: 373557
Summary of Call Performance Issues on Pick List
Detail of Fix Improve speed of AR1, AR2 and HMB format despatch notes.
Set-up and Configuration No set-up/configuration required


Customer Ref: Stock Warehouse

OBS Log Number: 373582
Summary of Call SW Records - committed figures
Detail of Fix Amend how STOCK WAREHOUSE table is updated. Move updates to DP_SAW so that 2 users cant over write each other's updates.
Set-up and Configuration No set-up/configuration required


Customer Ref: Stock Snapshot

OBS Log Number: 373963
Summary of Call Held stock flag stock snapshot
Detail of Fix Amendment to BRT format stock snapshot to correct setting of the held stock reason code.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC33868961

OBS Log Number: 374701
Summary of Call Stock Order Not Reached Booker
Detail of Fix Create receipt based on ordered cases.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC33888607

OBS Log Number: 374791
Summary of Call Order Stuck
Detail of Fix Recheck order status and line status prior to deleting a line. Audit line deletions for support purposes.
Set-up and Configuration No set-up/configuration required


Customer Ref: CY_MOV_DTL

OBS Log Number: 375052
Summary of Call Date filter does not work on CY_MOV_DTL
Detail of Fix Allow date ranges, ensure dates select correct info
Set-up and Configuration No set-up/configuration required


Customer Ref: Location Validation

OBS Log Number: 363375
Summary of Call Ext. Repos Val. not read multi-deep use
Detail of Fix Improve multi deep location validation
Set-up and Configuration No set-up/configuration required


Customer Ref: Stock Snapshot

OBS Log Number: 370832
Summary of Call EDI - Dynamic Stock Snapshot not working
Detail of Fix Fix to configurable outbound edi flows.
Set-up and Configuration No set-up/configuration required


Customer Ref: GRN Conf

OBS Log Number: 370981
Summary of Call Ord Dtl displaying incorrect case avail
Detail of Fix Changed RDT Grn Confirmation package to no longer set pallets as frozen.
Set-up and Configuration No set-up/configuration required


Customer Ref: WMS Tariff

OBS Log Number: 371855
Summary of Call WMS Tariff issue - Cust PO Ref length
Detail of Fix When an order is despatched and 'generate auto tariff' functionality is run, only pass the entered customer po reference if the order is an marked as an export and value matches an existing voyage reference.
Set-up and Configuration No set-up/configuration required


Customer Ref: 352069

OBS Log Number: 372025
Summary of Call Charging issues
Detail of Fix Remove duplicate column from interface file

Fix issue with how WHS05001 tariff is calculated when container is moved from container yard location or de-stuffed.

Amend calculations, so they reference 'movement type' field rather than 'service' field in calculations, as 'service' not always populated.

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


Customer Ref: Receipting error

OBS Log Number: 372088
Summary of Call Error Receipting last pallet
Detail of Fix Fix invalid cursor error when GRN is being closed.
Set-up and Configuration No set-up/configuration required


Customer Ref: Receipting error

OBS Log Number: 372217
Summary of Call Error when receipting pallet scan space
Detail of Fix New warehouse rule to trim leading spaces from the customer pallet ID in the 601 message. Rule is LTCP
Set-up and Configuration No set-up/configuration required


Customer Ref: Pick Replens

OBS Log Number: 369709
Summary of Call Replen when stock already in location
Detail of Fix Improve auditing functions for the Bulk to Pick Replen screen.
Set-up and Configuration No set-up/configuration required


Customer Ref: Pick Conf

OBS Log Number: 371981
Summary of Call Loads at incorrect status
Detail of Fix Amend pick confirmation logic to ensure load header status updated correctly if one order on pick wave is despatched before final order is pick confirmed.
Set-up and Configuration No set-up/configuration required


Customer Ref: Destuff receipts

OBS Log Number: 372795
Summary of Call Destuff receipt tasks not sent to WCS
Detail of Fix Amend de-stuff process, so that RF receipt messages sent even when location doesn't start with 'Bay' when YBW1 rule set to Yes.
Set-up and Configuration No set-up/configuration required


Customer Ref: GRN

OBS Log Number: 373311
Summary of Call Unable to run GRN report
Detail of Fix GRN report not finishing - will now run
Set-up and Configuration No set-up/configuration required


Customer Ref: GRN Import

OBS Log Number: 375192
Summary of Call EDIFact GRN import
Detail of Fix Amend ADR edifact upload, so process handles unknown SKU correctly
Set-up and Configuration No set-up/configuration required


Customer Ref: Release log

OBS Log Number: 375452
Summary of Call Release log for 374649
Detail of Fix Fix issue when user moves a container to stack location after de-stuffing event, so an error isn't raised and the container move is completed.
Set-up and Configuration No set-up/configuration required



TID CHANGES

OBS Log Number:

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


OBSL PRODUCT DEVELOPMENT

OBS Log Number:

Reporter:
Summary of Call
Detail of Fix
Set-up and Configuration No set-up/configuration required


MODULES DELIVERED

Module Name Version No Description Log Number
AT_EDI_PDP_HEADER_OUT_374441.sql 1.1 AT Script 374441
AT_ROUTE_HEADERS_372875.sql 1.1 AT Script 372875
AT_WARE_DIARY_HEADERS_370795.sql 4.3 AT Script 370795
AT_WARE_GOODS_ENTRY_PALLETS_370923.sql 4.1 AT Script 370923
CT_V_ORS_EDI_SALORD_373413.sql 4.2 CT Script 373413
DATA_BAY_DIARY_CONFIG_370795.sql 4.2 Database Script 370795
DATA_BAY_DIARY_CONFIG_USER_370795.sql 4.1 Database Script 370795
DATA_CONF_EDI_IN_MSG_370832.sql 4.1 Database Script 370832
DATA_DYNAMIC_MESSAGES_359355.sql 4.1 Database Script 359355
DATA_DYNAMIC_MESSAGES_370288.sql 1.1 Data Script 370288
DATA_DYNAMIC_MESSAGES_372122.sql 4.1 Data Script 372122
DATA_ORS_MASTER_DATA_370795.sql 4.1 Database Script 370795
DATA_ORS_MASTER_DATA_375052.sql 1.1 Data Script 375052
DATA_ORS_USER_DETAILS_372122.sql 4.2 Data Script 372122
DATA_U_ROUTE_HEADERS_372875.sql 1.1 Database Script 372875
DATA_WAREHOUSE_RULES_371776.sql 4.1 Database Script 371776
DATA_WAREHOUSE_RULES_372217.sql 1.1 Database Script 372217
DATA_WAREHOUSE_RULES_CONTROL_370795.sql 4.2 Database Script 370795
DATA_WAREHOUSE_RULES_CONTROL_371776.sql 4.1 Database Script 371776
DATA_WAREHOUSE_RULES_CONTROL_371845.sql 4.1 Database Script 371845
DATA_WAREHOUSE_RULES_CONTROL_372865.sql 4.1 Database Script 372865
DATA_WMS_TRANSLATIONS_371829.sql 4.1 Database Script 371829
DATA_WMS_TRANSLATIONS_372122.sql 4.1 Data Script 372122
DP_CONF_EDI_IN.sql 4.103 Dynamic Inbound EDI package 372579
DP_CONF_EDI_OUT.sql 4.32 Dynamic Outbound EDI package 370832
DP_DESPATCH.sql 4.100 Despatch Confirmation Package 1 372831
DP_DESPATCH.sql 4.99 Despatch Confirmation Package 1 371855
DP_EDIGEN_HOLD_VAL.sql 4.19 EDI Inbound Holds Validation Package 371829
DP_EDIGEN_OUT_PACK_LABEL.sql 4.15 Packing Label 372763
DP_EDIGEN_OUT_PDP_CONF.sql 4.148 Outbound EDI Generation 372420
DP_EDIGEN_OUT_PDP_CONF.sql 4.149 Outbound EDI Generation 372663
DP_EDIGEN_OUT_PDP_CONF.sql 4.150 Outbound EDI Generation 374441
DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql 4.64 Receipt conf outbound file creation 372420
DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql 4.65 Receipt conf outbound file creation 372663
DP_EDIGEN_OUT_ST_BAL.sql 4.96 STK balance flat file package 373963
DP_EDIGEN_PRE_ADVICE_LOAD.sql 4.60 WMS Pre Advice EDI load 371348
DP_EDIGEN_PRE_ADVICE_LOAD.sql 4.61 WMS Pre Advice EDI load 372232
DP_EDIGEN_PRE_ADVICE_LOAD.sql 4.62 WMS Pre Advice EDI load 372663
DP_EDIGEN_PRE_ADVICE_LOAD.sql 4.63 WMS Pre Advice EDI load 375192
DP_EDIGEN_PRE_ADVICE_VAL.sql 4.87 EDI Pre-Advice Validation 372865
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.245 Inbound EDI Sales Order Upload 359355
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.246 Inbound EDI Sales Order Upload 372232
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.247 Inbound EDI Sales Order Upload 372663
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.249 Inbound EDI Sales Order Upload 372122
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.250 Inbound EDI Sales Order Upload 375192
DP_EDIGEN_SALES_ORDER_VAL.sql 4.221 Order_Header update package 359355
DP_EDIGEN_SALES_ORDER_VAL.sql 4.222 Order_Header update package 372122
DP_GEN_WMS_TARIFF.sql 4.18 Tariff Generation package 372025
DP_HVY_PICK_CONF.sql 4.12 Pick Confirm 371981
DP_NET_PORTAL.sql 4.58 Package for .net diary system 370795
DP_NET_PORTAL.sql 4.58 Package for .net diary system 371845
DP_NET_PORTAL.sql 4.59 Package for .net diary system 372100
DP_NET_PORTAL.sql 4.60 Package for .net diary system 372769
DP_PFS.sql 4.6 Database Package 372875
DP_PICK_CONF_1.sql 4.69 Pick Confirmation Database Package 1 371981
DP_PICK_CONF_1.sql 4.70 Pick Confirmation Database Package 1 372831
DP_PICK_CONF_1.sql 4.71 Pick Confirmation Database Package 1 373582
DP_PICK_CONF_2.sql 4.28 Pick Confirmation Database Package 2 372831
DP_PICK_CONF_2.sql 4.29 Pick Confirmation Database Package 2 373582
DP_POP.sql 4.50 Purchase Order Processing 374701
DP_PORTAL.sql 4.24 Portal Package 370795
DP_PORTAL.sql 4.25 Portal Package 372100
DP_RDT.sql 4.54 RDT Messages 360665
DP_RDT_GRNCONF.sql 4.73 RDT Goods Receipt Confirmation 370981
DP_RDT_GRNCONF.sql 4.74 RDT Goods Receipt Confirmation 372088
DP_RDT_LOCENQ.sql 4.29 RDT Location Enquiry 363375
DP_RDT_PICK_CONF.sql 4.118 RDT Pick Confirmation 360665
DP_RDT_PICK_CONF.sql 4.119 RDT Pick Confirmation 371981
DP_RDT_PICK_CONF.sql 4.121 RDT Pick Confirmation 372672
DP_RDT_PICK_CONF.sql 4.122 RDT Pick Confirmation 373582
DP_RDT_PICK_REQUEST.sql 4.62 Pick Request Database Package 360665
DP_RDT_PICK_REQUEST.sql 4.63 Pick Request Database Package 372100
DP_RDT_PICK_REQUEST.sql 4.64 Pick Request Database Package 372672
DP_RDT_STKENQ.sql 4.32 RDT Stock Enquiry processing 373582
DP_REPORTS.sql 4.12 Reports package 371885
DP_SAW.sql 4.9 Stock Warehouse Update 373582
DP_USER_LOG_INFO.sql 4.4 User audit display 369709
DP_WHS0155.sql 4.6 Putaway Confirmation 370923
DP_WHS0610.sql 4.2 Bulk to pick replenishment package 373386
DP_WHS7872.sql 4.64 RDT Inbound Pallet Movements 370923
DP_WHS7872.sql 4.65 RDT Inbound Pallet Movements 372204
DP_WMS_ALLOC.sql 4.187 Allocation Procedure 371981
DP_WMS_ALLOC.sql 4.188 Allocation Procedure 372831
DP_WMS_ALLOC.sql 4.189 Allocation Procedure 373582
DP_WMS_IF.sql 4.29 Database package for warehousing 372217
DP_XFM_PROCESS_CONTROL.sql 4.8 XF Monitor Package 371152
DP_YBW_IF.sql 4.39 Integration Package 372769
DP_YBW_IF.sql 4.40 Integration Package 372795
DP_YBW_IF.sql 4.41 Integration Package 375452
LAS0312.fmx 4.158 Pick Wave Maintenance 371152
LAS0312.fmx 4.159 Pick Wave Maintenance 372100
LAS0312.fmx 4.160 Pick Wave Maintenance 372739
PFS1541.fmx 4.43 EDI Sales Order Validation 372122
POS1020.fmx 4.37 Stock Demand Control Processing 370288
RJPRNTQ.fmx 4.4 Print Queue Control 372413
SOS7000.fmx 4.66 Simple Order Entry 374791
splitter_adr.ksh 4.4 Pre-upload ADR ksh file 372232
STKSTOC01B.fmx 4.104 Stock Maintenance 372414
STS3007.fmx 4.17 Pallet Movement Enquiry 371316
V_ORDER_DEL_ADDRESS.sql 4.4 Order Delivery Address View 371771
V_STOCK_BY_AREA.sql 4.3 Database View 368556
WHR0151.rdf 4.21 Goods Received Note 373311
WHR1720_OBS.rdf 4.3 OBS format pick list 371152
WHR1900_AR1.rdf 4.5 AR1 format Despatch Note 373557
WHR1900_AR2.rdf 4.3 AR2 format Despatch Note 373557
WHR1900_FW1_L.rdf 4.29 FW1 Format Despatch Note (Land) 371152
WHR1900_FW1_P.rdf 4.28 FW1 Format Despatch Note (Port) 371152
WHR1900_HMB.rdf 4.4 HMB format Despatch Note 373557
WHS0080.fmx 4.10 Reason Codes Maintenance 371655
WHS0110.fmx 4.92 Goods Receipt Pre-Advice 374241
WHS0150.fmx 4.147 Goods Receipt Confirmation 371776
WHS0150.fmx 4.148 Goods Receipt Confirmation 372620
WHS0156.fmx 4.21 GRN Putaway Check Digits 370923
WHS0165.fmx 4.4 Total Warehouse Pallets 370853
WHS0542.fmx 4.35 Stock Take Count Input 371776
WHS0610.fmx 4.31 Bulk to Multi Pick Replenishment 369709
WHS0610.fmx 4.32 Bulk to Multi Pick Replenishment 373386
WHS0631.fmx 4.63 Stock Adjustments – add pallets 371776
WHS0700.fmx 4.65 Warehouse Movements 372822
WHS0900.fmx 4.23 Stock Location Enquiry 368556
WHS1710A.fmx 4.90 Pick List Confirmation 360665
WHS1710A.fmx 4.91 Pick List Confirmation 372038
WHS1710A.fmx 4.93 Pick List Confirmation 372672
WHS1710A.fmx 4.94 Pick List Confirmation 372831
WHS1945.fmx 4.135 Pack Header 356917
WHS1945.fmx 4.136 Pack Header 373077
WHSORA010.fmx 4.90 Allocation Kick-off 372100
WHSORA020.fmx 4.68 Pick List Kick-off 372100
XFM0020.fmx 4.65 XF Monitor 372122


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_WMS_810_P037&oldid=9064’