PATCH WMS P042: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 85: Line 85:
{| width="100%"
{| width="100%"
|-
|-
|width="30%"|'''Summary of Call'''|| GSK Update to Despatch Note
|width="30%"|'''Summary of Call'''|| WREQ0067369 - Update to Despatch Note
|-
|-
|'''Detail of Fix''' || "Amend issues with 'Ship' address display, re orders M2500000000000000008 and M2500000000000000009 / warehouse CNA
|'''Detail of Fix''' || Amend issues with 'Ship' address display, re orders M2500000000000000008 and M2500000000000000009 / warehouse CNA


Add STORE DESCRIPTION of ORDER HEADER between Customer Name and Address Line 1 fields.
Add STORE DESCRIPTION of ORDER HEADER between Customer Name and Address Line 1 fields.


If blank, move all fields up one line to avoid empty line."
If blank, move all fields up one line to avoid empty line.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}
== Aptean Log Number: 01894394 ==
== Aptean Log Number: 01894394 ==
Line 101: Line 102:
|width="30%"|'''Summary of Call'''|| Inbound EDI Hold Load Flow
|width="30%"|'''Summary of Call'''|| Inbound EDI Hold Load Flow
|-
|-
|'''Detail of Fix''' || "Amend EDI Hold validation package to populate the prev reason code
|'''Detail of Fix''' || Amend EDI Hold validation package to populate the prev reason code


Add new UOM Type of 'Q' to handle cases and units."
Add new UOM Type of 'Q' to handle cases and units.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}
== Aptean Log Number: 01894436 ==
== Aptean Log Number: 01894436 ==
Line 113: Line 115:
|width="30%"|'''Summary of Call'''|| RF Exchange Pallet process
|width="30%"|'''Summary of Call'''|| RF Exchange Pallet process
|-
|-
|'''Detail of Fix''' || "Add new owner rule RFEH (RF Exchange Hold)
|'''Detail of Fix''' || Add new owner rule RFEH (RF Exchange Hold)


If set to Yes, allow users to exchange held pallets"
If set to Yes, allow users to exchange held pallets
|-
|-
|'''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
|-
|RFEH
|Owner
|Y
|User able to exchange held pallets (if pallet hold reason code matches order hold reason code)
|-
|RF Exchange Held
|
|Any other value
|No change in functionality
|}
== Aptean Log Number: 01911798 ==
== Aptean Log Number: 01911798 ==
Line 140: Line 161:




Add new owner rule HRRC (Hold Reason - store entered reason code), which if set to yes, will store so that the manually entered release reason code is stored as ‘audit’ table release reason code"
Add new owner rule HRRC (Hold Reason - store entered reason code), which if set to yes, will store so that the manually entered release reason code is stored as 'audit' table release reason code"
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required YES - NEW PARAMS
|}
|}
Line 152: Line 173:
|'''Detail of Fix''' || Owner rule DTOW added to allow transport into in D017 segment, owner rule DE12 to include alloc reason code in new DE12 segment
|'''Detail of Fix''' || Owner rule DTOW added to allow transport into in D017 segment, owner rule DE12 to include alloc reason code in new DE12 segment
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required YES - NEW PARAMS
|}
|}
Line 182: Line 203:
{| width="100%"
{| width="100%"
|-
|-
|width="30%"|'''Summary of Call'''|| Add Pallet Type
|width="30%"|'''Summary of Call'''|| Pallet Type
|-
|-
|'''Detail of Fix''' || Add pallet type to DE12 segment
|'''Detail of Fix''' || Add pallet type to DE12 segment
Line 216: Line 237:
{| width="100%"
{| width="100%"
|-
|-
|width="30%"|'''Summary of Call'''|| WREQ0069569 - Creation of New Reports for GSK
|width="30%"|'''Summary of Call'''|| WREQ0069569 - Creation of New Reports
|-
|-
|'''Detail of Fix''' || Development complete ready for release WREQ0069569 - Creation of New Reports for GSK
|'''Detail of Fix''' || "New ORS 'USER_ACC' (User account) report
New Order / Serial Report - run from either WHS0290 (Order Serial
Report) or outbound EDI."
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required yes - new access
|}
|}
Line 243: Line 266:
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}




Revision as of 12:01, 15 June 2022




Aptean Logo.png







{{{Client}}}

Release Notes

CALIDUS WMS

23rd May 2022 - 1.0
Reference: P42











































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

Aptean Log Number: 00264834

Summary of Call WREQ0067369 - Update to Despatch Note
Detail of Fix Amend issues with 'Ship' address display, re orders M2500000000000000008 and M2500000000000000009 / warehouse CNA

Add STORE DESCRIPTION of ORDER HEADER between Customer Name and Address Line 1 fields.

If blank, move all fields up one line to avoid empty line.

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


Aptean Log Number: 01894394

Summary of Call Inbound EDI Hold Load Flow
Detail of Fix Amend EDI Hold validation package to populate the prev reason code

Add new UOM Type of 'Q' to handle cases and units.

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


Aptean Log Number: 01894436

Summary of Call RF Exchange Pallet process
Detail of Fix Add new owner rule RFEH (RF Exchange Hold)

If set to Yes, allow users to exchange held pallets

Set-up and Configuration


New Parameters
Parameter Name Config Level Setting Value Result
RFEH Owner Y User able to exchange held pallets (if pallet hold reason code matches order hold reason code)
RF Exchange Held Any other value No change in functionality


Aptean Log Number: 01911798

Summary of Call CR-4-Nov 21 Pallet Type on GRMK Message
Detail of Fix The 'GRMK' message includes the pallet type at the end of the 'R002' segment starting in position 411 for 4 alphanumeric characters.
Set-up and Configuration No set-up/configuration required

Aptean Log Number: 01894409

Summary of Call New IAJD Fields
Detail of Fix "Store the old reason code is the 'audit' table prev reason code

For stock adjustment, populated 2 new fields Pid_Qty_After_Cases And Pid_Qty_After_Units


Add new owner rule HRRC (Hold Reason - store entered reason code), which if set to yes, will store so that the manually entered release reason code is stored as 'audit' table release reason code"

Set-up and Configuration No set-up/configuration required YES - NEW PARAMS

Aptean Log Number: 01930166

Summary of Call Despatch Message Changes
Detail of Fix Owner rule DTOW added to allow transport into in D017 segment, owner rule DE12 to include alloc reason code in new DE12 segment
Set-up and Configuration No set-up/configuration required YES - NEW PARAMS

Aptean Log Number: 01933767

Summary of Call Bay Diary Landing Report
Detail of Fix Add Uom Info of Ware Diary Headers / change label from 'comments' to 'special instructions'
Set-up and Configuration No set-up/configuration required

Aptean Log Number: 00261276

Summary of Call 19c testing
Detail of Fix "UTL_FILE has been added to create a new directory for 19c changes in databases.

​Able to generate both FTP and receive mail for EXPORTS, REPORTS and ORS in individual screens and EDI maintenance screen.

Oracle system directories will need to be created for the database."

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

Aptean Log Number: 01968093

Summary of Call Pallet Type
Detail of Fix Add pallet type to DE12 segment
Set-up and Configuration No set-up/configuration required

Aptean Log Number: 01911801

Summary of Call Line Type 4 - Additional Change
Detail of Fix Amend screen and EDI logic to allow users to upload/create line type 4 (allocate by pallet) orders when held stock when AHSO (Allocate Held Stock) rule set to 'C'.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 01972540

Summary of Call Add rotation number to GSK report in Oracle Reporting Suite
Detail of Fix "Add rotation no to GSK format report.

Change 3 title labels."

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


Aptean Log Number: 01978647

Summary of Call WREQ0069569 - Creation of New Reports
Detail of Fix "New ORS 'USER_ACC' (User account) report

New Order / Serial Report - run from either WHS0290 (Order Serial Report) or outbound EDI."

Set-up and Configuration No set-up/configuration required yes - new access


Aptean Log Number: 01982047

Summary of Call Despatch Note Modification
Detail of Fix Replace 'store description' field with 'gift message' as part of reporting address data.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02010155

Summary of Call GRN Print email
Detail of Fix Create new 'CON' GRN Receipt Note format to allow the reporting of container no and advice note no when GRN Receipt Note printed.
Set-up and Configuration No set-up/configuration required


SUPPORT INCIDENTS

Customer Ref:

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


TID CHANGES

OBS Log Number:

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


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_INVENTORY_AUDIT_JNL_DETAILS_01894409.sql 4.3 Data Script 01894409
AT_ORDER_HEADER_01978647.sql 4.1 Data Script 01978647
AT_OWNER_WARE_PARAMS_01978647.sql 4.1 Data Script 01978647
CT_TEMP_HOLD_REL_PALLETS_00273581.sql 4.1 Data Script 00273581
DATA_CONF_EDI_OUT_MSG_LEVEL_COLS_00271584.sql 4.1 Data Script 00271584
DATA_CONF_EDI_OUT_MSG_LEVEL_COLS_00271825.sql 4.1 Data Script 00271825
DATA_DYNAMIC_MESSAGES_01894394.sql 4.1 Data Script 01894394
DATA_DYNAMIC_MESSAGES_02019931.sql 4.1 Data Script 02019931
DATA_FXM_OPTIONS_01808849.sql 4.2 Data Script 01978647
DATA_FXM_OPTIONS_01978647.sql 4.1 Data Script 01978647
DATA_FXM_SCREENS_01978647.sql 4.1 Data Script 01978647
DATA_ORS_MASTER_DATA_01978647.sql 4.1 Data Script 01978647
DATA_ORS_SQL_01978647.sql 4.1 Data Script 01978647
DATA_STOCK_BASE_SELL_00271608.sql 4.1 Data Script 00271608
DATA_WAREHOUSE_RULES_01894409.sql 4.1 Data Script 01894409
DATA_WAREHOUSE_RULES_01894436.sql 4.1 Data Script 01894436
DATA_WAREHOUSE_RULES_02023303.sql 4.1 Data Script 02023303
DATA_WAREHOUSE_RULES_CONTROL_01894409.sql 4.1 Data Script 01894409
DATA_WAREHOUSE_RULES_CONTROL_01894436.sql 4.1 Data Script 01894436
DATA_WAREHOUSE_RULES_CONTROL_01930166.sql 1.1 Data Script 01930166
DATA_WAREHOUSE_RULES_CONTROL_02022982.sql 4.1 Data Script 02022982
DATA_WAREHOUSE_RULES_CONTROL_02023303.sql 4.1 Data Script 02023303
DP_CONF_EDI_IN.sql 4.107 Dynamic Inbound EDI package 01942642
DP_DESPATCH.sql 4.105 Despatch Confirmation Package 1 01927435
DP_DESPATCH.sql 4.108 Despatch Confirmation Package 1 00273682
DP_DESPATCH.sql 4.110 Despatch Confirmation Package 1 01968022
DP_DESPATCH.sql 4.111 Despatch Confirmation Package 1 01982586
DP_DESPATCH.sql 4.112 Despatch Confirmation Package 1 02023303
DP_EDI_OUTBOUND.sql 4.109 EDI Outbound Receipt Confirmation 02039423
DP_EDIGEN_HOLD_VAL.sql 4.20 EDI Inbound Holds Validation Package 01894394
DP_EDIGEN_HOLD_VAL.sql 4.21 EDI Inbound Holds Validation Package 01894409
DP_EDIGEN_HOLD_VAL.sql 4.22 EDI Inbound Holds Validation Package 00271584
DP_EDIGEN_HOLD_VAL.sql 4.24 EDI Inbound Holds Validation Package 00272552
DP_EDIGEN_HOLD_VAL.sql 4.25 EDI Inbound Holds Validation Package 00273581
DP_EDIGEN_HOLD_VAL.sql 4.27 EDI Inbound Holds Validation Package 02022982
DP_EDIGEN_OUT_PDP_CONF.sql 4.157 Outbound EDI Generation 01929347
DP_EDIGEN_OUT_PDP_CONF.sql 4.158 Outbound EDI Generation 01930166
DP_EDIGEN_OUT_PDP_CONF.sql 4.159 Outbound EDI Generation 01968093
DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql 4.69 Receipt conf outbound file creation 01911798
DP_EDIGEN_PROD_VAL.sql 4.52 Inbound EDI Stock Upload Validation 00271608
DP_EDIGEN_SALES_ORDER_VAL.sql 4.231 Order_Header update package 01927435
DP_EDIGEN_SALES_ORDER_VAL.sql 4.232 Order_Header update package 01911801
DP_EDIGEN_SALES_ORDER_VAL.sql 4.233 Order_Header update package 01982586
DP_NET_PORTAL.sql 4.64 Package for .net diary system 02016540
DP_ORS_FUNCS_WMS.sql 4.31 Extract Suite Functions package 01978647
DP_PICK_CONF_1.sql 4.76 Pick Confirmation Database Package 1 01927435
DP_PICK_CONF_1.sql 4.78 Pick Confirmation Database Package 1 00273682
DP_PICK_CONF_1.sql 4.79 Pick Confirmation Database Package 1 01981676
DP_PICK_CONF_1.sql 4.80 Pick Confirmation Database Package 1 02020012
DP_PICK_CONF_2.sql 4.33 Pick Confirmation Database Package 2 01927435
DP_PICK_CONF_2.sql 4.35 Pick Confirmation Database Package 2 00273682
DP_PICK_CONF_2.sql 4.36 Pick Confirmation Database Package 2 01968022
DP_PICK_CONF_2.sql 4.37 Pick Confirmation Database Package 2 01981676
DP_RDT_PICK_CONF.sql 4.130 RDT Pick Confirmation 00273682
DP_RDT_PICK_CONF.sql 4.131 RDT Pick Confirmation 02018447
DP_RDT_PICK_CONF.sql 4.132 RDT Pick Confirmation 02021059
DP_RDT_PICK_CONF.sql 4.133 RDT Pick Confirmation 02039423
DP_RDT_STKENQ.sql 4.34 RDT Stock Enquiry processing 01894436
DP_RDT_STKENQ.sql 4.35 RDT Stock Enquiry processing 00273682
DP_SOP_01.sql 4.9 Sales Order Detail db package 01911801
DP_UPM_RENT.sql 4.32 Package to generate rent charges 01971675
DP_UPM_WHS_CHARGE.sql 4.31 Invoice Charges Procedure 01961565
DP_WHS0280.sql 4.2 GSK Inbound Report 01972540
DP_WHS0290.sql 4.1 GSK Order Serial Report 01978647
DP_WHS7872.sql 4.66 RDT Inbound Pallet Movements 02040541
DP_WMS_ALLOC.sql 4.195 Allocation Procedure 01927435
DP_WMS_ALLOC.sql 4.197 Allocation Procedure 00273682
DP_WMS_ALLOC.sql 4.198 Allocation Procedure 01911801
DP_WMS_ALLOC.sql 4.199 Allocation Procedure 01982586
DP_WMS_ALLOC.sql 4.201 Allocation Procedure 02022286
DP_WMS_ALLOC.sql 4.202 Allocation Procedure 02019309
ENQSOON03A.fmx 4.18 SOP Enquiries 02013187
FXMINIT.fmx 4.14 Flex Menu Initiation 01974351
GTS0621_WHS.fmx 4.3 Route Maintenance 01958712
LAS0312.fmx 4.163 Pick Wave Maintenance 02011048
SOS1110.fmx 4.152 Sales Order Entry 02011048
SOS1112.fmx 4.7 Credit Card Details 01966378
SOS1112.fmx 4.8 Credit Card Details 01911801
SOS1112.fmx 4.9 Credit Card Details 00295336
SOS1117.fmx 4.92 Sales Order Detail Lines 01927435
SOS1117.fmx 4.93 Sales Order Detail Lines 00273682
SOS1117.fmx 4.96 Sales Order Detail Lines 01968022
SOS1117.fmx 4.97 Sales Order Detail Lines 01911801
SOS1117.fmx 4.98 Sales Order Detail Lines 01981757
TRG_INS_IAJD.sql 4.35 Row-level Insert trigger for IAJD 01847238
TRG_STOCK_BIR.sql 4.2 Database trigger 01942642
UTL_FILE.sql 4.1 UTL_FILE package 00261276
WHR0110_NOM.rdf 4.6 GRN Checklist 02063841
WHR1420.rdf 4.7 Landing Report 01933767
WHR1900_GSK.rdf 4.10 GSK format despatch note 01894905
WHR1900_GSK.rdf 4.12 GSK format despatch note 00264834
WHR1900_GSK.rdf 4.13 GSK format despatch note 00266918
WHR1900_GSK.rdf 4.14 GSK format despatch note 01982047
WHS0150.fmx 4.156 Goods Receipt Confirmation 02010155
WHS0150.fmx 4.157 Goods Receipt Confirmation 00304934
WHS0290.fmx 4.1 Automated Process Maintenance 01978647
WHS0631.fmx 4.66 Stock Adjustments – add pallets 01969499
WHS0633.fmx 4.17 GRN Reversals 01894409
WHS0670.fmx 4.39 Sell By Date 02010436
WHS0700.fmx 4.71 Warehouse Movements 00211518
WHS0700.fmx 4.72 Warehouse Movements 02011048
WHS1710A.fmx 4.101 Pick List Confirmation 01968022
WHS1710A.fmx 4.102 Pick List Confirmation 02019931
WHS1714.fmx 4.136 Pick Confirmation 00306672
WHS1900.fmx 4.60 Despatch Print Kick-Off 01981376
WHS2050.fmx 4.51 Hold / Release Stock 01894409
WHSORA010.fmx 4.91 Allocation Kick-off 02011048
WHSORA020.fmx 4.69 Pick List Kick-off 02011048


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_P042&oldid=10048’