Show TOC

Object documentationMRP Wizard, Step 5: Documents Data Source Locate this document in the navigation structure

 

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.
Documents Data Source Fields
Time Range

Defines a time range for data to be included in the MRP calculation.

  • Within Planning Horizon

    Only documents within the Start Date and End Date range (as defined in MRP Wizard, Step 2: Scenario Details) are considered in MRP calculations and displayed with recommendations.

    The application displays supplies and demands before the Start Date but does not include them in the calculation; therefore, there are no recommendations for the demands before the Start Date.

    Past due data is summed together with recommendations for the system date column.

  • Include Historical Data

    All demands and supplies before the Start Date are considered in MRP calculations. Recommendations are summed together and displayed in the system date column.

    The Historic Data field in the MRP report is visible only after you have selected the Include Historical Data option in this step.

Sources of Demand and Supply to be Included in MRP Calculation

To include document sources in the MRP calculation, select corresponding checkboxes for the document type.

  • Purchase Orders

    When you select the checkbox, in the MRP report, SAP Business One displays open purchase orders as supplies.

    To include only selected purchase orders, select the Expanded Purchase Order Selection checkbox. For more information, see Expanded Document Selection.

  • Blanket Purchase Agreements

    When you select the checkbox, in the MRP report, SAP Business One displays blanket purchase agreements with the status of Approved as supplies. The blanket agreements with a vendor code are considered as a blanket purchase agreement.

    Note Note

    MRP considers only the blanket agreements of type Specific.

    End of the note.
  • Sales Orders

    When you select the checkbox, in the MRP report, SAP Business One displays open sales orders as demands.

    To include only selected sales orders, select the Expanded Sales Order Selection checkbox. For more information, see Expanded Document Selection.

  • Blanket Sales Agreements

    When you select the checkbox, in the MRP report, SAP Business One displays blanket sales agreements with the status of Approved as demands. The blanket agreements with a customer code are considered as a blanket sales agreement.

    Note Note

    MRP considers only the blanket agreements of type Specific.

    End of the note.
  • Production Orders

    To include only selected production orders, select the Expanded Production Order Selection checkbox. For more information, see Expanded Document Selection.

    Note Note

    MRP calculation considers only production orders with the Status Planned or Released. Completed production orders are not relevant for calculation, because they have already impacted the inventory.

    End of the note.
    • For Standard production orders, in the MRP report, the application displays the parent items as demands and the child items as supplies.

    • For Disassembly production orders, in the MRP report, the application displays the parent items as supplies and the child items as demands.

  • Inventory Transfer Requests

    • For the issuing warehouse, SAP Business One displays the requested quantities as demands.

    • For the receiving warehouse, SAP Business One displays the requested quantities as supplies.

    Note Note

    The MRP cannot recommend inventory transfer requests for scenarios where you choose to run by company. The MRP considers all the demands and supplies jointly for the whole company as one warehouse, and it does not make sense to transfer inventory within one warehouse. For more information, see MRP Wizard, Step 4: Inventory Data Source.

    End of the note.
  • Recurring Order Transactions

    When you select this checkbox, SAP Business One considers recurring transactions that have been scheduled for sales and purchase order documents.

    Note Note

    The MRP includes a recurring order transaction only when it contains the following data:

    • A quantity per item line

    • A warehouse per item line

    • A Next Execution Date

    End of the note.

    For more information, see Managing Recurring Transactions.

    • Reserve Invoices

      Note Note

      This option is not available for the India localization.

      End of the note.

      When you select this checkbox, SAP Business One considers open reserve invoices and open correction invoices for reserve invoices in the MRP calculation.

      • For A/R reserve invoices and correction invoices, the application displays them as demands.

      • For A/P reserve invoices and correction invoices, the application displays them as supplies.

      To include only selected reserve invoices, select the Expanded Reserve Invoice Selection checkbox. For more information, see Expanded Document Selection.

    • Documents Restrictions

      Select the document restriction checkboxes to include only selected documents in the MRP calculation. To do so, proceed as follows:

      1. For a specific document type, select the document restriction checkbox. For example, for sales orders, select the Restrict Sales Orders checkbox.

      2. In the Selected Documents window, to filter documents, choose the Add Documents button.

      3. In the Add Documents window, use the selection criteria to specify documents to be added.

        For purchase orders and sales orders, to include only orders with the Status of Approved, select Approved Orders Only.

        For production orders, to include only orders with the Status of Released, select Released Orders Only.

      4. Choose OK to close the window and return to the Selected Documents window. The window displays all the documents you added.

      5. To exclude one or more records from the MRP calculation, deselect the Selected checkbox and choose OK.

        The record remains in the window, but is not included in the MRP calculation.

      6. To delete a record from the window, right-click the relevant row and select Delete Row.

      7. To delete all the records from the window, choose the Clear All Documents button.

    Inventory Level

    Uses the specified inventory level as a demand in MRP calculation, to ensure that the required inventory level is available for unexpected orders. Not to consider inventory level requirements in the calculation, leave this field blank.

    Note Note

    To maintain an item's inventory level values (both company level and warehouse level), see Item Master Data: Inventory Data Tab.

    End of the note.
    • When you are running MRP by company (see MRP Wizard, Step 4: Inventory Data Source), the application consolidates the inventory level requirements as one demand for the default warehouse.

      • On the Inventory Data tab of the Item Master Data window, if you have selected the Manage Inventory by Warehouse checkbox for an item, the application sums up the inventory level values of all warehouses (Min. Inventory,Max. Inventory, and Req. Inventory) for which Include Demand is selected in step 4.

      • On the Inventory tab of the Item Master Data window, if you have deselected the Manage Inventory by Warehouse checkbox for an item, the application takes the defined company inventory level values (Required,Minimum, and Maximum) as a demand for all warehouses together.

    • When you are running MRP by warehouse (see MRP Wizard, Step 4: Inventory Data Source), the application considers inventory level requirements separately for each relevant warehouse.

      • On the Inventory Data tab of the Item Master Data window, if you have selected the Manage Inventory by Warehouse checkbox for an item, and in the MRP wizard step 4 you have selected the Include Demand checkbox for one or more warehouses, the application takes the defined warehouse inventory level values (Min. Inventory,Max. Inventory, and Req. Inventory) separately as relevant for the warehouses.

      • On the Inventory Data tab of the Item Master Data window, if you have deselected the Manage Inventory by Warehouse checkbox for an item, the application takes the company inventory level values (Required, Minimum, and Maximum) you defined respectively for each warehouse for which you have selected the Include Demand checkbox.

    Forecast

    Use this field to decide whether to consider forecast data in MRP calculations.

    • If you do not want to consider forecast data in MRP calculations, leave the field blank.

    • To consider forecast data in the MRP calculation, in the dropdown list, choose one forecast, or choose Define New to define a new forecast.

      If you have defined sales orders and blanket sales agreements to consume forecast, in the MRP calculation, the forecasted amount, minus the amount consumed by sales orders and blanket sales agreements, is regarded as demands.

      To configure the forecast consumption settings for open sales orders, choose   Administration   System Initialization   General Settings   Inventory   Planning   tab. For more information, see General Settings: Inventory Tab.

      To configure the forecast consumption settings for blanket sales agreements, in the Blanket Agreement Item Details window, use the Consume Forecast checkbox to determine whether to use this item to consume forecast when it is involved in a blanket agreement.

    When you choose to consider a forecast in the MRP calculation, the application assigns a warehouse to the demands from the forecast according to the following rules:

    • If you select only one warehouse in step 4, the application links the demands from the forecast to this warehouse.

    • If you select more than one warehouse in step 4, and the default warehouse is one of them, the application links the forecast to the default warehouse.

    • If you select more than one warehouse in step 4, and the default warehouse is not one of them, the application links the forecast to the first warehouse code in ascending order.

    Note Note

    The consumption of forecasted amount by sales orders and blanket sales agreements is irrespective of the warehouse of the sales orders or the blanket sales agreements.

    End of the note.
    Recommendations

    Defines the document types recommended after the MRP wizard calculates the results. Purchase orders and production orders are mandatory recommended document types. You can define whether to recommend inventory transfer requests when you are running the MRP by warehouse.

    • Purchase Orders

      Note Note

      This checkbox is read-only and by default selected.

      End of the note.

      Items with the Procurement Method of Buy are recommended with purchase orders.

      In step 4, if you have selected Run by Warehouse, you have the following warehouse options:

      • To generate purchase orders to the default warehouse of the item, select Generate to Default Warehouse.

        For more information about the default warehouse, see Item Master Data: Inventory Data Tab.

        Note Note

        When you have not included the default warehouse to the MRP run in step 4, the recommendation still goes to the default warehouse if you select this checkbox.

        When there is no default warehouse defined for the item, the recommendation goes to the first warehouse (sorted according to warehouse code) in the selection grid in step 4 for which the Include Demand checkbox has been selected.

        End of the note.
      • To generate purchase orders to the warehouse that demands inventory supplies, select Generate to Warehouse with the Demand.

    • Production Orders

      Note Note

      This checkbox is read-only and by default selected.

      End of the note.

      Items with the Procurement Method of Make are recommended with production orders. The application recommends the production orders to the warehouse as defined in the production BOM.

    • Inventory Transfer Request

      Note Note

      You can include inventory transfer request as one of the recommendation types only when you are running the MRP by warehouse.

      End of the note.

      When you select this checkbox, the application recommends inventory transfer requests before recommending purchase orders and production orders. Warehouses in the same Location have higher priorities. The application automatically chooses the warehouse with the highest available inventory level as the sending warehouse.

      If you have chosen to consider the Minimum and Required Inventory Level for warehouses, the application makes sure that after the inventory transfer recommendation, the inventory level of the sending warehouse does not fall below the inventory level you set. For the inventory level calculation algorithm, see the field explanation above for the Inventory Level.

    Save Scenario

    Saves the MRP scenario at the current stage.

    Available only when you add a new scenario or update an existing one.

    Note Note

    You cannot save an MRP scenario if it is a simulation.

    End of the note.