WMS 810 P013 120215
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 | Cust pallet ID incorrect on pick list
- 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 |
