WMS 810 ER014-002
EMERGENCY RELEASE - WMS 810
RELNOTE ER014-002
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| AT_CARRIERS_325028.sql | Alter Table Script | 4.1 | 325028 | EDI Process | 3 | Amendment to add Q8 format inbound and outbound EDI flows, along with a new Q8 format despatch note.
Covers inbound sales order and outbound GRMK, stock balances, notification of ohange of order status and outbound despatch message for Clarkes haulier. |
Paul Reed |
| AT_EDI_SALES_ORDER_DETAIL_325028.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| AT_EDI_SALES_ORDER_MASTER_325028.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| AT_ORDER_DETAIL_325028.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| AT_ORDER_HEADER_325028.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| AT_STK_STOCKIST_325028.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| DATA_EDI_MAPS_325028.sql | Data Script | 4.2 | " | " | " | " | " |
| DATA_ML_CAPTIONS_325028.sql | Data Script | 4.1 | " | " | " | " | " |
| DATA_PROGRAM_IMAGES_325028.sql | Data Script | 4.1 | " | " | " | " | " |
| DATA_WAREHOUSE_RULES_CONTROL_325028.sql | Data Script | 4.1 | " | " | " | " | " |
| DP_DESPATCH.sql | Despatch Processing | 4.67 | " | " | " | " | " |
| DP_EDIGEN_OUT_PDP_CONF.sql | Outbound order messages | 4.62 | " | " | " | " | " |
| DP_EDIGEN_OUT_RECEIPT_CONFIRM.sql | Outbound goods receipt confirmation | 4.23 | " | " | " | " | " |
| DP_EDIGEN_OUT_ST_BAL.sql | Outbound Stock Balances | 4.55 | " | " | " | " | " |
| DP_EDIGEN_OUT_TRANSPORT.sql | EDI Transport Interface | 4.14 | " | " | " | " | " |
| DP_EDIGEN_SALES_ORDER_LOAD.sql | EDI Sales Order Load | 4.154 | " | " | " | " | " |
| DP_EDIGEN_SALES_ORDER_VAL.sql | EDI Sales Order Validation | 4.143 | " | " | " | " | " |
| DATA_DYNAMIC_MESSAGES_325028.sql | Data Script | 4.1 | " | " | " | " | " |
| PFS1541.fmx | EDI SOP Validation Screen | 4.28 | " | " | " | " | " |
| STS1000.fmx | Owner Maintenance | 4.84 | " | " | " | " | " |
| WHR1900_Q8.rdf | Despatch Note | 4.1 | " | " | " | " | " |
| WHS0150.fmx | Goods Receipt Confirmation | 4.106 | " | " | " | " | " |
| WHS0172.fmx | One screen goods receipt | 4.23 | " | " | " | " | " |
| Registry/Rules Settings | ||
| Path & Name | Setting Value | Result |
| Owner | Y | Q8 enabled 'Y' In goods receipt cust PO field is mandatory |
| Owner | N/Null | Cust PO field not mandatory |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| STS4080.fmx | Owner Maintenance | 4.2 | 325813 | VAT Text on desp note | 3 | Add new 1 char VAT Text field to RNC EDI flow. Depending on VAT Text of order header print appropriate text message of RNC format despatch note. | Howard Allen |
| AT_OWNER_MESSAGE_325813.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| WHR1900_RNC.rdf | RNC format despatch note | 4.8 | " | " | " | " | " |
| DP_EDIGEN_SALES_ORDER_LOAD.sql | EDI Sales Order Load | 4.154 | " | " | " | " | " |
| AT_ORDER_HEADER_325813.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| AT_EDI_SALES_ORDER_MASTER_325813.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| DATA_EDI_MAPS_325813.sql | Database Script | 4.1 | " | " | " | " | " |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| DATA_DYNAMIC_MESSAGES_320949.sql | Data Script | 4.1 | 320949 | RM-9P7DGF | 3 | The database script will create a new owner-level rule called 'GWDV' ('GEN Weights and Dimensions Validation') that can be configured for the owner of a GRN to ensure that the stock codes that are being received have all of the required data before the GRN can be confirmed as received:
1 Gross Weight 2 Net Weight 3 Case Length 4 Case Width 5 Case Depth 6 Case Volume The database script will create 3 new dynamic messages that can be issued in the Goods Receipt Confirmation screen. When the owner-level rule 'GWDV' is set to 'Y' the user will be prompted to enter the missing stock data before entering the pallet details for the stock code being received. The user will not be able to confirm the GRN until all of the missing stock data has been entered. |
Ryan McLaren |
| DATA_WAREHOUSE_RULES_CONTROL_320949.sql | Data Script | 4.1 | " | " | " | " | " |
| WHS0150.fmx | Goods Receipt Confirmation Form | 4.105 | " | " | " | " | " |
| Registry/Rules Settings | ||
| Path & Name | Setting Value | Result |
| Owner Rule 'GWDV' | Y | The user will be prompted to enter the missing stock data before entering the pallet details for the stock code being recieved. The user will not be able to confirm the GRN until all of the missing stock data has ben entered |
| Owner Rule 'GWDV' | N or NUll or it does not exist | The user will not be prompted to enter the missing stock data |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| DP_EDIGEN_SALES_ORDER_LOAD.sql | EDI Sales Order Load | 4.152 | 326971 | GBB Format EDI | 3 | Created new GBB format based on RAB format with the addition of the customer code | Howard Allen |
| DATA_EDI_MAPS_326971.sql | Data Script | 4.1 | " | " | " | " | " |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| DP_EDIGEN_SALES_ORDER_VAL.sql | EDI Sales Order Validation | 4.141 | 326404 | - | 4 | Amend 'orphan record' validation to also remove order well and free type address records. | Emily Collins |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| DATA_WAREHOUSE_RULES_CONTROL_326907.sql | Data Script | 4.1 | 326907 | ST096 | 3 | Add OELN (Original EDI Line No) rule, which if set, will store original order line no for split order | Steve Talbott |
| DP_EDIGEN_SALES_ORDER_LOAD.sql | EDI Sales Order Load | 4.154 | " | " | " | " | " |
| DP_EDIGEN_OUT_PDP_CONF.sql | Database Package | 4.64 | " | " | " | " | " |
| Registry/Rules Settings | ||
| Path & Name | Setting Value | Result |
| Owner/OELN | Y | The SAP EDI line number is populated using the line position, line 1 - 1, line 2 - 2and so on |
| Original EDI Line Number | Not set or any other value | Pre-existing functionality applies |
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| AT_EDI_PDP_DETAIL_OUT_321459.sql | Alter Table Script | 4.1 | 321459 | HT-9PND4W | 3 | The 'AT' database scripts will alter the database tables to add the new items.
The 'DATA' database script will insert the new EDI mapping for the 'PACK' import file format. The 'CT' database script will create a new sequence number for the manual order allocation file. The database trigger will include the new manual order allocation assessment. The database packages will: 1. Copy the new items for a new owner. 2. Import the new 'PACK' file. 3. Create the new manual order allocation file. 4. Include the new 'PRICE' section in the manual and EDI order allocation files. 5. Include the new 'PACK' section in the pack complete, despatch confirmation and POD confirmation files. The 'Owner Maintenance' screen will display the new items for configuration in the 'Outbound Despatch Message' section in the 'EDI Outbound' tab page: 1. Price on OB Alloc Message 2. Pack on OB Desp Message 3. EDI Currency Code A new outbound EDI process will need to be setup: 1. Process Code: '{COMPANY_CODE}{WAREHOUSE_ID}{ORDER_OWNER}_GEN_MNALC'. 2. Process Description: 'Manual Order Allocation Message'. 3. Process Command: 'DESP1'. 4. Transfer Method: 'EDI'. 5. Transfer Type: 'EDI Transfer'. 6. Send/Receive 'Send'. 7. All Warehouses: 'No'. The 'Process Type' can be configured as required. The 'EDI File Separator' can be specified as required. The directory parameters and file patterns can be specified for the database as required. |
Hemal Tailor |
| AT_EDI_PDP_HEADER_OUT_321459.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| AT_STK_STOCKIST_321459.sql | Alter Table Script | 4.2 | " | " | " | " | " |
| CT_EDI_MA_SEQ_321459.sql | Create Table Script | 4.1 | " | " | " | " | " |
| DATA_EDI_MAPS_321459.sql | Data Script | 4.1 | " | " | " | " | " |
| TRG_ORDER_HEADER_AU.sql | Trigger | 4.4 | " | " | " | " | " |
| DP_COPY_OWNER.sql | Copy Owner Package | 4.13 | " | " | " | " | " |
| DP_EDIGEN_DHEG_UPD_LOAD.sql | Inbound EDI Package | 4.6 | " | " | " | " | " |
| DP_EDIGEN_DHEG_UPD_VAL.sql | Inbound EDI Package | 4.10 | " | " | " | " | " |
| DP_EDI_OUTBOUND.sql | Outbound EDI Package | 4.87 | " | " | " | " | " |
| DP_EDIGEN_OUT_PDP_CONF.sql | 4.63 | Outbound EDI Package | " | " | " | " | " |
| STS1000.fmx | Owner Maintenance Form | 4.85 | " | " | " | " | " |
