Show TOC

Object documentationMRP Wizard, Step 5: Documents Data Source

 

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 Requests

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

    To include only selected purchase requests, select the Restrict Purchase Requests checkbox to define the required documents. For more information, see the Documents Restrictions section at the end of the field help for Sources of Demand and Supply to Be Included in MRP Calculation.

  • Purchase Quotations

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

    To include only selected purchase quotations, select the Restrict Purchase Quotations checkbox to define the required documents. For more information, see the Documents Restrictions section at the end of the field help for Sources of Demand and Supply to Be Included in MRP Calculation.

  • 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 Restrict Purchase Orders checkbox. For more information, see the Documents Restrictions section at the end of the field help for Sources of Demand and Supply to Be Included in MRP Calculation.

  • 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.

    To include only selected purchase agreements, select the Restrict Purchase Agreements checkbox to define the required documents. For more information, see the Documents Restrictions section at the end of the field help for Sources of Demand and Supply to Be Included in MRP Calculation.

    Note Note

    MRP considers only the blanket agreements of type Specific.

    End of the note.
  • Sales Quotations

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

    To include only selected sales quotations, select the Restrict Sales Quotations checkbox to define the required documents. For more information, see the Documents Restrictions section at the end of the field help for Sources of Demand and Supply to Be Included in MRP Calculation.

  • 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 Restrict Sales Orders checkbox. For more information, see the Documents Restrictions section at the end of the field help for Sources of Demand and Supply to Be Included in MRP Calculation.

  • 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.

    To include only selected sales agreements, select the Restrict Sales Agreements checkbox to define the required documents. For more information, see the Documents Restrictions section at the end of the field help for Sources of Demand and Supply to Be Included in MRP Calculation.

    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 Restrict Production Orders checkbox. For more information, see the Documents Restrictions section at the end of the field help for Sources of Demand and Supply to Be Included in MRP Calculation.

    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.

    To include only selected transfer requests, select the Restrict Transfer Requests checkbox to define the required documents. For more information, see the Documents Restrictions section at the end of the field help for Sources of Demand and Supply to Be Included in MRP Calculation.

    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

      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 Restrict Reserve Invoices checkbox. For more information, see the Documents Restrictions section at the end of the field help for Sources of Demand and Supply to Be Included in MRP Calculation.

      Documents Restrictions

      Select the Restrict <Document Names> 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.

    • Required - Replenish items up to the required inventory level.

    • Minimum - Replenish items up to the minimum inventory level.

    • Maximum - Replenish items up to the maximum inventory level.

    • Minimum - Maximum - Replenish items up to the maximum inventory level only when it falls below the minimum inventory level.

    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, Req. Inventory, and Min. - Max. Inventory) for which Include Demand is selected in step 4.

      • 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 defined company inventory level values (Required, Minimum, Maximum, and Min. - Max.) 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, Req. Inventory, and Min. - Max. 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, and Min.- Max.) 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.

    • If you want to consider forecast data in MRP calculations:

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

      • To consider data of multiple forecasts in the MRP calculation, in the dropdown list, choose Multiple Forecasts. When the Selected Documents - Forecast window appears, select the forecasts you want to consider in this window.

      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 Start of the navigation path Administration Next navigation step System Initialization Next navigation step General Settings Next navigation step Inventory Next navigation step Planning End of the navigation path 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 a 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.