NETSTOCK | Overview of the menus | Orders

Orders

Use Orders to:

  • Create orders from ideal order recommendations

  • Create transfers between warehouses based on the requirements of the sub-location rolling up to the central warehouse

  • Prioritise orders on suppliers that have recommended orders for items that have existing issues: items with unsatisfied customer orders, items that are already stocked out with no stock currently on order, or items that are potentially going to stock out with no stock currently on order

  • Prioritise orders based on the biggest total order value or total units recommended

  • Order ahead for supplier shut downs or Chinese New Year

 

Create a new order

orders_create_order_menu.png
 

Click on the Orders menu item to show all suppliers with recommended orders today.

Click to enlarge the image

To create a new order:

  1. Select the required location – all suppliers who have recommended orders for today are displayed

  2. Select to filter the list, if required

  3. Select to create the order schedule for a group, if required

  4. Ensure Order from: Suppliers is selected

  5. Either show suppliers with items that need ordering within their default look forward days, or those with orders any time in the next 12 months

  6. Click next to the supplier you wish to create the order for

  7. Click on the Create order button

Note: to create an order for a supplier who does not have a recommended order today (or does not appear in the list), search for the supplier using the Create order for a specific supplier search box and create the order. You can then add items to the order schedule.

 

View saved recommended orders

Click to enlarge the image

Click on the Orders menu dropdown to show all Saved recommended orders that have been created and/or downloaded but not yet archived. The information displayed includes:

  • The warehouse / location the order is for

  • Whether the order is on a supplier or central warehouse

  • The source, being the supplier or central warehouse

  • Who created the order schedule and when

  • The total value of the order schedule

Selecting any of these saved order schedules will open it, displaying the individual sku order recommendations.

Note: You can also navigate to the Saved recommended orders while viewing todays order recommendations by clicking on the Saved recommended orders tab (see the Create a new order image above).

 

The order schedule

Both creating a new order and viewing saved recommended orders, takes you to the order schedule.

Click to enlarge the image

The Order schedule is the list of items from the selected supplier that have an order recommendation today based on their stock level, forecasts, inventory policy, and look forward days.

Pertinent information is displayed to enable you to quickly evaluate the recommended quantity, including:

  • Product code, description and classification

  • Unit of measure and lead time information

  • Order recommendation information

  • Optimal inventory levels and comparison with current stock position

  • Sales versus forecast comparison

  • DownloadArchive, Add to order, and Analysis buttons

  • An order summary showing line count, order units and order value

Note: If you do not complete working on an order schedule the day you create it, and only get back to it a day or two later, it is preferable to regenerate the order schedule for that location and supplier. The reasons are as follows:

  • The order schedule is a snapshot of what was required to be ordered from that supplier at that point in time. This snapshot does not get updated with daily information.

  • As up to date information is synced daily, the information available now will include any sales that have occurred since the order schedule was generated, the current stock on hand figure and any committed or allocated stock, for example - and may result in a different order recommendation.

 

Click to enlarge the image

The first column shows product and group information:

  • Product code and description

  • Groups; dimensions that may be used to filter and sort data

  • The ability to capture a line comment

 

Click to enlarge

The second column shows unit of measure and lead time information:

  • The unit of measure

  • The lead time for supply

  • The ability to override the lead time

  • The EAD - expected arrival date - based on the lead time

 

Click to enlarge the image

The order section shows the order recommendation details, cost and value:

  • The ideal order quantity

  • The order constraints: minimum order quantity and order multiple

  • The order recommendation, including the impact of the constraints

  • The ability to amend the order quantity and/or unit cost

  • The value based on the amended quantity x the amended unit cost

 

Click to enlarge the image

The classification section displays the item’s classification, according to the matrix, in addition to the status of the item.

  • The item is a stocked item, as the matrix is displayed

  • The item is highlighted as AH,

    • An A item on the ABC ranking, and

    • A HIGH item on the high. medium, low velocity ranking

  • The item is currently Stocked Out

When reviewing orders, you might like to:

  • Click on the column heading to sort the order schedule by Class or Velocity. This enables you to take more care with your very important items when reviewing order recommendations.

  • Click on the Status to sort the order schedule, so that all stocked out items can be reviewed first.

 

The policy section contains a chart that shows:

  • How far into the future your lead time (LT), safety stock (SS) and replenishment cycle (RC) go - the green, gold and purple backgrounds

  • How long your current stock on hand (O/H) will last, if there is any

  • When any outstanding orders (O/O) are due to arrive and how long they will last

For those who prefer numbers, these are shown below the chart.

In this example:

  • There is no stock on hand (O/H = 0u)

  • There are 160 units on order (O/O = 160u), which will arrive a few days from now and last for 32 days

  • There are 100 units on back order (B/O = 100u) that must be factored into the order recommendation

Hover options - policy section

Click to enlarge the image

Hovering over O/H will display if there is stock of this item in other locations that could possibly be transferred instead of purchasing from the supplier.

Click to enlarge the image

Hovering over O/O will display details of the outstanding orders for the item.

Click to enlarge the image

Hovering over B/O will display details of the back order quantity, showing the breakdown between allocated and overdue customer orders.

 
orders_schedule_col8.png

The demand section shows a demand versus forecast comparison.

  • The historical sales, the blue area in the graphic

  • The future demand, which could include:

    • The sales forecast that has been generated/amended

    • The distribution forecast, to satisfy sub-locations

    • The BOM forecast, for demand on this item from a finished good

  • The sales and forecast averages

  • The age of the product

Hover options - demand section

Click to enlarge the image

Hovering over the chart displays a table showing the actual sales and demand numbers, with a row for each demand stream that has any demand, including:

  • Sales history 

  • Sales forecast

  • Distribution forecast

  • BOM forecast

Click to enlarge the image

Hovering over the Tot CO (total customer orders), displays a list of all outstanding customer orders and when the customer would like to take delivery.

Click to enlarge the image

Hovering over period to date (PTD) sales displays sales as a percentage of the month’s forecast, then compares that to how far through the period we are.

  • If the bars are close: sales are tracking forecast

  • If the sales/forecast bar is bigger than the period bar: we are selling quicker than we forecast and should potentially increase the forecast

  • If the period bar is bigger than the sales/forecast bar: we are selling slower than the forecast and should potentially decrease the forecast

 

Other options

Click to enlarge the image

 

On the bottom left of the order schedule, there are options to:

  • Download this order schedule; this creates the information required to create the order in your system

  • Archive this order schedule; this removes this order from the saved recommended orders

  • Add items to this order that do not have order recommendations today, possibly in order to meet supplier terms or to fill containers

  • View Analysis for this order

  • View details of who created the order schedule, when they created it and for which location/supplier combination

 

Clicking on the Add button brings up these choices:

  • Select from all items to add; which displays all items supplied by this supplier

  • Select from top-up items to add; which displays all items that do not have an order recommendation today but are below their Order up to (max)

  • Add a specific item; where you type in the product code of the item you wish to add

 

Click to enlarge the image

Clicking the Analysis button displays some totals for the order, grouped by:

  • ABC

  • HML

  • The dimensions which have been configured for your environment

 

The order summary

Click to enlarge the image

On the bottom right of the order schedule, a dynamic order summary is updated as changes are made to recommended order quantities.

  • Columns show totals for recommended orders, amended orders and the difference

  • Rows showing totals for number of items, total units, total value, order volume and order weight (if volume and/or weight data are available)