PATCH WMS 810 P023

From Calidus HUB
Revision as of 11:58, 2 June 2017 by StylesC (talk | contribs)





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS WMS

1st June 2017 - 1.0
Reference: P023











































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: SC-AKPF88

OBS Log Number: 341989
Reporter: Steve Carpenter
Summary of Call CR01 - Case Filter on Pick Wave
Detail of Fix Added 2 new selection criteria - select by customer and select by either units, cases or mixed orders.
Set-up and Configuration No set-up/configuration required


Customer Ref: SC-AKPGY6

OBS Log Number: 341992
Reporter: Steve Carpenter
Summary of Call CR04 - I/B - Order & Product EDI Changes
Detail of Fix Pass manufacture and sell by date to RDT goods receipt process

Set customer po number and line no for RDT create pallet records.

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


Customer Ref: SC-AKPGY6

OBS Log Number: 342710
Reporter: Dave Potter
Summary of Call Log to release 341992/SC-AKPGY6
Detail of Fix Amend inbound product upload - adding 2 new fields - Alloc Proc Seq and Stock Audit

Amend inbound GRN upload - adding 2 new segments - J022 (stock level) and J032 (pallet level).

Amend EDI product and EDI GRN upload validation screens to maintain new fields.

Change goods receipt confirmation to allow users to add / maintain customer po line number field.

Add rule ACLM (Allow users to maintain Customer PO Line No) to control whether this new field is display or not.

Set-up and Configuration


Registry/Rules Settings
Path & Name Setting Value Result
Owner / ACLM Y Customer PO line number field is user maintainable
(Allow users to maintain Customer PO Line No) Any other value Customer PO line number field is display only
Owner / GCR4 Y R004 segment produced
(GRMK Rec Conf Message creates R004 segment) Any other value R004 segment not produced

Customer Ref: Pack List Update

OBS Log Number: 342804
Reporter: Phil Harding
Summary of Call Customer specific pack list
Detail of Fix New KLE format despatch note.
Set-up and Configuration No set-up/configuration required


Customer Ref: Despatch Note

OBS Log Number: 342911
Reporter: Emilia Borecka
Summary of Call Generic despatch note
Detail of Fix New generic format despatch note 'GEN' for customer using WMS translation to hold channel specific return address and information.
Set-up and Configuration No set-up/configuration required


Customer Ref: EDI

OBS Log Number: 342035
Reporter: Sue Blake
Summary of Call SHP new EDI
Detail of Fix Create new 'SHP' EDI sales order upload.
Set-up and Configuration No set-up/configuration required


Customer Ref: RNC despatch EDI

OBS Log Number: 342320
Reporter: Sue Blake
Summary of Call Change to RNC despatch EDI
Detail of Fix Change RNC flow adding new RDCC Owner rule (Ren Despatch EDI Customer Configuration).
Set-up and Configuration


Registry/Rules Settings
Path & Name Setting Value Result
Owner / RDCC A Select both ‘WEBORDER’ (B2C customer) and non-WEBORDER customers (B2B customer)
Ren Despatch EDI Customer Configuration B Select non-WEBORDER customers (B2B customer) only
C No change - select ‘WEBORDER’ (B2C customer) only
Not set or any other value No change - select ‘WEBORDER’ (B2C customer) only


Customer Ref: Returns Processing

OBS Log Number: 342568
Reporter: Emilia Borecka
Summary of Call Returns Processing
Detail of Fix Goods receipt processing amended to use new owner rule RRST to allow return/receipt of redundant stock.
Set-up and Configuration


Registry/Rules Settings
Path & Name Setting Value Result
Owner / RRST Y 'Y' to allow receipt/return of redundant stock

Customer Ref: Despatch note

OBS Log Number: 343173
Reporter: Sue Blake
Summary of Call Despatch note format change
Detail of Fix The new despatch note format MUR will be available for selection in the Despatch Print screen.
Set-up and Configuration No set-up/configuration required


Customer Ref: Rotation Numbers

OBS Log Number: 342143
Reporter: Barry Preece
Summary of Call Allocate single rotation numbers
Detail of Fix Line type 8 functionality added to allocate from a single rotation.
Set-up and Configuration No set-up/configuration required


SUPPORT INCIDENTS

Customer Ref: Stock Enquiry

OBS Log Number: 341841
Reporter: Michael Huxley
Summary of Call Date of Last Field in Stock Enquiry
Detail of Fix Amendment to Pallet level stock enquiry ENQSKSK03A to prevent stock balance fields from being updated in an enquiry screen.
Set-up and Configuration No set-up/configuration required


Customer Ref: Pick Conf

OBS Log Number: 342086
Reporter: Jennie Baldwin
Summary of Call Catch Weight balance from Pick Conf
Detail of Fix Amendment to Pick Confirmation so adjustments to stock with a catch weight balance are correctly reflected if adjustments (zero pick) are made when pick confirming an order.
Set-up and Configuration No set-up/configuration required


Customer Ref: Pick List

OBS Log Number: 342099
Reporter: Michael Huxley
Summary of Call Pick List not printing correctly
Detail of Fix New owner rule DSAP (Display stock AKA code on FWP pick list) has been added. When not set, or set to N the standard stock code will print.

When set to Y, if an AKA code is present this will be appended to the stock code on the output.

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


Customer Ref: EDI

OBS Log Number: 342174
Reporter: Howard Allen
Summary of Call FRE EDI process shows wrong line number-
Detail of Fix Amendment to FRE format EDI despatch message to populate line number correctly.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC17742549

OBS Log Number: 342481
Reporter: Ryan Mclaren
Summary of Call Specific user unable to print despatch
Detail of Fix Amendment to Despatch notes formats CT1 and FWL to set the logon id to 12 characters to match the field size in the database.
Set-up and Configuration No set-up/configuration required


Customer Ref: EDI Update

OBS Log Number: 342796
Reporter: Phil Harding
Summary of Call 'Stockist sub code' field removal
Detail of Fix Amend the outbound EDI goods receipt confirmation message, so that the separated R002 format matches expected layout.

This is done by removed rogue stockist sub code field.

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


Customer Ref: 04.05.17 KP

OBS Log Number: 342824
Reporter: Krzysztof Pruski
Summary of Call Haz info not included in outbound EDI fi
Detail of Fix Amendment to VIGO interface to ensure HAZ record is written for stock codes with hazardous details.
Set-up and Configuration No set-up/configuration required


Customer Ref: Despatch Note

OBS Log Number: 343031
Reporter: Daniel Brown
Summary of Call Wes despatch note formatting error
Detail of Fix Layout amendments so large orders are displayed correctly.
Set-up and Configuration No set-up/configuration required


Customer Ref: Replen Issue

OBS Log Number: 343201
Reporter: Simon Eland
Summary of Call Replen Issue
Detail of Fix Ensure that RDT message status is set correctly, that the message is only put on hold when neccessary.
Set-up and Configuration No set-up/configuration required


Customer Ref: Packing Note Update

OBS Log Number: 343250
Reporter: James Lees
Summary of Call KLE Packing Note Update
Detail of Fix Layout changes. Ensure labels displayed fully.
Set-up and Configuration No set-up/configuration required


Customer Ref: RF Replen Type

OBS Log Number: 342583
Reporter: Phil Harding
Summary of Call RF Replen Type - ADD Rule
Detail of Fix Add new owner rule RASM (Replen Always Stock Moves). If set to Yes, all moves, regardless of quantity, will be set as stock moves.
Set-up and Configuration No set-up/configuration required


Customer Ref: Inbound Labels

OBS Log Number: 342736
Reporter: Phil Harding
Summary of Call Prevent lable generation
Detail of Fix Prevent label generation if warehouse rule PLGR is set to Y and if the GR is identified as a return.
Set-up and Configuration No set-up/configuration required


Customer Ref: Overnight Orders

OBS Log Number: 342121
Reporter: Michael Huxley
Summary of Call Overnight Orders Report
Detail of Fix Amend orders report so that if multiple product types exist for a specific order, order data is not duplicated.
Set-up and Configuration No set-up/configuration required


Customer Ref: INC17669292

OBS Log Number: 342359
Reporter: Ryan Mclaren
Summary of Call EDI Polling Crashed - Screen Hangs
Detail of Fix Add new index to improve performance
Set-up and Configuration No set-up/configuration required


Customer Ref: eec email

OBS Log Number: 342371
Reporter: Emily Collins
Summary of Call NOMS deals issue
Detail of Fix Fix issue that when ordered quantity greater than max ordered quantity, deal discount calculated only on valid figure, not on invalid quantity.
Set-up and Configuration No set-up/configuration required


Customer Ref: N/A

OBS Log Number: 342165
Reporter: Dave Bessell
Summary of Call Lower Case Order Number
Detail of Fix Upshift order numbers on creation
Set-up and Configuration No set-up/configuration required


Customer Ref: ORS Report

OBS Log Number: 342458
Reporter: Howard Allen
Summary of Call Duplicate Records on ORS report
Detail of Fix Amendment to standing data parameters for ORDERS reports in Oracle Reporting suite to include the owner code in link to the pack header.
Set-up and Configuration No set-up/configuration required


Customer Ref: ORS Data

OBS Log Number: 342401
Reporter: Peter Blackburn
Summary of Call Add order line comment to ORS data
Detail of Fix Add Order Line Comment field to ORS master data at order detail level.
Set-up and Configuration No set-up/configuration required


TID CHANGES

OBS Log Number: 333892

Customer Ref: Pick Sheet
Reporter: James Ross
Summary of Call Info Missing From Pick Sheet
Detail of Fix Amend report for 11g - ensure barcode does not overlap text fields.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 342661

Customer Ref: 250417
Reporter: M Woods
Summary of Call OBS Ref 342371
Detail of Fix Ensure link from deal header and deal detail is unique
Set-up and Configuration No set-up/configuration required


OBS Log Number: 343345

Customer Ref: GRN EDI error
Reporter: Dave Potter
Summary of Call allow files over 40 chars to be uploaded
Detail of Fix Ensure if file name longer than 40 characters, file can be moved to archive directory successfully.
Set-up and Configuration No set-up/configuration required


OBSL PRODUCT DEVELOPMENT

OBS Log Number: 342749

Reporter: Dave Potter
Summary of Call Fix compilation error.
Detail of Fix Change handling of WLE records, so that database changes doesn't invalidate package. Change handling of WLE records, so that database changes doesn't invalidate package.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 330697

Reporter: Phil Harding
Summary of Call WHS0610 Bulk To Pick Replenishment Updat
Detail of Fix Bulk to pick replenishment screen (WHS0610) changed to display log entries in main screen and to list the audit numbers of the move(s) created allowing the Stock Movement screen (WHS0700) to be displayed directly from the replen screen.

The Stock Movements screen has been changed to receive the audit number from WHS0610 and display the associated movement details.

Change made to ensure trans in/out qtys on pallet records updated if move qty changed.

Further validation added to prevent pallet ID to from being changed after pallet records (WLEs) have been updated.

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


OBS Log Number: 340814

Reporter: Phil Harding
Summary of Call ENQSOON10A update2
Detail of Fix Amendment to order enquiry screen ENSSOON10A.fmx to add totals to status summary and to allow user to double click on a status to view on orders at that status.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 342540

Reporter: Phil Harding
Summary of Call std pallet qty passed to RF update
Detail of Fix If unit_of_measure2 matches the stocking_uom, set the std_pallet_qty to case qty rather than the unit qty.
Set-up and Configuration No set-up/configuration required


MODULES DELIVERED

Module Name Version No Description Log Number
AT_EDI_GRN_CONF_DETAIL_OUT_341992.sql 4.1 Alter Table Script 342710
AT_EDI_PRE_ADVICE_DETAIL_IN_341992.sql 4.1 Alter Table Script 342710
AT_EDI_PRE_ADVICE_PALLET_IN_341992.sql 4.1 Alter Table Script 342710
AT_EDI_PRODUCT_MASTER_341992.sql 4.1 Alter Table Script 342710
AT_WARE_GOODS_ENTRY_DETAILS_341992.sql 4.1 Alter Table Script 342710
AT_WARE_GOODS_ENTRY_PALLETS_341992.sql 4.1 Alter Table Script 342710
AT_WARE_LOCATION_ENTRIES_341992.sql 4.1 Alter Table Script 342710
AT_WMS_TRANSLATIONS_342911.sql 4.1 Alter Table Script 342911
AT_XF_PROCESS_TRACKING_342359.sql 4.1 Alter Table Script 342359
CT_STOCK_REDUNDANT_UPLOAD_342568.sql 4.1 Create Table Script 342568
DATA_CONF_EDI_IN_MSG_342568.sql 4.1 Data Script 342568
DATA_CONF_EDI_IN_MSG_COLS_342568.sql 4.1 Data Script 342568
DATA_DYNAMIC_MESSAGES_341992.sql 4.1 Data Script 342710
DATA_EDI_MAPS_341992.sql 4.1 Data Script 342710
DATA_EDI_MAPS_342035.sql 4.1 Data Script 342035
DATA_ML_CAPTIONS_330697.sql 4.1 Data Script 330697
DATA_ML_CAPTIONS_341989.sql 4.1 Data Script 341989
DATA_ML_CAPTIONS_342143.sql 4.1 Data Script 342143
DATA_ML_CAPTIONS_342911.sql 4.1 Data Script 342911
DATA_ML_CAPTIONS_343173.sql 4.1 Data Script 343173
DATA_ORS_MASTER_DATA_342401.sql 4.1 Data Script 342401
DATA_ORS_SQL_342458.sql 1.1 Data Script 342458
DATA_SYSTEM_REGISTRY_343173.sql 4.1 Data Script 343173
DATA_WAREHOUSE_RULES_CONTROL_342099.sql 1.2 Data Script 342099
DATA_WAREHOUSE_RULES_CONTROL_342320.sql 4.1 Data Script 342320
DATA_WAREHOUSE_RULES_CONTROL_342568.sql 4.1 Data Script 342568
DATA_WAREHOUSE_RULES_CONTROL_342583.sql 4.1 Data Script 342583
DATA_WAREHOUSE_RULES_CONTROL_342710.sql 4.2 Data Script 342710
DATA_WAREHOUSE_RULES_CONTROL_342736.sql 1.1 Data Script 342736
DATA_XF_COMMAND_342568.sql 4.1 Data Script 342568
DP_CONF_EDI_IN.sql 4.84 Dynamic Inbound EDI package 342568
DP_DEAL_CALC.sql 4.15 Deals Calculation Package 342661
DP_EDI_OUTBOUND.sql 4.96 EDI Outbound Receipt Confirmation 342568
DP_EDI_OUTBOUND.sql 4.97 EDI Outbound Receipt Confirmation 342710
DP_EDIGEN_OUT_GEN_INTF.sql 4.11 Outbound EDI Generic Interface 342121
DP_EDIGEN_OUT_PDP_CONF.sql 4.85 Outbound EDI Generation 342174
DP_EDIGEN_OUT_PDP_CONF.sql 4.86 Outbound EDI Generation 342320
DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql 4.31 Receipt conf outbound file creation 342568
DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql 4.33 Receipt conf outbound file creation 342710
DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql 4.34 Receipt conf outbound file creation 342796
DP_EDIGEN_OUT_SALES.sql 4.15 Outbound EDI Sales Process 342568
DP_EDIGEN_OUT_TRANSPORT.sql 4.20 Outbound EDI Transport Package 342824
DP_EDIGEN_OUTBOUND.sql 4.14 Outbound EDI 342710
DP_EDIGEN_PRE_ADVICE_LOAD.sql 4.34 WMS Pre Advice EDI load 342710
DP_EDIGEN_PRE_ADVICE_LOAD.sql 4.35 WMS Pre Advice EDI load 343345
DP_EDIGEN_PRE_ADVICE_VAL.sql 4.56 EDI Pre-Advice Validation 342710
DP_EDIGEN_PROD_VAL.sql 4.42 Inbound EDI Stock Upload Validation 342710
DP_EDIGEN_PRODUCT_MASTER_LOAD.sql 4.28 EDI Stock Table Upload 342710
DP_EDIGEN_REPLEN_VAL.sql 4.6 EDI Replenish validation file 342583
DP_EDIGEN_REPLEN_VAL.sql 4.7 EDI Replenish validation file 342749
DP_EDIGEN_REPLEN_VAL.sql 4.8 EDI Replenish validation file 343201
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.191 Inbound EDI Sales Order Upload 342035
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.192 Inbound EDI Sales Order Upload 342165
DP_EDIGEN_SALES_ORDER_VAL.sql 4.167 Order_Header update package 342143
DP_ENQSOON10A.sql 4.3 Database Package 340814
DP_PICK_CONF_1.sql 4.51 Pick Confirmation Database Package 1 342086
DP_PICK_CONF_2.sql 4.17 Pick Confirmation Database Package 2 342086
DP_PRE_BATCH_PROCESS.sql 4.2 Pre Batch process package 341989
DP_RDT.sql 4.35 RDT Messages 341992
DP_RDT_GRNCONF.sql 4.28 RDT Goods Receipt Confirmation 342736
DP_RDT_GRNCONF.sql 4.29 RDT Goods Receipt Confirmation 341992
DP_RDT_STOCK_DRIP_FEED.sql 4.17 RDT Stock Drip Feed Process 342540
DP_RDT_STOCK_DRIP_FEED.sql 4.18 RDT Stock Drip Feed Process 342568
DP_WHS0150.sql 4.41 Goods Receipt Confirmation 342710
DP_WMS_ALLOC.sql 4.130 Allocation Procedure 342143
ENQSKSK03A.fmx 4.8 Stock Enquiry Detail 341841
ENQSOON10A.fmx 4.9 Order Enquiry - Multiple warehouses/owners 340814
LAS0312.fmx 4.128 Pick Wave Maintenance 341989
PFS1510_GEN.fmx 4.21 Generic Inbound EDI pre-advice 342710
PFS1520.fmx 4.13 Product Master Validation 342710
SOS7000.fmx 4.58 Simple Order Entry 342371
WHR1700_FWP.rdf 4.19 Pick/Pack List 333892
WHR1700_FWP.rdf 4.20 Pick/Pack List 342099
WHR1720_NOV.rdf 4.10 Pick List 333892
WHR1720_SER.rdf 4.11 Serial Number Format Pick List 333892
WHR1900_CT1.rdf 4.8 CT1 Format Despatch Note 342481
WHR1900_FWL.rdf 4.7 Despatch Note Print - Generic 342481
WHR1900_GEN.rdf 4.1 Generic Despatch Note 342911
WHR1900_MUR.rdf 4.1 Customer Despatch Note 343173
WHR1900_WES.rdf 4.18 Client specific despatch note 343031
WHR1945_KLE.rdf 4.2 Customer Packing Label 342804
WHR1945_KLE.rdf 4.3 Customer Packing Label 343250
WHS0003.fmx 4.3 Default Printer Maintenance - Find Default Printer 342911
WHS0110.fmx 4.49 Goods Receipt Pre-Advice 342568
WHS0150.fmx 4.116 Goods Receipt Confirmation 342710
WHS0172.fmx 4.26 Rotation Stock Details 342568
WHS0610.fmx 4.21 Bulk to Multi Pick Replenishment 330697
WHS0700.fmx 4.40 Warehouse Movements 330697
WHS1710A.fmx 4.64 Pick List Confirmation 342086
WHS1945.fmx 4.87 Pack Header 342804


ADDITIONAL CHANGES

WCS

A WCS change is required for the following logs:

  • 342568


EPOD/T2A

There are no ePOD/T2A changes required.


MCS

There are no MCS changes required.


PORTAL/TTM

There are no Portal changes required.


EDI

There are no EDI changes required.


Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=PATCH_WMS_810_P023&oldid=4480’