- The question of how does reorder point work in SAP is important to using it properly.
- We cover how does reorder point work in SAP in both ERP and APO.
Reorder points are a method of planning that is non-forecast based. Reorder points are typically, but not always set based upon the historical analysis of the sales of a product location combination.
See our references for this article and related articles at this link.
Background on Reorder Point Planning in SAP
For many years, companies used reorder point planning in SAP ERP before some companies decided to move to APO for their planning. Reorder point planning is still quite popular with a number of companies. As I describe in the book Supply Planning with MRP, DRP, and APS Software, in a historical review of the topic of reorder point planning that was research for the book, I have concluded that reorder point planning has been unfairly maligned, primarily by software vendors and consultants and even a number of authors chose to take a one sided view of the topic, characterizing reorder point planning as passe.
Many of the arguments used against reorder point planning don’t hold up under scrutiny when one considers products with certain demand history characteristics (I provide this scrutiny to specific anti-reorder point planning quotations taken from other books). I say this having worked in, and implemented, every supply planning method that is available in software: reorder points have their place, and many of the critics of reorder point planning have unfounded reasons for resisting them.
Reorder Point Planning in SAP ERP
Let’s look at the reorder point controls that are found on the Material Master in SAP ERP. This is the most common ERP system, but most systems with supply planning functionality work in a similar manner. SAP has the following quotations on reorder points:
“The system then calculates the net requirements. The system compares the available stock at plant level (including safety stock) plus the firmed receipts that have already been planned (purchase orders, production orders, firmed purchase requisitions and so on) with the reorder point. If the sum of the stock plus receipts is less than the reorder point, a material shortage exists.” – SAP Help
This makes it sound as if the reorder point in SAP ERP does forward calculate, but an important question is for how long.
The reorder level (also known as the reorder point) is made up of the sum of the safety stock plus the expected average material consumption within the replenishment lead-time. Therefore, when determining the reorder level, you must take safety stock, previous consumption values or future requirements, and the replenishment lead time into account. – SAP Help
Therefore, it is over the replenishment lead-time. So in a formula format, it looks like the following:
Sum (Safety Stock + Expected Average Consumption for the Replenishment Lead Time)
The reorder level or point is essentially the demand over lead-time + the safety stock, which is the upper level of demand based upon the variability in supply and demand (depending upon how the company calculates safety stock and what the safety stock takes into account). Manual or Externally
Calculated Reorder Point Planning in SAP ERP
Once the external program produces values, or if the reorder points are to be manually determined, these are the fields that are populated. This is shown in the following screenshot:
Automatic Reorder Point in SAP ERP
When calculated automatically using the base functionality in SAP ERP, SAP has the following quote on how this works:
“If you choose the automatic reorder point planning procedure then both the reorder level and the safety stock level are determined by the integrated forecasting program. The system determines the forecast values for future requirements by means of historical data. From these forecast values, the system then calculates the reorder level and the safety stock level, taking the service level, which is specified by the MRP controller, and the material’s replenishment lead time into account. The system then records these two values in the appropriate material master record. Since the forecast is carried out at regular intervals, the reorder level and the safety stock level are continually adapted to the current consumption and delivery situation. This means that a contribution is made towards keeping stock levels low.” – SAP Help
This is shown in the graphic below:
This setting would be a problem for many clients that I work with. They don’t necessarily want their safety stock determined by an integrated forecasting program just because they are selecting automatic reorder point determination.
Using this also means setting a service level and setting it for every product location combination. This can be another problem because companies typically don’t have a custom service level but often have blanked service levels. However, a blanked service level for large parts of the product database can be applied. Some schemes may look like the following:
- A Products: 98% Service Level
- B Products: 95% Service Level
- C Products 88% Service Level
Once the external program produces values, or if the reorder points are to be manually determined, these are the fields that are populated. Setting service levels with safety stock in the most integrated and intelligent way that I am aware of.
This article answer the question of how does reorder point work in SAP? How does reorder point work in SAP has several different answers depending upon the configuration.
A reorder point is very simply a quantity of stock or an interval at which a “reorder,” or order, is to be created. In reorder point planning, orders are not triggered by a specific requirement (such as a forecast or dependent requirement), but instead by the depletion of stock over time, eventually triggering the minimum stock level or reorder point. Reorder points can be used with any of the supply planning methods, or they can be used to exclusively control the supply plan without any of the methods. However, when it is used solely to control the supply plan, the company is said to be performing reorder point planning, as opposed to forecast-based planning. MRP/DRP and APS (heuristic, allocation, cost optimization, inventory optimization) methods are forecast-based planning.
And it comes down to forecastability of the product location combination. If the forecast is of reasonable accuracy, then MRP can be used. If the forecast is high in error, and cannot be improved much beyond this error, then a reorder point will typically perform better than creating a forecast.
We developed an approach where reorder points are calculated externally, which allows for a higher degree of control, and for the average inventory to be coestimated in a way that provides an observable total system inventory, holding cost, service level and a picture of what is happening to the overall system. This is called the Brightwork Explorer. Calculating individual parameters like reorder points without an appreciation for the systemwide does not make any sense.