Operation Optimized Order Proposal

Nav123: Navision, Showare, OrderApp

Print Friendly, PDF & Email


Through the job queue entries the item statistics should be automated.Navision should be able to calculate 10-20 articles per second. Through the parameter string you can specify how many articles Navision & Business Central should calculate per run. Rule of thumb: Each article should be calculated once a week.
This results in the number of articles divided by the number of runs per week = number of articles per run.
The number of runs per week results from the set Start- and End time as well as the Number of minutes between executions.

Order parameters

You can recognize almost all fields for the optimized order proposal through the beginning Durch. which stands for for average. The average is the buyer's best friend: It makes it easier and more refined (with a few additional algorithms) to forecast demand.

Purchasing Setup

Screenshot der Einkauf Einrichtung für den optimierten Bestellvorschlag  unter Navision / Business Central

Round up the average order proposal starting from %*

If you enter a value here, e.g. 80%, Business Central or Navision checks when determining the order quantity whether the order quantity 80% (in this example) is the next larger unit. In this case, the order quantity will be rounded up to the next larger unit.

Average purchase history date formula

To determine the average delivery time, the optimized order proposal analyzes the history of deliveries. With this date formula you can specify how far into the past Navision should look for this. Recommendation: Look back at Business Central and 1-2 years. Looking too long into the past makes outliers forgotten too slowly, whereas looking too briefly evaluates outliers too strongly.

Average next article to calculate**

Up to which article was the statistics updated. Business Central or Navision only ever calculates a handful of items in order not to unnecessarily burden the server and the entire system. As soon as the last article has been calculated, Business Central or Navision starts all over again. See also automation.

Average factor order proposal*:.*

Navision and Business Central always calculate the order proposals according to the classic commercial calculation method: In the case of normal goods dispatch, new goods should be ordered in good time so that the new goods arrive exactly when the last stock is sold out.

Optimaler Bestellzyklus: Warenbestand und Kapitlabindung werden minimiert, Lagerverfügbarkeit wird maximiert.

This reduces the capital tied up to a minimum (no more goods are kept in stock than are normally sold until they are replenished). At the same time, the stock availability is increased to - normally - 100%: All customer orders that hit the statistical average can be served directly from the warehouse.

However, there are also good reasons to specifically drive a stock down (-) or up (+), e.g.

+ There is untied capital available, which is to be invested in the inventory
+ Favorable capital market interest rates, which bring more returns than costs when investing in inventory
+ Expected bottlenecks (e.g. signs of a pandemic such as Corona, observed or expected changes in customers' purchasing behavior, announced price increases by suppliers).
+ Increased shelf life
- Changes in buying behavior
- Fashion changes
- Shortened shelf life (best before date)

In such cases you can increase the order proposals (a factor> 1, e.g. a factor of 1.10 increases the order proposals by 10%) or reduce them (factor 90% of the calculated order proposal quantity))

Aufruf für die Aktualisierung der Abverkaufsdaten für den optimierten Bestellvorschlag von Hand
This menu command can also be used to start the update of the sales data for the optimized order proposal manually. However, this is usually not necessary as the item statistics are updated automatically via the job queue items.

Accounts payable master

Ansicht der Kreditoreneinrichtung (Lieferantenstammdaten) für den optimierten Bestellvorschlag in Navision / Business Central aus dem RTC-Client
Screenshot of the vendor setup (supplier master data) for the optimized order proposal in Navision or Business Central in the RTC client

Ø Delivery time in days (fixed)*

“Normally” Navision or Business Central calculates the Ø delivery time automatically based on the purchase history.
But if you have direct purchases, this doesn't work. Example: You buy copper on the spot market, or fresh meat, fresh fruit, fish on the weekly market according to availability. Then you enter the purchased products in an order and post them directly. So you always have delivery times of 0 days here. Thus, Business Central or Navision cannot calculate meaningful delivery times for you, and thus no meaningful procurement quantities.
But the weekly market is every Wednesday. Then you can set an average delivery time in days of 7. Now Navision can again make you sensible order suggestions for a restocking period of about 7 days.

Average factor order proposal*: *:

A factor with the same function as in the Purchasing Setup. This factor here has a higher priority, if it is set, the factor is not taken out of the facility.

Average minimum order value* *

This value is used twice.
a) It is displayed as plain text in the order proposal in order to get a quick overview.
b) In an order, this value serves as a (changeable!) specification for an order value increase.

Article master

Screenshot der automatisch berechneten Artikel Bedarfstatistik für den optimierten automatischen Bestellvorschlag in Navision / Business Central
Article requirement statistics for the optimized automatic order proposal in Navision and Business Central RTC Client
Screenshot der Artikelkarte mit zusätzlichen Feldern optimierter Bestellvorschlag im nativen Navision (Windows Client) (bis zur Version 2009R2)
Item card with the additional fields for the optimized order proposal in native Navision (up to version 2009R2)

Average delivery time in days

What is the average time between ordering and delivery? This is important for the optimal time to reappoint.

Average deviation in delivery time

How accurate is the average delivery time in days?

Average consumption per day

How many pieces are sold / consumed on average per day?

Average consumption deviation

How accurate is the average consumption per day?

Average calculated on

When was the last time these statistics fields were updated for this article?

Average consumption factor

The factor as in the vendor or in the Setup. If the factor is used in the article master, the other two factors are irrelevant (highest priority).

Average Buying Customers

How many different customers are buying this item? The smaller this number, the more dangerous: If a single buying customer drops out, you may be left with the inventory. The maximum number of buying customers is capped at 10, since from this value the risk diversification is wide enough.

Average special items

In the case of special items, the statistics fields are not used for the order proposal. Only customer orders are included in the order proposal. (Of course, the customer orders are also included in the order proposal for normal articles.)

Order quantity

Lot size, in these levels the article is ordered. Useful e.g. for canisters or canned goods: Only one whole pallet layer, e.g. 9 pieces, can be ordered at a time. A layer that is only partially filled is more likely to cause damage during transport. So Navision & Business Central will order at least 9 or multiples of that if needed. This is a standard Business Central and Navision field.

Backup inventory

The safety stock should never be started, so this is deducted from the available stock when the order is proposed. The meaningful inventory is thus increased by the safety stock. This is a standard Business Central & Navision field.

Seasonal items

In the case of seasonal items, the average sales are not calculated on the basis of the last 5 months, but on the basis of the past 5 years in each month.
Example: The statistics are updated in December. For a non-seasonal article (e.g. bread), the average consumption/sales is determined from the months November, October, September, August, July (December has the highest weighting). For a seasonal item (e.g. chocolate Santas), the average consumption/sales for the order proposal is determined from the past 5 Novembers (November of the previous year, November of the previous year...).

Accounts receivable setup

Zeitlicher Horizont in die Vergangenheit um die Durchschnittlichen Abverkäufe (Verkauf) pro Artikel zu ermitteln

How far into the past Business Central or Navision should look to determine the average sales. Recommendation: 3 years (-3y)

Generation of an order proposal

Call up the optimized order proposal in Navision (RTC) or Business Central
Calling up the optimized order proposal in the native Navision (up to version 2009R2) with the native client

Through Optimized order proposal start the calculation of the order proposal. Through Optimized order proposal for supplier start the order proposal for a specific supplier. In the next step, you can then select the supplier from the list of vendors.

Ergebnis einer automatischen Bestellvorschlagsermittlung

Order value increase

In the order header (purchase order header), enter in the field Increase order value the desired order value. This field is pre-filled with the content "Minimum order value" from the accounts payable master.
Then select the order value increase:

Intelligente Bestellwerterhöhung: Navision / Business Central fügt Artikel, die demnächst sowie benötigt werden, automatisch bis zur angegebenen Höhe der Bestellung hinzu

Navision & Business Central automatically adds items that are needed soon to the order up to the specified amount.

* The "Durch." in the field name only indicates in this field that this setting belongs to the optimized order proposal. This is not really a field that represents an average (Ø).