Order Management Layer

FILE MAINTENANCE & SETUP

Order Management Control Maintenance

The new maintenance screen controls the main functions of the Order Management System.

Field Name	Description	Type	Generic Values
Owner Code	Pre-populated field	n/a
Last Change User	Pre-populated field	n/a
Last Change Date	Pre-populated field	n/a
Automatically Create Anticipated Orders Allow manual Entry of Master Orders	When set to “Y”, the anticipated orders will be created automatically following a successful order upload. When set to “N”, the anticipated orders will not be created until the creation is requested by clicking the ‘Create Anticipated Orders’ button. The default value is “N”.	Drop down list	Yes/No
Use Default Warehouse Search if Postcode Not found	n/a	Drop down list	Yes/No
Split Order lines across Warehouses	n/a	Drop down list Yes/No
Default Order Priority	n/a	List of Values
Eaches on outbound EDI	n/a	Drop down list	Yes/No
Warehouse Assignment Method	n/a	Drop down list	Yes/No
Required % order Lines Fulfilled to use Primary Warehouse	% value	n/a
Volume per Despatch Pallet per MTQ	Free entry of numeric weight value	n/a
Volume Unit of Measure	List of Values Yes/No	n/a
Weight Unit of Measure	List of Values Yes/No	n/a

If these details have not been specifically setup then the Order Management software will operate with the pre-determined default value for each option.

Automatically Create Anticipated Orders Y/N.
When set to “Y”, the anticipated orders will be created automatically following a successful order upload. When set to “N”, the anticipated orders will not be created until the creation is requested by clicking the ‘Create Anticipated Orders’ button. The default value is “N”.

Allow Entry of Master Orders Y/N.
When set to “Y”, it will be possible to enter a master order directly in the ‘Master Orders’ control form. This option could be used if the EDI order files have failed to reach the server or to rapidly enter an emergency order. If “N” is selected then this functionality is not available. The default is “N”.

Use Default Warehouse Search Y/N.
When set to “Y”, if a customer exists with a postcode that cannot be found on the warehouse search table, then the default warehouse search sequence will be used. When set to “N”, if a postcode cannot be found on the warehouse search table then any orders for this post code will fail to create anticipated orders. the default value is “Y”

Split Order Lines Over Warehouses Y/N.
When set to “Y” and a single order line cannot be satisfied from a single warehouse then the system will split the order line over the warehouses, with available stock, aiming to deliver as much stock as possible. When set to “N”, the system will assign a single order line to a single warehouse. If this warehouse does not have sufficient stock then the order line will be short.

NB. This flag should be set to “N” as the SMS system cannot handle more than one despatch message per order line.

The default value is “N”.

Default Order Priority
This flag should be set to the default order priority. When anticipated orders are created, the order priority will be set to this default. The default value is “N”.

Eaches on Outbound EDI
This flag should be set to “Y” to run the new PIPP specific stock snapshot format and to ensure the despatch confirmation message includes the number of eaches. The default value is “N”.

Warehouse Assignment Method
This will be a drop down list field with two possible choices.
1. Use Customer’s Warehouse Assignment Method. When this value is set, the alternative warehouse allocation method will be enabled.
2. Normal Warehouse Assignment Method. When this value is set, the normal method of warehouse allocation will be used. This value will over-ride the customer’s setting.

Required % Order Lines Fulfilled to use Primary Warehouse
This value will only be required when the Warehouse Assignment method is set to ‘Use Customer’s Warehouse Assignment Method’. This will be the percentage value used, during the creation of the anticipated orders, when a customer is set to use the alternative warehouse assignment method, to decide if the primary warehouse should be used for the order. For example, if this value was set to 90% and 92% of the order lines could be fulfilled from the primary warehouse then the primary warehouse would be used for those order lines.

Volume Per Despatch Pallet MTQ
This value stores the volume of the despatch pallet. This value will be used in the OML to calculate the number of pallets required.

Volume Unit Of Measure
This value controls the Unit Of measure used in the OML to display the volume. The default value is “MTQ”.

Weight Unit Of Measure
This value controls the Unit Of measure used in the OML to display the weight. The default value is “KGM”.

Fast Customer Address Maintenance

This screen displays all the customer addresses with options to search by certain selection criteria.

Full Address Tab

The screen will allow the following details to be updated:-
• Customer type
• Name
• Address line 1
• Address line 2
• Town
• County
• Post code
• Vehicle type
• Route code
• Carrier code
• Despatch instructions
• Contact
• Phone number
• E-mail address

Customer Type
The customer type and description. A list of values available.

Vehicle Type
The default vehicle type for this customer. A list of values available.

Town
To display the approximately the first 12 characters of the customer’s town. Longer town names will be truncated. The “Full Address” tab should be used to edit the town.

Route
The customer’s default route code. A list of values will be available. Route codes are set up for each warehouse. The customer’s default route code will only apply to the anticipated orders assigned to the warehouse that the route code belongs to

Warehouse Assignment Method
The “Warehouse Assignment Method” will have the following values:-

Primary Preferred % - Use primary warehouse first if over a % order lines can be fulfilled by primary warehouse.

Primary Preferred Always - Always use primary warehouse first. Any remaining lines will be assigned a warehouse using the normal warehouse assignment rules.

Primary Only – Only ever use the primary warehouse for this customer. If any stock is unavailable in the primary warehouse then the order will be short.

Normal – Normal warehouse assignment rules. If the warehouse assignment is blank then this is the value that will be used.

Delivery Instructions

The “Delivery Instructions” tab can be used to enter picking text, which will be printed on the pick list and despatch text which will be printed underneath the “Special Instructions” heading on the PIPP format despatch note.

Warehouse Search List

The “Warehouse Search List” tab will show the first ten warehouses in the warehouse search list for each customer based on the customer type and post code.

Selection Criteria

The selection criteria tab will be used to restrict the number of customers found and to search for customers with specific details.

(See screen shot below)

• The first part of the Postcode, Name, Address Line 1, Address Line 2, Town, County, Route or Phone Number can be entered to find records that match the start of the entered criteria.

• To search for a vehicle type, the drop down list will be used to select a value from the list of valid vehicle types.

• The “Search Address for” field will allow text to be entered. The Name, Address Line 1, Address Line 2, Town and County fields will be searched for a match.

The “Search Contact for” field will allow text to be entered. The contact field will be searched for a match.

• This search will not be case sensitive. E.g. “Hospital” will match “HOSPITAL”. If a “+” is entered then the system will return the records where the selected value is blank. E.g. If a “Route Code” of ‘+’ was searched for, then the system would find all customers that do not have a default route code set up.

• When all the required selection criteria have been entered, the ‘Find Customers’ button should be clicked. This will find the customers using the entered selection criteria.

• A “Delivery Instructions” tab will be available to view / amend any customer specific despatch or pick instructions. A “Customer Type” tab will be available to view / amend the customer type.

Selection Criteria The selection criteria tab will be changed to include “Primary Warehouse” and “Warehouse Assignment Rule” to allow customers to be found by these two selection criteria. An extra option will be included to allow the customers to be sorted by the primary warehouse.

Customer Type Maintenance

The WMS will use Customer types to identify which delivery points are hospitals. Use customer type maintenance, WHS4010 to enter this information.

Customers Wizard

This is the standard Customer Wizard which will display 1 delivery address for each query. A new “Fast Customer Address Maintenance” screen, SOS005, will be provided as part of this development which will display the address details in a tabular form for faster maintenance. Please see section 5.2 for further details.

The Collection Point codes will be set up on Unison as customers. This will be done by the use of the customer wizard or from an EDI customer upload.

NB: Special attention should be taken to ensure the customer type and post code are correct as this information will be used to identify which warehouses can be used to satisfy the orders.

The delivery address will be set-up using the ‘Delivery Details’ tab as shown below: -

The customer type can be found on the ‘SOP Details’ tab, as shown below: -

The “Customer Restrictions” tab can used to enter the “Despatch Note Text”. These details will be printed underneath the “Special Instructions” heading on the PIPP format despatch note.

Stock Codes

All stock codes must be set up on Unison. This includes the Generic Skus these are the stock codes used on the inbound order files. The AKA Product code, found on the ‘Further Stock’ tab, will be set to the manufacturers product code. If the stock code is ordered using a generic SKU then second line of the stock description should be set to the Generic SKU.

The Gross Weight of a shipping unit should be entered as this value will be used to calculate the weight of each order.

NB. The stock codes should be created by the EDI stock upload with a status of “Inactive”. After the initial creation the stock code set up should be completed using this stock code maintenance form.

The following key fields should be manually entered.

• Description 2 – set to the Generic SKU

• Description 3 - set to a unit of measure description. This information will be printed on the pick list to assist the pickers.

• Unit Of Measure 1 – This will be set to CASE or INNER or whatever the shipping unit is.

• Unit Of Measure 2 – Will be set to the same value as Unit of measure 1.

• Unit of Measure 3 – Will be set to Pallet and the number of cases/inners per pallet will be entered.

• Stocking UOM – Will be set to the shipping unit. It is expected that this will be Unit of Measure 2.

• To Transit – Will be set to the number of Eaches per shipping unit.

• ABC Code – Will be set to an agreed value to identify stock codes store on the SMS system.

• Product Status – Will be set to Active when stock code set up is complete.

• Allocation Sequence – Will be set to control which stock should be allocated first. This field is also important for the Generic Sku. The allocation sequence of the Generic Sku will be used, in the Order management layer, to decide which NCP codes should be used to fulfil an order.

• AKA Product code - set to the manufacturers product code

It is possible that different stock codes, relating to the same Generic Sku, will be set up with a different number of Eaches per Shipping Unit (stored in the ‘To Transit’ field).

The “Physical Attributes” tab should be used to enter the dimensions of the Shipping Unit.

Substitute Products

If a stock code can be substituted by another stock code then these can be created using Substitute Product Maintenance, SOS1010. The stock code on the order file (generic sku) will be set up as the main product and the stock codes (NCP codes), used in the WMS, will be linked to it as the main product.

NB. The substitutes will need to be created for each warehouse.

The substitute products will be selected using the allocation rule of the generic sku. If this allocation rule returns more than 1 possible substitute product then the sequence number on this maintenance screen will be used to decide which product to use.

Carrier Codes

The carrier codes for Own fleet and DHL express will need to be created using Carrier Code Maintenance WHS0055.

The carrier codes are created at company level.

Route Codes

Route codes will need to be setup. A route code can be created for each vehicle. The transport department will then assign which vehicle will deliver each order. The route code / vehicle ID will then be stamped against the orders before the orders are sent to the warehouse for picking.

The route codes are created at warehouse level.

ML Captions – Vehicle Type

A new caption type, “Vehicle_Type” to store the list of valid vehicle types. The list of valid vehicle types will be maintainable by using the “ML Captions Update” screen on the system setup menu.

Owner Maintenance

Owner Maintenance (STS1000), “EDI Inbound” tab, includes a ‘Customer Type Upload” flag. This flag should be set to “Yes” to ensure the customer types are set following the creation of new customers.

System Parameters – Auto Allocation

This system parameters screen WHS0010 includes a parameter, ‘OML Auto Allocation’. This flag can be set to “Yes“ or “No” and will only be visible when the database has an OMS control record setup. The system parameters are setup at warehouse level which means each warehouse can have this flag set to the required value.

When the flag is set to “Yes” any orders that are sent from the Anticipated Order Screen to this warehouse will be automatically allocated.

System Parameters – Marshall Location

This system parameters screen WHS0010 on the “Default Locations” tab includes a parameter, “Default Marshalling Location”. This parameter can be set to a marshalling location. During the load planning process, a marshalling location must be entered. If this parameter is set then the marshalling location will default to this value when a marshalling location has not been entered.

OMS Maintenance - Warehouse Status Maintenance

A tab named “Warehouse Status” will be included on the “OMS Maintenance” screen. This screen will be used to enter which customer types can be serviced by which warehouses. An ‘Available Flag’ will be included to allow a warehouse to be set as unavailable for orders from a certain customer type.

This table will be checked when EDI orders are assessed to decide which warehouse to use to fulfil the orders.

OMS Maintenance - Warehouse Default Search Sequence

A tab named “Warehouse Default Search Sequence” will be included on the “OMS Maintenance” screen. This screen will be used to enter which customer types can be serviced by which warehouse(s)

This screen will be used to enter which customer types can be serviced by which warehouse(s) in which sequence. It is expected that postcodes will have their own warehouse search sequence. This table will serve as a backup when a delivery address exists where the delivery point / postcode settings cannot be found.

OMS Maintenance - Warehouse Search Sequence by Post Code

A tab named ‘Warehouse Search Sequence by Post Code’ will be included on the “OMS Maintenance” screen.

Generally, the first part of the postcode will be used but it will be possible to enter a whole postcode.

The system will use the postcode of the customer delivery address and then search for the warehouse search sequence for this postcode as follows :-

• Search for an exact postcode match.
  
• Search for first 4 characters of postcode
  
• Search for first 3 characters of postcode
  
• Search for first 2 characters of postcode
  
• Search for first character of postcode
  

The customer type is included as different customer types could have a different warehouse search sequences.

The postcodes will have a list of warehouses attached. This is the sequence in which warehouses will be checked when searching for available stock. Unavailable warehouses will be highlighted in red.

There will be options to sort this data by postcode then customer type or by customer type then post code. This will be controlled by clicking the buttons ‘Postcode’ or ‘Cust Type’ at the top of the page.

A postcode or part postcode can be found by clicking ‘Enter Query’ then selecting the postcode field and entering the start of the postcode. Upon ‘Execute Query’ the postcodes will be found. When a new warehouse search sequence is entered, an error will be given if the same warehouse id occurs more than once. The screen will include the following function buttons: -

Populate Post Codes Button. A new database package will be written to populate the postcodes and customer types on the warehouse search sequence table. This package will read through the customer table and link to the customers address to find the postcode. The system will use the first part of the postcode, the section before the space. If a space is not found in the postcode then the first 4 characters will be used. If the combination of customer type and start of postcode does not exist, then a record will be created with a blank warehouse. When the population is complete, the system will display the newly created postcodes.

Exchange Warehouse Button This button will be used to replace a particular warehouse with another warehouse. When this button is clicked, the user will be prompted to enter:

• The warehouse ID to be replaced
  
• The replacement warehouse ID.
  
• Confirm Exchange.
  

The system will read through all warehouse search sequences looking for the warehouse ID that is to be replaced. When the warehouse ID is found, it will be replaced by the new warehouse ID. If the new warehouse ID already exists as one of the warehouses in the search sequence then the old warehouse ID will be removed.

Find Warehouse Button

When this button is clicked, the user will be prompted to enter:

• The warehouse ID to search for.
  
• Confirm
  

The system will read through all warehouse search sequences looking for the entered warehouse ID. The system will then display any postcodes that include this warehouse as part of the search sequence.

OMS Maintenance - Default Vehicle / Carrier

A tab named “Default Vehicle / Carrier” will be included on the “OMS Maintenance” screen.

This tab will be used to maintain the default carrier code and vehicle type for each customer type. Only one carrier code and vehicle type can be entered for a single customer type.

When in the carrier code field, control L can be type to display the list of values. A list of valid vehicle types will be displayed when the field is clicked upon to allow one of the displayed vehicle types to be selected. Both the vehicle type and carrier code will be validated.

When the anticipated orders are created, the customer type will be used to find the correct carrier code for the order.

During the creation of the anticipated orders, the vehicle type will be set to the vehicle type set up against the customer’s delivery address. If a customer does not have their default vehicle type set then the vehicle type will be set to the vehicle type set up in this screen for the relevant customer type.

OMS Maintenance - Order Priority and Delivery Days

A tab named “Order Priority and Delivery Date” will be included on the “OMS Maintenance” screen.

This tab will be used to control the setting of the delivery date based upon the order priority. The order priority will be entered with the number of days till delivery. If the number of days till delivery is set to zero then the delivery date will be set to today’s date. If the number of days till delivery is set to 1 then the delivery date will be set to tomorrow’s date.

The setting of the delivery date will be done when the anticipated order is created. Any re-assessment will result in the re-setting of the delivery date. It will be possible to find orders in the anticipated orders screen and amend the order priority. This will result in the delivery date being re-set to the new delivery date based upon the entered order priority.

Order Priority

The order priority will be set to the value received on the EDI order file in the emergency order flag field. This is expected to be ‘Y’ or ‘N’. These two values will need setting up on ‘Order Priority Maintenance’ screen as shown below. Use Order Priority Maintenance, SOS1600.

OMS User Defaults

A new maintenance screen will be provided to control the main functions of the Order Management System at a user level. This screen will allow each user to be set up with their preferred settings and will allow the OML software to be configured to suit each user’s requirements. Unless stated otherwise, the user’s settings will override the OMS control settings.

Allow Entry of Master Orders Y/N. When set to “Y”, it will be possible to enter a master order directly in the ‘Master Orders’ control form. This option could be used if the EDI order files have failed to reach the server or to rapidly enter an emergency order. If “N” is selected then this functionality is not available for this user. NB. The “Allow Entry of Master Orders” must be set to Y on OMS control as well as against the user . If the “Allow Entry of Master Orders” must be set to N on OMS control then no user will be able to enter master orders regardless of the value of this flag.

Automatically Find Master Orders Y/N. When set to Y, instead of the master order screen starting up on the Selection Criteria tab, the user will be taken straight into the main master order tab.

Allow Cancellation of Master Orders Y/N. When set Y, the user will be able to click the cancel buttons in the master orders screen. If set to N, then the Cancellation buttons will be greyed out in the master order screen.

Automatically Find Anticipated Orders Y/N. When set to Y, instead of the anticipated order screen starting up on the Selection Criteria tab, the user will be taken straight into their preferred tab, as set up on the “Startup Anticipated Orders in Tab” option.

Automatically Select Anticipated Orders Y/N. The anticipated orders have a check box next to each order. This flag controls whether this check box is checked or left blank. When set to Y, every time the user triggers a query in the anticipated orders screen, the system will automatically check the orders. This option should be used when the user is setup to retrieve a small number of records for each find. NB, Queries are triggered following any possible change to the displayed orders. For example, if an order is re-assigned to a different warehouse, then the system will re-query the data as the re-assignment may have placed the order outside the “Selection Criteria”. The re-query of the data will reset the value of the check flag, to either blank or checked, depending upon the setting of this flag.

Allow Re-assessment of Anticipated Orders Y/N. This flag controls whether this user is allowed to click the “Re-assess ALL orders at Status New” in the anticipated order screen. If this flag is set to N then the button will be greyed out.

Startup Tab on Anticipated Orders This can be set to control which tab the form displays following every re-find of orders. Values are:-

• Orders
• Order Summary
• Planning
• Delivery Address
• Stock Details

For Transport planning users this can be set to “Planning” to run the form in “Planning” mode.

Anticipated Orders First Column This can be set to control which data value is displayed in the first column on the “Anticipated Orders” screen, Orders tab. A drop down list will be available which will allow one of the following data fields to be selected as the first column:-

• ESI reference
• Customer name
• WMS Order Number

The setting of the user’s, “Anticipated Orders First Column”, flag will control which value will be displayed in the first column of the anticipated orders screen.

Default Master Order Status If this value is set, then the Status on the selection criteria tab on the master order screen, will be automatically filled in to this value.

Default Warehouse If this value is set, then the warehouse on the selection criteria tab on the anticipated order screen will be automatically filled in to this value.

Default Order Priority If this value is set, then the priority on the selection criteria tab on the anticipated order screen will be automatically filled in to this value.

Default Customer Type If this value is set, then the customer type on the selection criteria tab on the anticipated order screen will be automatically filled in to this value.

Default Anticipated Order Status If this value is set, then the status on the selection criteria tab on the anticipated order screen will be automatically filled in to this value. Allowed values are:-

Default Transport Code If this value is set, then the transport code on the selection criteria tab on the anticipated order screen will be automatically filled in to this value.

Default Customer Code If this value is set, then the customer code on the selection criteria tab on the anticipated order screen will be automatically filled in to this value.

Default Route Code If this value is set, then the route code on the selection criteria tab on the anticipated order screen will be automatically filled in to this value.

Default Postcode If this value is set, then the postcode on the selection criteria tab on the anticipated order screen will be automatically filled in to this value. The start of a postcode can be entered e.g. CH to find all orders for postcodes beginning with CH.

Default Vehicle Type If this value is set, then the Vehicle Type on the selection criteria tab on the anticipated order screen will be automatically filled in to this value.

Radio Buttons – “Only this Value” A radio button titled “Only this value” will be included next to each of the default search values. If this button is clicked to the Yes position, then the user will only be able to find orders for their default setting. This will allow certain users a restricted view of the anticipated orders while other users can change the selection criteria to view all orders.

Volume Per Despatch Pallet MTQ This value stores the volume of the despatch pallet. This value will be used in the OML to calculate the number of pallets required. If this value is blank or zero then the OML will use the volume per despatch pallet set up on OMS Control.

Volume Unit Of Measure This value controls the Unit Of measure used in the OML to display the volume. If this value is blank then the OML will use the ‘Volume Unit of Measure’ set up on OMS Control.

Weight Unit Of Measure This value controls the Unit Of measure used in the OML to display the weight. If this value is blank then the OML will use the ‘Weight Unit of Measure’ set up on OMS Control.

Sort Anticipated Orders By The two sort fields control how the anticipated orders are sorted. The following sort options are available. NB. The sort field names are the actual names of the database columns rather than a column description.

• Warehouse_id – The warehouse assigned to the anticipated order.
• WMS_Order_num – The warehouse order number.
• Order_description – The ESI order reference.
• Status – The status of the anticipated order. (N – New, P – Planned or S – Sent to WMS).
• Cust_code – The customer code.
• Oh_Seq_no – The system generated sequence number for each anticipated order. This sort option will return the anticipated orders in the sequence in which they were generated.
• Order_priority – The priority of the order.
• Delivery_date – The delivery date is evaluated as the “Entered Delivery Date”, if a “Entered Delivery Date” has been entered against the order. If a “Entered delivery date” has not been entered the delivery date will be set to the “Default Delivery date”.
• Default Delivery Date – The default delivery date. This is the delivery date based on the order priority.
• Planned Delivery Date – The entered delivery date. This date can be entered against an anticipated order to override the “Default delivery date”.
• Transport Code – Also known as the carrier code.
• Create_date_stamp – The date the anticipated order was created.
• Create_user – the user id of the user who created the anticipated orders.
• Change_date_stamp – The date of the last change to the anticipated order.
• Change_user – The user id of the user who last changed the order.
• Weight – The weight of the order.
• Volume – The volume of the order. NB. The pallets are calculated using the volume. Sorting by this option is equivalent to sorting by the number of pallets.
• Route_code – The route code assigned to the order.
• Load_number – The load number assigned to the order.
• Drop_seq – The drop sequence that has been entered against each order.
• Marshall_loc – The marshal location assigned to the order.
• Load_date – The load date assigned to the order. The load date field includes the load time.
• Postcode – The postcode of the customer’s delivery address.
• Town – The town of the customer’s delivery address.

If the sort options are left blank, the orders will be sorted by the ESI order reference (order_description) then by the warehouse id.

ORDERS

Master Orders – Selection Criteria

If the user is not setup to automatically find master orders, then the master order screen will start on the selection criteria tab. If the user has a “Default Master Order Status” setup on “OMS Users” then this will be used to automatically populate the status field. If the user is setup, on “OMS users”, to only find orders with this status, then the status field will be grey and the user will not be able to find orders with any other status.

Following entry of the selection criteria, the “Find Orders” button can be clicked to display the master orders that match the criteria.

Status - Status can be set to -

• N – New Master Orders
• O – OK, Master orders that have been successfully converted into Anticipated Order.
• C- Cancelled Master Orders,
• 9 – Despatched.

Name - A partial customer name can be entered to find orders with a customer name containing the entered text.

Date - The date selection fields, +0 can be entered for today’s date, +1 for tomorrow’s date. The day number of the month can be entered and the system will default the current month and year.

Postcode - The first part of the postcode can be entered to find orders with postcodes matching the entered text.

Master Orders Screen – Main Screen

This screen will show the Master Orders. Master orders are created, either by EDI order upload or by entering directly using this form, with a status of “New”.

If the ‘Allow Entry of DH Orders’ flag is set to “Y” on the OMS Control screen and “Y” on the OMS Users screen, then this user will be able to enter master orders using this screen.

Create Anticipated Orders Button This button will validate the details and move the orders onto the next stage. Details cannot be changed in this screen for orders that have been moved onto the Anticipated Order stage. The details will remain to provide a history. Master Orders that have been successfully converted to anticipated orders will have a status of OK. Order that have been despatched will have a despatched status.

Cancel Order Button If the ‘Allow Cancellation of Master Orders’ flag is set to “Y” on the OMS Users screen then this user will be allowed to use the ‘Cancel Order’ button. If this flag is set to N for the user then the ‘Cancel Order’ button will be grey and this user will not be able to cancel master orders. Master orders can be cancelled, using this screen, while they only exist in the order management layer. Master orders that have been sent to the warehouse, must be cancelled using one of the Warehouse order cancellation screens. If the warehouse order is cancelled, the orders re-assessed to reset the anticipated order status to New, then it will be possible to cancel the master order.

To cancel a master order, the order to be cancelled will be clicked to make it the current record. The “Cancel Order” button will be clicked. A prompt will appear asking the user to confirm.

When the ‘Yes’ button is clicked, the order will set to status cancelled. To complete the cancellation, the changes must be saved by clicking the Save icon or pressing Control S. Upon save, any associated anticipated orders will be deleted. If the leave screen is clicked without a save then a prompt will appear, as shown below. If the No button is clicked then the cancellation will not be saved returning the order to it’s original status.

When a master order is cancelled, the system will write details of a zero despatched order to the despatch confirmation transient tables. The next EDI outbound despatch confirmation run will include the cancelled master orders showing zero quantity despatched.

Master Orders Screen – Stock Detail Screen

The ‘Stock Details’ tab on the Master Orders main screen can be clicked to display the stock details for the current order.

The stock details screen will have the following layout: -

Quantity fields will be displayed to the right of the screen.

• Ordered Eaches – The order quantity in eaches for this order line.
• Anticipated Eaches – The quantity expected in eaches to be delivered based on stock availability.
• Sent to WMS Eaches– The quantity in eaches of this order line that has been sent to the appropriate warehouse for picking / despatch.

NB. The quantity ordered will be in a number of eaches. The quantity anticipated / sent to WMS may be higher when the quantity ordered has been rounded up to allow delivery of a whole shipping unit of the product.

For example, if quantity ordered was 17 but product is stored in cases where each case contains 10 eaches. The order would need to despatch 2 cases of the product which equates to 20 eaches. This line would show, qty ordered 17, qty anticipated 20.

Inventory Enquiry Button This button will only be useful for order lines where the stock code used on the master order matches the stock code on the WMS. This button calls the standard WMS inventory enquiry.

Cancel Order Button If the ‘Allow Cancellation of Master Orders’ flag is set to “Y” on the OMS Users screen then this user will be allowed to use the ‘Cancel Line’ button. If this flag is set to N for the user then the ‘Cancel Line’ button will be grey and this user will not be able to cancel master order lines. Master order lines can be cancelled, using this screen, while they only exist in the order management layer. To cancel a master order line, the order line to be cancelled will be clicked to make it the current record. The “Cancel Line” button will be clicked. A prompt will appear for the user to confirm.

When the ‘Yes’ button is clicked, the order line will set to status cancelled. To complete the cancellation, the changes must be saved by clicking the Save icon or pressing Control S. Upon save, any associated anticipated orders will be deleted. If the leave screen is clicked without a save then a prompt will appear, as shown below. If the No button is clicked then the cancellation will not be saved and the order line will return to it’s original status.

When a master order line is cancelled, the system will write details of a zero despatched order line to the despatch confirmation transient tables. The next EDI outbound despatch confirmation run will include the cancelled master order lines showing zero quantity despatched.

Show History Button

The “Show History” button can be clicked to change the display to show the dates and usernames of the order creation and last change.

Normal Warehouse Assignment Rules

Each order will be assessed to decide which warehouse will be used to supply the stock.

The CPC code from the order file will be used to find the customer record on Unison. The customer record includes the customer type and delivery address. The customer type will be used to determine which orders are for hospitals. The full postcode and customer type will be used to find the warehouse search sequence. If a warehouse search sequence does not exist for the full postcode, then the first four characters of the postcode will be used to search for a warehouse search sequence. If a warehouse search sequence is not found for the first 4 characters of the post code then the system will check for the first three characters then first two characters. If a warehouse search sequence does not exist for the first part of the post code and the ‘Use Default Warehouse Search Sequence’ flag is set to “Y” on the OMS control screen then the default warehouse search sequence will be used for the customer type.

If a warehouse search sequence does not exist for the first part of the post code and the ‘Use Default Warehouse Search Sequence’ flag is set to “N” on the OMS control screen or a default warehouse search sequence has not been set up for the customer type then a warehouse search sequence cannot been found. The anticipated order will be created as an out of stock order for the non-existent warehouse ID of ‘+’. This warehouse ID will need to be corrected by either setting up a warehouse search sequence for the postcode followed by re-assigning the order or by specifying which warehouse should be used in the ‘Anticipated Orders Control’ screen.

Once the warehouse search sequence has been found, the system will check the status of each warehouse in the list. If any of the warehouses have their available flag set to “No” for the customer type then this warehouse will be ignored when searching for available stock.

When considering available stock, the system will check for substitute product codes in the same warehouse and include the substitute products in the free stock calculation.

The warehouse search sequence will be used to check the warehouses in the correct sequence.

The rules can be summarised as follows: -

• Can ALL the lines on order be satisfied from this warehouse.
• Can full individual order lines be satisfied from this warehouse.
• Can part of a line be satisfied from this warehouse.
• Any shortages will result in an order for the primary warehouse unless some of the stock was available in another warehouse. In this case, the order will be raised for the stock with available stock for the full order quantity.

NB. The setting of the ‘Split Order Lines’ control flag will control whether or not a single order line will be split across more than one warehouse.

For example, the warehouse search sequence could be Coventry, Manchester then Leeds. 1. Can entire order be satisfied from Coventry? If yes, then order will be placed in the Coventry warehouse. If no then:
a. Can entire order be satisfied from Manchester? If yes, then order will be placed in the Manchester warehouse. If no then:
i. Can entire order be satisfied from Leeds. . If yes, then order will be placed in the Leeds warehouse. If no then:
2. Can any individual order lines be satisfied from Coventry. If Yes then an order will be placed in the Coventry warehouse for these order lines only.
3. Can any individual order lines be satisfied from Manchester? If yes, then an order will be placed in the Manchester warehouse for these order lines only.
4. Can any individual order lines be satisfied from Leeds? If yes, then an order will be placed in the Leeds warehouse for these order lines only.
5. Can any part order lines be satisfied from Coventry. If yes, then an order will be placed in the Coventry warehouse for the available stock only.
6. Can any part order lines be satisfied from Manchester. If yes, then an order will be placed in the Manchester warehouse for the available stock only.
7. Can any part order lines be satisfied from Leeds. If yes, then an order will be placed in the Leeds warehouse for the available stock only.
8. Any completely short lines will then generate an order, for the short quantity, for the primary warehouse, Coventry.
9. Any lines that have a partial shortage will increase the quantity on the order line to the quantity ordered rather than the quantity available.

NB. The age of the stock will not be considered when selecting the warehouse.

The OMS control table will first be checked. If the “Warehouse Assignment Method” is set to Normal then the existing method of assigning a warehouse will be utilised. If this flag is set to “Use Customer’s Warehouse Assignment Method” then the customer’s “Warehouse Assignment Method” will be checked. If the customer’s value is set to “Normal” then the existing method of assigning a warehouse will be utilised. If the customer’s value is set to “Primary Only”, then the order will be assigned to the primary warehouse. If the primary warehouse does not have sufficient stock then the order will be short. If the customer’s value is set to “Primary Preferred Always”, then the system will assign the orders lines that can be fully fulfilled to the primary warehouse, any remaining order lines will be assigned using the normal warehouse assignment rules.

If the customer’s value is set to “Primary Preferred %”, then the system will calculate the percentage of the order lines that can be fulfilled from the primary warehouse. If this calculated percentage is lower than the “Required % Order Lines Fulfilled to use Primary Warehouse”, as setup on OMS Control, then the existing method of assigning a warehouse will be utilised. If the calculated percentage is higher or equal, then the lines that can be fulfilled by the primary warehouse will be assigned to the primary warehouse. Any remaining order lines will be assigned using the normal warehouse assignment rules

The normal warehouse assignment process will need to be changed to ignore any lines already assigned by the new warehouse assignment method.

A new flag will be added to the anticipated order header table to store the warehouse assignment method used. This flag will be set when the anticipated order is created and will be used in the “Anticipated Orders” screen to enable orders created using the alternative warehouse assignment rule to be identified and highlighted in pale green.

Stock Code Assignment Rules

Each stock code on the master order will be first checked in the chosen warehouse to find if there is available stock. If there is insufficient stock available for the ordered stock code (Generic SKU) then the substitute products will be considered.

A Generic Sku can have many NPC codes linked to it, as setup on substitute product maintenance. The system will decide which of these stock codes to use for the order.

Each stock code has an ‘Allocation Sequence’ which controls the sequence the stock is allocated. The stock can be allocated by the following options:-

• Age – The manufacture date of the product will be used.
  
• Sell By Date
  
• Customer Batch – The customer rotation number will be used.
  
• Receipt Date
  
• System Batch - The system rotation number will be used.
  

It is expected that all the NPC codes, for a single generic sku, will have similar characteristics. However, it is possible to set the allocation sequence for each NPC code differently. If a generic sku has NPCs that are set up with different allocation sequences then it will not be possible to compare them. For this reason, the allocation sequence of the Generic Sku will be used rather than the allocation sequence of the NPC when deciding how to select for the most appropriate NPC code.

The Generic Sku will be used to find the substitute products (NPC codes) and the system will then decide which of the NPCs to use.

Depending upon the allocation sequence of the Generic Sku, the system will select the NPC with the oldest sell by date / manufacture date / customer rotation / receipt date / rotation number. The system will then take the available stock for this NPC. If more stock is required, then the system will repeat the process to find the next NPC with available stock and continue until the order line has sufficient stock or until there is no more stock available.

NB. This method does not achieve strict FIFO/FEFO. However, it has the advantage of minimising the number of NPC codes used to satisfy an order line. When the order is sent to the warehouse for allocating, the warehouse allocation process will use the allocation sequence of the NPC code and the owner’s allocation rules, to decide which rotations to allocate.

The warehouse stock codes (NPC codes) may be set up with a different number of eaches in a shipping unit. This means the quantity ordered may change depending upon which warehouse stock code is selected for the order line.

For example, if the quantity ordered was 17:-
Product 1 is stored in cases where each case contains 10 eaches. The order would need to despatch 2 cases of the product which equates to 20 eaches. This line would show, qty ordered 17, qty anticipated 20.
Product 2 is stored in cases where each case contains 12 eaches. The order would need to despatch 2 cases of the product which equates to 24 eaches. This line would show, qty ordered 17, qty anticipated 24.

Create Anticipated Unison Orders

A new database package that will be written to convert the master orders into anticipated orders. This process will contain the agreed rules for warehouse and stock code selection.

Based upon these rules, the system will transfer the contents of the master order files into a new set of tables. The most appropriate warehouse ID will be assigned and if required the master order will be split into several anticipated orders. The end result will be a set of Anticipated orders.

The route code of the anticipated order will be automatically populated. Route codes are created at warehouse level. Each delivery address can have a route code assigned to it.

When an anticipated order is created, the system will find the route code setup for the customer’s delivery address. The system will then check to find if this route code is a valid route code for the warehouse that the order is assigned to. If the route code is valid then it will be assigned to the order. If the route code is not valid for the warehouse assigned to the order then the anticipated order’s route code cannot be set to the customer’s default and will remain blank. In this case, the route code will be set when the anticipated order is plan confirmed.

The Master Orders table will be updated to show what quantity is anticipated to be delivered based on the stock availability across the warehouses.

This process will be written to allow it to be re-run against the same set of Anticipated Orders. Re-running the process can be done to reconsider to stock position in each warehouse. If a particular warehouse is set as unavailable then this process will need to be re-run to re-assign the orders to available warehouses.

Anticipated Orders - Selection Criteria

If the user is not setup to automatically find anticipated orders, then the anticipated order screen will start on the selection criteria tab. If the user has a default values setup on “OMS Users” then these will be used to automatically populate the matching fields. If the user is setup, on “OMS users”, to only find orders with a certain default value, then these fields will be grey and the user will not be able re-enter these values on this form.

Following entry of the selection criteria, the “Find Orders” button can be clicked to display the anticipated orders that match the criteria.

The Volume and Weight fields will be populated by the values set up for the user. If the user does not have these details set then the values set up on the “OMS Control” screen will be used. These default values can be overridden.

The delivery date field can be used to search for a specific delivery date. The delivery date is defined as the “Entered Delivery Date”, if a date has been entered or the “Default Delivery Date”, if the “Entered Delivery Date” is blank. It will be possible to enter ‘+1” to search for orders due for delivery tomorrow. “+0” for today’s date. “-1” for yesterday’s date. The “Clear All Selection Criteria” button can be used to blank out the entered details.

When the “Find Orders button” is pressed, orders matching the selection criteria will be found and displayed. If no selection criteria are entered then all the orders will be displayed.

It will be possible to enter the first part of the postcode rather than the whole postcode

When searching for a ‘Line Ref’ (DH order number), the system will display the order header containing a line for the entered ‘Line Ref’. It will be possible to then click the ‘Stock Details’ tab. ALL lines for the order header will be displayed. The entered ‘Line Ref’ will be highlighted in green to distinguish it from the other order lines, as shown below.

Similarly, when searching for a stock code, the system will display all order headers containing a line for the entered stock code. It will be possible to then click the ‘Stock Details’ tab. ALL lines for the order header will be displayed. The entered stock code will be highlighted in green to distinguish it from the other order lines. The system will check both the Generic Sku and the NPC code when searching by stock code.

Anticipated Orders – Orders

This screen (OMS7000) will show the anticipated orders. If the user is set up with the “Automatically Select Anticipated Orders” flag set to Y then the check box, at the start of the line, will be automatically checked.

The vertical scrollbar on the left of the screen can be used to scroll up and down the orders.

A single master order (ESI reference) may contain several order lines each with a different product code. If stock levels were low across the warehouses and stock needed to be despatched from 5 warehouses then the ESI order reference would be shown as 5 lines on this screen, a line for each warehouse.

The order priority can be changed which may reset the default delivery date. The “OMS Maintenance” screen, “Order Priority and Delivery Days” tab is used to set the number of delivery days for theOrder Priority.

The “Entered Delivery Date” field can be used to override the default delivery date. If a date is entered in this field then this wil be the delivery date used when the warehouse order is created.

Anticipated Order Colour

The anticipated orders new ‘Warehouse Assignment Method” flag will be checked and used to determine the colour setting for the anticipated order.

The new colour system hierarchy will be:-

• Red for short orders.
• Amber for fulfilled orders from a warehouse other than the primary warehouse.
• Light Green for an order from the primary warehouse using the new warehouse assignment method.
• Green for a fulfilled order from the primary warehouse using the normal warehouse assignment rules.
• White for an order that has been sent to the warehouse.

When a short order is the current order, the “Stock Details” tab can be clicked to view all the order lines. The short order line will be highlighted in red. To query why an order shows as amber, the “Delivery Details” tab can be clicked and the scrollbar used to move to the far right of the delivery details. The “Display Full Current Warehouse Search List for this Postcode and Customer Type” button can be clicked to view the default warehouse search sequence. The warehouse assigned to the order will be highlighted in amber.

NB. An order that has used the new warehouse assignment method will show the order from the primary warehouse as light green. The remaining lines may have been assigned to a non-primary warehouse. These remaining lines will show as amber.

Anticipated Order Status

New – Newly created anticipated orders will have a status of New. The orders can be assigned to a new warehouse while they are at this status. If the ‘Re-assign ALL Orders’ button is clicked then all anticipated orders with a status of New will be cleared down and recreated.

Planned – The planned status will only allow limited changes. Order must be at this status before they can be sent to the warehouse.

Sent To WMS – Orders that have been sent to the warehouse for allocation, picking and despatch.

NB. The anticipated order status does not get updated following each change of warehouse order status. The screen links to the warehouse order to find the status to display the warehouse order status. For this reason, the displayed status may be 6 – Pick confirmed but it is not possible to search for orders at status 6 as the anticipated order status is S – Sent to warehouse.

Buttons

Uncheck / Check All This button can be used to Check or uncheck all the orders.

ESI Reference / Address Name / WMS Order No This button can be used to toggle the display between the ESI order reference, the delivery address name and the WMS order number. If the order has not yet been sent to the warehouse then the WMS Order No will be shown as blank.

Process Selected It is possible to select certain orders using the check box on the left hand side of the screen. The ‘Process Selected’ button opens a new window to allow an action to be specified and performed on the selected orders.

Orders Enquiry. This button will be enabled for orders that have been sent to the warehouse. It will call the standard warehouse order enquiry.

Check for Cancelled WMS Orders This button will call the database package that reads through the WMS Orders looking for any orders that have been cancelled. When this button is clicked, the system will check the warehouse orders for any cancelled order lines. When orders are cancelled using the “Manual Order Cancellation” screen, the orders may have been allocated or pick confirmed. This process will include ALL cancelled orders. NB. Despatch confirmed orders cannot be cancelled.

A single order line for a generic sku may result in several warehouse orders lines when more than 1 NPC is required to satisfy the order line. A warehouse order line will only be considered cancelled when ALL the NPC warehouse order lines relating to a DH order line, are cancelled.

NB. A short pick or a pick confirm to zero will not be classed as a cancelled order. Orders that are short picked or pick confirmed to zero will be despatch confirmed. The EDI despatch confirmation message will go back to DH showing the quantity despatched.

This “Check for Cancelled WMS Orders” process will also be run when the “Re-assess all orders at status new” button is clicked.

Reassess ALL Orders at Status New This button will call the database package that creates the anticipated orders. All anticipated orders at status new will be deleted and then recreated using the current stock levels and warehouse availability when deciding which warehouse and NPC code to use to satisfy the order. As anticipated orders are deleted and then re-created, if changes have been made such as entering delivery dates or changing order priority, then these changes will be lost.

The “Reassess ALL Orders at Status New” button will give a warning message prior to running this process. The user will be asked:

“Warning. This process will recreate orders at status “New”. If changes have been made to over-ride the default settings then these changes will be lost. Do you want to continue?”

If the No button is clicked then the process will not be run.

Send Checked Orders to Warehouse. This will run the database package, which converts anticipated orders to committed warehouse orders. Orders must show a status of ‘New; or ‘Planned’ to be sent to the warehouse for allocation. This button should only be used to send indivual orders to the warehouse. The Planning tab will be used to send a whole planned load of orders to the warehouse. If an order is at a planned status with a route and load number assigned then it will be removed from the load prior to sending it to the warehouse.

Anticipated Orders – Process Selected

The Process Selected button will display a new screen where the user can select what they wish to do with the selected orders.

Orders that have been sent to the warehouse will NOT be updated by this process.

Warehouse Change or Re-select

The Change Warehouse options are:-

• Over-ride Default Warehouse Search – If this option is chosen, the user can specify a new warehouse search sequence. When the confirm button is clicked the new warehouse search sequence will be used to recreate the anticipated orders.

• Default – Use Postcode to assign warehouse. This option can be used to re-assess the selected orders and assign the most appropriate warehouse based on the current settings and stock levels. This option can be used when a warehouse status has changed or stock levels have changed.

• Primary Warehouse Only – This option can be used to only select the primary warehouse when creating anticipated orders.

The selected orders must be at status “New” for this change to be allowed. Orders at status Planned will be ignored.

Change Route / Delivery Date

Update Route / Delivery Date This option will only process orders at a status of New. Orders at status planned or sent to warehouse will be ignored.

If this option is selected then the user will be prompted to enter a route code and delivery date. When the confirm button is clicked, the selected orders will be updated with the entered route code and delivery date, providing the selected order has a status of New.

Reset Planned Orders to Status New

Reset Selected Planned Orders to Status New This option can be used to reset the selected planned orders to a status of New. This option can only be used to change orders with a status of Planned to Status New. Orders sent to the warehouse will be ignored.

It is possible to enter a delivery date. The selected orders will have this new delivery date entered against them when the orders change to a status of New.

The following fields will be re-set as the order is no longer considered planned.

• Marshalling Location – set to blank
  
• Load Date – set to blank
  
• Load Time – set to blank
  
• Load Number – set to blank
  
• Drop Sequence – set to blank
  
• Default Vehicle type – set to the default vehicle type for the customer type
  
• Entered vehicle type – set to blank
  
• The postcode stamped against the anticipated order will be reset to the customer’s current postcode.
  
• The town stamped against the anticipated order will be reset to the customer’s current town.
• Route code - The system will find the route code setup for the customer’s delivery address. The system will then check if this route code is a valid route for the warehouse that the order is assigned to. If the route is valid then this route code will be assigned to the order. If the route is not a valid route code for the warehouse assigned to the order then the route code cannot be set to the customer’s default resulting in a blank route code.

(NB. Once orders have been sent to the warehouse there is a new Order Cancellation Screen to cancel the selected orders and deallocate stock – Change request NH-7X9CN7).

There is no option to cancel an anticipated order. Instead, the master order can be cancelled which will delete the associated anticipated order.

Anticipated Orders – Delivery Address

This screen (OMS7000) will show the anticipated orders when the delivery address tab is clicked, the address lines will be shown on the right side of the screen.

The scrollbar at the bottom of the screen can be used to display the warehouse search sequence for the postcode.

This will show the current warehouse search sequence and the Postcode part used.

NB. Any warehouse set as unavailable will be excluded from this display, as it will not be considered when re-assigning the orders.

Anticipated Orders – Summary

This screen (OMS7000) will show the anticipated orders when the “Order Summary” tab is clicked, the order summary details will be displayed for the current order. For orders that have been sent to the warehouse, the ‘Order Enquiry’ button can be clicked to call the standard order enquiry. This screen will give further details e.g. dates allocated, picked etc.

piccy

Anticipated Orders – Stock Details

This screen (OMS7000) will show the anticipated warehouse orders when the “Stock Details” tab is clicked, the stock lines for the current order will be displayed. If a line on the order is short, this will be highlighted in red, as shown below.

The stock code button can be clicked to change the display from the NPC code to the Generic Sku. The current quantity will show the quantity expected to be delivered. For orders that have been sent to the warehouse and allocated, the current quantity will be set depending upon the order status. For allocated orders, it will be the allocated quantity, for pick confirmed orders, it will be the pick confirmed quantity and for despatched orders it will be the despatched quantity. For orders at the anticipated status or committed status, this quantity will be the anticipated quantity.

piccy

The ‘Inventory Enquiry’ button can be clicked to display the standard inventory enquiry for the current NPC code.

The scroll bar at the bottom of the screen can be used to display further details. All the quantity fields will be displayed as the number of eaches.

piccy

A shipping unit description will be displayed to show how the number of eaches has been converted into the quantity anticipated. The calculated required number of eaches will be zero if there is no available stock.

piccy

Anticipated Orders - Planning

This ‘Planning” tab will be used to group orders into loads. To plan orders, the selection criteria tab should used to refine the number of orders. The following minimum details should be entered.

• Status – Set to “New” or “New or Planned” as only orders at this status can be planned,
• Delivery Date – Orders grouped into a load must have the same delivery date.
• Warehouse – Orders grouped into a load must be assigned to the same warehouse.

The sort options, on the “Selection Criteria” tab, can be used to sort orders by Volume or weight.

The town has a maximum size of 30 characters. Due to limited space on this screen, the full 30 characters will NOT be displayed. The maximum number of characters that can fit within the allocated area will be displayed. This will be approximately 12 characters if the town is in uppercase or approximately 15 characters if the town is lowercase. If the town is blank then the county will be displayed instead.

The system has the ability to display the weight and volume in a specified unit of measure. The preferred units of measure and the volume per pallet are setup on “OMS Control”. Each user can then override this setting by using “OMS Users” to set their preferred units of measure againt the username. These settings can also be overridden by specifying the units of measure and volume per pallet on the “Selection Criteria” tab.

The Weight and Volume of each order will be calculated and displayed in the selected Unit of measure. The weight will be calculated as the number of eaches divided by the transit factor (to give the number of shipping units) multiplied by the weight of a shipping unit as setup on stock maintenance. The volume will be calculated as the number of eaches divided by the transit factor (to give the number of shipping units) multiplied by the volume of a shipping unit as setup on stock maintenance. The despatch pallets will be calculated as the volume divided by the Volume per pallet, as displayed on the selection criteria tab.

The “Check Box” flag will be used to Select / Deselect orders for inclusion / exclusion from a load. The totals, of the selected orders, will be displayed at the bottom of the screen.

piccy

The “Find Load” field at the top of the screen can be used to find a load number. This option will ignore the search settings on the “Selection Criteria” tab and find ALL the orders assigned to the load.

NB. If a load is created but not sent to the warehouse then it will exist in the Order Management Layer at status Planned. To process this load, the “Find Load” field MUST be used to find the Load Number. This is to ensure ALL orders assigned to the load are selected, prior to using the “Plan Confirm” button.

The drop sequences should be entered and saved prior to sending the load to the warehouse as the drop sequence will sequence the assignment of the system order numbers.

The “Plan Confirm” button can be clicked to proceed. At this point, the selected orders will be validated to check they are at the correct status, for the same warehouse and for the same delivery date. An error message will be given if the validation fails.

Providing the orders pass the validation, the “Load Summary” details will be displayed.

piccy

The system will check the selected orders and find the first non blank route code for the checked orders. This route code will be set as the default route code and displayed. The default can be accepted by returning over the field or a different route code can be entered.

When the “Confirm Load” button is clicked, the system will check all the orders selected for inclusion on the load. If any of the orders have a route code that does not match the entered / default route code then a warning message will be given.

piccy

If the user clicks “yes”, then the entered / default route code will be set as the route code for all the selected orders.

The marshalling location will default to the default marshalling location for the warehouse, as set up on system parameters.

The load date and load time will be entered. Standard date processing will be available for the date field.

The “Exit” button can be used to return to the previous screen. The “Cancel and Uncheck” button can be used to reset the details to re-start planning. The “Confirm Load” button can be used to proceed to the next stage. This will stamp the route code, marshalling location, load date and time against the selected orders. The load number will be generated and displayed. The orders will change to status Planned.

The text on the “Confirm Load” button will be changed to “Send to Warehouse”.

piccy

The “Exit” button can be used to return to the planning screen. The “Cancel and Uncheck” button can be used to reset the details to re-start planning. This will blank out the route, load number, load date, load time, marshalling location and drop sequence from the orders and will set the status of these orders back to New.

The “Send to Warehouse” button can be used to send the load to the warehouse. This will move the orders onto status Committed.

The drop sequence will be used to reverse sort the orders prior to the generation of the system warehouse order numbers. The first warehouse order number will be for the last drop and the last warehouse order number will be for the first drop. When the warehouse produces the pick list for the route / load, the pick list is sorted by the warehouse order number. This means the order for the last drop will be printed at the start of the pick list as this is the order that should be loaded onto the delivery vehicle first.

piccy

Adding Orders to an Existing Load

A field “Add to Existing Load” will be included on the planning tab. Orders at status New can be added to an existing load by first using the check box to select the required orders. On the Planning tab, the “Add to Existing Load” field will be used to enter the load number.

piccy

A list of values will be available which will show the current planned loads in the OML. It will not be possible to add an order to a load that has already been sent to the warehouse.

piccy

As return is pressed in the “Add to Existing Load” field, the system will validate the selected orders to ensure they are for the same warehouse and delivery date as the orders currently assigned to the existing load. Providing the orders pass validation, the system will populate the route, marshalling location, load date, load time and load number of the selected orders. The system will then automatically display the new load, showing ALL the orders for the load with the new load totals at the bottom of the screen.

piccy

Send Planned Orders to Warehouse

A new database package will be written that will convert planned anticipated orders into warehouse orders. The new OML auto allocation warehouse flag will be found for the warehouse. If this flag is set to “Yes” then following the sending of each load / order to the warehouse, the allocation package will be called to automatically allocate the orders. If this flag is set to “No” then the package will create committed warehouse orders and commit the stock to the orders. The committed orders can then be allocated and processed through the WMS system.

This package will be run either when the ‘Send Selected Orders To Warehouse” button is clicked or when the user completes the Planning of a load and clicks the “Send to Warehouse” button on the “Load Summary” screen. When a planned load is sent to the warehouse, this package will also create the Route / load.

The ‘Send Selected Orders To Warehouse” button will allow orders at status New or Planned to be sent to the warehouse for picking. If this option is used to send an order that is at status planned and included on a load, then the order will be removed from the load before being sent to the warehouse as an individual order.

Orders will be created for each warehouse with the following details set: -

• Status set to 1, committed
• Order Priority
• Route code to the route entered against the anticipated order.
• Booking date set to the date the order was created as an anticipated order.
• Delivery date set to the “Entered Delivery Date”, if set or the default delivery date if a “Entered Delivery Date” has not been entered.
• Carrier Code will be set to the transport code entered against the anticipated order.

Order lines can be created for a number of cases and a number of singles. It is expected that the stock codes will be set up with the stocking unit of measure set to unit of measure 2. This set up will result in order lines for a number of cases or inners with the number of units set to 0.

If the stock code is setup with the stocking unit of measure set to unit of measure 1, this will result in an order line for a number of units with the number of cases set to 0.

The system will consider the number of eaches per shipping unit (stored in the transit factor on stock maintenance) when calculating how many cases / inners or units are required.

For example, if the number of eaches ordered was 17 but product is stored in cases where each case contains 10 eaches. The order would need to despatch 2 cases of the product which equates to 20 eaches. When viewed in the order management screen, OMS7000, this line would show, qty ordered 17, qty anticipated 20. When viewed through the Order Enquiry, this line would show as 2 cases ordered. The pick list, pick confirmation screen etc will all show 2 cases ordered rather than the number of eaches.

If a stock code is setup with a transit factor of zero, then the system will treat this stock as containing 1 each per stocking uom.

For this release, it is expected that the pick wave screen will be used, by the warehouse, to find the orders that are ready for picking. In future, it is expected that the transport planning will set the route and load number which will allow the orders to be created already grouped into a pick wave, ready for allocation.

If the warehouse is set to automatically allocate the orders then any allocation failure will result in the allocation for the entire load / order being rolled back. This means the warehouse will need to manually allocate the orders by using the allocation screen or the pick wave screen.

NB. As the Warehouse order creation runs as a separate process, the sending of the load / order to the warehouse, will NOT be rolled back if the allocation run fails.

Order Cancellation

It is possible to Cancel the Master Order, providing the user has permission to perform this action. If the master order is cancelled, then any anticipated orders will be removed from the anticipated orders tables. The Master Order will remain with a cancelled status. It will be possible to cancel the entire order or a single master order line.

When a master order is cancelled, the system will write details of a zero despatched order to the despatch confirmation transient tables. The next EDI outbound despatch confirmation run will include the cancelled master orders showing zero quantity despatched.

Once orders have been sent to the warehouse for processing, they cannot be cancelled from within the Order Management Layer as stock may have been allocated or picked for the order. Instead orders should be pick confirmed to zero and despatched. This will then send a despatch confirmation message. CMRCMR

Each time the ‘Reassess ALL Orders at Status New” button is clicked from “Anticipated Orders”, the database package that re-creates the Anticipated Orders will be run. This package will first check if any orders have been cancelled in the warehouses. If all the order lines relating to a master order detail have been cancelled then the anticipated order will be reset to status New and the warehouse will be set to ‘+’. The warehouse is set to ‘+’ to highlight the fact that orders have been cancelled in the warehouse. It is possible to enter a warehouse of ‘+’ in the selection criteria tab to find all orders that do not have a warehouse assigned. At this stage, it will be possible to cick the “Process Selected” button and re-direct the orders to a specific warehouse. Alternatively, the “Re-assess ALL Orders at Status New” button can be clicked again to recreate the anticipated orders. This second run of the process will assign the warehouse according to the warehouse assignment rules.

NB. A Generic Sku may need more than 1 NPC to satisfy the order line. In this situation, all the related NPC order lines will need to be cancelled before the Order Management Layer will treat the order line as cancelled. The DH order number cannot appear more than once in a despatch confirmation message, this is why ALL the detail lines that relate to a DH order number, must be cancelled before the OML will treat the master order line as cancelled.

Special Instructions

The anticipated orders screen (OMS7000) will include a “Special Instructions” button. When this button is clicked a despatch text entry popup will appear.

piccy

The special instructions will be displayed on the far of the “Planning” tab which can be accessed by using the scrollbar and scrolling to the right.

piccy

The special instructions will be stored at the ESI reference level. A single ESI reference could generate anticipated orders for two or more warehouses. In this case, the ESI reference will be shown more than once on the main orders screen BUT the special instructions will only need to be entered once. The special instructions can be changed at any order status. When the orders are sent to the warehouse, the special instructions (at ESI reference level) will be transferred to the despatch instructions of the WMS order number. Any changes to the special instructions within the OML will be cascaded down to the WMS order number despatch instructions.

If required, the standard order entry screen (SOS1110), “Order Notes” button, can be used to amend the WMS order despatch instructions. However, if this order is then cancelled and the order re-processed through the OML the despatch instructions will revert back to the Special instructions entered in the OML.

piccy

The PIPP format of the despatch note will be changed to print any despatch text setup for the customer followed by any despatch instructions for the order.

piccy

Document History

Version	Date	Status	Reason	Initials
Version 1	09/11/2010	In Progress		LBW

Copyright OBS Logistics © 2008

The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied