Overview

Chart

The chart can be viewed in three different timescales:

  • Months
  • Weeks
  • Days

To choose a timescale, go to the upper right corner and change the time setting. It is also possible to change how long period is shown for historical data and for the forecast by typing in the wanted period in the upper right corner. Note that this only changes the chart view and has no effect on how the forecast is calculated.

Number typed in for history and forecast will be shown to match the selected time scale, as seen below.

changing-graph-view

   

Grid

Next to the Chart button in the upper left corner is a tab called Grid. All information found there are the same as can be seen on the chart, including historical information about the sale, estimated stock and forecast, and more.

item-card-grid

   

Details

Next to the Chart and Grid tabs is a tab called Details. Information about each product can be found by clicking the Details button for that product. The information is divided into five categories, shown below:

  • Basic Info
  • Additional Info
  • Stock Info
  • Forecast Settings
  • Order Routes
  • Undelivered Orders

item-card-details

It is possible to show pictures of the item within the Details tab, but it depends on your setup and how/where the pictures of your products are kept.

Basic Info

This section contains basic information about the product, serving both as information for the user and as an input into the order logic calculation. This information is taken directly from product information in the ERP system. Information about columns in AX and NAV can be found in the corresponding Standard AX Connector Manual and Standard NAV Connector Manual.

The following list includes short explanation for information found in basic info:

  • Name: Name of the product.
  • Item group: Group that the product is allocated to within ERP.
  • Article no: Article number.
  • ABC Grouping: The item’s ABC grouping, if applicable.
  • Location: Selected location for that product.

Additional Info

  • Description: Description of the product from ERP.
  • Weight: Weight of the product.
  • Volume: Volume of the product.
  • Sale price: Sale price of the product.
  • Additional lead-time: Users have the option to add additional days to the base lead-time registered in the system. This is to adjust for potential delays on product delivery.
  • Order frequency: How often an order is placed for a specific item.
  • Size: Size of the product, if appropriate.
  • Color: Color of the product, if appropriate.
  • Style: Style of the product, if appropriate.

Stock Info

  • Stock: Total stock on hand for chosen product in that variant.
  • Undelivered: Total for all open, undelivered orders for the specified product in the specified location.
  • Wastage Days: Number of days, before expiring date, that stock should be excluded in inventory level.
  • Min Stock: This can either be the min in store or reorder point in the min-max method. First, if we use this as min in store (for display models) or other location, then this number will become the minimum quantity of the product to be held in that location and added to the order calculation as extra safety stock to avoid empty shelfs. The number in this field will become the new zero and the inventory should not go below this number so on top of this min stock number we will calculate forecast and safety stock like normally. Secondly, if you will add value to max stock field, this min stock will become the reorder point in the min-max order method. This means that when your stock of a certain product reaches or is below this minimum, it’s time to reorder and we order the difference between current stock and max stock, so Order Qty = Max stock – current stock.
  • Max Stock: The max stock is only used when min-max is turned on within the order logic under settings (see chapter Order logic 3.4.1. in this manual). If a number is inputted in both min stock and max stock, the system will automatically order up to max stock (target stock) when the stock reaches or is below the min stock, without considering anything else, like forecast or safety stock. The order quantity will be the difference between max stock and current stock but if order multiple (qty per unit) or MOQ is registered, then the final order qty might become higher than the max stock number (so this is not an upper cap on orders qty or inventory level). There can be cases where it is practical to use the min-max method like new or slow-moving products, but it can be difficult to both find and maintain optimal min stock and max stock values. If using min-max method for some products, we recommend an exception report for items with min and max stock values where these values are compared to resent sales values.

Forecast Settings

  • Confidence Factor: The confidence factor of the item. This is set in the AGR system.
  • Skip to forecast date: The date historical data starts from. This is used if it has been decided by user to ignore some historical data prior to that date. This is done in some extreme cases when sales history for some time period is not reliable to use.
  • Forecast from date: The forecast period will start at this date.
  • Forecast to date: The forecast period will end at this date.
  • Event Model: The default event model considers the Easter holiday and how it does not fall on the same date every year, but rather adjusted the sales history to follow the model of the Easter timeline without focusing on the date. It is possible to create a new event model, for perhaps a similar holiday that doesn´t always fall on the same date, or to turn this default event model off if the Easter holiday in no way affects your business.

Order Routes

In the drop down, selection a different supplier can be chosen if they are defined in ERP. Information is taken directly from ERP and viewed in the AGR module.

For the chosen supplier, the following data is listed below:

  • Primary Route: The vendor where the order is coming from
  • Route Info: Will show you all the information about the Primary Route. Sometimes possible to toggle between two different routes.
  • Min order: The minimum order quantity the supplier accepts (e.g. box, pallet).
  • Cost price: Cost price of the product.
  • Lead time days: Number of days it takes to get the product delivered. Days are counted from when supplier gets the order until the product arrives and can be counted as stock on hand.
  • Qty. pr. unit: Quantity in the ordering unit (e.g. Box, pallet)
  • Qty. pr. layer: How many units are per layer.
  • Qty. on pallet: How many units are per pallet.

Undelivered

This is a list of all the undelivered of this item that is broken down by purchase order according to vendor.