PATCH WMS P041: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 80: Line 80:
|}
|}
-->
-->
== Customer Ref: ==
 
{| width="100%"
== Aptean Log Number: 01735895 ==
|-  
{| width="100%"
|width="30%"|'''OBS Log Number:'''  || '''Reporter:'''  
|-
|width="30%"|'''Summary of Call'''|| Pack List - Development & Test
|-
|'''Detail of Fix''' || "Create new EDI customer specific upload fields
 
Create customer format despatch note
 
NOTE: The customer format logo will need to be copied to the 'image' folder. This will need to be done manually."
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Aptean Log Number: 01798122 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| Data Validation to SHP EDI message
|-
|'''Detail of Fix''' || Amend the SHP format EDI sales order upload, so that all non-numeric fields are checked and stripped of commas and or double quotes.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Aptean Log Number: 01798848 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| WREQ0063020 - New field required in Unison/EDI and GOW
|-
|'''Detail of Fix''' || "Add TEMP_ALARM_PROFILE to Order Header.
 
Field can only be populated via EDI sales order upload process via the T014 segment.
 
Field only visible in WMS using EDI Sales Order Processing screen, Enquiry By Order Number screen and ORS Orders report."
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Aptean Log Number: 01812787 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| Development for WREQ0064254
|-
|'''Detail of Fix''' || Add new Serial number ADSN (Allow Duplicate Serial Numbers for Owner) rule. The 'Rule' can be set either at owner or warehouse level.
 
If set, users will be able to receive and hold the same serial number against multiple stock codes.
 
Goods receipts will allow for same serial number to be receipted against multiple stock codes.
 
Sales order allocated and picking will be changed to ensure that the correct serial number information is updated.
 
Additional Comments
 
ADSN rule only works when linked to VAPS (Validate Against Pre-Advised Serials) rule, as change needs serial number record to be populated with a valid stock code.
 
It is assumed that no single sales order will contain the same serial number multiple times, as no sales order will despatch stock linked to multiple trials.
 
NOTE: This change only covers the goods receipt and sales order process. Other processes such as adjustments, movements etc will be covered by a separate change request.
|-
|'''Set-up and Configuration''' ||
|}
 
{| class="wikitable" border="1" width="100%"
|- bgcolor="silver"
!colspan="4" | New Parameters
|-
|-
|'''Summary of Call'''||
!Parameter Name !! Config Level !! Setting Value !! Result
|-
|-
|'''Detail of Fix''' ||
|ADSN (Allow Duplicate Serial Numbers for Owner)
|OWNR or WARE
|Y
|Allow serial numbers to be uploaded against multiple stocks against a single owner.
Note: As before, only one serial number record will be able to exists a individual stock code at any one point.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|
|
|Not set / any other value
|No change in functionality
|}
|}
<!-- NEW PAGE -->
 
== Customer Ref: ==
{| width="100%"
== Aptean Log Number: 00247545 ==
|-  
{| width="100%"
|width="30%"|'''OBS Log Number:''' || '''Reporter:'''  
|-
|width="30%"|'''Summary of Call'''|| Errors with duplicate serial numbers
|-
|'''Detail of Fix''' || Fix issue when serial number pre-exist and new pallet received which share the same serial number.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Aptean Log Number: 01817971 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| Stock Ordering Issue
|-
|'''Detail of Fix''' || The 'Cases Actual' field for the summary can be changed without displaying an exceptional error message when it is rejected due to 'insufficient stock' or when it is accepted and 'successfully adjusted'.
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Aptean Log Number: 00246130 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| Manufacture Date
|-
|'''Detail of Fix''' || "Fix issue with voyage manufacturing date.
 
When new GRN assigned to a pre-existing voyage with different expected date, ensure that all pre-existing data updated correctly."
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Aptean Log Number: 00224348 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| Fly kitting / Committed Stock
|-
|'''Detail of Fix''' || Ensure that when STOCK WAREHOUSE table updated, the 'Committed' values are never set to a negative value
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Aptean Log Number: 01808849 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| Inbound report
|-
|'''Detail of Fix''' || "Created new customer specific format serials report.
Report allows users to select GRNs or Advice Note No ranges of non-putaway receipts.
Screen added to warehouse reports menu option."
|-
|'''Set-up and Configuration''' ||
|}
 
{| class="wikitable" border="1" width="100%"
|- bgcolor="silver"
!colspan="3" | New Access
|-
|-
|'''Summary of Call'''||
!Access Tab!! Name !! Description
|-
|-
|'''Detail of Fix''' ||
|Warehousing / Warehouse Report
|-
|WHS0280
|'''Set-up and Configuration''' || No set-up/configuration required
|GSK Serial Report Parameter Screen
|}
|}
 
== Aptean Log Number: 01826947 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| Packing Note Changes
|-
|'''Detail of Fix''' || "Amendments to customer format despatch note
Serial Number lines grouped by stock code
Addresses have blank lines removed"
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Aptean Log Number: 01832918 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| Change to deal end date
|-
|'''Detail of Fix''' || Allow deal end date to be changed and audited when registry setting DealChangePassword is set and validated successfully
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}
== Aptean Log Number: 01824820 ==
{| width="100%"
|-
|width="30%"|'''Summary of Call'''|| Remove base charges
|-
|'''Detail of Fix''' || "Add new 'BASE PICK' field to Ware Despatch Details.
 
Amend Manual Pick Confirmation, RF Pick Confirmation and Heavey Pick Confirmation processes to populate field if RBPC (Remove Base Pick Charge) rule is set to Yes for non-part pallet pick.
 
Add new WMS translation value of BASE_PICK to indicate which rate id is the 'picking' charge.
 
If not set, or part pallet pick, set value to No.
 
When despatch invoice values generated, if WMS translation matches Rate ID and rule flag set to Yes, generate picking charge with zero value and description of 'base pick'."
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|}




Line 459: Line 627:


A Portal change is required for the following logs:  
A Portal change is required for the following logs:  
* Log
OR


There are no Portal changes required.
* Log 01798848
 


== EDI ==
== EDI ==

Revision as of 18:22, 15 December 2021




Aptean Logo.png







{{{Client}}}

Release Notes

CALIDUS WMS

8th Dec 2021 - 1.0
Reference: P041











































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: 01735895

Summary of Call Pack List - Development & Test
Detail of Fix "Create new EDI customer specific upload fields

Create customer format despatch note

NOTE: The customer format logo will need to be copied to the 'image' folder. This will need to be done manually."

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

Aptean Log Number: 01798122

Summary of Call Data Validation to SHP EDI message
Detail of Fix Amend the SHP format EDI sales order upload, so that all non-numeric fields are checked and stripped of commas and or double quotes.
Set-up and Configuration No set-up/configuration required

Aptean Log Number: 01798848

Summary of Call WREQ0063020 - New field required in Unison/EDI and GOW
Detail of Fix "Add TEMP_ALARM_PROFILE to Order Header.

Field can only be populated via EDI sales order upload process via the T014 segment.

Field only visible in WMS using EDI Sales Order Processing screen, Enquiry By Order Number screen and ORS Orders report."

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

Aptean Log Number: 01812787

Summary of Call Development for WREQ0064254
Detail of Fix Add new Serial number ADSN (Allow Duplicate Serial Numbers for Owner) rule. The 'Rule' can be set either at owner or warehouse level.

If set, users will be able to receive and hold the same serial number against multiple stock codes.

Goods receipts will allow for same serial number to be receipted against multiple stock codes.

Sales order allocated and picking will be changed to ensure that the correct serial number information is updated.

Additional Comments

ADSN rule only works when linked to VAPS (Validate Against Pre-Advised Serials) rule, as change needs serial number record to be populated with a valid stock code.

It is assumed that no single sales order will contain the same serial number multiple times, as no sales order will despatch stock linked to multiple trials.

NOTE: This change only covers the goods receipt and sales order process. Other processes such as adjustments, movements etc will be covered by a separate change request.

Set-up and Configuration
New Parameters
Parameter Name Config Level Setting Value Result
ADSN (Allow Duplicate Serial Numbers for Owner) OWNR or WARE Y Allow serial numbers to be uploaded against multiple stocks against a single owner.

Note: As before, only one serial number record will be able to exists a individual stock code at any one point.

Not set / any other value No change in functionality


Aptean Log Number: 00247545

Summary of Call Errors with duplicate serial numbers
Detail of Fix Fix issue when serial number pre-exist and new pallet received which share the same serial number.
Set-up and Configuration No set-up/configuration required

Aptean Log Number: 01817971

Summary of Call Stock Ordering Issue
Detail of Fix The 'Cases Actual' field for the summary can be changed without displaying an exceptional error message when it is rejected due to 'insufficient stock' or when it is accepted and 'successfully adjusted'.
Set-up and Configuration No set-up/configuration required

Aptean Log Number: 00246130

Summary of Call Manufacture Date
Detail of Fix "Fix issue with voyage manufacturing date.

When new GRN assigned to a pre-existing voyage with different expected date, ensure that all pre-existing data updated correctly."

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


Aptean Log Number: 00224348

Summary of Call Fly kitting / Committed Stock
Detail of Fix Ensure that when STOCK WAREHOUSE table updated, the 'Committed' values are never set to a negative value
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 01808849

Summary of Call Inbound report
Detail of Fix "Created new customer specific format serials report.

Report allows users to select GRNs or Advice Note No ranges of non-putaway receipts. Screen added to warehouse reports menu option."

Set-up and Configuration
New Access
Access Tab Name Description
Warehousing / Warehouse Report WHS0280 GSK Serial Report Parameter Screen


Aptean Log Number: 01826947

Summary of Call Packing Note Changes
Detail of Fix "Amendments to customer format despatch note

Serial Number lines grouped by stock code Addresses have blank lines removed"

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


Aptean Log Number: 01832918

Summary of Call Change to deal end date
Detail of Fix Allow deal end date to be changed and audited when registry setting DealChangePassword is set and validated successfully
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 01824820

Summary of Call Remove base charges
Detail of Fix "Add new 'BASE PICK' field to Ware Despatch Details.

Amend Manual Pick Confirmation, RF Pick Confirmation and Heavey Pick Confirmation processes to populate field if RBPC (Remove Base Pick Charge) rule is set to Yes for non-part pallet pick.

Add new WMS translation value of BASE_PICK to indicate which rate id is the 'picking' charge.

If not set, or part pallet pick, set value to No.

When despatch invoice values generated, if WMS translation matches Rate ID and rule flag set to Yes, generate picking charge with zero value and description of 'base pick'."

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
DATA_WAREHOUSE_RULES_CONTROL_01595090.sql 4.1 Data Script 01595090
DP_WHS2180.sql 4.16 Find Nearest Free Location 01595090
DP_WHS2185.sql 4.32 Suggested Location database package 01595090
DATA_WAREHOUSE_RULES_00225983.sql 4.2 Data Script 00225983
DATA_WAREHOUSE_RULES_CONTROL_00225983.sql 4.1 Data Script 00225983
DP_RDT_PICK_CONF.sql 4.126 RDT Pick Confirmation 00225983
SOS1110.fmx 4.150 Sales Order Entry 01782160
DP_PORTAL.sql 4.28 Portal Package 01786354
DP_DESPATCH.sql 4.104 Despatch Confirmation Package 1 01759926
WHS0110.fmx 4.94 Goods Receipt Pre-Advice 01782573
DATA_DYNAMIC_MESSAGES_01782573.sql 4.1 Data Script 01782573
DP_WHS0150.sql 4.52 Goods Receipt Confirmation 01782573
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.259 Inbound EDI Sales Order Upload 01735895
DP_EDIGEN_SALES_ORDER_VAL.sql 4.226 Order_Header update package 01735895
DP_UNIX_FILES.sql 4.25 Database Package 01735895
AT_EDI_SALES_ORDER_DETAIL_01735895.sql 4.1 Data Script 01735895
AT_EDI_SALES_ORDER_MASTER_01735895.sql 4.1 Data Script 01735895
AT_ORDER_DETAIL_01735895.sql 4.1 Data Script 01735895
AT_ORDER_HEADER_01735895.sql 4.1 Data Script 01735895
CT_EDI_SALES_ORDER_CONTENTS_01735895.sql 4.1 Data Script 01735895
CT_ORDER_DETAIL_CONTENTS_01735895.sql 4.1 Data Script 01735895
DATA_DYNAMIC_MESSAGES_01782573.sql 4.1 Data Script 01735895
DATA_EDI_MAPS_01735895.sql 4.1 Data Script 01735895
DATA_ML_CAPTIONS_01735895.sql 4.1 Data Script 01735895
DATA_SYSTEM_REGISTRY_01735895.sql 4.1 Data Script 01735895
WHR1900_GSK.rdf 4.2 GSK format despatch note 01735895
PFS1541.fmx 4.45 EDI Sales Order Validation 01735895
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.260 Inbound EDI Sales Order Upload 01798122
DP_EDIGEN_PRE_ADVICE_LOAD.sql 4.70 WMS Pre Advice EDI load 00239592
DP_NOMS_DESPREC.sql 4.32 Despatch Receipt 00231329
DP_EDIGEN_PRE_ADVICE_VAL.sql 4.91 EDI Pre-Advice Validation 01755175
DP_YBW_IF.sql 4.43 Integration Package 01755175
DP_SERIALS_2.sql 4.16 Medical/Serial Number entry/validation package 00233137
DATA_EDI_MAPS_01807797.sql 4.1 Data Script 01807797
WHR1900_GSK.rdf 4.3 GSK format despatch note 01807797
ENQSOON01A.fmx 4.39 Enquiry By Order Number 01798848
PFS1541.fmx 4.46 EDI Sales Order Validation 01798848
DP_EDIGEN_SALES_ORDER_VAL.sql 4.227 Order_Header update package 01798848
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.261 Inbound EDI Sales Order Upload 01798848
DATA_ORS_MASTER_DATA_01798848.sql 4.1 Data Script 01798848
DATA_EDI_MAPS_01798848.sql 4.1 Data Script 01798848
AT_ORDER_HEADER_01798848.sql 4.1 Data Script 01798848
AT_EDI_SALES_ORDER_MASTER_01798848.sql 4.1 Data Script 01798848
DP_COPY_OWNER.sql 4.16 Copy owner processing 01793009
WHR1900_GSK.rdf 4.5 GSK format despatch note 00246304
DP_WMS_ALLOC.sql 4.191 Allocation Procedure 01812787
DP_SERIALS_2.sql 4.17 Medical/Serial Number entry/validation package 01812787
DP_EDIGEN_PRE_ADVICE_VAL.sql 4.92 EDI Pre-Advice Validation 01812787
AT_SERIAL_NUMBER_RANGE_01812787.sql 4.1 Data Script 01812787
AT_OWNER_MED_TRANSLATION_01812787.sql 4.1 Data Script 01812787
DATA_WAREHOUSE_RULES_CONTROL_01812787.sql 4.1 Data Script 01812787
DATA_WAREHOUSE_RULES_01812787.sql 4.1 Data Script 01812787
AT_EDI_PRE_ADVICE_SERIALS_IN_01812787.sql 4.1 Data Script 01812787
WHS0200.fmx 4.19 Pick by Line Ticket Print Kick Off 01812787
DATA_OWNER_MED_TRANSLATIONS_01812787.sql 4.1 Data Script 01812787
WHS0200.fmx 4.21 Pick by Line Ticket Print Kick Off 00247545
POS1020.fmx 4.40 Stock Demand Control Processing 01817971
WHS0110.fmx 4.95 Goods Receipt Pre-Advice 00246130
DP_WHS0150.sql 4.53 Goods Receipt Confirmation 00246130
SOS1110.fmx 4.151 Sales Order Entry 00224348
SOS1117.fmx 4.91 Sales Order Detail Lines 00224348
DP_SAW.sql 4.11 Stock Warehouse Update 00224348
DATA_DYNAMIC_MESSAGES_01808849.sql 4.1 Data Script 01808849
WHS0280.fmx 4.1 GSK Serial Report Parameter Screen 01808849
DATA_FXM_OPTIONS_01808849.sql 4.1 Data Script 01808849
DATA_FXM_SCREENS_01808849.sql 4.1 Data Script 01808849
DP_WHS0280.sql 4.1 GSK Serial Report Package 01808849
TRG_INS_IAJD.sql 4.33 Row-level Insert trigger for IAJD 01759102
TRG_INS_IAJD_AIS.sql 4.14 Table level Insert trigger for IAJD 01759102
DP_CONF_EDI_OUT.sql 4.33 Dynamic Outbound EDI package 01759102
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.262 Inbound EDI Sales Order Upload 01807207
DP_PICK_CONF_1.sql 4.74 Pick Confirmation Database Package 1 01822211
DP_POP.sql 4.52 Purchase Order Processing 01822860
STS1085.fmx 4.4 Standard Cost Maintenance 01822860
POS1012.fmx 4.11 Mass PO Suggestion Confirmation 01822860
POS1013.fmx 4.6 Purchase Order Generation 01822860
WHR1900_GSK.rdf 4.9 GSK format despatch note 01826947
WHS1714.fmx 4.133 Pick Confirmation 00252051
SOS1428.fmx 4.20 Stock Kits Assembly Request 01827829
SOS7100.fmx 4.6 Deals Maintenance Form 01832918
CT_DEAL_HEADER_AUDIT_01832918.sql 1.1 Data Script 01832918
DATA_DYNAMIC_MESSAGES_01832918.sql 1.1 Data Script 01832918
TRG_DEAL_HEADER_BIUR.sql 4.1 Trigger 01832918
WHS1710A.fmx 4.99 Pick List Confirmation 01824820
DP_PICK_CONF_1.sql 4.75 Pick Confirmation Database Package 1 01824820
DP_PICK_CONF_2.sql 4.32 Pick Confirmation Database Package 2 01824820
AT_WARE_DESPATCH_DETAILS_01824 4.1 Data Script 01824820
DP_RDT_PICK_CONF.sql 4.128 RDT Pick Confirmation 01824820
DP_HVY_PICK_CONF.sql 4.14 Pick Confirm 01824820
DP_UPM_WHS_CHARGE.sql 4.29 Invoice Charges Procedure 01824820
DATA_WMS_TRANSLATIONS_01824820 4.1 Data Script 01824820
WHS1714.fmx 4.134 Pick Confirmation 01833363
DP_EDIGEN_SALES_ORDER_VAL.sql 4.228 Order_Header update package 00254221
AT_EDI_SALES_ORDER_CONTENTS_00 4.1 Data Script 00254221
DP_EDIGEN_SALES_ORDER_VAL.sql 4.229 Order_Header update package 01844339
DP_STOCK_DEMAND.sql 4.54 Overnight Stock Demand Process 01845111
DATA_CONF_EDI_OUT_MSG_LEVEL_COLS_01836177.sql 4.1 Data Script 01836177
WHS1714.fmx 4.135 Pick Confirmation 01845685
DP_EDIGEN_SALES_ORDER_VAL.sql 4.230 Order_Header update package 01846217
DP_CONF_EDI_OUT.sql 4.34 Dynamic Outbound EDI package 00258198
DP_YBW_IF.sql 4.44 Integration Package 01817969
DP_NET_PORTAL.sql 4.63 Package for .net diary system 01817969
DP_WMS_ALLOC.sql 4.192 Allocation Procedure 01817969
DP_WMS_ALLOC.sql 4.193 Allocation Procedure 01838108
DP_CONF_EDI_IN_2.sql 4.38 Configurable EDI 2 Package 01838108
WHS1910.fmx 4.94 Despatch Confirmation 01828576
PFS1510_GEN.fmx 4.28 Generic Inbound EDI pre-advice 01855577
DP_EDIGEN_PRE_ADVICE_LOAD.sql 4.71 WMS Pre Advice EDI load 01855577
DP_EDIGEN_PRE_ADVICE_VAL.sql 4.93 EDI Pre-Advice Validation 01855577
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.263 Inbound EDI Sales Order Upload 01896911
DP_RDT_GRNCONF.sql 4.77 RDT Goods Receipt Confirmation 01847240


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 01798848


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_P041&oldid=9770’