WMS 810 P014: Difference between revisions

From Calidus HUB
VisualWikitext
No edit summary
No edit summary
Line 573: Line 573:
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|AT_EDI_PRE_ADVICE_DETAIL_IN_325118.sql
|AT_EDI_PRE_ADVICE_DETAIL_IN_325118.sql
|4.1
|Database Script
|Database Script
|4.1
|325118
|325118
}}
}}
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|AT_EDI_PRE_ADVICE_HEADER_IN_325118.sql
|AT_EDI_PRE_ADVICE_HEADER_IN_325118.sql
|4.1
|Database Script
|Database Script
|4.1
|325118
|325118
}}
}}
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|AT_EDI_PRE_ADVICE_PALLET_IN_325118.sql
|AT_EDI_PRE_ADVICE_PALLET_IN_325118.sql
|Database Script
|4.1
|4.1
|No Change to functionality
|325118
|325118
}}
}}
Line 633: Line 633:
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|CT_V_ORS_EDI_PREADV_325118.sql
|CT_V_ORS_EDI_PREADV_325118.sql
|4.1
|Database Script
|Database Script
|4.1
|325118
|325118
}}
}}
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|CT_V_ORS_EDI_SALORD_325118.sql
|CT_V_ORS_EDI_SALORD_325118.sql
|4.1
|Database Script
|Database Script
|4.1
|325118
|325118
}}
}}
Line 687: Line 687:
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|DATA_ORS_MASTER_DATA_325118.sql
|DATA_ORS_MASTER_DATA_325118.sql
|4.1
|Database Script
|Database Script
|4.1
|325118
|325118
}}
}}
Line 699: Line 699:
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|DATA_ORS_SQL_325118.sql
|DATA_ORS_SQL_325118.sql
|4.1
|Database Script
|Database Script
|4.1
|325118
|325118
}}
}}
Line 723: Line 723:
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|DATA_WAREHOUSE_RULES_CONTROL_326392.sql
|DATA_WAREHOUSE_RULES_CONTROL_326392.sql
|4.1
|Database Script
|Database Script
|4.1
|326392
|326392
}}
}}
Line 753: Line 753:
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|DP_DESPATCH.sql
|DP_DESPATCH.sql
|4.66
|EDI Despatch File
|EDI Despatch File
|4.66
|326392
|326392
}}
}}
Line 831: Line 831:
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|DP_EDIGEN_SALES_ORDER_VAL.sql
|DP_EDIGEN_SALES_ORDER_VAL.sql
|4.139
|EDI Sales Order Validation
|EDI Sales Order Validation
|4.139
|325118
|325118
}}
}}
Line 940: Line 940:
|WHR1720_FWK.rdf
|WHR1720_FWK.rdf
|4.1
|4.1
|#N/A
|FWK format pick list
|325385
|325385
}}
}}
Line 957: Line 957:
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|WHR1900_WES.rdf
|WHR1900_WES.rdf
|4.50
|4.5
|Client specific despatch note
|Customer despatch note
|325417
|325417
}}
}}
{{PATCHModDeliveredTableRow
{{PATCHModDeliveredTableRow
|WHR1900_WES.rdf
|WHR1900_WES.rdf
|4.600
|4.6
|Client specific despatch note
|Client specific despatch note
|325646
|325646
Line 1,021: Line 1,021:
|325605
|325605
}}
}}
 
{{PATCHModDeliveredTableRow
|WHS1945.fmx
|4.78
|Pack Header
|325948
}}
{{PATCHModDeliveredTableRow
|WHS1946.fmx
|4.30
|Packing Detail
|325948
}}
{{PATCHModDeliveredTableRow
|AT_DYNAMIC_MESSAGES_326240.sql
|1.1
|Alter Table Script
|326240
}}
{{PATCHModDeliveredTableRow
|AT_EDI_ERROR_CONTROL_326240.sql
|1.1
|Alter Table Script
|326240
}}
{{PATCHModDeliveredTableRow
|WHSORA025.fmx
|4.47
|Pick List Reprint Kick-off
|326099
}}
{{PATCHModDeliveredTableRow
|DP_WMS_ALLOC.sql
|4.117
|Allocation Procedure
|326344
}}




Line 1,037: Line 1,072:
</tr>
</tr>
{{PATCHRegSettingsTableRow
{{PATCHRegSettingsTableRow
|LogNumber=The Supimix Log Number. Leave blank if multiple values
|325564
|Name=The Path and Name of the Registry Setting. Leave blank is multiple values
|Owner/DPAA
|Value=The setting value. If left blank, default to 'Any Other Vlaue'
|Y
|Result=The expected result of setting the Registry Setting as the Value specified
|Extra debug messages written
}}
{{PATCHRegSettingsTableRow
|325564
|Despatch Advanced Auditing
|Not set or any other value
|No Change
}}
{{PATCHRegSettingsTableRow
|324713
|Owner PCAA
|Y
|Populate records on new ORDER AUDIT record
}}
{{PATCHRegSettingsTableRow
|324713
|Pick Confirmation Advanced Auditing
|Not set or any other value
|No Change
}}
}}
{{PATCHRegSettingsTableRow
{{PATCHRegSettingsTableRow
|The Supimix Log Number. Leave blank if multiple values
|326392
|The Path and Name of the Registry Setting. Leave blank is multiple values
|Owner SDEO
|The setting value. If left blank, default to 'Any Other Vlaue'
|Y
|The expected result of setting the Registry Setting as the Value specified
|Email sent to ALLOC EMAIL ADDRESS of Stk Stockist rather than EMAIL ADDRESS of Free Type Address.
}}
}}
</table>
{{PATCHRegSettingsTableRow
|326392
|Send despatch email to Owner not Customer
|Not set or any other value
|No Change
}}
{{PATCHRegSettingsTableRow
|322138
|Owner/SDSP
|Y
|Separates Inbound and Outbound split order functionality
}}
{{PATCHRegSettingsTableRow
|322138
|Split Despatch Message
|N or any other value
|No Change to functionality
}}
{{PATCHRegSettingsTableRow
|322138
|Owner / SSOH
|Y
|Stock snapshot only produces records for stock codes that have on hand stock quantities
}}
{{PATCHRegSettingsTableRow
|322138
|Stock Snapshot On hand
|N or any other value
|No Change to functionality
}}
{{PATCHRegSettingsTableRow
|322138
|GeneralSettings / MaxDespMessages
|5000
|Will open a new outbound file every 5000 orders
}}
 
 
 


[[Category:{{#var:Client}} PATCH]]
[[Category:{{#var:Client}} PATCH]]

Revision as of 15:00, 27 April 2015




Aptean Logo.png







OBS Logistics Ltd

Release Notes

CALIDUS WMS

16th April 2015 - 1.0
Reference: Patch 14











































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
324759 ST087 4 D Fix bug with EDI sales order upload to ensure the sales order file is uploaded as expected. Atherstone EDI - Inbound Steve Talbott ER013-001 N   N  
324729 REJ format DESP msg 3 D Create new REJ format despatch note Rejuvenine u/a Howard Allen ER013-002 N   N  
324850 - 3 - Amendment to PIPP format despatch note print to display correct post code against the delivery address on EDI orders. Droitwich General - Reports PAUL REED ER013-003 N   N  
324823 - 4 D Add 'primary warehouse' field to the Customer ORS report. u/a General - Reports Zalkifl Ghanty ER013-004 N   N  
324947 - 3 - Releasing of existing programs. Fix issue with form so that an Oracle 4062 error is raised when the user presses 'Check Line'. Ely Stock - Hold/release PAUL REED ER013-005 N   N  
324852 ST088 4 D Allow full snapshot to generate when there are greater than 500,000 products on file. Atherstone EDI - Outbound Steve Talbott ER013-006 N   N  
324964 Rework of 324823 3 D Fix issue with ORS change, so report references post code not port code. u/a General - Reports Zalkifl Ghanty ER013-007 N   N  
325007 JD-056 4 D Populate <recipientPhone> and <recipientMobilePhone> in updateconsignment message. Atherstone General Josh Daffern ER013-008 N   N  
324937 EARS00035691600 3 - For interval jobs, if user presses force run, reset run time to old interval time. So if a job is set to run once a day, don't 'lose' today's run. u/a EDI - Outbound Lynda Spencer ER013-009 N   N  
324981 EARS00035692828 3 - Allow use of date selection in ORS (SC_COUNTS reports). u/a Warehs - reports Mark Chapnell ER013-010 N   N  
322138 ST-9QBKH6 3 D Create new BHS format XML format despatch message. This message contains a new system registry value 'MaxDespMessages', which will be set initially to 5000. Add new owner rule SSOH (Stock Snapshot On Hand), which will when set to Y, amend the generic stock snapshot, so it only displays stock records with on hand stock balances. Atherstone u/a Steven Talbott ER013-011 N   N  
325345 - 2 Amend 't_stock_from' from 20 zeros to 1, as stock code '00-10007' is less than 20 zeros but still greater than 1 zero. u/a u/a Howard Allen ER013-012 N   N  
325120 EARS00035696881 3 - Fix issue affecting site where user enters in a blank count value. Even if a pallet needs to be zero counted, the user will need to enter in a quantity. Also add validation to stop the user from entering in a negative value. u/a PI Functionality MARK CHAPNELL ER013-013 N   N  
325417 - 2 - Ensure report runs if multiple owners have OWNER MESSAGE 'DESP', 'DFT1', 'DFT2' setup. Change report to add phone no and email address to delivery address. Get email address from either free type address or customers address record depending on setup. u/a u/a Daniel Brown ER013-014 N   N  
325414 UCB Despatch Note 3 - Amendment to UCB format despatch note to remove text portion no longer required. u/a u/a Zalkifl Ghanty ER013-015 N   N  
325274 PIPPLS060 3 D Fix issue when one pallet is receipted in, and customer pallet id flag is set to generate - ensure reference is successfully generated. There is no issue if multiple pallets receipted or GRN is created by inter-warehouse transfer process, and customer pallet id will be pre-populated. u/a GRN - Confirm Lynda Spencer ER013-016 N   N  
325504 Program missing 3 - Found that DP_EDI_OUTBOUND.sql vrs 4.84 had been missed from 322138 / ST-9QBKH6 (Sterling for BHS Orders) Atherstone Operational Management Dave Potter ER013-017 N   N  
325564 Despatch File Fail 3 D Added a new owner level rule DPAA (Despatch Advanced Auditing) to type to work out reason why certain route/loads do not generate despatch messages. u/a EDI - Outbound Dave Potter ER013-018 N   N  
325646 - 2 - Amendment to WES format despatch note print to correct

for printing of delivery address details.

u/a Orders - Desp note Howard Allen ER013-019 N   N  
325754 INC9057002 3 - Ensure pallet labels can be generated for pallets with an on hand case quantity greater than 100,000 units u/a GRN - Putaway Mark Chapnell ER013-020 N   N  
325737 - 2 - Amend Westex format despatch note so address is correctly displayed. u/a u/a Howard Allen ER013-021 N   N  
325835 Add STTK to KMOVES 3 D Add stock take (STTK) transactions to the KMOVES report as part of Write On and Write Off calculations. u/a Stock - Balances Lynda Spencer ER013-022 N   N  
325118 EP-9U5FU5 3 D Define ORS parameters to create reports to list EDI errors for SALESIN sales order load and PREADV goods receipt load. Ireland u/a Emlyn Phipps ER013-023 N   N  
326392 Email changes 3 D Add new SDEO (Send Despatch Email to Owner not Customer) rule.

If set to Yes, then email sent to ALLOC EMAIL ADDRESS of Stk Stockist rather than EMAIL ADDRESS of Free Type Address.

If rule not set, or set to any other value, then email address continues to be taken from EMAIL ADDRESS of Free Type Address.

u/a Orders - Desp conf Howard Allen ER013-024 N   N  
324713 - 4 D Added new PCAA (pick conf advanced auditing) rule to write audit records to new order audit table. trying to identify cause of pallets leaving allocated stockon pallets after pick confirmation process complete. u/a Orders - Pick conf Dave Potter N   N  
324829 EARS00035688915 4 - Checks to change serial numbers consider owner of

stock not current owner.

u/a Stock - Maintenance Ryan McLaren - N   N  
325321 EARS00035703146 3 - Amendment to Lock monitor jobs running tab to prevent errors with field size on program name/parameters. u/a General - Enquiries PARBAT ODERDRA - N   N  
325277 EARS00035701985 4 - Amend PACK_EFUL ORS report to ensure despatched date is a selectable report, and data doesn't repeat when orders split over multiple product types and packing records. Note: To implement this change, any previous version of the PACK_EFUL report will need to be deleted or abandoned as only a new version of the ORS report change will pick up the changes. Atherstone General - Reports JOSH DAFFERN - N   N  
325512 Stock Take ORS rpts 3 - Improve performance of SC Counts detail ORS report. Ensuring report uses the correct indexes. u/a ORS Reports Dave Potter - N   N  
322712 Packing Changes 3 CR Add new packing level DHEG generation functionality. Add new pack validation and OWNER CARRIER table to control new functionality. If labels generated out of packing, stop labels being generated by picking. u/a u/a Howard Allen - N   N  
325605 INC8991999 4 - Amendments to screen to resolve release issues - stop the digital signature errors when releasing multiple lines. u/a Stock - Hold/release Zalkifl Ghanty - N   N  
325789 - 2 - Amendment to stock take update so customer pallet id on the STTK movement transaction is populated correctly from the pallet being adjusted. Ripon Stock - Stocktake Paul Reed - N   N  
326120 - 3 - Changed mass movement screen to allow for usernames of

more than 10 characters.

Ripon Stock - Movements Krzysztof Pruski - N   N  
325385 - 3 - Created a new version of WHR1700_FWP in WHR1720_FWK. Ensure that the delivery address country code is correctly printed. u/a Orders - Reports Mike Huxley - N   N  
325948 INC91761688 4 - Additional auditing added to the packing screens to help trace issue of key info not passing from header to detail screen. Atherstone Orders - Pack list Josh Daffern - N   N  
326240 INC9293368 3 - New indexes to improve performance in tracking tab of XF Monitor. Atherstone Performance Steve Talbott - N   N  
326099 INC9234949 4 - Do not run reprints for route/loads that are fully pick confirmed. Atherstone Orders - Pack list Steven Talbott - N   N  
326344 - 3 - Changes to audit log generation u/a Orders - Allocation Emily Collins - N   N  

Modules Delivered

Module Name Version No Description Log Number
AT_EDI_PRE_ADVICE_DETAIL_IN_325118.sql 4.1 Database Script 325118
AT_EDI_PRE_ADVICE_HEADER_IN_325118.sql 4.1 Database Script 325118
AT_EDI_PRE_ADVICE_PALLET_IN_325118.sql 4.1 No Change to functionality 325118
AT_ORDER_HEADER_322138.sql 4.1 Alter Table Script 322138
AT_ORDER_HEADER_AUDIT_322138.sql 4.1 Alter Table Script 322138
AT_PACK_HEADER_322712.sql 4.1 Alter Table Script 322712
AT_PACK_SETUP_322712.sql 4.1 Alter Table Script 322712
CT_ORDER_AUDIT_324713.sql 4.1 Create Table Script 324713
CT_ORDER_AUDIT_SEQ_324713.sql 4.1 Create Table Script 324713
CT_OWNER_CARRIERS_322712.sql 4.10 Create Table Script 322712
CT_V_ORS_EDI_PREADV_325118.sql 4.1 Database Script 325118
CT_V_ORS_EDI_SALORD_325118.sql 4.1 Database Script 325118
DATA_DYNAMIC_MESSAGES_325120.sql 4.1 Data Script 325120
DATA_EDI_MAPS_322712.sql 4.1 Data Script 322712
DATA_ML_CAPTIONS_322712.sql 4.1 Data Script 322712
DATA_ML_CAPTIONS_325385.sql 4.1 Data Script 325385
DATA_ORS_MASTER_DATA_324823.sql 4.1 Data Script 324823
DATA_ORS_MASTER_DATA_324964.sql 4.1 Data Script 324964
DATA_ORS_MASTER_DATA_324981.sql 1.1 Data Script 324981
DATA_ORS_MASTER_DATA_325118.sql 4.1 Database Script 325118
DATA_ORS_MASTER_DATA_325277.sql 4.1 Data Script 325277
DATA_ORS_SQL_325118.sql 4.1 Database Script 325118
DATA_ORS_SQL_325277.sql 4.1 Data Script 325277
DATA_ORS_SQL_325512.sql 4.1 Data Script 325512
DATA_ORS_USER_DETAILS_324981.sql 1.1 Data Script 324981
DATA_WAREHOUSE_RULES_CONTROL_326392.sql 4.1 Database Script 326392
DATA_WAREHOUSE_RULES_CONTROL_322138.sql 4.1 Data Script 322138
DATA_WAREHOUSE_RULES_CONTROL_324713.sql 4.1 Data Script 324713
DATA_WAREHOUSE_RULES_CONTROL_325564.sql 4.1 Data Script 325564
DP_DESPATCH.sql 4.65 Despatch Confirmation Package 1 322138
DP_DESPATCH.sql 4.66 EDI Despatch File 326392
DP_EDI_OUTBOUND.sql 4.84 EDI Outbound Receipt Confirmation 325504
DP_EDI_OUTBOUND.sql 4.85 EDI Outbound Receipt Confirmation 325564
DP_EDIGEN_DHEG_UPD_LOAD.sql 4.5 Inbound DHL EDI Message upload 322712
DP_EDIGEN_DHEG_UPD_VAL.sql 4.9 Inbound DHEG validation package 322712
DP_EDIGEN_OUT_PACK_LABEL.sql 4.13 Packing Label 322712
DP_EDIGEN_OUT_PDP_CONF.sql 4.58 Outbound EDI Generation 324729
DP_EDIGEN_OUT_PDP_CONF.sql 4.61 Outbound EDI Generation 322138
DP_EDIGEN_OUT_ST_BAL.sql 4.52 STK balance flat file package 324852
DP_EDIGEN_OUT_ST_BAL.sql 4.53 STK balance flat file package 322138
DP_EDIGEN_OUT_ST_BAL.sql 4.54 STK balance flat file package 325345
DP_EDIGEN_SALES_ORDER_LOAD.sql 4.149 Inbound EDI Sales Order Upload 324759
DP_EDIGEN_SALES_ORDER_VAL.sql 4.138 Order_Header update package 322138
DP_EDIGEN_SALES_ORDER_VAL.sql 4.139 EDI Sales Order Validation 325118
DP_KMOVES_STK_BAL.sql 4.14 K-Moves 'balances' package 325835
DP_METAPACK.sql 4.30 New Metapack API package 325007
DP_PICK_CONF_1.sql 4.42 Pick Confirmation Database Package 1 324713
DP_PICK_CONF_1.sql 4.43 Pick Confirmation Database Package 1 322712
DP_PICK_CONF_2.sql 4.16 Pick Confirmation Database Package 2 324713
DP_PLBC_CASE_LABELS.sql 4.23 Case Label print package 325754
DP_PROCESS_CONTROL_XFM.sql 4.31 Outbound process control 324937
DP_PROGRAM_AUDIT_TRAIL.sql 4.5 Program Audit Trail 324713
DP_RDT_PICK_CONF.sql 4.61 RDT Pick Confirmation 322712
DP_WARE_MOVEMENTS.sql 4.9 Database Package 326120
DP_WARE_STOCK_TAKE_UPDATE.sql 4.13 Stock Take Database Package 325789
DP_WHS2050.sql 4.12 Package for Hold/Release 324947
DP_WHS2050.sql 4.13 Package for Hold/Release 325605
ENQSOOC01B.fmx 4.4 SOP Enquiries 322138
FXMLOCKM.fmx 4.10 Lock Monitor 325321
STKSTOC01B.fmx 4.69 Stock Maintenance 324829
STS1000.fmx 4.83 Owner Maintenance 322712
WHR1720_FWK.rdf 4.1 FWK format pick list 325385
WHR1900_PIP.rdf 4.10 Pipp Specific Despatch Note 324850
WHR1900_UCB.rdf 4.11 Despatch note for UCB 325414
WHR1900_WES.rdf 4.5 Customer despatch note 325417
WHR1900_WES.rdf 4.6 Client specific despatch note 325646
WHR1900_WES.rdf 4.7 Client specific despatch note 325737
WHR1945_BHS.rdf 4.9 Client specific packing list 322138
WHS0150.fmx 4.103 Goods Receipt Confirmation 325274
WHS0230.fmx 4.20 Calender Maintenance 325835
WHS0544_PIP.fmx 4.15 Count Input 325120
WHS1944.fmx 4.18 Pack Params 322712
WHS1945.fmx 4.75 Pack Header 322712
WHS2050.fmx 4.31 Hold / Release Stock 324947
WHS2050.fmx 4.32 Hold / Release Stock 325605
WHS1945.fmx 4.78 Pack Header 325948
WHS1946.fmx 4.30 Packing Detail 325948
AT_DYNAMIC_MESSAGES_326240.sql 1.1 Alter Table Script 326240
AT_EDI_ERROR_CONTROL_326240.sql 1.1 Alter Table Script 326240
WHSORA025.fmx 4.47 Pick List Reprint Kick-off 326099
DP_WMS_ALLOC.sql 4.117 Allocation Procedure 326344

New Registry Settings

Log Number Path & Name Setting Value Result
325564 Owner/DPAA Y Extra debug messages written
325564 Despatch Advanced Auditing Not set or any other value No Change
324713 Owner PCAA Y Populate records on new ORDER AUDIT record
324713 Pick Confirmation Advanced Auditing Not set or any other value No Change
326392 Owner SDEO Y Email sent to ALLOC EMAIL ADDRESS of Stk Stockist rather than EMAIL ADDRESS of Free Type Address.
326392 Send despatch email to Owner not Customer Not set or any other value No Change
322138 Owner/SDSP Y Separates Inbound and Outbound split order functionality
322138 Split Despatch Message N or any other value No Change to functionality
322138 Owner / SSOH Y Stock snapshot only produces records for stock codes that have on hand stock quantities
322138 Stock Snapshot On hand N or any other value No Change to functionality
322138 GeneralSettings / MaxDespMessages 5000 Will open a new outbound file every 5000 orders
Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=WMS_810_P014&oldid=1897’