Requirements parameters
Prerequisites
Refer to documentation Implementation
Screen management
The Requirements parameters function contains a Home information section and four additional sections:
- You use two sections to define the MRP calculation parameters.
- You use two sections to define the MPS calculation parameters.
You define a set of MRP and MPS parameters per site.
Header
You use the Home section to define the site for which MRP (Material Requirements Planning) and MPS (Master Production Schedule) calculation runtime parameters are required. The site must be a warehouse (storage site).
Storage site (field STOFCY) |
Use this field to define the storage site (warehouse). The site defined on the user record is displayed by default but can be amended.
|
Tab MRP Calculation
You use this section to define the first set of MRP (Material Requirements Planning) calculation parameters.
In this section you specify the firm horizon for the planning calculations and how the recommendations are to be bucketed, that is in days, weeks and months.
You specify which resources are to be included in the MRP calculations, that is, you specify which order types and stock MRP must include replenishments from. You can include include incoming stock from purchase orders, work orders, intersite (transfer) and subcontract orders. You can choose to remove uninspected items, that is those items that have not yet been through quality control, from the calculation of available stock.
You also specify which requirements to include, that is, which order types the MRP calculations must include demand from. You can include demand from the forecasts you have entered, sales and intersite orders, and project tasks.
The parameters you select for the starting (initial) stock calculations can significantly affect the length of time it takes to run the MRP calculations. Please observe the notes and warnings for the Transfers field (MRPTRFSTO) below in particular.
The MRP parameters are continued in the MRP Calculation 1 section.
Processing
BOM type (field MRPALTTYP) |
This field is used in conjunction with the BOM code field. Use this field to define which type of BOM code (Manufacturing or Subcontract) will be defined in the BOM code field. |
BOM code (field MRPBOMALT) |
Use this field to define the BOM code that is to be used in the Material Requirements Planning (MRP) and the Master Production Schedule (MPS) calculations.
|
Weekly structure (field MRPTWD) |
A weekly structure is a set of 7 values, each specifying the hourly capacity of a day in the week.
Calendars are used for calculating the capacity of a work center. |
Replanning analysis (field MRPANYLTI) |
Specify the duration of the replanning analysis period (in weeks). This period starts beyond the firm horizon, provided it has been defined for the product. |
Load calculation (field MRPCAPLTI) |
Use this field to define the duration of the load calculation (in weeks), if permitted for the defined BOM code.
|
Production lead time (field MRPMFGLTI) |
Use this field to define the type of manufacturing lead time to be used by the calculations:
Lead time calculation from routings significantly increases the processing time. When a routing is not associated with a product, the default data is obtained from the product-site record for all suggested work orders. |
Maximum stock analysis (field MRPMAXANY) |
Select this check box to activate overstock analysis. The suggestion considers the maximum stock at period end. |
Print calculation report (field MRPPRNFLG) |
Select this check box to print a report of the MRP or MPS calculations at the end of the processing run. |
MPS and MRP products (field MRPITM) |
Select this check box if all MRP and MPS managed products should be included in the planning calculations.
|
Exclusive selection (field MRPITMCOD) |
Select this check box if the work order suggestions / purchase order suggestions (WOS / POS) calculation is only to be performed on the items selected according to the MRP and MPS parameters (MRP, MPS and MRP + MPS products).
Leave this check box clear to ensure ascending compatibility between previous versions of the requirement calculations. The WOS / POS suggestions calculation is carried out on all products at the site. Only the WOS / MWS results relating to the selected product group are then specified in the ORDERS - WIP table. All MWS are considered as requirements for the current calculation, regardless of their origin (either MRP or MPS). |
Buckets
Days (field MRPDAYNBR) |
The requirement calculation groups requirements by period and generates purchase or production suggestions for each requirement. Material Requirements Planning (MRP) calculation periods are known as "buckets". Buckets can be defined in days, weeks and months. The grouping matches the division of the proposals from the calculation.
It is possible to perform a requirement calculation with one or many period types (but always in the following order: days, weeks, months). The division into periods can be performed over a horizon of 2000 days (just over 5 years), and for a maximum of 1000 periods. Depending on the calculation start date, the number of periods will automatically be adjusted so that "week" type periods start on the first day of the week and "month" type periods cover an entire month with a possible week's overlap. For example, a grouping of 30 days / 4 weeks / 12 months will be expressed as:
|
Weeks (field MRPWEENBR) |
Months (field MRPMONNBR) |
Automatic adjustment (field MRPBUCCOR) |
Select this check box to adjust the schedule automatically to conform to the following rules:
The following rules are applied:
For example:
|
Block number 6
Specific parameter (field MRPSPEPAR) |
Use this parameter for a specific processing script. This parameter is not used by Sage X3. |
Starting stock
Deduct allocations (field MRPPHYSTO) |
The MRP or MPS process is based on the start stock quantity, requests (demand) and resources (replenishments). It determines the reorder suggestions required for each product. Start stock specifies the stock type on which the calculations are based. Select this check box if physical stock must be included in the calculated start stock quantity. Allocated stock will be deducted from the start stock. |
Quality control stock (field MRPCTLSTO) |
Use this field to control how uninspected items (stock at Q status), that is those items that have not yet been through quality control, are to be used in the calculation of available stock.
|
Rejected stock (field MRPREJSTO) |
Select this check box if the planning calculations should include rejected stock in the initial stock quantity (stock at R status). |
Transfers (field MRPTRFSTO) |
Select this check box if the planning calculations should include transfer stock (stock being transferred to a different site) in the initial stock quantity. Sage advises that you leave this check box clear. Selecting this check box can significantly affect the time it takes to run the MRP calculations.
Leave this check box clear if your intersite transfers are managed using a continuous workflow (process). If a direct delivery at one site without an initial purchase order on the other sitedoes not create an intersite transfer receipt simultaneously on the second site, select this check box. That is, you should include transfer stock if the receipt at the second site (the intersite "transferred to" site) is generated independently. A purchase order (TRF) that exists on the requester site will cover all |
Phantoms (field MRPGHOSTO) |
Select this check box if the planning calculations should include the eventual stock of phantom subgroups in the initial stock quantity. This parameter is only active if you select the MPS and MRP products |
Requirements
Forecasts (field MRPSOSFLG) |
Select the check box to specify if the associated requirement (demand) is to be included in the MRP or MPS calculations. You can include demand from the forecasts you have entered, sales and intersite orders. |
Sales orders planned (field MRPSOPFLG) |
Sales orders firm (field MRPSOFFLG) |
Transfers suggested (field MRPTPSFLG) |
Transfers planned (field MRPTPPFLG) |
Transfers firm (field MRPTPFFLG) |
Pending issues (field MRPWAISTO) |
Select this check box if the planning calculations should decrease quantities related to suspended transactions from the available stock quantity. |
Forecast offset (field MRPHORDEM) |
Select this check box if any sales forecast adjustments must be within the demand horizon. This only concerns products for which a request horizon has been defined at the site level. The adjustment for the planning calculations is based on the following principle:
|
Resources
Work orders planned (field MRPWOPFLG) |
Select the check box to specify if the associated resource (order type) is to be included in the MRP or MPS calculations as a replenishment. You can include incoming stock from purchase orders, work orders, intersite (transfer), subcontract orders, and project tasks. |
Work orders released (field MRPWOFFLG) |
POs planned (field MRPPOPFLG) |
POs firm (field MRPPOFFLG) |
Transfers planned (field MRPTRPFLG) |
Transfers firm (field MRPTRFFLG) |
Subcontracts planned (field MRPEOPFLG) |
Subcontracts firm (field MRPEOFFLG) |
Project task planned (field MRPMTPFLG) |
Project task firm (field MRPMTFFLG) |
Tab MRP Calculation 1
The MRP (Material Requirements Planning) calculation parameters continue in this section.
In this section you define the final set of parameters to be used for the planning calculations and which make and buy recommendations (suggested orders) can be created to cover demand and replenish stock. For example, you can optionally exclude safety stock and manufacturing losses from the calculations.
You also define the replanning rules, that is the rules that define the time period within which actual requirements can be established and resources can be replanned.
Miscellaneous
Ignore safety stock (field MRPSAFSTO) |
Select this check box if the planning calculations should ignore safety (security) stock, regardless of the parameter defined in the reorder strategy. |
Ignore coverage (field MRPCOV) |
Select this check box if the planning calculations should ignore the coverage duration for all processed products. |
Resources in coverage (field MRPCOVRES) |
Select this check box if, for the products managed with coverage, the planning calculations should take replenishments (resources) into account in the coverage horizon. |
Ignore link scrap % (field MRPSHRPRC) |
Select this check box if the planning calculations should ignore the loss (scrap) percentage on a component line of a bill of materials (BOM).
|
Ignore firm horizon (field MRPPLHDAT) |
Select this check box if the planning calculations should ignore the firm horizon when creating replenishment suggestions. |
Rebuild safety stock (field MRPSAFCOV) |
Use this field to define how the MRP or MPS calculations should handle safety stock.
|
Suggested orders
Work order suggestions (field MRPWOSFCY) |
Select the check box to specify if the associated resource (order type) can be generated to cover demand or replenish stock. You can select to generate all types of order "suggestions" (work orders (WOS), purchase orders (POS), intersite replenishments (TRS), and subcontract orders (EOS). |
POs suggested (field MRPPOSFCY) |
Intersite suggestions (field MRPWOSFCYI) |
Subcontract suggestions (field MRPEOSFCY) |
Statistics
Last calculation date (field MRPLASDAT) |
This field displays the date the MRP calculations / MPS calculations were last run. |
Time in minutes (field MRPLASLTI) |
This field displays the length of time (in minutes) it took to complete the last MRP calculation / MPS calculation run. |
Grid Replanning rules
Type (field RPLTYP) |
This field displays the type of resource that can be replanned. The first two characters = the order type; the third character (P (Planned) or F (Firm)) = the status of the order. For example, POP = Purchase order Planned, WOF = Work order Firm. |
Method (field RPLMOD) |
Replanning determines the consistency of the planning (within a replanning lead time) for each resource with the requests and suggestions, and optimizes the resource with respect to the requirements. For each type of resource that can be replanned, use this field to define the replanning mode:
If the selected replanning mode is Messages only or Simulation, at least one lead time must be entered.
|
Backward lead time (field RPLBWDLTI) |
Use this field to define the earliest time (in calendar days) within which resources can be replanned. The replanning uses this lead time to propose the coverage of a requirement to meet demand. |
Forward lead time (field RPLFRWLTI) |
Use this field to define the latest time (in calendar days) within which resources can be replanned. The replanning uses this lead time to propose the coverage of a requirement to meet demand. |
Replan quantities (field RPLUPDQTY) |
Use this field to define which type of replanning must be carried out for quantities (advance, delay). |
Replan dates (field RPLUPDDAT) |
Use this field to define which type of replanning must be carried out for dates (advance, delay). |
Block number 4
Decrease below EOQ (field RESBLWLOT) |
Use this check box to define the replanning behavior when a resource is sufficient to cover the requirements:
|
Retain orders in process (field WIPPRO) |
Use this field to control the replanning of work in progress orders:
A work order is defined as "in progress" if at least one production tracking record exists; a subcontract order is defined as "in progress" as soon as it is ordered; a purchase order is defined as "in progress" if it is partially received. |
Ignore reorder policy in replanning (field REOPOLDIS) |
Select this check box if the reorder strategy for "net quantity" type is to be ignored. Resources are replanned with reference to the requirements included in the calculations. Leave this check box clear if resources are only replanned with reference to the first (chronological) requirement included in the calculations. |
Replan material requirements (field MRPMWRPLN) |
Select this check box to replan material requirements created for a work order if the work order is replanned. Leave this check box clear if the original material requirements created for a work order are to be retained.
|
Tab MPS Calculation
You use this section to define the first set of MPS (Master Production Schedule) calculation parameters.
In this section you specify the firm horizon for the schedule and how the recommendations are to be bucketed, that is in days, weeks and months.
You specify which resources are to be included in the MPS calculations, that is, you specify which order types and stock the MPS must include replenishments from. You can include include incoming stock from purchase orders, work orders, intersite (transfer) and subcontract orders. You can choose to remove uninspected items, that is those items that have not yet been through quality control, from the calculation of available stock.
You also specify which requirements to include, that is, which order types the MPS calculations must include demand from. You can include demand from the forecasts you have entered, sales and intersite orders, and project tasks.
The parameters you select for the starting (initial) stock calculations can significantly affect the length of time it takes to run the MPS calculations. Please observe the notes and warnings for the Transfers field (MPSTRFSTO) below in particular.
The MPS parameters are continued in the MPS Calculation 2 section.
Processing
BOM type (field MPSALTTYP) |
This field is used in conjunction with the BOM code field. Use this field to define which type of BOM code (Manufacturing or Subcontract) will be defined in the BOM code field. |
BOM code (field MPSBOMALT) |
Use this field to define the BOM code that is to be used in the Material Requirements Planning (MRP) and the Master Production Schedule (MPS) calculations.
|
Weekly structure (field MPSTWD) |
A weekly structure is a set of 7 values, each specifying the hourly capacity of a day in the week.
Calendars are used for calculating the capacity of a work center. |
Replanning analysis (field MPSANYLTI) |
Specify the duration of the replanning analysis period (in weeks). This period starts beyond the firm horizon, provided it has been defined for the product. |
Load calculation (field MPSCAPLTI) |
Use this field to define the duration of the load calculation (in weeks), if permitted for the defined BOM code.
|
Production lead time (field MPSMFGLTI) |
Use this field to define the type of manufacturing lead time to be used by the calculations:
Lead time calculation from routings significantly increases the processing time. When a routing is not associated with a product, the default data is obtained from the product-site record for all suggested work orders. |
Maximum stock analysis (field MPSMAXANY) |
Select this check box to activate overstock analysis. The suggestion considers the maximum stock at period end. |
Print calculation report (field MPSPRNFLG) |
Select this check box to print a report of the MRP or MPS calculations at the end of the processing run. |
MPS and MRP products (field MPSITM) |
Select this check box if all MRP and MPS managed products should be included in the planning calculations.
|
Exclusive selection (field MPSITMCOD) |
Select this check box if the work order suggestions / purchase order suggestions (WOS / POS) calculation is only to be performed on the items selected according to the MRP and MPS parameters (MRP, MPS and MRP + MPS products).
Leave this check box clear to ensure ascending compatibility between previous versions of the requirement calculations. The WOS / POS suggestions calculation is carried out on all products at the site. Only the WOS / MWS results relating to the selected product group are then specified in the ORDERS - WIP table. All MWS are considered as requirements for the current calculation, regardless of their origin (either MRP or MPS). |
Buckets
Days (field MPSDAYNBR) |
The requirement calculation groups requirements by period and generates purchase or production suggestions for each requirement. Material Requirements Planning (MRP) calculation periods are known as "buckets". Buckets can be defined in days, weeks and months. The grouping matches the division of the proposals from the calculation.
It is possible to perform a requirement calculation with one or many period types (but always in the following order: days, weeks, months). The division into periods can be performed over a horizon of 2000 days (just over 5 years), and for a maximum of 1000 periods. Depending on the calculation start date, the number of periods will automatically be adjusted so that "week" type periods start on the first day of the week and "month" type periods cover an entire month with a possible week's overlap. For example, a grouping of 30 days / 4 weeks / 12 months will be expressed as:
|
Weeks (field MPSWEENBR) |
Months (field MPSMONNBR) |
Automatic adjustment (field MPSBUCCOR) |
Select this check box to adjust the schedule automatically to conform to the following rules:
The following rules are applied:
For example:
|
Block number 6
Specific parameter (field MPSSPEPAR) |
Use this parameter for a specific processing script. This parameter is not used by Sage X3. |
Starting stock
Deduct allocations (field MPSPHYSTO) |
The MRP or MPS process is based on the start stock quantity, requests (demand) and resources (replenishments). It determines the reorder suggestions required for each product. Start stock specifies the stock type on which the calculations are based. Select this check box if physical stock must be included in the calculated start stock quantity. Allocated stock will be deducted from the start stock. |
Quality control stock (field MPSCTLSTO) |
Use this field to control how uninspected items (stock at Q status), that is those items that have not yet been through quality control, are to be used in the calculation of available stock.
|
Rejected stock (field MPSREJSTO) |
Select this check box if the planning calculations should include rejected stock in the initial stock quantity (stock at R status). |
Transfers (field MPSTRFSTO) |
Select this check box if the planning calculations should include transfer stock (stock being transferred to a different site) in the initial stock quantity. Sage advises that you leave this check box clear. Selecting this check box can significantly affect the time it takes to run the MRP calculations.
Leave this check box clear if your intersite transfers are managed using a continuous workflow (process). If a direct delivery at one site without an initial purchase order on the other sitedoes not create an intersite transfer receipt simultaneously on the second site, select this check box. That is, you should include transfer stock if the receipt at the second site (the intersite "transferred to" site) is generated independently. A purchase order (TRF) that exists on the requester site will cover all |
Phantoms (field MPSGHOSTO) |
Select this check box if the planning calculations should include the eventual stock of phantom subgroups in the initial stock quantity. This parameter is only active if you select the MPS and MRP products |
Requirements
Forecasts (field MPSSOSFLG) |
Select the check box to specify if the associated requirement (demand) is to be included in the MRP or MPS calculations. You can include demand from the forecasts you have entered, sales and intersite orders. |
Sales orders planned (field MPSSOPFLG) |
Sales orders firm (field MPSSOFFLG) |
Transfers suggested (field MPSTPSFLG) |
Transfers planned (field MPSTPPFLG) |
Transfers firm (field MPSTPFFLG) |
Pending issues (field MPSWAISTO) |
Select this check box if the planning calculations should decrease quantities related to suspended transactions from the available stock quantity. |
Forecast offset (field MPSHORDEM) |
Select this check box if any sales forecast adjustments must be within the demand horizon. This only concerns products for which a request horizon has been defined at the site level. The adjustment for the planning calculations is based on the following principle:
|
Resources
Work orders planned (field MPSWOPFLG) |
Select the check box to specify if the associated resource (order type) is to be included in the MRP or MPS calculations as a replenishment. You can include incoming stock from purchase orders, work orders, intersite (transfer), subcontract orders, and project tasks. |
Work orders released (field MPSWOFFLG) |
POs planned (field MPSPOPFLG) |
POs firm (field MPSPOFFLG) |
Transfers planned (field MPSTRPFLG) |
Transfers firm (field MPSTRFFLG) |
Subcontracts planned (field MPSEOPFLG) |
Subcontracts firm (field MPSEOFFLG) |
Project task planned (field MPSMTPFLG) |
Project task firm (field MPSMTFFLG) |
Tab MPS Calculation 2
The MPS (Master Production Schedule) calculation parameters continue in this section.
In this section you define the final set of parameters to be used for the scheduling calculations and which make and buy recommendations (suggested orders) can be created to cover demand and replenish stock.
The MPS does not require some of these parameters. As the MRP and MPS parameters are similar the field help description applicable to the MRP parameters is included.
The MPS does not require replanning rules. You can set the Method field (RPLMODS) to No processing, and the Replan quantities and Replan dates fields (RPLUPDQTYS / RPLUPDDATS) to None
Miscellaneous
Ignore safety stock (field MPSSAFSTO) |
Select this check box if the planning calculations should ignore safety (security) stock, regardless of the parameter defined in the reorder strategy. |
Ignore coverage (field MPSCOV) |
Select this check box if the planning calculations should ignore the coverage duration for all processed products. |
Resources in coverage (field MPSCOVRES) |
Select this check box if, for the products managed with coverage, the planning calculations should take replenishments (resources) into account in the coverage horizon. |
Ignore link scrap % (field MPSSHRPRC) |
Select this check box if the planning calculations should ignore the loss (scrap) percentage on a component line of a bill of materials (BOM).
|
Ignore firm horizon (field MPSPLHDAT) |
Select this check box if the planning calculations should ignore the firm horizon when creating replenishment suggestions. |
Rebuild safety stock (field MPSSAFCOV) |
Use this field to define how the MRP or MPS calculations should handle safety stock.
|
Suggested orders
Work order suggestions (field MPSWOSFCY) |
Select the check box to specify if the associated resource (order type) can be generated to cover demand or replenish stock. You can select to generate all types of order "suggestions" (work orders (WOS), purchase orders (POS), intersite replenishments (TRS), and subcontract orders (EOS). |
POs suggested (field MPSPOSFCY) |
Intersite suggestions (field MPSWOSFCYI) |
Subcontract suggestions (field MPSEOSFCY) |
Statistics
Last calculation date (field MPSLASDAT) |
This field displays the date the MRP calculations / MPS calculations were last run. |
Time in minutes (field MPSLASLTI) |
This field displays the length of time (in minutes) it took to complete the last MRP calculation / MPS calculation run. |
Grid Replanning rules
Type (field RPLTYPS) |
This field displays the type of resource that can be replanned. The first two characters = the order type; the third character (P (Planned) or F (Firm)) = the status of the order. For example, POP = Purchase order Planned, WOF = Work order Firm. |
Method (field RPLMODS) |
Replanning determines the consistency of the planning (within a replanning lead time) for each resource with the requests and suggestions, and optimizes the resource with respect to the requirements. For each type of resource that can be replanned, use this field to define the replanning mode:
If the selected replanning mode is Messages only or Simulation, at least one lead time must be entered.
|
Backward lead time (field RPLBWDLTIS) |
Use this field to define the earliest time (in calendar days) within which resources can be replanned. The replanning uses this lead time to propose the coverage of a requirement to meet demand. |
Forward lead time (field RPLFRWLTIS) |
Use this field to define the latest time (in calendar days) within which resources can be replanned. The replanning uses this lead time to propose the coverage of a requirement to meet demand. |
Replan quantities (field RPLUPDQTYS) |
Use this field to define which type of replanning must be carried out for quantities (advance, delay). |
Replan dates (field RPLUPDDATS) |
Use this field to define which type of replanning must be carried out for dates (advance, delay). |
Block number 4
Decrease below EOQ (field RESBLWLOTS) |
Use this check box to define the replanning behavior when a resource is sufficient to cover the requirements:
|
Retain orders in process (field WIPPROS) |
Use this field to control the replanning of work in progress orders:
A work order is defined as "in progress" if at least one production tracking record exists; a subcontract order is defined as "in progress" as soon as it is ordered; a purchase order is defined as "in progress" if it is partially received. |
Ignore reorder policy in replanning (field REOPOLDISS) |
Select this check box if the reorder strategy for "net quantity" type is to be ignored. Resources are replanned with reference to the requirements included in the calculations. Leave this check box clear if resources are only replanned with reference to the first (chronological) requirement included in the calculations. |
Replan material requirements (field MPSMWRPLN) |
Select this check box to replan material requirements created for a work order if the work order is replanned. Leave this check box clear if the original material requirements created for a work order are to be retained.
|
Reports
By default, the following reports are associated with this function :
PRTSCR : Screen print
This can be changed using a different setup.
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Site XX: Record does not existThe site that has been entered is not defined.
A value must be entered in at least one of the three fieldsNo period division has been made in the scheduling horizon.