MRP can calculate version-managed items based on the available stock of the item.
Each Item version is treated as an individual item.
ATTENTION: This only applies to batch/serial-managed items.
IMPORTANT: if you have an item that is controlled by versions, it is calculated by each version.
If the item is marked as version-controlled, but not managed by batches/serials, the item is calculated as one line.
Documents* that have empty version field take the default version.
Such documents are forecasts, sales orders, sales quotations, reverse invoices, stock transfer requests, Purchase orders, Purchase quotations, Beas PO requests.
Minimum stock for version:
If minimum stock is set, the calculation applies the minimum stock only for the version that was set as default. See image below.
Note: Inventory information is not displayed by I-Version in the "By Warehouse" tab.
Description
Item description.
Lead time
Lead time or replenishment time according to the item master in working days.
- MRP setting "Notify of minimum inventory" is activated
- Warehouse Stock > Minimum Inventory
What the system checks
Activate this parameter to enable a warning icon for items where the Total minimum inventory status is positive, but at least one of the warehouses may require a stock transfer (Warehouse minimum inventory status is negative).
This notification corresponds to the situation of the warehouses at the time of MRP calculation and not necessarily to the current status of the warehouses.
Example:
Warehouse 01: Min. Inventory = 100, Current Inventory = 0
Warehouse 02: Min. Inventory = 0, Current Inventory = 200
Warehouse 03: Min. Inventory = 500, Current Inventory = 0
Total Min. Inventory = 600, Total Inventory = 200
In this case Balance is > 0,
The inventory in one warehouse is not enough to cover the Minimum Inventory of this warehouse and the Total Min. Inventory > Total Inventory
- the system shows the requirement and the actual item must be checked.
- the system displays no alert.
Example:
Warehouse 01: Min. Inventory = 100, Current Stock = 0
Warehouse 02: Min. Inventory = 0, Current Stock = 200
Warehouse 03: Min. Inventory = 0, Current Stock = 0
Total Min. Inventory = 100, Total Stock = 200
In this case Balance is > 0, but the inventory in one warehouse is not enough to cover the Minimum Inventory of this warehouse and Total Min. Inventory < Total Inventory
- the system does not show requirement
- the system displays the alert.
I-Versions
When working with I-Versions (Setting "Consider I-Version" is activated), minimum inventory by warehouse is indicated only in the active version.
However, inventory information in the by Warehouse tab is not considered per I-Version. This means that it considers the complete inventory of the Item. See MRP Order recommendation by Warehouse.
Note: If blocked batches are reserved and not considered, this may lead to incorrect values. Because in this case, blocked batches will be subtracted from the displayed stock.
Inflow
Sum of all planned inflow in Inventory UoM (according to current filter settings), excluding order related quantities (e.g. bill of materials with order related item) and pegged requirements that were covered by reservations.
Outflow
Sum of all planned issues in Inventory UoM (according to current filter settings) plus sum of all planned inflow in Inventory UoM (according to current filter settings), excluding order-related quantities (e.g. bill of materials with order related item).
Balance
Balance of stock level-minimum stock-planned issue+planned inflow in the period of computation displayed in Inventory UoM.
Note: If you create a work order, the system uses the Production warehouse related to all Warehouse rules and Configuration settings. It does not use the Default warehouse.
Action
Action to be taken by MRP. In Massive mode, this column is automatically filled with the selected procurement method:
- Buy
- Make
- Transfer: Transfer between Replenishment warehouse and the current warehouse.
Note: When the quantity in each line is entered manually (manual mode), the system only fills this field with values "Buy" or "Make". You must select "Transfer" manually.
Warehouse from
Replenishment warehouse. Select the supplier warehouse to transfer items from - mandatory field only for "Transfer" action.
Repl. Stock
Replenishment stock quantity in Inventory UoM. The sum indicated in this columns reflects all the stock in different Replenishment warehouses.
Order recommendation by:
CW x
Month x
or user defined
Order recommendation for next calendar weeks, months or other time units, that can be defined manually.
PATH: MRP > MRP Wizard > Select a scenario and click the Order recommendation button
First slot (e.g. <= CW5) : week at the moment of the MRP run.
second to second to last slot: slots of defined duration (e.g. one week)
last slot: all requirements from the beginning of the last slot until the far future.
Window maintenance_order_browse.psr
Depending on the defined time period for the calculation and the type of time period representation, the system calculates the count of columns. 2–18 periods are displayed then.
In Planning Scenario > Scheduling you can define other time units, for example monthly, bi-weekly or in customized time unit definitions.
Attention! Order proposal date is not the requirement date!
An order proposal corresponds to the requirement date minus the average delivery time, lead time and some buffer days.
In the order recommendation list it is possible to determine the quantity to be ordered automatically, even if the last possible date has not yet been reached. Select the number of buffer days, as well as the desired procurement method. Then, the test starts determining what quantity should be ordered, taking into account the lead time + buffer days (working days):
PATH: MRP > MRP Wizard/Order recommendations > Select a scenario > Order recommendation button > mode button > Pre-assign button.
WIndow mrp_strukturansicht_vorbelegen.psr
Calculation
The requirement date (list of peggings) is less or equal to the current date + lead time + buffer days given in working days. The sum of the affected peggings, taking into account the already planned receipts in this period, is the quantity to be ordered or to be produced. The calculated delivery date is, at earliest, the current day (today) + replenishment lead time + buffer days (work days). The determined date is at least one day after current date + replenishment lead time. If the determined day is not a working day, the next working day is identified and proposed. The determined values are entered in the order recommendation item list (upper part) in columns "quantity" and "requirement date".
Click the Create request button to complete the process.
Note: This pre-allocation function considers only storage-related assemblies.
Attention: Supplier and price need to be entered prior to the creation of purchase documents. Items without this information are ignored.
1.Lead time from the item master appears in the calculation is 20 days.
PATH: MRP > MRP Wizard > Select a scenario and click the Order recommendation button
Window: mrp_view_masterrahmen
2.Fill PO quantities. Additional days can be entered.
Period = Current day + Lead time (item master) + work days
End of the period = 24.07.2010
The last requirement of 31 pieces from 26.07.2010 is outside the period.
Period = Current day + Lead time (item master) + work days
End of the period = 23.08.2010
The last requirement of 31 pieces from 26.07.2010 is now inside the period.
If by right-clicking on a calendar week the purchase order quantity (field "quantity“) is pre-allocated, the delivery date is also pre-allocated according to the selected calendar week. It is also possible to enter the desired delivery date of the purchase order to be created.
Order multiples
Order multiples (item master) is taken into account.
Example: Order multiple 10
Purchase order recommendation CW of 10: 6 pcs, CW 11: 4 Pcs
Displayed: CW 10: 10 Pcs, CW 11: 0 Pcs
It is always rounded up to the next order multiple and the subsequent purchase is covered by it. Double requests are avoided.
Order possibility
Collective purchase request/collective production request: Right-click on the time heading (CW x), which uses the order quantities for CW x. The requirements are entered in the quantity column. Only entries with corresponding requirements are displayed. For purchase orders the price and the supplier must be entered, for production request only the quantity. Then, the process can be started via "production request" or "order request".
Take over single quantity: If the quantity is to be used for one item, right-click in the CW x column on the corresponding item and choose "order request" or "production request".
This is not possible in collective order mode. For activating the detailed view click on the mode button. Thereafter, data can be completed and the process can be started.
Quantity
Quantity to be purchased / produced in Inventory UoM (Column header "quantity").
Color codes:
GRAY: For "Make" items
RED: For "Buy" items
Quantity purchasing item
Quantity to be purchased / produced in purchasing units (Column header "quantity").
Color codes:
GRAY: For "Make" items
RED: For "Buy" items
Purchasing UoM
Purchasing UoM according to item master data.
Factor Purchase UoM
Factor Purchasing UoM to Inventory UoM according to item master data.
The system select the correct Purchase Agreement number automatically for current supplier, quantity and delivery date.
Blanked Agreement ID
Internal Purchase Agreement Number
Gross price
If a gross price list for the chosen supplier was stored, all price quotations are then carried out for gross prices (cannot be changed). If an order is prepared, the price is submitted as a gross price.
Deliv. date
Delivery date for the purchase order to be created. It is pre-allocated with the first outflow (e.g. requirement date from customer order or work order). The balance (inventory, other inflow) is not considered. If the first planned outflow is in the past, this date will be displayed in this field.
Date of order
Planned inflow of first purchase order. Color codes:
RED: Date is today or before today.
GRAY: Date is later than today.
First demand
First planned issue (delivery date of customer order, forecast). Color codes:
RED: Date is today or before today.
GRAY: Date is later than today.
Sales Uom
Sales UoM.
Sales factor
Factor Inventory UoM to sales UoM.
MRP
Scheduling ID according to item master data.
Order related
Active for order related items.
Procurement Method
Purchase item or production item.
Produce
Active for production items.
Buy
Active for purchase items.
Sales item
Active for sales items.
Purchase item
Active for purchase items.
free
Clearance attribute according to item master.
free from
Clearance attribute "from" according to item master.
free to
Clearance attribute "to" according to item master.
blocked
Attribute blocked according to item master.
blocked from
Attribute blocked "from" according to item master.
blocked to
Attribute blocked "to" according to item master.
Item account
Default account as per item master.
Note: The account is only correct if the account was set up per item.
raw material
Raw material according to item master.
Order multiple
Order multiple according to item master data > Planning Data tab.
Minimum order amount
Minimum order amount according to item master data > Planning Data tab.
Maximum amount
Minimum order amount according to item master.
Goods issue for production
Total of planned production outflow.
Goods receipt from production
Total of planned production on hand.
Ordered
Total of incoming purchase orders.
Sales order
Total Sales order outflow.
Quantity for chosen PO
Total items for PO as selected in Planning > Detail > Filter.
Note: The content is not saved and stays available until the list is redrawn. This field may be used for customizations, as well as fields "UDF1 ... UDF3".
Project
Not supported.
First inflow
First inflow by purchase (P) or production order (W).
Note: For Transfer actions you must define a Replenishment warehouse in the corresponding field of the Order recommendation list.
Pre-Assign
Opens a new window to calculate what quantities need to be produced or purchased for the next X days. Use this to make material requirement planning for a defined upcoming period.