Home Get Help Goto App
Switch language: Dansk

Forecasting

Forecasting makes it easy to plan your production and your purchases in relation to your sales. You can plan weeks, months and years ahead.

The forecasting feature works like this: You enter your expected sales for a given SKU. Now you can see the consequences for your inventory and convert the sale directly to purchase and production orders. You can also make estimates for your expected sale based on sales in earlier periods.

Convert forecast to orders

  1. Click Warehouse in the top-menu and select Forecasting in the drop-down menu.
  2. Indicate which SKU(s) you wish to estimate your sales for in the left sidebar.
  3. In the row Expected in the table, you fill in your expected sales for each SKU for a specific month or week.
  4. Click the button Supply in the upper right corner. Now you will see your inventory, expected supply and expected sales for the selected SKUs.
  5. Tick the small boxes for the SKUs you wish to create orders for. You can also click the button Select all.
  6. Select period From and To. Now click Create Order.
  7. Select Purchase Order or Production Order.
  8. Fill in the order details. The order will be created with the selected SKUs.
    • The quantities ordered will be set so that the quantity will not go below the reorder point at any time within the selected period.
    • The order date has been determined by the SKU with the longest lead time and the delivery date is set to the beginning of the period.
  9. Click Save.

Estimate forecast

  1. Click Warehouse in the top-menu and select Forecasting in the drop-down menu. Hvis du i forvejen er på forecasting-siden for Forsyning, skal du klikke på knappen Salg i øverste højre hjørne.
  2. Indicate which SKU(s) you wish to estimate forecast for in the left sidebar.
  3. In the row Expected in the table, you fill in your expected sales for each SKU for a specific month or week.
  4. Tick the small boxes for the SKUs you wish to make estimates for. You can also click the button Select all.
  5. Select period From and To. Now click Estimate Forecast.
  6. In the dialogue, you can now apply a trend or a correction for the expected sales in percentage. You can indicate whether it should be calculated based on
    • Current forecast in the selected period.
    • Same period last year.
    • Period of same length before selected period.
  7. Click Calculate.

Guide for the rows in the tables

Sales

On order The sales orders already entered in the application.
Quote The sales quotes already entered in the application.
Expected Here you can enter your expected sales for the SKU. This is the only row you can enter data into. The other rows indicate sales quotes and sales orders already created.

Supply

Supply The supply added to your inventory from production orders and purchase orders in the period.
- (Actual Sales/Quotes) The actual sales on sales orders and sales quotes already entered in the application.
- Expected sales Here you can enter the expected sales for the SKUThis is the only row you can enter data into. The other rows are calculations based on stock movement and the expected sales that you entered.

If you already entered expected sales in the sales forecasting table, it will appear here.

NB. The expected sales must include the actual sales/quotes.
- Consumes (production) Indicates what has been consumed in production of the SKU in the period.
- Adjustments Indicates any waste or loss in the period.
= Stock Movements Sums up the stock movements of the period, i.e. what went in or out of stock in total.
Initial Inventory Your inventory at the beginning of the period.
End Inventory Your inventory at the end of the period.
×

Tilmeld dig nyhedsbrev

Få de nyeste vejledninger i din indbakke.

Tutorials

Get Started

Import & Export of Data

Integrations

Master Data

Settings

Order Management

Inventory Management

Financials

Reports

Miscellaneous