PATCH WMS 810 P020: Difference between revisions

From Calidus HUB
VisualWikitext
(Created page with "<div class="noprint"> {{#vardefine:Client|OBS}} {{#vardefine:ClientName|OBS Logistics Ltd}} {{#vardefine:System|''CALIDUS'' WMS}} {{#vardefine:Doc_Title|Release Notes}} {{#vardef...")
 
No edit summary
Line 95: Line 95:
|'''Detail of Fix''' || Order Number Summary enquiry subtracts discount from values if NOMS rule is Y.                              Manifest Pre-Spends Report and Despatch Manifest Report now report discount.                            Order Spends Report and Despatch Spends Report now indicate which line the discount applies to, but do not report discount is selection parameters are either for stock code PC or product class 77 (setup on WMS Translations, see FS).
|'''Detail of Fix''' || Order Number Summary enquiry subtracts discount from values if NOMS rule is Y.                              Manifest Pre-Spends Report and Despatch Manifest Report now report discount.                            Order Spends Report and Despatch Spends Report now indicate which line the discount applies to, but do not report discount is selection parameters are either for stock code PC or product class 77 (setup on WMS Translations, see FS).
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' ||
|}
|}
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''Registry/Rules Settings'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Path &amp; Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
<tr>
<td>Owner</td>
<td>Code from = "PC" & Code To = "PC"</td>
<td>If 'Stock Code From' and 'Stock Code To' set to "PC" in Order Spends Report or Despatch Spends Report parameters any discount on the order(s) selected will not be reported.</td>
</tr>
<tr>
<td>Owner</td>
<td>Code from = "77" & Code To = "77"</td>
<td>If 'Product Class From' and 'Product Class To' set to "77" in Order Spends Report or Despatch Spends Report parameters any discount on the order(s) selected will not be reported.</td>
</tr>
</table>




Line 170: Line 196:
|'''Detail of Fix''' || Create new ELL format replenishment file.
|'''Detail of Fix''' || Create new ELL format replenishment file.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' ||
|}
|}
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''New Screens'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Suggested Menu Path'''</font></td>
<td bgcolor="silver"><font size="2">'''Screen ID'''</font></td>
<td bgcolor="silver"><font size="2">'''Screen Description'''</font></td>
</tr>
<tr>
<td>/Setup/EDI</td>
<td>PFS1521</td>
<td>EDI replenishment validation</td>
</tr>
</table>




Line 245: Line 290:
|'''Detail of Fix''' || Amend REN format stock snapshot. If RDSA rule set to Yes, report stock/qty/aka code instead of stock/qty.
|'''Detail of Fix''' || Amend REN format stock snapshot. If RDSA rule set to Yes, report stock/qty/aka code instead of stock/qty.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' ||
|}
|}
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''Registry/Rules Settings'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Path &amp; Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
<tr>
<td>RDSA</td>
<td>Y</td>
<td>REN format stock snapshot reports STOCK CODE / QTY / AKA STOCK CODE</td>
</tr>
<tr>
<td>Ren - Display Stock AKA in stock snapshot</td>
<td>N or another value</td>
<td>REN format stock snapshot reports AKA STOCK CODE or STOCK CODE / QTY (pre-existing format). </td>
</tr>
</table>




Line 292: Line 363:
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''Registry/Rules Settings'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Path &amp; Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
<tr>
<td>SD3R Owner Rule</td>
<td>1</td>
<td>Description 2 is required, Description 3 may be left blank</td>
</tr>
<tr>
<td>SD3R Owner Rule</td>
<td>2</td>
<td>Description 3 is required, Description 2 may be left blank</td>
</tr>
<tr>
<td>SD3R Owner Rule</td>
<td>3</td>
<td>Description 2 and 3 are both required</td>
</tr>
<tr>
<td>SD3R Owner Rule</td>
<td>Any other value</td>
<td>Neither description 2, nor description 3 will be required</td>
</tr>
</table>




Line 322: Line 430:
|'''Detail of Fix''' || The send_email procedure within the DP_RUN_REPORT package has been changed to check a new registry setting, Global / GeneralSettings / SecureMailRequired. If set to ‘Y’ the secure mail script is used otherwise the standard script is used.
|'''Detail of Fix''' || The send_email procedure within the DP_RUN_REPORT package has been changed to check a new registry setting, Global / GeneralSettings / SecureMailRequired. If set to ‘Y’ the secure mail script is used otherwise the standard script is used.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' ||
|}
|}
<table border="1px" width="100%">
<tr>
<td colspan="3" bgcolor="silver"><font size="2">'''Registry/Rules Settings'''</font></td>
</tr>
<tr>
<td bgcolor="silver"><font size="2">'''Path &amp; Name'''</font></td>
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td>
<td bgcolor="silver"><font size="2">'''Result'''</font></td>
</tr>
<tr>
<td>Global/GeneralSettings/SecureMailRequired</td>
<td>Y</td>
<td>Secure email script is used ($QCOM/OMSendEmail_secure.ksh).</td>
</tr>
<tr>
<td>Global/GeneralSettings/SecureMailRequired</td>
<td>N</td>
<td>Standard email script is used ($QCOM/OMSendEmail.ksh).</td>
</tr>
</table>




Line 774: Line 908:
!Module Name !! Version No !! Description !! Log Number
!Module Name !! Version No !! Description !! Log Number
|-
|-
|  ||  ||  ||  
| AT_EDI_PRE_ADVICE_DETAIL_IN_336645.sql || 4.1 || Alter Table Script || 336645
|-
| AT_EDI_PRE_ADVICE_HEADER_IN_336645.sql || 4.1 || Alter Table Script || 336645
|-
| AT_WARE_GOODS_ENTRY_DETAILS_336645.sql || 4.1 || Alter Table Script || 336645
|-
| AT_WARE_GOODS_ENTRY_HEADERS_336645.sql || 4.1 || Alter Table Script || 336645
|-
| AT_WARE_GOODS_ENTRY_PALLETS_336882.sql || 4.1 || Alter Table Script || 336882
|-
| AT_WARE_LOCATION_ENTRIES_336882.sql || 4.1 || Alter Table Script || 336882
|-
| CT_EDI_REPLEN_INBOUND_336704.sql || 4.1 || Create Table Script || 336704
|-
| CT_EDI_SBL_SEQ_336758.sql || 4.1 || Create Table Script || 336758
|-
| CT_EDI_STOCK_BAL_WLE_336758.sql || 4.1 || Create Table Script || 336758
|-
| CT_TEMP_IN_STKSNAP_336758.sql || 4.1 || Create Table Script || 336758
|-
| DATA_DYNAMIC_MESSAGES_336704.sql || 4.1 || Data Script || 336704
|-
| DATA_DYNAMIC_MESSAGES_337410.sql || 4.1 || Data Script || 337410
|-
| DATA_DYNAMIC_MESSAGES_337545.sql || 4.1 || Data Script || 337545
|-
| DATA_DYNAMIC_MESSAGES_337764.sql || 4.1 || Data Script || 337764
|-
| DATA_DYNAMIC_MESSAGES_337827.sql || 4.1 || Data Script || 337827
|-
| DATA_EDI_MAPS_335177.sql || 4.1 || Data Script || 335177
|-
| DATA_EDI_MAPS_336645.sql || 4.1 || Data Script || 336645
|-
| DATA_EDI_MAPS_336647.sql || 4.1 || Data Script || 336647
|-
| DATA_EDI_MAPS_336704.sql || 4.1 || Data Script || 336704
|-
| DATA_EDI_MAPS_336758.sql || 4.1 || Data Script || 336758
|-
| DATA_EDI_MAPS_337545.sql || 4.1 || Data Script || 337545
|-
| DATA_ML_CAPTIONS_337277.sql || 4.1 || Data Script || 337277
|-
| DATA_ORS_SQL_336900.sql || 1.1 || Data Script || 336900
|-
| DATA_PRINT_FORMAT_PROCESS_337277.sql || 4.1 || Data Script || 337277
|-
| DATA_SYSTEM_REGISTRY_336891.sql || 4.1 || Data Script || 336891
|-
| DATA_WARE_RDT_STATS_336886.sql || 4.1 || Data Script || 336886
|-
| DATA_WAREHOUSE_RULES_CONTROL_336882.sql || 4.1 || Data Script || 336882
|-
| DATA_WAREHOUSE_RULES_CONTROL_337577.sql || 4.1 || Data Script || 337577
|-
| DATA_WAREHOUSE_RULES_CONTROL_337764.sql || 4.1 || Data Script || 337764
|-
| DATA_WAREHOUSE_RULES_CONTROL_338001.sql || 4.1 || Data Script || 338001
|-
| DATA_WAREHOUSE_RULES_CONTROL_334077.sql || 4.1 || Data Script || 334077
|-
| DP_CONF_EDI_IN.sql || 4.82 || Dynamic Inbound EDI package || 337300
|-
| DP_CONF_EDI_IN.sql || 4.83 || Dynamic Inbound EDI package || 334077
|-
| DP_CONF_EDI_IN_2.sql || 4.22 || Configurable EDI 2 Package || 336958
|-
| DP_EDIGEN_OUT_ST_BAL.sql || 4.63 || STK balance flat file package || 337306
|-
| DP_EDIGEN_OUT_ST_BAL.sql || 4.64 || STK balance flat file package || 336758
|-
| DP_EDIGEN_OUT_ST_BAL.sql || 4.65 || STK balance flat file package || 338001
|-
| DP_EDIGEN_PRE_ADVICE_LOAD.sql || 4.32 || WMS Pre Advice EDI load || 336645
|-
| DP_EDIGEN_PRE_ADVICE_VAL.sql || 4.52 || EDI Pre-Advice Validation || 336645
|-
| DP_EDIGEN_PROD_VAL.sql || 4.40 || Inbound EDI Stock Upload Validation || 334077
|-
| DP_EDIGEN_REPLEN_LOAD.sql || 4.1 || EDI Replenish load file || 336704
|-
| DP_EDIGEN_REPLEN_VAL.sql || 4.1 || EDI Replenish validation file || 336704
|-
| DP_EDIGEN_REPLEN_VAL.sql || 4.2 || EDI Replenish validation file || 337706
|-
| DP_EDIGEN_REPLEN_VAL.sql || 4.3 || EDI Replenish validation file || 337990
|-
| DP_EDIGEN_SALES_ORDER_LOAD.sql || 4.180 || Inbound EDI Sales Order Upload || 335177
|-
| DP_EDIGEN_SALES_ORDER_LOAD.sql || 4.181 || Inbound EDI Sales Order Upload || 336647
|-
| DP_EDIGEN_SALES_ORDER_LOAD.sql || 4.182 || Inbound EDI Sales Order Upload || 337545
|-
| DP_EDIGEN_SALES_ORDER_LOAD.sql || 4.183 || Inbound EDI Sales Order Upload || 337794
|-
| DP_EDIGEN_SALES_ORDER_LOAD.sql || 4.184 || Inbound EDI Sales Order Upload || 337827
|-
| DP_EDIGEN_SALES_ORDER_VAL.sql || 4.154 || Order_Header update package || 335177
|-
| DP_EDIGEN_SALES_ORDER_VAL.sql || 4.155 || Order_Header update package || 337545
|-
| DP_EDIGEN_SALES_ORDER_VAL.sql || 4.156 || Order_Header update package || 337827
|-
| DP_EDIGEN_STK_SNAP_LOAD.sql || 4.1 || Inbound Stock Snapshot message || 336758
|-
| DP_RDT.sql || 4.33 || RDT Messages || 336882
|-
| DP_RDT_GRNCONF.sql || 4.25 || RDT Goods Receipt Confirmation || 336882
|-
| DP_RDT_PALLET_MOVE_REQ.sql || 4.22 || RDT Pallet Moves || 337990
|-
| DP_RDT_PICK_CONF.sql || 4.63 || RDT Pick Confirmation || 336886
|-
| DP_RDT_PICK_REQUEST.sql || 4.38 || Pick Request Database Package || 337879
|-
| DP_RUN_REPORT.sql || 4.8 || Secure email/reports package || 336891
|-
| DP_STOCK_SBD_EXPIRY.sql || 4.9 || Sell_by date expiry || 337512
|-
| DP_WHR1701.sql || 4.7 || Manifest Pre-Spends XLS Output Procedure || 336233
|-
| DP_WHR1701.sql || 4.8 || Manifest Pre-Spends XLS Output Procedure || 337875
|-
| DP_WHR1901.sql || 4.10 || Despatch Manifest XLS Output Procedure || 336233
|-
| DP_WHR1901.sql || 4.11 || Despatch Manifest XLS Output Procedure || 337875
|-
| DP_WHR1902.sql || 4.7 || Product Despatch Report || 336233
|-
| DP_WHR1902.sql || 4.8 || Product Despatch Report || 337875
|-
| DP_WHR1903.sql || 4.3 || Order Spends excel format package || 336233
|-
| DP_WHR1903.sql || 4.4 || Order Spends excel format package || 337875
|-
| DP_WHS0150.sql || 4.40 || Goods Receipt Confirmation || 336882
|-
| DP_WMS_ALLOC.sql || 4.128 || Allocation Procedure || 337194
|-
| DP_WMS_IF.sql || 4.21 || Database package for warehousing || 336882
|-
| DP_WMS_PROCS.sql || 4.5 || WMS Procedure package || 337362
|-
| DP_WMS_PROCS.sql || 4.6 || WMS Procedure package || 337410
|-
| ENQSOON03A.fmx || 4.14 || SOP Enquiries || 336233
|-
| ENQSOON10A.fmx || 4.7 || Order Enquiry - Multiple warehouses/owners || 338074
|-
| OMS7000.fmx || 4.33 || Anticipated Orders Control || 336869
|-
| OMS7000.fmx || 4.34 || Anticipated Orders Control || 337262
|-
| OMS7000.fmx || 4.35 || Anticipated Orders Control || 338018
|-
| PFS1521.fmx || 4.1 || EDI Replenish errors screen || 336704
|-
| PFS1521.fmx || 4.2 || EDI Replenish errors screen || 337706
|-
| PFS1541.fmx || 4.31 || EDI Sales Order Validation || 337545
|-
| SOS1110.fmx || 4.108 || Sales Order Entry || 334786
|-
| SOS1112.fmx || 4.6 || Credit Card Details || 337577
|-
| SOS1427.fmx || 4.10 || Stock Kits Assembly Request || 337325
|-
| STKSTOC01B.fmx || 4.77 || Stock Maintenance || 337410
|-
| STKSTOC01B.fmx || 4.78 || Stock Maintenance || 334077
|-
| TRG_INS_IAJD.sql || 4.24 || Row-level Insert trigger for IAJD || 337362
|-
| V_CONTAINER_NO.sql || 4.5 || Database view for pallet enquiry || 336882
|-
| V_SER_WDD.sql || 4.3 || Serial View || 332768
|-
| WHR1701_NOM.rdf || 4.10 || Manifest Pre-Spends Report || 336233
|-
| WHR1701_NOM.rdf || 4.11 || Manifest Pre-Spends Report || 337875
|-
| WHR1900_CT1.rdf || 4.1 || CT1 Format Despatch Note || 337277
|-
| WHR1900_NOM.rdf || 4.27 || Despatch Manifest || 336233
|-
| WHR1900_NOM.rdf || 4.28 || Despatch Manifest || 337875
|-
| WHR1900_NOV.rdf || 4.5 || Client specific despatch note || 332768
|-
| WHR1900_SER.rdf || 4.4 || Blind Despatch Note || 332768
|-
| WHR1900_UCB.rdf || 4.13 || Despatch note for UCB || 332768
|-
| WHR1902.rdf || 4.7 || Despatch Note Mask || 336233
|-
| WHR1902.rdf || 4.8 || Despatch Note Mask || 337875
|-
| WHR1903.rdf || 4.3 || Roll cage label || 336233
|-
| WHR1903.rdf || 4.4 || Roll cage label || 337875
|-
| WHS0150.fmx || 4.114 || Goods Receipt Confirmation || 336882
|-
| WHS0150.fmx || 4.115 || Goods Receipt Confirmation || 337785
|-
| WHS0172.fmx || 4.25 || Rotation Stock Details || 337764
|-
| WHS0300.fmx || 4.4 || Order Range Summary Report Parameter Screen || 336626
|-
| WHS0700.fmx || 4.39 || Warehouse Movements || 337512
|-
| WHS0915.fmx || 4.29 || Pallet Enquiry || 336882
|-
| WHS1701.fmx || 4.11 || Cage Label Parameter Screen || 338003
|-
| WHS1714.fmx || 4.121 || Pick Confirmation || 337936
|-
| WHS1901.fmx || 4.19 || Despatch Note Reprint Kick-off || 338003
|-
| WHS1902.fmx || 4.16 || Despatch Mask Kick-off || 338003
|-
| WHS1903.fmx || 4.9 || Consignment Note || 338003
|-
| WHS1910.fmx || 4.65 || Despatch Confirmation || 337456
|-
| WHS8140.fmx || 4.10 || Disbursement Receipts || 337578
|-
| XFM0020.fmx || 4.57 || XF Monitor || 337706
|-
|}
|}




Line 783: Line 1,145:


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


There are no WCS changes required.
336882


== EPOD/T2A ==
336886
 
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 ==
== PORTAL/TTM ==


A Portal change is required for the following logs:
There are no Portal changes required.
* Log
OR


There are no Portal changes required.


== EDI ==
== EDI ==
An EDI change is required for the following logs:
* Log
OR


There are no EDI changes required.
There are no EDI changes required.

Revision as of 12:11, 29 September 2016





Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS WMS

26th Sep 2016 - 1.0
Reference: P020











































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: MW-AAXBC9

OBS Log Number: 336233
Reporter: Mark Hext
Summary of Call Spends reports showing Incorrect values.
Detail of Fix Order Number Summary enquiry subtracts discount from values if NOMS rule is Y. Manifest Pre-Spends Report and Despatch Manifest Report now report discount. Order Spends Report and Despatch Spends Report now indicate which line the discount applies to, but do not report discount is selection parameters are either for stock code PC or product class 77 (setup on WMS Translations, see FS).
Set-up and Configuration


Registry/Rules Settings
Path & Name Setting Value Result
Owner Code from = "PC" & Code To = "PC" If 'Stock Code From' and 'Stock Code To' set to "PC" in Order Spends Report or Despatch Spends Report parameters any discount on the order(s) selected will not be reported.
Owner Code from = "77" & Code To = "77" If 'Product Class From' and 'Product Class To' set to "77" in Order Spends Report or Despatch Spends Report parameters any discount on the order(s) selected will not be reported.


Customer Ref: EDI ORDER - INBOUND

OBS Log Number: 335177
Reporter: Phil Harding
Summary of Call EDI ORDER - INBOUND
Detail of Fix create new ELL format sales order upload.
Set-up and Configuration No set-up/configuration required


Customer Ref: New pre-advice

OBS Log Number: 336645
Reporter: Phil Harding
Summary of Call New pre-advice for Vintner
Detail of Fix Create new Ellis format csv format pre-advice upload. Upload is pipe separated and has an EDI format of ELL.
Set-up and Configuration No set-up/configuration required


Customer Ref: WMS to WCS message

OBS Log Number: 336886
Reporter: PJH
Summary of Call New WMS to WCS message
Detail of Fix create new 325 message to be sent from wms to wcs, which will release held replenishments.
Set-up and Configuration No set-up/configuration required


Customer Ref: GR confirmation

OBS Log Number: 336882
Reporter: PJH
Summary of Call Capture vintage value at goods receipt
Detail of Fix Add vintage field (4 chars) to both Ware Goods Entry Pallets and Ware Location Entries. Populate field both manually and via RF upload
Set-up and Configuration No set-up/configuration required


Customer Ref: Replen Move

OBS Log Number: 336704
Reporter: Simon Eland
Summary of Call New replen move flow
Detail of Fix Create new ELL format replenishment file.
Set-up and Configuration


New Screens
Suggested Menu Path Screen ID Screen Description
/Setup/EDI PFS1521 EDI replenishment validation


Customer Ref: New inbound stock

OBS Log Number: 336758
Reporter: Phil Harding
Summary of Call New stock snapshot flow.
Detail of Fix New ELL format stock snapshot. An inbound file will be received, which will generation the creation of an outbound stock snapshot.
Set-up and Configuration No set-up/configuration required


Customer Ref: Book 66 Order Import

OBS Log Number: 336647
Reporter: Paul Reed
Summary of Call Book 66 Order Import EDI update
Detail of Fix Create new B66 format edi sales order upload.
Set-up and Configuration No set-up/configuration required


Customer Ref: Fast Track Developme

OBS Log Number: 337764
Reporter: Paul Reed
Summary of Call Fast Track development
Detail of Fix Added new warehouse level rule 'GNAP', (Print GRN Note after GRN putaway conf). If set, the user can only print the GRN Note after GRN has been putaway confirmed.
Set-up and Configuration No set-up/configuration required


Customer Ref: PO 44010306885

OBS Log Number: 337875
Reporter: Mark Hext
Summary of Call NOMS - Reporting changes
Detail of Fix Amend reports so that discount is displayed for reports that display order level details only. Reports that show data at stock level have the discount field removed.
Set-up and Configuration No set-up/configuration required


Customer Ref: Change REN format

OBS Log Number: 338001
Reporter: Howard Allen
Summary of Call Add AKA stock code to REN format stk snp
Detail of Fix Amend REN format stock snapshot. If RDSA rule set to Yes, report stock/qty/aka code instead of stock/qty.
Set-up and Configuration


Registry/Rules Settings
Path & Name Setting Value Result
RDSA Y REN format stock snapshot reports STOCK CODE / QTY / AKA STOCK CODE
Ren - Display Stock AKA in stock snapshot N or another value REN format stock snapshot reports AKA STOCK CODE or STOCK CODE / QTY (pre-existing format).


Customer Ref: RM-ACNH77

OBS Log Number: 337277
Reporter: Ryan McLaren
Summary of Call New Despatch Format
Detail of Fix A new ‘CT1’ format despatch note has been created. This was based on the FWL format but with three new fields added: Tracking Ref, Temp Monitor and Serial Number. The following fields were removed: Order Type, Special Instructions/Remarks, Vat No, Transport Note(Hazards), Despatch Note Message, Volume and Driver Signature.
Set-up and Configuration No set-up/configuration required


Customer Ref: HT-A65DTA

OBS Log Number: 332768
Reporter: Hemal Tailor
Summary of Call Change to Field Label on Despatch Note
Detail of Fix Change label on reports from 'Carrier AWB' to 'Carrier Ref'.
Set-up and Configuration No set-up/configuration required


Customer Ref: LS-A7XKCW

OBS Log Number: 334077
Reporter: Lynda Spencer
Summary of Call Change to RIO PJ-A4NGS3
Detail of Fix The SD3R owner rule has been amended to control validation of both Description 2 and Description 3 of the stock record. The rule now has three possible values: 1 - Descrption 2 required 2 - Description 3 required 3 - Description 2 & 3 required Any other value or no set up then neither required.
Set-up and Configuration No set-up/configuration required


Registry/Rules Settings
Path & Name Setting Value Result
SD3R Owner Rule 1 Description 2 is required, Description 3 may be left blank
SD3R Owner Rule 2 Description 3 is required, Description 2 may be left blank
SD3R Owner Rule 3 Description 2 and 3 are both required
SD3R Owner Rule Any other value Neither description 2, nor description 3 will be required


SUPPORT INCIDENTS

OBS Log Number: 336891

Customer Ref: N/A
Reporter: Karl
Summary of Call Spends manfest incorrect
Detail of Fix The send_email procedure within the DP_RUN_REPORT package has been changed to check a new registry setting, Global / GeneralSettings / SecureMailRequired. If set to ‘Y’ the secure mail script is used otherwise the standard script is used.
Set-up and Configuration


Registry/Rules Settings
Path & Name Setting Value Result
Global/GeneralSettings/SecureMailRequired Y Secure email script is used ($QCOM/OMSendEmail_secure.ksh).
Global/GeneralSettings/SecureMailRequired N Standard email script is used ($QCOM/OMSendEmail.ksh).


OBS Log Number: 337512

Customer Ref: INC14930993
Reporter: Mark Chapnell
Summary of Call GB-DSC-Reading-Unison IPP-Held pallets r
Detail of Fix Correctly manage held qty on mid-move pallets during overnight auto hold of expired stock.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337578

Customer Ref: N/A
Reporter: Paul Reed
Summary of Call Email print invoices
Detail of Fix Do not give display error when charge code description is at max length.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337936

Customer Ref: N/A
Reporter: Mark Hext
Summary of Call Pick Conf - simple layout
Detail of Fix Fix data issue for NOMS users with security level 1, so they don't get oracle error. Also hid 'invoicing' buttons for these users, as they don't use WMS invoicing.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337456

Customer Ref: N/A
Reporter: MIchael Huxley
Summary of Call opcom unix_value_error /tmp full
Detail of Fix Amendment to WHS1910 despatch confirmation so when finding order the data select clause is set correctly. This prevents data query returning all records and potentially building a temporary forms workfile that fills the /tmp area.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337990

Customer Ref: N/A
Reporter: Simon Eland
Summary of Call Amend REPLEN text in 111 msg
Detail of Fix Amend the 111 message so that the 'Replen/Move' text sent is up shifted to 'REPLEN or MOVE'.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337577

Customer Ref: N/A
Reporter: Paul Reed
Summary of Call Units and cases picking
Detail of Fix Added new 'PSPQ' (Potter Select Pallet Quantity) functionality to separate standard 2 UOM functionality, and Potter Group specific logic, when the user can select singles, which are created by allocation via break case functionality.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336900

Customer Ref: INC14633821
Reporter: Gavin Pickering
Summary of Call GB-DSC-Lutterworth-ORS Owners and Wareho
Detail of Fix Script created to update the database query behind the Oracle Reporting SUite Inventory report for the Pallet level data extract. The query now included the user parameters to limit for the warehouses and owners that the user is set-up to use.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 334786

Customer Ref: N/A
Reporter: KATE HALL
Summary of Call Manually picking an order
Detail of Fix Amend to link between order header and the select pallets to stop issues with order not being found due to failure on re-extecute query.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337194

Customer Ref: N/A
Reporter: Jennie Baldwin
Summary of Call Stock Rotation - allocation query
Detail of Fix Amendment to the WMS allocation process for allocation rule 3 'O' Optimised Bulk Picking so selecting from part pallets is done in the correct order. within the customer rotation.
Set-up and Configuration No set-up/configuration required


TID CHANGES

OBS Log Number: 336869

Customer Ref: PIPPLS082
Reporter: L Spencer
Summary of Call LS-9T8DT7 - Add product storage
Detail of Fix Ensure maximum recommended volume warning is generated when only one order is selected.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336958

Customer Ref: PIPPLS083
Reporter: L Spencer
Summary of Call LS-9T8DT7 - Add product storage
Detail of Fix Ensure if EDI PIPP Order upload contains multiple customers, then the product type validation is customer/order specific, and not file specific, as the file may contain orders for many customers.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337300

Customer Ref: Remove spaces
Reporter: Dave Potter
Summary of Call Conf EDI in - strip spaces
Detail of Fix For Stock Uom, Stock Base Sell and Stock Uploads, remove blank spaces from uploaded data. WLE upload also amended likewise, as well as having remove hyphens from location code.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337545

Customer Ref: EDI Order change
Reporter: Nick Gabb
Summary of Call Vintner changes to ELL format message
Detail of Fix Amend the ELL (Ellis) format sales order load file to add location code and re-send flag. The re-send flag will be ignored, but the location code, if populated, must exist and contain the stock code / location code. Also, raise an error if the order reference exists for a non-cancelled order.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 336626

Customer Ref: PIPPLS080
Reporter: L Spencer
Summary of Call PJ-A4RDLH Order Range PDF
Detail of Fix Amend screen so it references the user entered warehouse id rather than the system warehouse id, so if user changes warehouse, the user entered warehouse code is used to select data.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337262

Customer Ref: PIPPLS086
Reporter: L Spencer
Summary of Call LS-9T8DT7 - Add product storage
Detail of Fix Fix validation so if orders assigned to pre-existing route load, the cumulative quantities are checked to see if they exceed maximum limits.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337827

Customer Ref: N/A
Reporter: phil harding
Summary of Call Error reports run via ELL sales ord upl.
Detail of Fix Ensure that when comma separated files are uploaded, the EDI error reports run. Also add an error check to ensure that the system order number's first character is alpha-numeric.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337706

Customer Ref: Add RDT call to replen
Reporter: Si Eland
Summary of Call Add rdt process to edi replen generation
Detail of Fix When EDI replenishment, automatically move movement to 'printed' status and send message to RF with status '9' (held). Change XF Monitor, so when user presses 'error detail' button, screen runs PFS1521 (EDI Replenishments). Fix error with PFS1521 screen title.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337785

Customer Ref: N/A
Reporter: Dave Potter
Summary of Call goods receipt re-work
Detail of Fix If rotation no is stored in Ware Goods Entry Details via EDI process, do not overwrite rotation no with a new system generated rotation no.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 338003

Customer Ref: N/A
Reporter: Mark Hext
Summary of Call Report screens slow to validate
Detail of Fix Improve performance for validation in NOMS specific reports.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 338018

Customer Ref: Rework of 337262
Reporter: L Spencer
Summary of Call Transit fct included in volume calc.
Detail of Fix Fix issue with max qty assigned to route/load. Check transit qty figure, so OMS ordered qty of 500 and the transit qty is 50, then the WMS ordered qty is 10 not 500.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337325

Customer Ref: N/A
Reporter: Daniel Brown
Summary of Call Kit assembly request error
Detail of Fix Ensure if rule KACU (kitting . allow cases and units) is not set, the screen runs as previous, so even if a stock code is setup as if it uses units, stock is always in cases.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337362

Customer Ref: N/A
Reporter: Daniel Brown
Summary of Call Order Maintenance cancel order error
Detail of Fix Ensure that if the user cancels an order via pressing the cancel button in SOS1110, the order cancels correctly.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337306

Customer Ref: GB1 format ss change
Reporter: Howard Allen
Summary of Call Add header to GB1 format stk snapshot.
Detail of Fix Add header to gb1 format stock snapshot.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337410

Customer Ref: N/A
Reporter: Paul Reed
Summary of Call Optimised Picking
Detail of Fix Allow user to update factor 2 to 3 either manually or by changing the standard pallet type.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 337879

Customer Ref: N/A
Reporter: Paul Reed
Summary of Call Pick didnt prompt for container id
Detail of Fix Fix issue with RFO1 (Part Pick Only) functionality . ensure that the system correctly finds pallet information to ensure it can correctly calculate full/part pallets.
Set-up and Configuration No set-up/configuration required


OBSL PRODUCT DEVELOPMENT

OBS Log Number: 337794

Reporter: Dave Potter
Summary of Call RAB EDI sales order upload delimiter
Detail of Fix Amend RAB EDI sales format upload process so that the blank-line check isn't hardcoded to commas, as users wish to use ^ (caret) separated records.
Set-up and Configuration No set-up/configuration required


OBS Log Number: 338074

Reporter: Phil Harding
Summary of Call ENQSOON01A update customer address data
Detail of Fix The customer name and address which may be included in the ‘Details’ tab of the Multi Warehouse Order Enquiry will now be taken from the FREE_TYPE_ADDRESS record if the address is entered manually, otherwise the customer’s delivery address will be used. This should now match the delivery address displayed in the Order Enquiry itself.
Set-up and Configuration No set-up/configuration required


MODULES DELIVERED

Module Name Version No Description Log Number
AT_EDI_PRE_ADVICE_DETAIL_IN_336645.sql 4.1 Alter Table Script 336645
AT_EDI_PRE_ADVICE_HEADER_IN_336645.sql 4.1 Alter Table Script 336645
AT_WARE_GOODS_ENTRY_DETAILS_336645.sql 4.1 Alter Table Script 336645
AT_WARE_GOODS_ENTRY_HEADERS_336645.sql 4.1 Alter Table Script 336645
AT_WARE_GOODS_ENTRY_PALLETS_336882.sql 4.1 Alter Table Script 336882
AT_WARE_LOCATION_ENTRIES_336882.sql 4.1 Alter Table Script 336882
CT_EDI_REPLEN_INBOUND_336704.sql 4.1 Create Table Script 336704
CT_EDI_SBL_SEQ_336758.sql 4.1 Create Table Script 336758
CT_EDI_STOCK_BAL_WLE_336758.sql 4.1 Create Table Script 336758
CT_TEMP_IN_STKSNAP_336758.sql 4.1 Create Table Script 336758
DATA_DYNAMIC_MESSAGES_336704.sql 4.1 Data Script 336704
DATA_DYNAMIC_MESSAGES_337410.sql 4.1 Data Script 337410
DATA_DYNAMIC_MESSAGES_337545.sql 4.1 Data Script 337545
DATA_DYNAMIC_MESSAGES_337764.sql 4.1 Data Script 337764
DATA_DYNAMIC_MESSAGES_337827.sql 4.1 Data Script 337827
DATA_EDI_MAPS_335177.sql 4.1 Data Script 335177
DATA_EDI_MAPS_336645.sql 4.1 Data Script 336645
DATA_EDI_MAPS_336647.sql 4.1 Data Script 336647
DATA_EDI_MAPS_336704.sql 4.1 Data Script 336704
DATA_EDI_MAPS_336758.sql 4.1 Data Script 336758
DATA_EDI_MAPS_337545.sql 4.1 Data Script 337545
DATA_ML_CAPTIONS_337277.sql 4.1 Data Script 337277
DATA_ORS_SQL_336900.sql 1.1 Data Script 336900
DATA_PRINT_FORMAT_PROCESS_337277.sql 4.1 Data Script 337277
DATA_SYSTEM_REGISTRY_336891.sql 4.1 Data Script 336891
DATA_WARE_RDT_STATS_336886.sql 4.1 Data Script 336886
DATA_WAREHOUSE_RULES_CONTROL_336882.sql 4.1 Data Script 336882
DATA_WAREHOUSE_RULES_CONTROL_337577.sql 4.1 Data Script 337577
DATA_WAREHOUSE_RULES_CONTROL_337764.sql 4.1 Data Script 337764
DATA_WAREHOUSE_RULES_CONTROL_338001.sql 4.1 Data Script 338001
DATA_WAREHOUSE_RULES_CONTROL_334077.sql 4.1 Data Script 334077
DP_CONF_EDI_IN.sql 4.82 Dynamic Inbound EDI package 337300
DP_CONF_EDI_IN.sql 4.83 Dynamic Inbound EDI package 334077
DP_CONF_EDI_IN_2.sql 4.22 Configurable EDI 2 Package 336958
DP_EDIGEN_OUT_ST_BAL.sql 4.63 STK balance flat file package 337306
DP_EDIGEN_OUT_ST_BAL.sql 4.64 STK balance flat file package 336758
DP_EDIGEN_OUT_ST_BAL.sql 4.65 STK balance flat file package 338001
DP_EDIGEN_PRE_ADVICE_LOAD.sql 4.32 WMS Pre Advice EDI load 336645
DP_EDIGEN_PRE_ADVICE_VAL.sql 4.52 EDI Pre-Advice Validation 336645
DP_EDIGEN_PROD_VAL.sql 4.40 Inbound EDI Stock Upload Validation 334077
DP_EDIGEN_REPLEN_LOAD.sql 4.1 EDI Replenish load file 336704
DP_EDIGEN_REPLEN_VAL.sql 4.1 EDI Replenish validation file 336704
DP_EDIGEN_REPLEN_VAL.sql 4.2 EDI Replenish validation file 337706
DP_EDIGEN_REPLEN_VAL.sql 4.3 EDI Replenish validation file 337990
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.180 Inbound EDI Sales Order Upload 335177
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.181 Inbound EDI Sales Order Upload 336647
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.182 Inbound EDI Sales Order Upload 337545
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.183 Inbound EDI Sales Order Upload 337794
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.184 Inbound EDI Sales Order Upload 337827
DP_EDIGEN_SALES_ORDER_VAL.sql 4.154 Order_Header update package 335177
DP_EDIGEN_SALES_ORDER_VAL.sql 4.155 Order_Header update package 337545
DP_EDIGEN_SALES_ORDER_VAL.sql 4.156 Order_Header update package 337827
DP_EDIGEN_STK_SNAP_LOAD.sql 4.1 Inbound Stock Snapshot message 336758
DP_RDT.sql 4.33 RDT Messages 336882
DP_RDT_GRNCONF.sql 4.25 RDT Goods Receipt Confirmation 336882
DP_RDT_PALLET_MOVE_REQ.sql 4.22 RDT Pallet Moves 337990
DP_RDT_PICK_CONF.sql 4.63 RDT Pick Confirmation 336886
DP_RDT_PICK_REQUEST.sql 4.38 Pick Request Database Package 337879
DP_RUN_REPORT.sql 4.8 Secure email/reports package 336891
DP_STOCK_SBD_EXPIRY.sql 4.9 Sell_by date expiry 337512
DP_WHR1701.sql 4.7 Manifest Pre-Spends XLS Output Procedure 336233
DP_WHR1701.sql 4.8 Manifest Pre-Spends XLS Output Procedure 337875
DP_WHR1901.sql 4.10 Despatch Manifest XLS Output Procedure 336233
DP_WHR1901.sql 4.11 Despatch Manifest XLS Output Procedure 337875
DP_WHR1902.sql 4.7 Product Despatch Report 336233
DP_WHR1902.sql 4.8 Product Despatch Report 337875
DP_WHR1903.sql 4.3 Order Spends excel format package 336233
DP_WHR1903.sql 4.4 Order Spends excel format package 337875
DP_WHS0150.sql 4.40 Goods Receipt Confirmation 336882
DP_WMS_ALLOC.sql 4.128 Allocation Procedure 337194
DP_WMS_IF.sql 4.21 Database package for warehousing 336882
DP_WMS_PROCS.sql 4.5 WMS Procedure package 337362
DP_WMS_PROCS.sql 4.6 WMS Procedure package 337410
ENQSOON03A.fmx 4.14 SOP Enquiries 336233
ENQSOON10A.fmx 4.7 Order Enquiry - Multiple warehouses/owners 338074
OMS7000.fmx 4.33 Anticipated Orders Control 336869
OMS7000.fmx 4.34 Anticipated Orders Control 337262
OMS7000.fmx 4.35 Anticipated Orders Control 338018
PFS1521.fmx 4.1 EDI Replenish errors screen 336704
PFS1521.fmx 4.2 EDI Replenish errors screen 337706
PFS1541.fmx 4.31 EDI Sales Order Validation 337545
SOS1110.fmx 4.108 Sales Order Entry 334786
SOS1112.fmx 4.6 Credit Card Details 337577
SOS1427.fmx 4.10 Stock Kits Assembly Request 337325
STKSTOC01B.fmx 4.77 Stock Maintenance 337410
STKSTOC01B.fmx 4.78 Stock Maintenance 334077
TRG_INS_IAJD.sql 4.24 Row-level Insert trigger for IAJD 337362
V_CONTAINER_NO.sql 4.5 Database view for pallet enquiry 336882
V_SER_WDD.sql 4.3 Serial View 332768
WHR1701_NOM.rdf 4.10 Manifest Pre-Spends Report 336233
WHR1701_NOM.rdf 4.11 Manifest Pre-Spends Report 337875
WHR1900_CT1.rdf 4.1 CT1 Format Despatch Note 337277
WHR1900_NOM.rdf 4.27 Despatch Manifest 336233
WHR1900_NOM.rdf 4.28 Despatch Manifest 337875
WHR1900_NOV.rdf 4.5 Client specific despatch note 332768
WHR1900_SER.rdf 4.4 Blind Despatch Note 332768
WHR1900_UCB.rdf 4.13 Despatch note for UCB 332768
WHR1902.rdf 4.7 Despatch Note Mask 336233
WHR1902.rdf 4.8 Despatch Note Mask 337875
WHR1903.rdf 4.3 Roll cage label 336233
WHR1903.rdf 4.4 Roll cage label 337875
WHS0150.fmx 4.114 Goods Receipt Confirmation 336882
WHS0150.fmx 4.115 Goods Receipt Confirmation 337785
WHS0172.fmx 4.25 Rotation Stock Details 337764
WHS0300.fmx 4.4 Order Range Summary Report Parameter Screen 336626
WHS0700.fmx 4.39 Warehouse Movements 337512
WHS0915.fmx 4.29 Pallet Enquiry 336882
WHS1701.fmx 4.11 Cage Label Parameter Screen 338003
WHS1714.fmx 4.121 Pick Confirmation 337936
WHS1901.fmx 4.19 Despatch Note Reprint Kick-off 338003
WHS1902.fmx 4.16 Despatch Mask Kick-off 338003
WHS1903.fmx 4.9 Consignment Note 338003
WHS1910.fmx 4.65 Despatch Confirmation 337456
WHS8140.fmx 4.10 Disbursement Receipts 337578
XFM0020.fmx 4.57 XF Monitor 337706


ADDITIONAL CHANGES

WCS

A WCS change is required for the following logs:

336882

336886

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_P020&oldid=3666’