WMS 810 P013 120215: Difference between revisions

From Calidus HUB
No edit summary
No edit summary
Line 41: Line 41:
|Greencore EDI update
|Greencore EDI update
-
-
If H001 EDI message contains the text 'COLLECTION', don't sent message to Vigo.
If H001 EDI message contains the text 'COLLECTION', don't sent message to Vigo.
Create new 'Sales Order' email format **NOTE - email template will need to be setup by a manual script**
Create new 'Sales Order' email format **NOTE - email template will need to be setup by a manual script**
Line 59: Line 58:
|4
|4
|
|
|Cust pallet ID incorrect on pick list
|Customer pallet ID will now print correctly on the pick for pallets adjusted onto the system.
-
 
Customer pallet ID will now print correctly on the pick for pallets adjusted onto the system.
|Selby
|Selby
|Orders - Pack list
|Orders - Pack list

Revision as of 14:24, 8 April 2015





Aptean Logo.png







OBS Logistics Ltd



WMS Software Release Notes

12th Feb 2015 - 1.0
Reference: Patch WMS_810_013












































Development Defects

Log Number Client Ref Log Priority CR/D Issue Raised and Test Objective Site Functional Area Reporter ER Number ESI Change Required WCS Change Required
321229 Greencore EDI update 3 D Greencore EDI update

- If H001 EDI message contains the text 'COLLECTION', don't sent message to Vigo. Create new 'Sales Order' email format **NOTE - email template will need to be setup by a manual script** Add new ECOL (Enable EDI Clear Order Lines) owner level rule. If set to Yes, if the user finds an EDI created order, which hasn't been allocated, a 'clear lines' button is displayed on the order entry canvas, which will move all lines to line type 2 (non-stock lines) Amend allocation process, so if order is allocated after it has been cleared, it stays at status 1 and an appropriate message is generated."

Selby u/a Paul Reed ER012-001 N   N  
323019 HA4 4 Customer pallet ID will now print correctly on the pick for pallets adjusted onto the system. Selby Orders - Pack list LUCY LOUGHTON ER012-002 N   N  
322914 PIPPLS053 3 D Despatch label printing error

-

Fix issue with PIP format despatch label when non-GPO address is used

u/a u/a Lynda Spencer ER012-003 N   N  
323141 - 2 D Despatch note printing incorrectly

-

Amend WES (Westex) format despatch note, to ensure post code is printed. Also ensure order details are not repeated.

u/a u/a HOWARD ALLEN ER012-004 N   N  
323055 - 3 Nominal code not added to charges

-

Ensure account code is populated when creating charges via RDT.

u/a RDT - WMS Interface Paul Reed ER012-005 N   N  
323011 - 3 D Master Order Screen (Order cancellation)

- Amendment to Cancel Order button the Master Order screen to remove the anticipated orders (if not sent to WMS) in the same way as the when using the cancel by line option. Also script to update ORS data for field header referring to ESI.

u/a u/a Zalkifl Ghanty ER012-006 N   N  
323267 EARS00035648650 4 Two pick lists printed for route/load

-

Audit the logon of pick requestor

u/a Orders - Pack list Martin Woods ER012-007 N   N  
323535 LS-9GWJZC 3 D Additional OML Functionalities

-

Amend form so the postcode sort button correctly orders the data on delivery address tab.

Note - it covers only point 1 of the TID.

u/a u/a Zalkifl Ghanty ER012-008 N   N  
323288 Rework of 321229 3 Rework of 321229

- Amend sales order email message to add End Delivery Date of Order Header to message

Amend both sales order screens so 'select pallets' canvases correctly report actual ordered quantities when orders have had the Greencore 'clear lines' functionality run.

Also reference Alloc Email Address (on Sales Order canvas) rather than Email address (on Main canvas).

Selby u/a Paul Reed ER012-009 N   N  
323774 PIPPLS058 3 WMS_AUDIT Change Date field

- Scripts to update Oracle reporting suite data for the WMS_AUDIT table data so changed_date field is now treated as a DATE field.

u/a General - Reports Lynda Spencer ER012-010 N   N  
323414 - 3 D Test Env Issue - Order Confirmation

-

Re-work of 314677. Fix issue with DFDT changes - when DPDT rule is not set, ensure that pick date is populated.

u/a u/a James Ross ER012-011 N   N  
323948 Internal 3 Prog missed off log 323288

-

DP_EDIGEN_SALES_ORDER_VAL.sql v4.136 was missed from log 323288

Selby u/a Dave Potter ER012-012 N   N  
324029 Rework of 321229 (2) 3 Fix issue with alloc email address

-

Ensure we always pass .alloc email addr. to sales order message process

Selby u/a Dave Potter ER012-013 N   N  
323627 - 3 CR PIP Stocktake add stock date validation

-

Add owner level rule 'SAPS' to allow stock take added pallets to have sell-by-dates in the past.

u/a PI Functionality Peter Blackburn ER012-014 N   N  
323853 - 3 CR Pip stock take changes

-

Create new PIP format stock take format, which matches the existing generic format except it will exclude any pallet has been created by an unconfirmed stock take.

A new owner level STAA (stock take advanced audit) controls the created of new stock take STTA rules.

Note: These new STTA audit records are moved to the STKTAKE_IAJD table once the stock take is either completed or rejected.

Healthcare - PIPP PI Functionality Dave Potter ER012-014 N   N  
324123 323853 - missing dev 3 Add missing functionality from 323853

-

Added Stock Take In Prog and Stock Take No fields to INVENTORY/PALLETS ORS report.

Stock Take In Prog is a 'selectable' field, so the user will be able to select only pallets under stock take

u/a PI Functionality Dave Potter ER012-015 N   N  
323075 PIPPLS056 3 D LS-9GMKUU Pre-fix pallet IDs

-

Ensure when owner pallet id flag set to G (Generate), that customer pallet id is not incremented when record saved.

u/a u/a Lynda Spencer ER012-016 N   N  
324338 - 4 Amend SALE file to handle recall orders

-

Amend SALE file so orders manually keyed so with a source of RECALL.

u/a EDI - Outbound Pam Hodgkinson ER012-018 N   N  
322263 - 3 D RIO LS-9GWJZC

-

Change label from 'DH Order No' to 'Customer Order'

u/a u/a Zalkifl Ghanty ER012-019 N   N  
323189 PIPPLS057 3 D LS-9GMKUU Pre-fix pallet IDs

-

If owner pallet id flag set to G (generate) and GRN is generated by an inter warehouse transfer, and has pallet details have been passed through, do not overwrite the cust pallet id.

u/a u/a Lynda Spencer ER012-020 N   N  
324514 STS3001 Update 3 D Stock enquiry screen STS3001

-

Add order ref (sellers ref) to enquiry screen - for PICK and SALE records, field labelled 'Order Reference'.

Ensure cust pallet id field always displayed when populated.

u/a u/a Paul Reed ER012-021 N   N  
324460 PIPPLS057 3 D PI Change on ER012-015

-

Amend ORS Inventory report so stock take no is now a range, where user can select 0 thro 0 to find pallets not under created by an unconfirmed stock take.

u/a u/a Lynda Spencer ER012-022 N   N  
322866 EARS00035638589 4 Unison Oracle spends Issue

-

Amendment to process for enable/disable customer credit limit check so only updates the customers that are currently at the specified sales territory.

u/a Setup - customers Martin Woods N   N  
323360 EARS00035650799 4 Packing report from ORS is incorrect

-

Amend the PACK_EFUL, so if the order contains more than 1 product type, the data is not duplicated.

Atherstone General - Reports Josh Daffern N   N  
323254 - 2 Whyte Chemicals (WH3) Sept / Oct / Nov

-

Amendment to invoice/Credit note prints to handle instance where customer has multiple invoice INV addresses. The print will select the address with the highest invoice address number.

Ripon Invoicing Kathryn Collison N   N  
323517 EARS00035654810 3 Pick wave batching is slow

-

Improve performance of pick wave screen

Atherstone Order Processing Steve Talbott N   N  
317981 JD-9KBCYD 3 D Metapak Update to use API v 5

-

Populate <recipientPhone> and <recipientMobilePhone> with PHONE_NO of ORDER_HEADER.

Atherstone u/a Josh Daffern N   N  
324147 - 2 Unable to delete address details

-

Amendment to customer wizard to correct handling of delivery address deletion, especially in environments that do not require the GPO address details.

Selby Setup - customers LUCY LAUGHTON N   N  
324234 EARS00035673216 3 Invalid Line Error

-

Amend EDI sales order upload procedure where a sales order line contains new line characters.

u/a EDI - Inbound RYAN MCLAREN N   N  
324444 HA4 despatch note 3 HA4 despatch note

-

Amendment to HA4 format despatch note to correct layout of delivery address field and prevent details overlapping.

Selby General - Reports Paul Reed N   N  
324526 Internal 3 D Add GRMK generation to one stage GRN

-

Added ability to create GRMK messages from one stage GRN screen, in line with pre-existing goods receipt functionality.

Harlow Warehouse u/a Dave Potter N   N  
323093 EARS00035644179 4 Order lines not saving during entry

-

Order Entry has been amended so pallets under stock take cannot be selected. This is for line types where a pallet / rotation / customer rotation is specified - general stock (line type 1) remains unchanged. The pallets will not appear in LOVs, and will not be included in any total fields. The stock enquiry and pallet enquiry have had the stock take indicator added so it is visible.

u/a Orders - Entry Mark Chapnell N   N  
324572 - 4 D Only allow upper case barcodes

-

Ensure entered barcodes must be uppercase.

u/a u/a Emily Collins N   N  

Modules Delivered

Module Name Version No Description Log Number
AT_STK_STOCKIST_321229.sql 4.1 Alter table Script 321229
AT_WARE_LOCATION_ENTRIES_323853.sql 4.1 Alter table Script 323853
AT_WARE_LOCATION_ENTRIES_324123.sql 4.1 Alter table Script 324123
CT_STKTAKE_IAJD_323853.sql 4.1 Create Table Script 323853
DATA_DYNAMIC_MESSAGES_321229.sql 4.2 Data Script 321229
DATA_DYNAMIC_MESSAGES_323627.sql 4.1 Data Script 323627
DATA_DYNAMIC_MESSAGES_324234.s 4.1 Data Script 324234
DATA_ML_CAPTIONS_321229.sql 4.1 Data Script 321229
DATA_ORS_MASTER_DATA_322263.sql 4.1 Data Script 322263
DATA_ORS_MASTER_DATA_323011.sql 4.1 Data Script 323011
DATA_ORS_MASTER_DATA_323360.sql 4.1 Data Script 323360
DATA_ORS_MASTER_DATA_323774.sql 4.1 Data Script 323774
DATA_ORS_MASTER_DATA_324123.sql 4.1 Data Script 324123
DATA_ORS_MASTER_DATA_324460.sql 4.1 Data Script 324460
DATA_ORS_SQL_323360.sql 4.1 Data Script 323360
DATA_ORS_USER_DETAILS_323011.sql 4.1 Data Script 323011
DATA_ORS_USER_DETAILS_323774.sql 4.1 Data Script 323774
DATA_OWNER_MESSAGE_322263.sql 4.1 Data Script 322263
DATA_WARE_LOCATION_ENTRIES_324123.sql 4.1 Data Script 324123
DATA_WAREHOUSE_RULES_CONTROL_321229.sql 4.1 Data Script 321229
DATA_WAREHOUSE_RULES_CONTROL_323627.sql 4.1 Data Script 323627
DATA_WAREHOUSE_RULES_CONTROL_323853.sql 4.1 Data Script 323853
DP_DESPATCH_CASE_LABELS.sql 4.22 Despatch Label Print 322914
DP_EDI_OUTBOUND.sql 4.83 EDI Outbound Receipt Confirmation 323853
DP_EDIGEN_OUT_SALES.sql 4.14 Outbound EDI Sales Process 324338
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.148 Inbound EDI Sales Order Upload 324234
DP_EDIGEN_SALES_ORDER_VAL.sql 4.135 Order_Header update package 321229
DP_EDIGEN_SALES_ORDER_VAL.sql 4.136 Order_Header update package 323948
DP_EDIGEN_SALES_ORDER_VAL.sql 4.137 Order_Header update package 324029
DP_METAPACK.sql 4.29 New Metapack API package 317981
DP_MSG_EMAIL.sql 4.7 Email creation package 321229
DP_MSG_EMAIL.sql 4.8 Email creation package 323288
DP_OMS_ANT.sql 4.30 Package to create anticipated Orders 323011
DP_ORS_FUNCS_WMS.sql 4.16 Extract Suite Functions package 323360
DP_PICK_REQ.sql 4.24 Pick request processing 323267
DP_RDT_DESP_UPDATE.sql 4.6 RDT Despatch process 323055
DP_SOP_01.sql 4.6 Sales Order Detail db package 321229
DP_SOP_01.sql 4.7 Sales Order Detail db package 323093
DP_WARE_STOCK_TAKE_PIP.sql 4.11 Stock Take update 323853
DP_WARE_STOCK_TAKE_PIP.sql 4.12 Stock Take update 324123
DP_WHSORA036.sql 4.2 Customer spends update package 322866
DP_WMS_ALLOC.sql 4.115 Allocation Procedure 321229
DP_WMS_ALLOC.sql 4.116 Allocation Procedure 323019
LAS0312.fmx 4.119 Pick Wave Maintenance 323517
OMS7000.fmx 4.31 Anticipated Orders Control 323535
OMS7010.fmx 4.15 Master Orders Control 323011
OMS7010.fmx 4.16 Master Orders Control 322263
SOS1110.fmx 4.96 Sales Order Entry 321229
SOS1110.fmx 4.97 Sales Order Entry 323288
SOS1110.fmx 4.98 Sales Order Entry 323093
SOS1117.fmx 4.72 Sales Order Detail Lines 323288
SOS1117.fmx 4.73 Sales Order Detail Lines 323093
STKSTOC01B.fmx 4.68 Stock Maintenance 324572
STS1000.fmx 4.82 Owner Maintenance 321229
STS3001.fmx 4.9 Stock Enquiry Sub Screen 324514
V_CONTAINER_NO.sql 4.3 Database view for pallet enquiry 323093
WHR1900_HA4.rdf 4.7 Client specific despatch note 324444
WHR1900_WES.rdf 4.4 Client specific despatch note 323141
WHR8118_CHR.rdf 4.12 Invoice Print - charges format 323254
WHR8118_MAN.rdf 4.5 Manual Invoice/Credit Report 323254
WHR8118_PRD.rdf 4.14 Invoice Print - product format 323254
WHR8119_CHR.rdf 4.4 Credit note print format CHR 323254
WHR8119_PRD.rdf 4.4 Credit note print format PRD 323254
WHS0150.fmx 4.102 Goods Receipt Confirmation 323189
WHS0172.fmx 4.21 Rotation Stock Details 324526
WHS0542.fmx 4.24 Stock Take Count Input 323627
WHS0542.fmx 4.25 Stock Take Count Input 323853
WHS0544_PIP.fmx 4.14 Count Input 323853
WHS0631.fmx 4.50 Stock Adjustments – add pallets 323019
WHS0631.fmx 4.51 Stock Adjustments – add pallets 323075
WHS0902.fmx 4.12 Stock Location Enquiry 323093
WHS0915.fmx 4.27 Pallet Enquiry 323093
WHS1714.fmx 4.112 Pick Confirmation 323414
WHSORA010.fmx 4.68 Allocation Kick-off 321229
WHSORA035.fmx 4.34 Customer Wizard 324147

New Registry Settings

Log Number Path & Name Setting Value Result
321229 Owner/ECOL Y Enable 'Clear line' functionality
321229 Enable EDI Clear Order Lines N, any other value, or not set -
323627 SAPS Y Allow new pallets created during stock take input to have sell-by-date in the past
323627 SAPS N/Null Pallets created in stock take input must have sell-by-date in the future
323853 STAA Y Create new STTA stock take audit record, which is cleared down once the stock take is completed or rejected
323853 Owner level stock take advanced auditing flag Any other value or rule not set No change in functionality

New Screens

Log Number Suggested Menu Path Screen ID Description