Material Requirements Planning (MRP) in SAP Business One provides the purchasing and production process with data to achieve an optimal inventory level via the corresponding processes. It is therefore about having the right quantity and quality of a required good in the right place at the right time in a cost-optimised manner.

Data basis of the MRP in SAP Business One

Material Requirements Planning (MRP) calculates the demand by first calculating the Stock for the parent items, followed by the stock levels, analysing the corresponding child items.

These data are used in the process:

The system then subtracts the demand from

  • Number of items in stock
  • Receipts from orders
  • Production orders
  • Stock transfers to the higher-level warehouse
  • Incoming advance invoices
  • Recurring transactions on the input side

General preparations for material requirements planning

There are some general requirements as a basis for correct material requirements planning in SAP Busines One. Most of the preparatory work concerns the material master data. In case you do not operate with fixed order points, but seasonal fluctuations or other values play a role, forecasts are used.

Preparation of the article master data

The item master data should be maintained in the system with as much detail as possible. This includes the general determination of the planning method, procurement method, order intervals, order multiples, minimum order quantity, lead times and tolerance days as well as the maintenance of the purchase price and required purchase quantities.

The forecasts in MRP with SAP Business One

A forecast is a way to predict future demand for your finished goods. Since not all customer orders are received on a fixed schedule that would allow for a constant production or purchasing plan, purchasing often has to operate with forecasts. Forecasts are based on historical sales data, current sales data and data on future sales.
In SAP Business One, you can generate a forecast manually or automatically. When one
chooses the automatic method, SAP Business One creates a forecast on the basis of
historical sales from sales orders or deliveries and outgoing invoices. One can add multiple forecasts if needed. One can then select a forecast in an MRP run.

Intelligent forecasting in SAP HANA

In SAP Business One / HANA there is an additional option to generate forecasts within the framework of material requirements planning. The so-called "intelligent forecasts" are available for this purpose. Ready-made statistical models are provided for this purpose:

  • TESM (Triple Exponential Smoothing)
  • LRDTSA (Linear Regression with Damped Trend and Seasonal Adjust)

The proposals generated in this way are visualised and can be further processed as such.

The Disposition Wizard in SAP Business One

Disposition Assistant in SAP Business One

The MRP wizard is the central element in material requirements planning with SAP Business One. In it, the different demand triggers and parameters are combined into an MRP proposal. In the wizard, you can set some parameters to model the results. As a result, order recommendations are generated, which can be orders from suppliers or production orders.

Data output of the results of material requirements planning

There are three options for displaying the determined data:
Daily: If you select this method, each day in the date range receives a column.
Weekly: If you choose this method, SAP Business One lists the columns by week number in the year.
Monthly: If you select this method, each month in the date range will receive

Consignment warehouse in SAP Business One

Consignment warehouse in SAP Business One

A consignment warehouse is a supplier's warehouse on the company premises or in the vicinity of a customer. In this warehouse, goods and/or ...
Continue reading ?
MRP in SAP Business One

MRP – Material Requirements Planning in SAP Business One

MRP (material requirements planning) and ERP are a pair of siblings where you don't know exactly which of the two is/are the ...
Continue reading ?
return rate

Return rates – on the trail of returns

Returns are increasingly burdening online trade. A key figure that is often used in a business context is the return rate. Returns are ordered goods that ...
Continue reading ?
supply chain crisis

Survive the supply chain crisis with an ERP

Disrupted supply chains and rising costs currently affecting manufacturing and trading companies were only triggered by the pandemic and...
Continue reading ?
Stocks in ERP systems

Manage inventories in ERP systems

Knowing which stocks are stored when, where and in what quantity is fundamentally important for companies. With a warehouse management system...
Continue reading ?
shipping interface

Shipping service providers and SAP Business One

Especially in times of increasing e-commerce, the shipping process plays an increasingly important role in merchandise management. The...
Continue reading ?
Cobi wms update

COBI.wms mobile warehouse software / update

COBI.wms is mobile warehouse software for handling warehouse and logistics processes for SAP Business One. As a reliable...
Continue reading ?
Batch management for medical devices

Manage batches for medical devices

Companies that manufacture medical devices in particular are obliged to manage these products in batches. This is especially true for all...
Continue reading ?
Mobile warehouse management

Mobile warehouse management – Better storage with an app

The fact that the automation of warehouse processes helps to reduce costs is no longer an insider tip. At the same time, many companies do not have the ...
Continue reading ?
Carrier with SAP B1

SAP Business One Connect for carriers

With the SAP Business One Integration Hub, SAP Business One users can quickly and easily dock to cloud-based services and applications ...
Continue reading ?

SAP Business One with Honeywell voice control solutions

Honeywell and SAP have partnered to deliver powerful voice technology, trusted by more than a million distribution center users...
Continue reading ?
FEFO, FIFO or LIFO? The differences in storage strategies

FEFO, FIFO or LIFO? The differences in storage strategies

No matter whether invoices, the e-mail inbox or Belge. Everyone quickly appreciates a good filing system, as it makes everyday life ...
Continue reading ?
The advantages of handling units in logistics

The advantages of handling units in logistics

What do shopping trolleys, bags and boxes have in common? That's right, they are used for transport, i.e. the temporary storage of things. An abstract...
Continue reading ?
Transparent supply chains with SSCC numbering

Transparent supply chains with SSCC numbering

If a delivery goes through more than one company, it is of great importance that the control of the supply chains is transparent and ...
Continue reading ?

Logistics on the way to digitization

A warehouse controlled and managed by artificial intelligence. Autonomous vehicles that guide us through this system. Smart glasses that keep track of ...
Continue reading ?

How warehousing is changing with ERP software

ERP software significantly simplifies warehousing for a company. Inventory, receipt, issue - with just a few clicks, warehouse management can ...
Continue reading ?