WMS 810 ER014-002

EMERGENCY RELEASE - WMS 810

RELNOTE ER014-002

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
AT_CARRIERS_325028.sql	Alter Table Script	4.1	325028	EDI Process	3	Amendment to add Q8 format inbound and outbound EDI flows, along with a new Q8 format despatch note. Covers inbound sales order and outbound GRMK, stock balances, notification of ohange of order status and outbound despatch message for Clarkes haulier.	Paul Reed
AT_EDI_SALES_ORDER_DETAIL_325028.sql	Alter Table Script	4.1	"	"	"	"	"
AT_EDI_SALES_ORDER_MASTER_325028.sql	Alter Table Script	4.1	"	"	"	"	"
AT_ORDER_DETAIL_325028.sql	Alter Table Script	4.1	"	"	"	"	"
AT_ORDER_HEADER_325028.sql	Alter Table Script	4.1	"	"	"	"	"
AT_STK_STOCKIST_325028.sql	Alter Table Script	4.1	"	"	"	"	"
DATA_EDI_MAPS_325028.sql	Data Script	4.2	"	"	"	"	"
DATA_ML_CAPTIONS_325028.sql	Data Script	4.1	"	"	"	"	"
DATA_PROGRAM_IMAGES_325028.sql	Data Script	4.1	"	"	"	"	"
DATA_WAREHOUSE_RULES_CONTROL_325028.sql	Data Script	4.1	"	"	"	"	"
DP_DESPATCH.sql	Despatch Processing	4.67	"	"	"	"	"
DP_EDIGEN_OUT_PDP_CONF.sql	Outbound order messages	4.62	"	"	"	"	"
DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql	Outbound goods receipt confirmation	4.23	"	"	"	"	"
DP_EDIGEN_OUT_ST_BAL.sql	Outbound Stock Balances	4.55	"	"	"	"	"
DP_EDIGEN_OUT_TRANSPORT.sql	EDI Transport Interface	4.14	"	"	"	"	"
DP_EDIGEN_SALES_ORDER_LOAD.sql	EDI Sales Order Load	4.154	"	"	"	"	"
DP_EDIGEN_SALES_ORDER_VAL.sql	EDI Sales Order Validation	4.143	"	"	"	"	"
DATA_DYNAMIC_MESSAGES_325028.sql	Data Script	4.1	"	"	"	"	"
PFS1541.fmx	EDI SOP Validation Screen	4.28	"	"	"	"	"
STS1000.fmx	Owner Maintenance	4.84	"	"	"	"	"
WHR1900_Q8.rdf	Despatch Note	4.1	"	"	"	"	"
WHS0150.fmx	Goods Receipt Confirmation	4.106	"	"	"	"	"
WHS0172.fmx	One screen goods receipt	4.23	"	"	"	"	"

Registry/Rules Settings
Path & Name	Setting Value	Result
Owner	Y	Q8 enabled 'Y' In goods receipt cust PO field is mandatory
Owner	N/Null	Cust PO field not mandatory

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
STS4080.fmx	Owner Maintenance	4.2	325813	VAT Text on desp note	3	Add new 1 char VAT Text field to RNC EDI flow. Depending on VAT Text of order header print appropriate text message of RNC format despatch note.	Howard Allen
AT_OWNER_MESSAGE_325813.sql	Alter Table Script	4.1	"	"	"	"	"
WHR1900_RNC.rdf	RNC format despatch note	4.8	"	"	"	"	"
DP_EDIGEN_SALES_ORDER_LOAD.sql	EDI Sales Order Load	4.154	"	"	"	"	"
AT_ORDER_HEADER_325813.sql	Alter Table Script	4.1	"	"	"	"	"
AT_EDI_SALES_ORDER_MASTER_325813.sql	Alter Table Script	4.1	"	"	"	"	"
DATA_EDI_MAPS_325813.sql	Database Script	4.1	"	"	"	"	"

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
DATA_DYNAMIC_MESSAGES_320949.sql	Data Script	4.1	320949	RM-9P7DGF	3	The database script will create a new owner-level rule called 'GWDV' ('GEN Weights and Dimensions Validation') that can be configured for the owner of a GRN to ensure that the stock codes that are being received have all of the required data before the GRN can be confirmed as received: 1 Gross Weight 2 Net Weight 3 Case Length 4 Case Width 5 Case Depth 6 Case Volume The database script will create 3 new dynamic messages that can be issued in the Goods Receipt Confirmation screen. When the owner-level rule 'GWDV' is set to 'Y' the user will be prompted to enter the missing stock data before entering the pallet details for the stock code being received. The user will not be able to confirm the GRN until all of the missing stock data has been entered.	Ryan McLaren
DATA_WAREHOUSE_RULES_CONTROL_320949.sql	Data Script	4.1	"	"	"	"	"
WHS0150.fmx	Goods Receipt Confirmation Form	4.105	"	"	"	"	"

Registry/Rules Settings
Path & Name	Setting Value	Result
Owner Rule 'GWDV'	Y	The user will be prompted to enter the missing stock data before entering the pallet details for the stock code being recieved. The user will not be able to confirm the GRN until all of the missing stock data has ben entered
Owner Rule 'GWDV'	N or NUll or it does not exist	The user will not be prompted to enter the missing stock data

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
DP_EDIGEN_SALES_ORDER_LOAD.sql	EDI Sales Order Load	4.152	326971	GBB Format EDI	3	Created new GBB format based on RAB format with the addition of the customer code	Howard Allen
DATA_EDI_MAPS_326971.sql	Data Script	4.1	"	"	"	"	"

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
DP_EDIGEN_SALES_ORDER_VAL.sql	EDI Sales Order Validation	4.141	326404	-	4	Amend 'orphan record' validation to also remove order well and free type address records.	Emily Collins

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
DATA_WAREHOUSE_RULES_CONTROL_326907.sql	Data Script	4.1	326907	ST096	3	Add OELN (Original EDI Line No) rule, which if set, will store original order line no for split order	Steve Talbott
DP_EDIGEN_SALES_ORDER_LOAD.sql	EDI Sales Order Load	4.154	"	"	"	"	"
DP_EDIGEN_OUT_PDP_CONF.sql	Database Package	4.64	"	"	"	"	"

Registry/Rules Settings
Path & Name	Setting Value	Result
Owner/OELN	Y	The SAP EDI line number is populated using the line position, line 1 - 1, line 2 - 2and so on
Original EDI Line Number	Not set or any other value	Pre-existing functionality applies

Module	Program Name	Ver	Call/Iss	Client Ref	Pr'ty	Remarks	Reporter
AT_EDI_PDP_DETAIL_OUT_321459.sql	Alter Table Script	4.1	321459	HT-9PND4W	3	The 'AT' database scripts will alter the database tables to add the new items. The 'DATA' database script will insert the new EDI mapping for the 'PACK' import file format. The 'CT' database script will create a new sequence number for the manual order allocation file. The database trigger will include the new manual order allocation assessment. The database packages will: 1. Copy the new items for a new owner. 2. Import the new 'PACK' file. 3. Create the new manual order allocation file. 4. Include the new 'PRICE' section in the manual and EDI order allocation files. 5. Include the new 'PACK' section in the pack complete, despatch confirmation and POD confirmation files. The 'Owner Maintenance' screen will display the new items for configuration in the 'Outbound Despatch Message' section in the 'EDI Outbound' tab page: 1. Price on OB Alloc Message 2. Pack on OB Desp Message 3. EDI Currency Code A new outbound EDI process will need to be setup: 1. Process Code: '{COMPANY_CODE}{WAREHOUSE_ID}{ORDER_OWNER}_GEN_MNALC'. 2. Process Description: 'Manual Order Allocation Message'. 3. Process Command: 'DESP1'. 4. Transfer Method: 'EDI'. 5. Transfer Type: 'EDI Transfer'. 6. Send/Receive 'Send'. 7. All Warehouses: 'No'. The 'Process Type' can be configured as required. The 'EDI File Separator' can be specified as required. The directory parameters and file patterns can be specified for the database as required.	Hemal Tailor
AT_EDI_PDP_HEADER_OUT_321459.sql	Alter Table Script	4.1	"	"	"	"	"
AT_STK_STOCKIST_321459.sql	Alter Table Script	4.2	"	"	"	"	"
CT_EDI_MA_SEQ_321459.sql	Create Table Script	4.1	"	"	"	"	"
DATA_EDI_MAPS_321459.sql	Data Script	4.1	"	"	"	"	"
TRG_ORDER_HEADER_AU.sql	Trigger	4.4	"	"	"	"	"
DP_COPY_OWNER.sql	Copy Owner Package	4.13	"	"	"	"	"
DP_EDIGEN_DHEG_UPD_LOAD.sql	Inbound EDI Package	4.6	"	"	"	"	"
DP_EDIGEN_DHEG_UPD_VAL.sql	Inbound EDI Package	4.10	"	"	"	"	"
DP_EDI_OUTBOUND.sql	Outbound EDI Package	4.87	"	"	"	"	"
DP_EDIGEN_OUT_PDP_CONF.sql	4.63	Outbound EDI Package	"	"	"	"	"
STS1000.fmx	Owner Maintenance Form	4.85	"	"	"	"	"