PATCH WMS770 P091 080512

From Calidus HUB
Revision as of 13:57, 8 December 2014 by Anw (talk | contribs)





Aptean Logo.png







OBS Logistics Ltd

Release Notes


CALIDUS TMS

8th May 2012 - 1.0
Reference: P091












































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
296736 - 3 "RF Putaway - no response from WMS

- Ensure that system correctly selects locations both forward and backwards for algo Y.

Also check to see that locations are selected only if

priority matches the highest priority available."
Huddersfield u/a Stuart McDowall 90-05
297004 - 4 "Viewing line type R orders using SOS1117

-

Ensure that line type R orders can successfully be viewed once they are allocated or above using the Sales Order Detail screen (SOS1117)."
Huddersfield u/a Stuart McDowall
296997 EARS00032265865 3 "Pallet quantities report

-

Amendment to process DP_STOCK_ENQ_REPORT to version 4.3 so fieldname to hold generated file name is long enough to incorporate all user logins."
Healthcare - PIPP Warehs - reports Hemal Tailor
296901 EARS00032252303 4 "Stock Demand Control Screen

-

If the user removes the value from the editable cases fields completely, on saving the value will be set to 0 instead of null."
Consumer - NOMS Purchase Orders Parbat Odedra 90-01
297022 EARS00032274071 4 "Oracle Reporting Suite; IAJD report slow

-

Amend queries to use indexes for reports on IAJD when selecting by date."
Consumer - NOMS Warehs - reports Parbat Odedra 90-02
297078 - 3 "Add missing close statement to DP_DESPATCH package

-

Amend despatch confirmation package, so if multiple pallets sharing a single rotation no are despatched, an oracle error does not occur during the despatch confirmation process."
Huddersfield u/a Dave Potter 90-04
296962 EARS00032260621 4 "Cannot find kits after creating orders

-

An issue was identified in the Kit Release screen where optional items had been short picked. This has been corrected so that the correct number of kits are built based purely on availability of stock for the mandatory items."
Healthcare - Poland (Roche) Stock - Kitting Lukasz Danel 90-06
297020 PO-8RSF8J 3 D "Change User Logons for Despatch RCPT scn

- Stop users selecting old orders when running Pick Confirmation if PCSL flag set to Y and user's security flag is set to 1.

If the NOMS specific despatch label is re-run, display a 'RE-PRINT' label to it."
Consumer - NOMS u/a Parbat Odedra 90-03
295159 PI-8P5KEC 3 D "Revised functionality in Stock Snapshot

-

A new version of the stock snapshot has been created. This version can be switched on by setting the format code, of a snapshot process, to BHS. This version will only include stock codes that have had a quantity change since the last run of a stock snapshot. A new report ""Stock Snapshot Report"", WHS2032, will need adding to the menu. The stock snapshot report will produce the snapshot in spreadsheet format. This can be set to run as a database job or run immediately and can be run to screen or e-mailed to a list of recipients."
Consumer - BHS Atherstone EDI - Outbound Phillip Isle 90-07
297079 - 3 "Add PND fields to Aisle Status screen

-

Allow the user to maintain the maximum number of pallets a PnD location can hold. This will allow the user to quickly and easily change the locations status from ie Full to Available."
Huddersfield u/a Dave Potter 90-05
297216 - 3 "Amendment to WHS0700 Stock Movements to correct error encountered with stock type moves where one of the pallet ids is move than 6 digits. Previously left the movemement partially completed." Healthcare - PIPP Stock - Movements Peter Blackburn 90-08
297280 - 3 "PND count issues

- Amend Aisle Sequence Maintenance so the form's error validation is only run when data is changed.

Amend putaway and movement confirmation to correctly downdate free and ware location pallet quantities."
Huddersfield u/a Dave Potter 90-09
296735 EARS00032222704 4 "Warehouse was associated to W36

-

New version of the overnight PO Suggestion sales demand processing. This deletes forecasts for warehouses with no prisons associated, and fixes an issue with first sales dates for New Line products."
Consumer - NOMS PO Suggestions Gemma Mead
295769 LD-8QGGF2 1 D "Create new general despatch note for UCB

-

Change to the despatch note format SER, to allow the owner and Kit Nos headings to be configurable. Change to the despatch note kick off screen, WHS1900, to force entry of the despatch format when owner rule DDDF is set to Y. Change despatch kick off screen to run the UCG format despatch note."
Healthcare - Clinical Trials Orders - Desp note Lukasz Danel 90-10
297405 - 3 "P&D Final Issues pre release

- Ensuring that the PnD locations are correctly downdated when a user using RF puts stock away from a default floor location

Also when the user, using the Goods Receipt Confirmation screen, changes the location of a pallet from a PnD aisle location to another location, the ‘from’ PnD aisle is correctly downdated, and where necessary, the ‘to’ PnD aisle is updated correctly."
Huddersfield u/a Stuart McDowell 90-11
296165 4 "Cancel order failed to free up serials

- Changes have been made to allocation to correctly create out of stock lines for held serials. The out of stock serials are created with the cancelled flag set to Y to enable a fast pick confirmation to zero without the need to remove serials from the orders.

The entry of serial numbers for an order has been changed to allow re-entry of a serial number that has previously been entered on an order providing the order has been cancelled."
Healthcare - Clinical Trials Orders - Pick conf Catherine Roscelli
296697 - 3 "RDT Pick Instructions

- If warehouse level RFPI flag set to E, set pick text to text_line_1 of order_line_message, if pick text is populated.

If it is not set, or the warehouse level RFPI is not set to E, pre-existing functionality will be applied."
Huddersfield u/a Stuart McDowall 90-12
297412 EARS00032335390 4 "Despatch note needs some changes

-

The UCB format despatch note has been fixed to correct the uppercase B to b. The Temp Monitor Ref field has been changed to print the serial no."
Healthcare - Clinical Trials Orders - Desp note Lucasz Danel 90-13
297193 - 3 "Free location generation

-

Expand the size of fields with free location generations, so pallet count values can handle an 8 digit value rather than a 4 digit value."
u/a u/a Dave Potter 90-21
297304 EARS00032318296 4 "PACK EDI generation problem

- XF Monitor screen has been amended so the format /

owner fields will now appear for packing flows."
Healthcare - Clinical Trials EDI Lukasz Danel 90-17
297441 - 3 D "Dispatch ticket prints

-

Changing form so that it can see and find orders which are status 5 and 6."
Consumer - NOMS u/a Parbat Odedra 90-14
297607 - 4 "Dispatch ticket prints

-

Stop an oracle message appearing on screen every time a label is printed"
Consumer - HM Prisons/NOMS u/a Dave Potter 90-15
297506 PND Count 3 "PND count incorrect

- Ensure that when stock is putaway via RF, the PnD locations associated with the aisles is correct.

Ensure that when a re-positioning occurs, the 'to' aisle is correctly updated as containing a pallet"
Huddersfield u/a Leon Winchester 90-16
297569 EARS00032359667 4 "Stock adjustment error

-

Amendment to WHS0630 stock adjustment form to ensure stock data is read and is available when updated stock balance and movement data. Fix for when user enters stock code and immediatley uses the 'Find' button - ensures stock description is displayed and stock factors have been read."
Healthcare - Clinical Trials Stock - Adjustments Lukasz Danel 90-27
297666 - 3 "P&D - Stock Movements

-

Ensure that when manual moves are confirmed, if the location on an aisle which has a PnD location, that the PnD location is correctly down dated when the move is completed."
Huddersfield u/a Stuart McDowall 90-18
297340 EARS00032325849 4 "Unable to place manual orders

-

Amend order of processing to ensure if any issues occur during the generation of the GRN the processing is rolled backed fully and gives the user an error message."
Consumer - HM Prisons/NOMS PO Suggestions Gemma Mead
297631 - 3 "Pick Conf not freeing locations

-

The RDT pick confirmation package has been changed to correctly update the status of the location picked from and to correctly update the associated free location details."
Huddersfield RDT - Pick Conf Stuart McDowall 90-19
297507 - 3 "Repositioned pallets still on hold

-

Ensuring that when multiple GRNs are receipted in, all goods receipts are receipted correctly."
Huddersfield u/a Stuart McDowall 90-20
297743 - 2 "Pallets going to the same location

-

Fix to the free location generation routine, where pallets which were receipt confirmed but not putaway confirmed were not included in the location totals."
Huddersfield u/a Stuart McDowall 90-22
297680 - 3 "Pallets not showing as Putaway

-

Ensure that stock is receipted and putaway, the system correctly maintains the location in the WLE Held stock record, so when the pallet is putaway, the record is delete."
Huddersfield u/a Stuart McDowall 90-23
297681 - 3 "Stock Movements Screen

-

The stock movements screen has been changed to ensure the suggest location package is called afresh for each pallet to ensure a new location is suggested for each pallet being moved when doing a pallet movement."
Huddersfield Stock - Movements Stuart McDowall 90-24
297338 - 3 "New picking container report

-

Create new picking containers oracle reporting suite flow."
Huddersfield u/a Stuart McDowall 90-25
297817 EARS00032400904 4 "Snapshot info is incorrect

-

Stock snapshot BHS format has been changed to include all changes to quantities when deciding whether to include a stock code in a partial stock snapshot as opposed to changes to on hand quantity only."
Consumer - BHS Atherstone EDI Phillip Isle 90-26
295940 LD-8QNK64 3 D "Create Portal Outbound Control screen

-

Added portal procedures for WMS."
Healthcare - Clinical Trials u/a Lukasz Danel 90-28
297943 JMS6419 2 "Ad Hoc move not freeing up location

- Ensure that RF Ad-hoc stock moves downdate the 'from' location correctly, so it becomes free.

Also amend the goods receipt screen, so that should the user attempt to delete a pallet record whose location code is '+', it does not raise an oracle error."
Huddersfield u/a Jeremy Brook 90-30
297511 - 3 "RF Pallet Enquiry not working

-

If a pallet enquiry is made for a pallet number which does not exist in the WMS, ensure that the 161 message returned does not inherit any data from the previous message."
Huddersfield u/a Stuart McDowall 90-31
298111 XFMoniter updates 3 "XFMoniter updates

-

Amend field handling - so that local processes and outbound process now automatically always display format code, owner code, customer identifier, priority sequence and end sequence. Inbound messages only ever display file format and file code."
u/a u/a Phil Harding 90-38
297951 Error reasons 3 "Error reasons on RF units

-

Amend package so that the correct pallet type record is being used. This will ensure that the correct error message, (when applicable), is passed back to the RF user."
Huddersfield u/a J. Brook 90-35
286464 REN-001 3 D "John Lewis Message

- A new flow will need to be setup running a 'package sql code' value of dp_edigen_out_ren_outbound.generate_daily_file. With the EODA rule set for the owner to Y (Yes), the system will be able to select orders which have been raised today or have been amended today whilst at status of 1. Note: Orders that are changed after status 1 via processes such as short picking or short despatching

will not be selected"
REN u/a Howard Allen 90-29
298208 - 3 D "Audit trigger update

-

An error was found with TRG_ORDER_DETAIL_BIR.sql when the user deletes a WLE record. Log raised to release fix, needs to be released with log 286464."
REN u/a Dave Potter 90-32
295941 LD-8QNJQH 3 D "Create Portal Inbound Confirmation screen

-

Added receipt procedures for the Portal system"
Healthcare - Clinical Trials u/a Lukasz Danel 90-33
298174 EARS00032454555 4 "EDI error report does not show all data

-

Report was not ever printing more than 1 page - the layout has been amended to allow multiple pages to print when required for EDI data / critical errors."
Consumer - BHS Atherstone EDI - Inbound Phillip Isle 90-36
297700 EARS00032385813 4 "Files not showing in the tracking tab

-

Product load has been amended to allow more than 100,000 products to be loaded from 1 file."
Consumer - BHS Atherstone EDI - Inbound Phillip Isle 90-37
298073 EARS00032436897 4 "Cannot delete snapshot reports

-

A ""Stop Job"" button has been included on the stock snapshot report screen. This button can be used to stop the stock snapshot job from running. The ""Submit Job"" button can be used to restart stopped jobs."
Consumer - BHS Atherstone Stock - Reports Phillip Isle 90-34
298326 PO Reqd 3 D "Update to Desp Note (LD-8P4KCH)

-

Fix report to display consignment ref rather than the order num as 'Consignment No:'."
Healthcare - Clinical Trials u/a Lukasz Danel 90-40
298221 - 3 "Release DP_EDIGEN_OUT_REN_OUTBOUND

-

Removed debug messages from package so allow release."
REN u/a Dave Potter 90-39
298403 - 4 "Consignment No is populate incorrectly

-

Change the 'Consignment No' to point to the 'Customer Ref' (CUSTOMER_PO_REF) field rather than the 'Reference' (ORDER_DESCRIPTION) field."
Healthcare - Clinical Trials u/a Catherine Roscelli 90-41
298476 LD-8QNJQH 3 D "Change for Portal Receipts

-

Added log for further release of portal package."
Healthcare - Clinical Trials u/a Roger Egdell 90-42
298449 EARS00032493977 3 "Stock allocation / packing issues

- Amend the consumable box and temperature LOV's so they calculate the available quantity directly from the pallet data rather than the Stock Warehouse data.

Ensure that if an order is rolled back, and the pallet data was downdated and the pallet record deleted, it is recreated when with a value of 1 case."
Healthcare - Poland (Roche) Orders - Pack list Lukasz Danel 90-43
298382 - 3 "GI001 not clearing with reposition

-

Ensure that if a goods receipt is repositioned from a default floor location, the floor location is correctly downdated."
Huddersfield u/a Stuart McDowall 90-44
298606 EARS00032521364 3 "Order status issue

-

Amend check on customer invoicing flag during POD conf so any blank / null value is treated as NO instead of Yes."
Healthcare - Clinical Trials Orders - Pod Lukasz Danel
298641 GOW-015 4 D "Portal Goods pre-advice issues

-

Change to receipt process to allow for Manual Rotations."
Healthcare - Clinical Trials u/a Lukasz Danel 90-45
297080 MJ-8RQCW6 3 D "Label redesign

- Create a new Grace Construction format barcode pallet label

To run the format, against the owner setup, on the 'format' tab, the 'Pallet Label PLBC' field must be set to GRC."
Industrial - Grace u/a Michal Janicki 90-46
298976 - 3 CR "Additional info in Lock Monitor

- New tab page to show users with multiple sessions.

Change to locks page - user details now shown by double-clicking on the username. List of all locks can be seen by double-clicking on the locks field."
Consumer - HM Prisons/NOMS Performance Mark Hext
296693 - 4 "Order input process has frozen in test

- Fixing 2 main errors 1) If and when Metapack fails with a catastrophic error ie (500)Internal Server Error, then mark all unprocessed lines as rejected.

2) If an invalid password error occurs, as metapack’s response is not classed as good-XML, handle error. Again, if sales order, reject whole file."
Consumer - BHS Atherstone Orders - Entry Dave Potter

Modules Delivered

Module Name Version No Description Log Number
DP_WHS2180.sql 4.12 Find Nearest Free Location 296736
DP_WHS2185.sql 4.15 Suggested Location database package 296736
SOS1117.fmx 4.55 Sales Order Detail Lines 297004
DP_STOCK_ENQ_REPORT.sql 4.3 Stock Enquiry Report 296997
POS1020.fmx 4.22 Stock Demand Control Processing 296901
ORS0100.fmx 4.24 Updates to SQL Data 297022
DP_DESPATCH.sql 4.40 Despatch Confirmation Package 1 297078
SOS1428.fmx 4.9 Stock Kits Assembly Request 296962
WHS1714.fmx 4.85 Pick Confirmation 297020
DP_NOMS_DESPREC.sql 4.22 Despatch Receipt 297020
WHS2032.fmx 4.1 Stock Snapshot 295159
CT_XF_DATE_RUN_295159.sql 4.1 Create Table Script 295159
DP_STOCK_SNAP_REPORT.sql 4.1 Stock Snapshot Report 295159
DP_SCHED_REPORT.sql 4.4 Scheduled Report Handling 295159
DP_EDIGEN_OUT_ST_BAL.sql 4.38 STK balance flat file package 295159
DP_EDI_OUTBOUND.sql 4.59 EDI Outbound Receipt Confirmation 295159
DATA_DYNAMIC_MESSAGES_297079.sql 4.1 Data Script 297079
WHS8231.fmx 4.3 Aisle Status Maintenance 297079
DP_WHS2185.sql 4.16 Suggested Location database package 297079
WHS0700.fmx 4.25 Warehouse Movements 297216
WHS0150.fmx 4.87 Goods Receipt Confirmation 297280
WHS8231.fmx 4.4 Aisle Status Maintenance 297280
DP_WHS2185.sql 4.17 Suggested Location database package 297280
DP_WHS2181.sql 4.4 Update Free Locations 297280
DP_WHS7872.sql 4.27 RDT Inbound Pallet Movements 297280
DP_STOCK_DEMAND.sql 4.37 Overnight Stock Demand Process 296735
DATA_WAREHOUSE_RULES_CONTROL_295769.sql 4.1 Data Script 295769
DATA_OWNER_MESSAGE_295769.sql 4.1 Data Script 295769
DATA_ML_CAPTIONS_295769.sql 4.1 Data Script 295769
WHS1900.fmx 4.31 Despatch Print Kick-Off 295769
WHR1900_SER.rdf 4.3 Blind Despatch Note 295769
DP_WHS2185.sql 4.18 Suggested Location database package 297405
DP_WHS2181.sql 4.5 Update Free Locations 297405
DP_WHS7872.sql 4.28 RDT Inbound Pallet Movements 297405
WHS0150.fmx 4.88 Goods Receipt Confirmation 297405
WHS0200.fmx 4.16 Pick by Line Ticket Print Kick Off 296165
DP_WMS_ALLOC.sql 4.105 Allocation Procedure 296165
WHR1700_3.rdf 4.9 Out of Stock Report 296165
DP_RDT_PICK_REQUEST.sql 4.32 Pick Request Database Package 296697
WHR1900_UCB.rdf 4.3 Despatch note for UCB 297412
AT_PALL_COUNT_SUB_297193.sql 4.1 Alter Table Script 297193
DP_WARE_LOC.sql 4.21 Free Location Generation – database package 297193
XFM0020.fmx 4.38 XF Monitor 297304
WHS1714.fmx 4.86 Pick Confirmation 297441
WHS1714.fmx 4.87 Pick Confirmation 297607
WHS0156.fmx 4.17 GRN Putaway Check Digits 297506
DP_WHS7872.sql 4.30 RDT Inbound Pallet Movements 297506
DP_WHS2181.sql 4.6 Update Free Locations 297506
DP_WHS2185.sql 4.19 Suggested Location database package 297506
WHS0630.fmx 4.66 Stock Adjustments 297569
WHS0700.fmx 4.26 Warehouse Movements 297666
POS1011.fmx 4.23 Purchase Order Suggestion Maintenance 297340
DP_POP.sql 4.33 Purchase Order Processing 297340
DP_RDT_PICK_CONF.sql 4.51 RDT Pick Confirmation 297631
DP_WHS7872.sql 4.31 RDT Inbound Pallet Movements 297507
DP_WARE_LOC.sql 4.22 Free Location Generation – database package 297743
DP_WHS7872.sql 4.32 RDT Inbound Pallet Movements 297680
WHS0700.fmx 4.27 Warehouse Movements 297681
DATA_ORS_SQL_297338.sql 4.1 Data Script 297338
DATA_ORS_MASTER_DATA_297338.sql 4.1 Data Script 297338
DP_EDI_OUTBOUND.sql 4.60 EDI Outbound Receipt Confirmation 297817
TRG_WARE_LOCATION_ENTRIES_BIR.sql 4.7 Trigger to create master sequence 297817
AT_STOCK_297817.sql 4.1 Alter Table Script 297817
DATA_WAREHOUSE_RULES_CONTROL_297817.sql 4.1 Data Script 297817
DATA_WAREHOUSE_RULES_297817.sql 4.1 Data Script 297817
DP_PORTAL.sql 4.1 Portal Package 295940
DP_PICK_REQ.sql 4.18 Pick request processing 295940
WHS0150.fmx 4.89 Goods Receipt Confirmation 297943
DP_WHS7872.sql 4.33 RDT Inbound Pallet Movements 297943
DP_RDT_STKENQ.sql 4.9 RDT Stock Enquiry procesing 297511
XFM0020.fmx 4.40 XF Monitor 298111
DP_RDT_LOCENQ.sql 4.13 RDT Location Enquiry 297951
DATA_ORS_SQL_286464.sql 4.1 Data Script 286464
DATA_ORS_MASTER_DATA_286464.sql 4.1 Data Script 286464
CT_OD_AUDIT_286464.sql 4.2 Create Table Script 286464
AT_ORS_SQL_286464.sql 4.1 Alter Table Script 286464
AT_ORDER_HEADER_286464.sql 4.1 Alter Table Script 286464
AT_ORDER_DETAIL_286464.sql 4.1 Alter Table Script 286464
DATA_WAREHOUSE_RULES_CONTROL_286464.sql 4.1 Data Script 286464
DATA_WAREHOUSE_RULES_286464.sql 4.2 Data Script 286464
TRG_ORDER_HEADER_BIR.sql 4.1 Trigger 286464
TRG_ORDER_DETAIL_BIR.sql 4.2 Trigger 286464
SOS1110.fmx 4.61 Sales Order Entry 286464
WHR1900_B2B.rdf 4.6 Amend Report Layout 286464
DP_EDIGEN_OUT_REN_OUTBOUND.sql 4.2 REN outbound daily created order data extract 286464
TRG_ORDER_DETAIL_BIR.sql 4.2 Trigger 298208
DP_PORTAL.sql 4.2 Portal Package 295941
XFM0020_ERR.rdf 4.2 EDI Error Report 298174
DP_EDIGEN_PROD_VAL.sql 4.31 Inbound EDI Stock Upload Validation 297700
WHS2032.fmx 4.2 Stock Snapshot 298073
WHR1900_UCB.rdf 4.4 Despatch note for UCB 298326
DP_EDIGEN_OUT_REN_OUTBOUND.sql 4.3 REN outbound daily created order data extract 298221
WHR1900_UCB.rdf 4.5 Despatch note for UCB 298403
DP_PORTAL.sql 4.4 Portal Package 298476
WHS1945.fmx 4.62 Pack Header 298449
DP_WHC1945.sql 4.25 Pack List Print 298449
DP_WHS7872.sql 4.35 RDT Inbound Pallet Movements 298382
SOS3000.fmx 4.16 Confirmation by Order Number 298606
DP_PORTAL.sql 4.5 Portal Package 298641
DP_PLBC_CASE_LABELS.sql 4.19 Case Label print package 297080
FXMLOCKM.fmx 4.7 Lock Monitor 298976
WHS4100.fmx 4.3 Soap Definition Maintenance 296693
DP_METAPACK.sql 4.13 New Metapack API package 296693

New Registry Settings

Log Number Path & Name Setting Value Result
296697 RFPI E The picking Instructions are taken from TEXT_LINE_1 of order line message, if populated. Else, pre-existing functionality applies.
Any other value Pre-existing functionality applies.
286464 Owner / EODA (Anable Order Detail Audit Trail) Y A new Order detail audit file called OD_AUDIT is populated. This will record the date, stock and qty involved
N No change in functionality

New Screens

Log Number Suggested Menu Path Screen ID Description