PATCH WMS P042: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 157: Line 157:
|width="30%"|'''Summary of Call'''|| New IAJD Fields
|width="30%"|'''Summary of Call'''|| New IAJD Fields
|-
|-
|'''Detail of Fix''' || "Store the old reason code is the 'audit' table prev reason code
|'''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
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
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''' ||
|'''Set-up and Configuration''' ||
Line 281: Line 280:
|width="30%"|'''Summary of Call'''|| WREQ0069569 - Creation of New Reports
|width="30%"|'''Summary of Call'''|| WREQ0069569 - Creation of New Reports
|-
|-
|'''Detail of Fix''' || "New ORS 'USER_ACC' (User account) report
|'''Detail of Fix''' || New ORS 'USER_ACC' (User account) report
 
New Order / Serial Report - run from either WHS0290 (Order Serial
New Order / Serial Report - run from either WHS0290 (Order Serial
Report) or outbound EDI."
 
Report) or outbound EDI.
|-
|-
|'''Set-up and Configuration''' ||
|'''Set-up and Configuration''' ||
Line 344: Line 345:
|width="30%"|'''Summary of Call'''|| Despatch Note
|width="30%"|'''Summary of Call'''|| Despatch Note
|-
|-
|'''Detail of Fix''' || "Amend the report’s ability to print serials.
|'''Detail of Fix''' || Amend the report’s ability to print serials.


Expand the size of the 'serial numbers' string from 1,000 char to 60,000 char, which will allow the report to print over 8,000 serials per stock code per order with current site serial number lengths."
Expand the size of the 'serial numbers' string from 1,000 char to 60,000 char, which will allow the report to print over 8,000 serials per stock code per order with current site serial number lengths.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 357: Line 358:
|width="30%"|'''Summary of Call'''|| Journal Creation
|width="30%"|'''Summary of Call'''|| Journal Creation
|-
|-
|'''Detail of Fix''' || "Amend database trigger to ensure stock code, sell by date, manufacture date, pallet id, rotation no and cust rotation no populated.
|'''Detail of Fix''' || Amend database trigger to ensure stock code, sell by date, manufacture date, pallet id, rotation no and cust rotation no populated.


Note: This change does not affect the 'CANC' or 'PACK' messages, as they are at order level and not pallet/order line level."
Note: This change does not affect the 'CANC' or 'PACK' messages, as they are at order level and not pallet/order line level.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 370: Line 371:
|width="30%"|'''Summary of Call'''|| ADR EDI
|width="30%"|'''Summary of Call'''|| ADR EDI
|-
|-
|'''Detail of Fix''' || "Amend UNA segment in ADR format DESADV despatch message.
|'''Detail of Fix''' || Amend UNA segment in ADR format DESADV despatch message.


The ',' or '.' in the UNA segment signifies that numeric fields will be separated by either a comma or a dot
The ',' or '.' in the UNA segment signifies that numeric fields will be separated by either a comma or a dot


This message needs to be a dot, as numeric fields will be reported as 1.23 not 1,23"
This message needs to be a dot, as numeric fields will be reported as 1.23 not 1,23
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 385: Line 386:
|width="30%"|'''Summary of Call'''|| Allocation by reason code
|width="30%"|'''Summary of Call'''|| Allocation by reason code
|-
|-
|'''Detail of Fix''' || "Add new AHSO (Allocate Held Stock) warehouse rule option of 'C' (combined). This will allow users to allocate held stock with reason codes 1 or R via either EDI order entry or manual order entry.
|'''Detail of Fix''' || Add new AHSO (Allocate Held Stock) warehouse rule option of 'C' (combined). This will allow users to allocate held stock with reason codes 1 or R via either EDI order entry or manual order entry.


Entered reason codes must be setup to allow the allocation of Held Stock."
Entered reason codes must be setup to allow the allocation of Held Stock.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 409: Line 410:
|width="30%"|'''Summary of Call'''|| Issue with Hold/Release message
|width="30%"|'''Summary of Call'''|| Issue with Hold/Release message
|-
|-
|'''Detail of Fix''' || "Fixed issue - ensure that messages containing 'GE' option work as expected, and hold records are processed as expected.
|'''Detail of Fix''' || Fixed issue - ensure that messages containing 'GE' option work as expected, and hold records are processed as expected.


Also fix - issue ensuring that new audit fields added via 01894409 (New Audit Journal Fields) can be selected by IAJD/Adjustments outbound configurable EDI flow."
Also fix - issue ensuring that new audit fields added via 01894409 (New Audit Journal Fields) can be selected by IAJD/Adjustments outbound configurable EDI flow.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 444: Line 445:
|width="30%"|'''Summary of Call'''|| Hold/Release Issue
|width="30%"|'''Summary of Call'''|| Hold/Release Issue
|-
|-
|'''Detail of Fix''' || "Ensure that when user 'swaps' hold, only 'selected' pallets are updated. Pallets that were not originally held but fall within the selection criteria will no longer be updated.
|'''Detail of Fix''' || Ensure that when user 'swaps' hold, only 'selected' pallets are updated. Pallets that were not originally held but fall within the selection criteria will no longer be updated.


Added new table TEMP_HOLD_REL_PALLETS to allow this."
Added new table TEMP_HOLD_REL_PALLETS to allow this.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 457: Line 458:
|width="30%"|'''Summary of Call'''|| Held Stock / Allocation / Pick
|width="30%"|'''Summary of Call'''|| Held Stock / Allocation / Pick
|-
|-
|'''Detail of Fix''' || "Amend WMS process so allocation does not remove allocation hold records when order is allocated.  
|'''Detail of Fix''' || Amend WMS process so allocation does not remove allocation hold records when order is allocated.  


Ensure system handles hold records correctly through pick and despatch processes."
Ensure system handles hold records correctly through pick and despatch processes.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 481: Line 482:
|width="30%"|'''Summary of Call'''|| Configurable EDI
|width="30%"|'''Summary of Call'''|| Configurable EDI
|-
|-
|'''Detail of Fix''' || "Amend Stock Update process:
|'''Detail of Fix''' || Amend Stock Update process:


Error records are not deleted when valid records are processed.
Error records are not deleted when valid records are processed.
If last record is invalid, if one or more valid record exists, don’t reject all records (for consistency).
If last record is invalid, if one or more valid record exists, don’t reject all records (for consistency).
Ensure Description3 populated.
Ensure Description3 populated.
Ensure error sequence populate correctly. "
 
Ensure error sequence populate correctly.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 497: Line 501:
|width="30%"|'''Summary of Call'''|| IAJD columns not populated
|width="30%"|'''Summary of Call'''|| IAJD columns not populated
|-
|-
|'''Detail of Fix''' || "Ensure 'add pallet' functionality in screen WHS0631 populates IAJD 'pid qty after cases' and 'pid qty after units' fields.
|'''Detail of Fix''' || Ensure 'add pallet' functionality in screen WHS0631 populates IAJD 'pid qty after cases' and 'pid qty after units' fields.


Previous fix only amended pallet amendment and pallet write off scenarios, not pallet add functionality."
Previous fix only amended pallet amendment and pallet write off scenarios, not pallet add functionality.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 510: Line 514:
|width="30%"|'''Summary of Call'''|| Pick Confirmation - Detail screen
|width="30%"|'''Summary of Call'''|| Pick Confirmation - Detail screen
|-
|-
|'''Detail of Fix''' || "When AHSO rule set to C:
|'''Detail of Fix''' || When AHSO rule set to C:


Sales Order Detail Lines – ensure 'available' quantity field correctly displays values for held and un-held stock.
Sales Order Detail Lines – ensure 'available' quantity field correctly displays values for held and un-held stock.


Pick List Confirmation - pallet LOV correctly references reason code and shows correct records for both held and un-held pallets."
Pick List Confirmation - pallet LOV correctly references reason code and shows correct records for both held and un-held pallets.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 536: Line 540:
|width="30%"|'''Summary of Call'''|| Select pallet screen in order entry does not show held pallet
|width="30%"|'''Summary of Call'''|| Select pallet screen in order entry does not show held pallet
|-
|-
|'''Detail of Fix''' || "A new field called 'Include Held Stock' will be available for the selection criteria to select pallets for a sales order.
|'''Detail of Fix''' || A new field called 'Include Held Stock' will be available for the selection criteria to select pallets for a sales order.
   
   
When 'Y', held stock will be considered to be available to order.
When 'Y', held stock will be considered to be available to order.
Line 542: Line 546:
When 'N', held stock will not be considered to be available to order.
When 'N', held stock will not be considered to be available to order.
   
   
'N' will be the default value."
'N' will be the default value.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 586: Line 590:
|width="30%"|'''Summary of Call'''|| Sales Order EDI
|width="30%"|'''Summary of Call'''|| Sales Order EDI
|-
|-
|'''Detail of Fix''' || "Amend EDI sales order upload so line type 3 orders with reason code AHSO set to C can be successfully uploaded.
|'''Detail of Fix''' || Amend EDI sales order upload so line type 3 orders with reason code AHSO set to C can be successfully uploaded.


Ensure that line type 1, 3, 4 and R can be processed when AHSO rule (Allocate Held Stock) is set to C and OLIS rule (Order Line Issue Life) is set to Y."
Ensure that line type 1, 3, 4 and R can be processed when AHSO rule (Allocate Held Stock) is set to C and OLIS rule (Order Line Issue Life) is set to Y.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 610: Line 614:
|width="30%"|'''Summary of Call'''|| Pallet Exchange - allocated figure incorrect
|width="30%"|'''Summary of Call'''|| Pallet Exchange - allocated figure incorrect
|-
|-
|'''Detail of Fix''' || "Fix issue with pallet id checks to ensure pallet exchange works correctly.
|'''Detail of Fix''' || Fix issue with pallet id checks to ensure pallet exchange works correctly.
For pallet exchange, populate allocate date time"
 
For pallet exchange, populate allocate date time
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 622: Line 627:
|width="30%"|'''Summary of Call'''|| Pick Confirmation pop-up message
|width="30%"|'''Summary of Call'''|| Pick Confirmation pop-up message
|-
|-
|'''Detail of Fix''' || "The owner rule PCSV can be set to:
|'''Detail of Fix''' || The owner rule PCSV can be set to:
   
   
N (to select any order line)
N (to select any order line)
Line 631: Line 636:
   
   
An available quantity for the order line will be displayed to assist the selection of an order line that can be used for the quantity being picked from the appended pallet.
An available quantity for the order line will be displayed to assist the selection of an order line that can be used for the quantity being picked from the appended pallet.
 
Cancelled order lines will not be available for selection."
Cancelled order lines will not be available for selection.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 665: Line 670:
|width="30%"|'''Summary of Call'''|| Order Enquiry - details screen
|width="30%"|'''Summary of Call'''|| Order Enquiry - details screen
|-
|-
|'''Detail of Fix''' || "The 'Order Number Summary' screen (ENQSOON03A) is changed so that for a cancelled order:
|'''Detail of Fix''' || The 'Order Number Summary' screen (ENQSOON03A) is changed so that for a cancelled order:
'Picked Value' is now populated
'Picked Value' is now populated
'To Pick/Packed' value is now populated
'To Pick/Packed' value is now populated
'Picked Price' value is now populated"
'Picked Price' value is now populated
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 679: Line 684:
|width="30%"|'''Summary of Call'''|| Allocation sequence
|width="30%"|'''Summary of Call'''|| Allocation sequence
|-
|-
|'''Detail of Fix''' || "The order lines will be allocated in this sequence (ascending unless stated otherwise):
|'''Detail of Fix''' || The order lines will be allocated in this sequence (ascending unless stated otherwise):
   
   
1 Order Number
1 Order Number
Line 692: Line 697:
Prior passes for order lines of types E and F plus B and 1 for consolidated lines will retain their allocation sequences.
Prior passes for order lines of types E and F plus B and 1 for consolidated lines will retain their allocation sequences.


Allocates available held stock for the reason code so line type 1 will not allocate previously allocated stock or committed stock for another pallet."
Allocates available held stock for the reason code so line type 1 will not allocate previously allocated stock or committed stock for another pallet.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 703: Line 708:
|width="30%"|'''Summary of Call'''|| Order Despatch
|width="30%"|'''Summary of Call'''|| Order Despatch
|-
|-
|'''Detail of Fix''' || "Added new EDPL (Extended Despatch Logging) rule.
|'''Detail of Fix''' || Added new EDPL (Extended Despatch Logging) rule.


This rule does not change functionality, but if set to 'Y', writes extra audit records when an order is manually despatched.
This rule does not change functionality, but if set to 'Y', writes extra audit records when an order is manually despatched.


Rule enabled for owners 'PU0','PU1','AT1','GR2','SH1','DC1' and 'UN1' try to find issue."
Rule enabled for owners 'PU0','PU1','AT1','GR2','SH1','DC1' and 'UN1' try to find issue.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 718: Line 723:
|width="30%"|'''Summary of Call'''|| Hold / Release EDI
|width="30%"|'''Summary of Call'''|| Hold / Release EDI
|-
|-
|'''Detail of Fix''' || "The 'HCAS' rule ('Hold Committed Allocated Stock') can be set for the owner code to enable stock that is committed or allocated to sales orders to switch its held reason code via the EDI process.
|'''Detail of Fix''' || The 'HCAS' rule ('Hold Committed Allocated Stock') can be set for the owner code to enable stock that is committed or allocated to sales orders to switch its held reason code via the EDI process.
   
   
When 'Y', stock that is committed or allocated to a sales order can be held for the new reason code after being released for the old reason code.
When 'Y', stock that is committed or allocated to a sales order can be held for the new reason code after being released for the old reason code.
Line 724: Line 729:
When 'N', stock that is committed or allocated to a sales order cannot be held for the new reason code after being released for the old reason code.
When 'N', stock that is committed or allocated to a sales order cannot be held for the new reason code after being released for the old reason code.


The customer pallet will be stored for the new held reason code when holding stock not by customer pallet."
The customer pallet will be stored for the new held reason code when holding stock not by customer pallet.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 746: Line 751:
|width="30%"|'''Summary of Call'''|| Unable to update system rotation for held stock
|width="30%"|'''Summary of Call'''|| Unable to update system rotation for held stock
|-
|-
|'''Detail of Fix''' || "Fix issue with handling held stock.
|'''Detail of Fix''' || Fix issue with handling held stock.


Screen now allows user to amend pallets where the hold is a manual hold.
Screen now allows user to amend pallets where the hold is a manual hold.


Ensure that hold details updated in line with pallet changes.
Ensure that hold details updated in line with pallet changes.
"
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 762: Line 766:
|width="30%"|'''Summary of Call'''|| Cancel message not generating/being sent
|width="30%"|'''Summary of Call'''|| Cancel message not generating/being sent
|-
|-
|'''Detail of Fix''' || "Ensure global variables are correctly reset so order cancellation message data are populated correctly.
|'''Detail of Fix''' || Ensure global variables are correctly reset so order cancellation message data are populated correctly.
 


Fix issue when order RF pick confirmed and pallet fully held with allocatable hold reason, to ensure allocatable stock quantities calculated correctly when pallet is validated."
Fix issue when order RF pick confirmed and pallet fully held with allocatable hold reason, to ensure allocatable stock quantities calculated correctly when pallet is validated.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 798: Line 801:
|width="30%"|'''Summary of Call'''|| Stock Movement 862 not moving held stock
|width="30%"|'''Summary of Call'''|| Stock Movement 862 not moving held stock
|-
|-
|'''Detail of Fix''' || "Ensure that when a pallet only contains a mixture of allocated and held stock, with no free stock available, if the user does a stock move, the held stock being moved is handled correctly.
|'''Detail of Fix''' || Ensure that when a pallet only contains a mixture of allocated and held stock, with no free stock available, if the user does a stock move, the held stock being moved is handled correctly.


Ensure that a WLE Held Stock record is created for the 'to' pallet."
Ensure that a WLE Held Stock record is created for the 'to' pallet.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
Line 855: Line 858:
|width="30%"|'''Summary of Call'''|| Generic Product Upload creating Stock Base Sell records with a zero 'price'
|width="30%"|'''Summary of Call'''|| Generic Product Upload creating Stock Base Sell records with a zero 'price'
|-
|-
|'''Detail of Fix''' || "Ensure that STOCK BASE SELL records are only written when a non-zero price is received
|'''Detail of Fix''' || Ensure that STOCK BASE SELL records are only written when a non-zero price is received


Data script will clean down STOCK BASE SELL records where price is zero."
Data script will clean down STOCK BASE SELL records where price is zero.
|-
|-
|'''Set-up and Configuration''' || No set-up/configuration required
|'''Set-up and Configuration''' || No set-up/configuration required
|}
|}




Revision as of 17:37, 16 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


DEVELOPMENTS

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


New Parameters
Parameter Name Config Level Setting Value Result
HRRC Owner Y Manually entered release reason code is stored as 'audit' table release reason code
Hold Reason - store entered reason code - N or Any other value Pre-existing functionality – the 'old' holding reason code is stored as 'audit' table release reason code


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


New Parameters
Parameter Name Config Level Setting Value Result
DTOW Owner Y Always include D017 segment transport details in despatch message
DE12 Owner Y Always include DE12 segment for reason code in despatch message


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


New Access
Access Tab Name Description
Warehousing / Warehousing Report WHS0290 Order Serial Report


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


BUGS

Aptean Log Number: 01894905

Summary of Call Despatch Note
Detail of Fix Amend the report’s ability to print serials.

Expand the size of the 'serial numbers' string from 1,000 char to 60,000 char, which will allow the report to print over 8,000 serials per stock code per order with current site serial number lengths.

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


Aptean Log Number: 01847238

Summary of Call Journal Creation
Detail of Fix Amend database trigger to ensure stock code, sell by date, manufacture date, pallet id, rotation no and cust rotation no populated.

Note: This change does not affect the 'CANC' or 'PACK' messages, as they are at order level and not pallet/order line level.

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


Aptean Log Number: 01929347

Summary of Call ADR EDI
Detail of Fix Amend UNA segment in ADR format DESADV despatch message.

The ',' or '.' in the UNA segment signifies that numeric fields will be separated by either a comma or a dot

This message needs to be a dot, as numeric fields will be reported as 1.23 not 1,23

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


Aptean Log Number: 01927435

Summary of Call Allocation by reason code
Detail of Fix Add new AHSO (Allocate Held Stock) warehouse rule option of 'C' (combined). This will allow users to allocate held stock with reason codes 1 or R via either EDI order entry or manual order entry.

Entered reason codes must be setup to allow the allocation of Held Stock.

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


Aptean Log Number: 00266918

Summary of Call Change to attention field in despatch note
Detail of Fix Amend the customer specific despatch note (WHR1900_GSK), so that the 'Attention' field displays the 'Contact Surname' rather than the 'Delivery Name'.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00271584

Summary of Call Issue with Hold/Release message
Detail of Fix Fixed issue - ensure that messages containing 'GE' option work as expected, and hold records are processed as expected.

Also fix - issue ensuring that new audit fields added via 01894409 (New Audit Journal Fields) can be selected by IAJD/Adjustments outbound configurable EDI flow.

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


Aptean Log Number: 00271825

Summary of Call Change to log 00271584
Detail of Fix Add new fields to 'Journal Detail' and 'Adjustment' 'IAJD_CRE' messages.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00272552

Summary of Call Update to hold/load EDI
Detail of Fix Re-work – ensure when changing stock code using 'GE' option and customer pallet no, that holds are only applied to the correct pallets
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00273581

Summary of Call Hold/Release Issue
Detail of Fix Ensure that when user 'swaps' hold, only 'selected' pallets are updated. Pallets that were not originally held but fall within the selection criteria will no longer be updated.

Added new table TEMP_HOLD_REL_PALLETS to allow this.

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


Aptean Log Number: 00273682

Summary of Call Held Stock / Allocation / Pick
Detail of Fix Amend WMS process so allocation does not remove allocation hold records when order is allocated.

Ensure system handles hold records correctly through pick and despatch processes.

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


Aptean Log Number: 01958712

Summary of Call Missing screen
Detail of Fix Missing screen from build deployed to test system.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 01942642

Summary of Call Configurable EDI
Detail of Fix Amend Stock Update process:

Error records are not deleted when valid records are processed.

If last record is invalid, if one or more valid record exists, don’t reject all records (for consistency).

Ensure Description3 populated.

Ensure error sequence populate correctly.

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


Aptean Log Number: 01969499

Summary of Call IAJD columns not populated
Detail of Fix Ensure 'add pallet' functionality in screen WHS0631 populates IAJD 'pid qty after cases' and 'pid qty after units' fields.

Previous fix only amended pallet amendment and pallet write off scenarios, not pallet add functionality.

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


Aptean Log Number: 01968022

Summary of Call Pick Confirmation - Detail screen
Detail of Fix When AHSO rule set to C:

Sales Order Detail Lines – ensure 'available' quantity field correctly displays values for held and un-held stock.

Pick List Confirmation - pallet LOV correctly references reason code and shows correct records for both held and un-held pallets.

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


Aptean Log Number: 01971675

Summary of Call Storage charges incorrect
Detail of Fix Generate rent charge when pallet created using change of ownership functionality.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 01966378

Summary of Call Select pallet screen in order entry does not show held pallet
Detail of Fix A new field called 'Include Held Stock' will be available for the selection criteria to select pallets for a sales order.

When 'Y', held stock will be considered to be available to order.

When 'N', held stock will not be considered to be available to order.

'N' will be the default value.

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


Aptean Log Number: 01981376

Summary of Call Despatch Print
Detail of Fix When existing SLDP rule is enabled, improved performance when validating load number
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 01981676

Summary of Call Pick Confirmation - Detail screen
Detail of Fix Amend DP_PICK_CONF_1 so that line type '4' (Allocate by Pallet) records are correctly pick confirmed.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 01981757

Summary of Call Order Entry
Detail of Fix Ensure correct free stock quantity displayed
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 01982586

Summary of Call Sales Order EDI
Detail of Fix Amend EDI sales order upload so line type 3 orders with reason code AHSO set to C can be successfully uploaded.

Ensure that line type 1, 3, 4 and R can be processed when AHSO rule (Allocate Held Stock) is set to C and OLIS rule (Order Line Issue Life) is set to Y.

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


Aptean Log Number: 00295336

Summary of Call Quantity available increases each time it is the cases field is entered in order lines detail screen
Detail of Fix Ensure if new order detail created, the issue life is populated if warehouse rule OLIS (order line issue life) is set to Y.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02018447

Summary of Call Pallet Exchange - allocated figure incorrect
Detail of Fix Fix issue with pallet id checks to ensure pallet exchange works correctly.

For pallet exchange, populate allocate date time

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


Aptean Log Number: 02019931

Summary of Call Pick Confirmation pop-up message
Detail of Fix The owner rule PCSV can be set to:

N (to select any order line) Y (to first select automatically a zero-pick order line) S (a new value to select short-pick order lines).

When this rule is S, the user will be prompted to select an order line against which the appended pallet will be stored.

An available quantity for the order line will be displayed to assist the selection of an order line that can be used for the quantity being picked from the appended pallet.

Cancelled order lines will not be available for selection.

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


Aptean Log Number: 02021059

Summary of Call Pallet Exchange incorrect
Detail of Fix Ensure when a pallet is chosen as an 'exchange' pallet after previously being 'exchanged', the process updates the correct order record.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02020012

Summary of Call Pick Confirmation - Cancel order
Detail of Fix Ensure 'cancel order' procedure works when order contains out of stock lines.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02013187

Summary of Call Order Enquiry - details screen
Detail of Fix The 'Order Number Summary' screen (ENQSOON03A) is changed so that for a cancelled order:

'Picked Value' is now populated 'To Pick/Packed' value is now populated 'Picked Price' value is now populated

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


Aptean Log Number: 02022286

Summary of Call Allocation sequence
Detail of Fix The order lines will be allocated in this sequence (ascending unless stated otherwise):

1 Order Number 2 Product Type 3 Product Picking Sequence 4 Product Code 5 Line Type Descending 6 Line Number

This allocation sequence will not be followed for order lines of types E, F or 2.

Prior passes for order lines of types E and F plus B and 1 for consolidated lines will retain their allocation sequences.

Allocates available held stock for the reason code so line type 1 will not allocate previously allocated stock or committed stock for another pallet.

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


Aptean Log Number: 02023303

Summary of Call Order Despatch
Detail of Fix Added new EDPL (Extended Despatch Logging) rule.

This rule does not change functionality, but if set to 'Y', writes extra audit records when an order is manually despatched.

Rule enabled for owners 'PU0','PU1','AT1','GR2','SH1','DC1' and 'UN1' try to find issue.

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


Aptean Log Number: 02022982

Summary of Call Hold / Release EDI
Detail of Fix The 'HCAS' rule ('Hold Committed Allocated Stock') can be set for the owner code to enable stock that is committed or allocated to sales orders to switch its held reason code via the EDI process.

When 'Y', stock that is committed or allocated to a sales order can be held for the new reason code after being released for the old reason code.

When 'N', stock that is committed or allocated to a sales order cannot be held for the new reason code after being released for the old reason code.

The customer pallet will be stored for the new held reason code when holding stock not by customer pallet.

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


Aptean Log Number: 02019309

Summary of Call Allocation - part / full pallet
Detail of Fix Rework allocation process as to how it calculates part and full stock pallet quantities when stock is held with 'allocatable' holds.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02010436

Summary of Call Unable to update system rotation for held stock
Detail of Fix Fix issue with handling held stock.

Screen now allows user to amend pallets where the hold is a manual hold.

Ensure that hold details updated in line with pallet changes.

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


Aptean Log Number: 02039423

Summary of Call Cancel message not generating/being sent
Detail of Fix Ensure global variables are correctly reset so order cancellation message data are populated correctly.

Fix issue when order RF pick confirmed and pallet fully held with allocatable hold reason, to ensure allocatable stock quantities calculated correctly when pallet is validated.

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


Aptean Log Number: 00304934

Summary of Call Amend GRN Note label logic
Detail of Fix Report label now displays the advice note no reference when container no is blank and 'Goods Receipt Note' format of 'CON'.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02040541

Summary of Call Adhoc Move - WMS Updates
Detail of Fix Amend ADHOC RDT movements when users are trying to move more than 2 case worth of units. Ensure that the available case/unit figures are correctly calculated.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00211518

Summary of Call Stock Movement 862 not moving held stock
Detail of Fix Ensure that when a pallet only contains a mixture of allocated and held stock, with no free stock available, if the user does a stock move, the held stock being moved is handled correctly.

Ensure that a WLE Held Stock record is created for the 'to' pallet.

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


Aptean Log Number: 02011048

Summary of Call Outstanding audits unable to confirm on the gun
Detail of Fix Fix oracle error when replenishment audit number is bigger than 99,999.
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00306672

Summary of Call Order cancellation not sending EDI
Detail of Fix Add 'EDI cancel' message functionality to pick cancellation process
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 02063841

Summary of Call Release task for report WHR0110_NOM
Detail of Fix Changes made to report WHR0110_NOM. Layout moved to the right
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 01974351

Summary of Call Delete Flag
Detail of Fix Ensure the delete flag for the users is correctly considered during login
Set-up and Configuration No set-up/configuration required


Aptean Log Number: 00271608

Summary of Call Generic Product Upload creating Stock Base Sell records with a zero 'price'
Detail of Fix Ensure that STOCK BASE SELL records are only written when a non-zero price is received

Data script will clean down STOCK BASE SELL records where price is zero.

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.


Note: Please include the latest EDI layout document v90 with the release email to the customer


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