Field descriptions: MRP calculation

The parent company or companies.

You need to enter a Company or a Site.

You can enter or select multiple companies.

The reference for the MRP calculation results set.

This is a free-format text field. Use it to identify the set of MRP calculation results.

Indicates if work order suggestions need to be exploded into requirements for the released item and its component items, according to the bill of material definition.

When selected, if the MRP calculation determines stock of the released item is in shortage, the MRP calculation processes its component requirements, together with any other supply and demand, to identify any stock shortages and create suggestions to satisfy those component item stock shortages.

When clear, the MRP calculation will process the requirements together with any other supply and demand, to identify stock shortages and create suggestions to satisfy the stock shortages for the released item only.

A range to filter for the name of the items to manufacture or buy.

Enter or select the item codes to include a range of items in the requirements calculations.

For a single item, enter or select the same item code for the From item and To item fields.

For all components of a single item, where the item is defined as a bill of material, enter or select the same released item code for the From item and To item fields.

Leave blank to include all purchased and manufactured items, and components of all released items.

Indicates if sales quotes need to be included in the requirements calculations.

When selected, sales orders at Quote status are included in the MRP calculation results set.

When clear, the MRP calculation ignores sales orders at Quote status.

The number of full weeks to include in the MRP calculation forecast.

The default is 5 weeks from the Start date. The value needs to be an integer. You cannot calculate part weeks.

Monday is the first day of the week. If the Start date is not a Monday, the number of days from the Start date up to and including the first Sunday is calculated as 1 week.

The production site or sites.

You need to enter a Company or a Site.

You can enter or select multiple production sites.

This field is disabled if you enter a Company.

The parent company or companies included in the MRP calculation request.

Blank if Sites are listed.

The reason the MRP calculation failed.

The error message gives specific details of an issue, where possible. For example, ItemSite: Record not found: {"item":"#Yeast","site":"#TECON03"} means that the MRP calculation is trying to include a demand or supply item "Yeast" in the calculations but the item does not exist at site "TECON03".

Indicates if work order suggestions are exploded into requirements for the released item and its component items, according to the bill of material definition.

Selected: Production suggestions are for the released item and component items, according to the bill of material definition.

Not selected: Production suggestions are for the released item only.

The range of items to be manufactured or bought in included in the MRP calculation request.

If the From item and To item are the same item code, the single named item only was included in the MRP calculation request.

Blank if all items and components of all released items are included in the MRP calculation request.

Indicates if sales quotes are included in the MRP calculation request.

Selected: Sales orders at Quote status are included in the MRP calculation results.

Not selected: The MRP calculation results do not include sales orders at Quote status.

The lowest level component item in the bill of material included in the MRP calculations, according to the bill of material definition, where 1 represents the released item level.

This field is only displayed when the Explode bill of material checkbox is selected.

The number of full weeks included in the MRP calculation forecast.

Monday is the first day of the week. If the Start date is not a Monday, the number of days from the Start date up to and including the first Sunday is calculated as 1 week.

The production site or production sites included in the MRP calculation request.

Blank if Companies are listed.

The parent company code.

The parent company name.

The code of the item to be manufactured or bought in.

The item name to be manufactured or bought in.

The order quantity.

The quantity is not necessarily the same as the quantity appearing on the demand that triggered the requirement. It represents the order quantity that MRP has calculated produces the best schedule, subject to the specified item-site replenishment rules and MRP calculation request criteria.

The quantity displays the unit of measure that will be used when you order the item, for example, metres, each, boxes.

The method the MRP calculations recommend you use to replenish stock to meet the demand.

Production: The suggested replenishment method is a work order.

Purchasing: The suggested replenishment method is a purchase order.

The production site name.

The date the item needs to be available to meet the demand.

The total price including VAT for a single Stock unit.

The Gross price is calculated automatically from the supplier prices if the Supplier name is displayed by default. You can increase or decrease the default price per unit.

You need to enter the price per Stock unit for the item if the Gross price is zero or blank.

The Gross price is:

• Zero if you entered or selected the Supplier or changed the default or the nominated supplier to a different Supplier.
• Blank if the Supplier is blank.

The purchased item name.

The planned order date.

The default is the MRP calculation request Start date. You can select a different date.

The planned purchase quantity.

The quantity is not necessarily the same as the quantity appearing on the demand that triggered the requirement. It represents the order quantity that MRP has calculated produces the best schedule, subject to the specified item-site replenishment rules and MRP calculation request criteria.

The Purchase unit defined for the item.

The purchasing site.

The Stock unit defined for the item.

The category that defines whether the routing and/or bill of material need to be added to the work order when it's created.

The default work order category is displayed but you can change it. The list of work order categories includes those delivered by Sage and work order categories created by your organisation that identify with your production processes. The following work order categories are delivered by Sage:

Assembly: Create an assembly order. Only add the default list of components to assemble or to process the Released item at the specified Site to the work order. Do not add production operations to the work order.

Normal: Create an assembly line order. Add the default sequence of shop floor processes and list of components to build or maintain the Released item at the specified Site to the work order.

Rework: Create a production line order. Only add the default sequence of shop floor processes to rebuild or maintain the Released item at the specified Site to the work order. Do not add components to the work order.

The name of the item to be made.

The default is the Released item name. You can enter a different item name.

The planned quantity.

The quantity is not necessarily the same as the quantity appearing on the demand that triggered the requirement. It represents the order quantity that MRP has calculated produces the best schedule, subject to the specified item-site replenishment rules and MRP calculation request criteria. You can increase or decrease the suggested order quantity.

The quantity is expressed in the Stock unit defined for the item.

The name of the item to be made.

The item to be made is defined as a bill of material. The BOM status needs to be Available to use.

The planned production start date.

The default is the MRP calculation request Start date. You can select a different date.

The initial work order status.

Planned: This is the default value. You cannot track planned work orders. You can select Firm instead.

Firm: You can track production of, and component consumption for firm work orders.

The number of items to produce or purchase in a single set.

For manufactured items: The number of items to produce in a single batch run. The figure is the optimal size of the production batch.

For purchased items: The number of items to purchase in a single "lot". The figure is the most cost effective order quantity.

The item needs to be made or purchased in multiples of the batch quantity.

The minimum reorder quantity as a multiple of the Batch quantity.

The item needs to be made or purchased in multiples of the batch quantity.

This quantity is used in the standard cost calculation.

The value of the horizontal axis in the stock projections and safety level graph.

Day: Display each date included in the MRP calculations from the MRP calculation request generation date.

Week: Display the date of each Monday included in the MRP calculations.

The item to be manufactured or bought in.

The number of full weeks included in the MRP calculation forecast.

Monday is the first day of the week. If the Start date is not a Monday, the number of days from the Start date up to and including the first Sunday is calculated as 1 week.

The method the MRP calculations recommend you use to replenish stock to meet the demand.

Purchasing: The suggested replenishment method is a purchase order.

Production: The suggested replenishment method is a work order.

For manufactured items, the average number of days it takes between placing an order for the item, producing it, then receiving it into stock.

For purchased items, the average number of days it takes between placing a purchase order for the item and the receipt of the goods.

This is the default value that is applied if a lead time has not been entered for a specific supplier.

The site the item is stored at or managed from.

The date or week when the stock is due to move.

If Frequency is Day: The stock projections are daily from the MRP calculation request generation date.

If Frequency is Week: The stock projections are weekly on a Monday from the Monday of the week of the MRP calculation request generation date.

The results of the projected stock safety level needed to protect the stock item against unforeseen circumstances such as non-delivery and damaged stock in chronological order, beginning from the earliest transaction included in the MRP calculation forecast.

The bucket or week number included in the MRP calculations.

The MRP calculation request criteria Start date and Period in weeks determine the weekly buckets.

The type of demand included in the MRP calculations that creates the suggestion. Demand can be from any of the following:

Starting stock

Sales order

Sales quote

Work order components and raw materials

A blank line is the supply order when a suggestion has been generated.

Safety stock is also a demand and is included in the MRP calculations, however, as safety stock is not a "transaction" it's not displayed.

The date of demand included in the MRP calculations that creates the anticipated production or the suggested replenishment date.

Supply and demand transactions with a due date in the past are set to the MRP calculation request Start date and appear in the first weekly bucket.

The quantity from the demand transaction or the quantity generated for the supply transaction.

Starting stock is calculated from the total quantity of Accepted stock on the MRP calculation request Start date.

A generated suggestion is rounded up to the item-site Batch quantity.