Product overview

Help and User Guide maintained for Material and Resource Planning version 201x.191.0.0 and upwards


Material and Resource Planning is designed specifically for Sage 200, Sage 200 BOM and Sicon Works Orders to provide a manufacturing solution, including suggested works orders, suggested purchase orders, suggested kits (if Kitting is enabled), labour and machine capacity planning and forecast sales order import.

The outcome of running Material Planning is that suggestions are generated for both what you need to order and what you need to make. These suggestions would then need to be actioned by the relevant user to create purchase orders, kits or works orders as appropriate. Having more accurate information held on the stock item with regards to supplier details (prices, lead time, order quantities) will lead to more accurate suggestions.

Note that installing Material Planning will disable the Multiple Dates button purchase order lines. The way that Sage stores these dates and quantities against the line is not stored in a way that can be processed by Material Planning, so this button then gets disabled. This button can be restored to the purchase order lines screen via a setting in MRP Settings, but dates entered via this button will be ignored by Material Planning. For customers wanting to process purchase orders with multiple delivery dates, it is recommended that they are broken into multiple lines for items being delivered on different scheduled dates.


1. Material Planning

Material Planning can only be run by one user at a time. Previous results can be reviewed, but only for the most recent run, regardless of which user generated that run. Users do not need to come out of Sage while Material Planning is running; it’s also possible for the user running it to minimize the screen in order to use other areas of Sage while it is running. However, given that Material Planning is using current stock levels and existing orders in its calculations, if these change mid-run, then the suggestions may not reflect those changes.

Material planning is based upon calculations of stock movements on stock items.  The stock movements are basically a timeline of incoming and outgoing stock on a stock item.  When stock levels fall below certain levels, or there isn’t enough stock to meet the demand from a sales order/works order/kit/forecast, then a suggestion is raised.

The stock movements for a particular stock item can be viewed from a number of places in the Sicon Manufacturing module.  One place to view these stock movements is on a stock item in stock control.  If a stock item is amended or viewed in Sage, then there will be a button called Stock Movements at the bottom of the screen. This screen is described in the Future Stock Movements section of this guide.

Having an understanding of stock movements will help when reviewing and investigating suggestions in material planning.


1.1. Options

Material planning has a number of options which affect the results of the material plan run.  These options are grouped into a number of sections. When you run material planning and then return to this screen again, the previous settings will have been retained (they are stored per user).

At the top of the screen is a facility to select a single stock code. This will then run Material Planning to generate suggestions for that selected stock code. The Clear button in the top right hand corner will only clear a stock code from this field, it does not reset any other settings.

Below this are options split for Suggested Kits (if Kitting is enabled), Suggested Works Orders (if Works Orders are enabled) and Suggested Purchase Orders. The tick boxes that start of each of these areas allow you to choose whether to run Material Planning for any combination of these three. So if you are running Material Planning having purchased just the Distribution module, then the only section that will be displayed will be Suggested Purchase Orders. If you do not have Run suggested purchase orders ticked, then you will not get any suggested purchase orders. You may be doing this because you are only interested in suggested works orders, for example. The Suggested Purchase Orders section also has separate settings to enable suggestions for the alternate SOP fulfillment methods in Sage 200 – supplier via stock or direct delivery, so these only need to be ticked if you are wanting to generate purchase orders that will be required for these fulfillment methods.

Within the three sections, where applicable these settings are repeated allowing you to select specific settings for each section.

Warehouses: This button allows you to select which warehouses should be included for the suggestions for that relevant section. The selected warehouses are then displayed to the right of the button.

Separate suggestions per warehouse: If this option is ticked, then the demand and current stock levels would be analyzed separately for each warehouse that was enabled via the Warehouses button. So if you were to run Material Planning for three warehouses, warehouse A would be looked at in isolation from warehouses B and C. If you don’t have this option ticked, then their current levels and demands would be grouped together. So you may have a sales order that needs stock from warehouse A where there isn’t any currently, but enough stock for it in warehouse C. In this scenario, potentially no suggestion would be generated as there could be enough stock in the three warehouses combined.

Group suggestions within: This drop down lets you select from ‘Never’, ‘1 week’, ‘2 weeks’, ‘1 month’ or ‘All’. This enables you to group suggestions together if they fit within the selected timeframe, i.e. two sales orders need the same stock item and they are scheduled to be dispatched within a couple of days of each other. Grouping within 1 week would combine them onto a single purchase/works order suggestion. Grouping will have the effect reducing the number of works orders and purchase orders suggested. Caution may need to be exercised with the ‘All’ option if you have demand loaded for the future (i.e. a sales order or forecast for many months’ time) and don’t mean to combine that with demand for the same item now.

Enable rescheduling: Ticking this box will cause Material Planning to look at existing works orders and purchase orders to see if they can be rescheduled to fit current demand (this option does not apply to Kitting). This will only look to pull forward existing orders if the supplier/production lead time is such that it could be possible; it does not suggest that current orders can be rescheduled to move them to later dates. This option will cause an additional column to be added to the Stock Movements screen to display the suggested reschedule date of the particular purchase or works order.

Group subassemblies: This setting only applies to suggested works orders, and is enabling you to indicate whether you wish to group all demand for subassemblies onto single works orders per subassembly. So if you have a common subassembly across multiple products, do you want a combined subassembly works order that will make enough of that subassembly item in order to fulfil all of the parent works orders that will need it. Alternatively, you would potentially get multiple works orders for the same subassembly, linked to their parent works orders independently of each other.

Enable warnings: This setting will enable warning messages to be displayed in the results of Material Planning advising if existing purchase/works orders will not arrive in time for the demand, based on the supplier lead time/production lead time.

Stock level options: This drop down allows you to select from ‘Ignore current stock’, ’Use minimum stock levels’, ‘Use reorder levels’ or ‘Maintain zero’. If you choose ‘Ignore current stock’, then Material Planning will generate suggestions to fulfill all current demand, ignoring whatever you currently hold in stock. Otherwise, the other three choices form the target level which Material Planning is aiming to keep your stock at once all current demand is fulfilled. These are either the minimum level, the reorder level or zero. If you are using the facility in the Distribution module to Calculate Min Stock Levels, then you would use the minimum stock level option when running Material Planning.

Allow over ordering: This option allows Material Planning to generate suggestions that could result in you having more stock than you require due to existing orders on the system. As an example, you have a purchase order due for delivery in several weeks’ time, but some immediate demand has entered your system. If the supplier lead time is short and you enable this setting, then Material Planning would generate an additional suggestion for this new demand, even though once the original purchase order arrives you will then have more than you need. Rather than enabling this setting, it may be preferable to enable the rescheduling option to generate rescheduling suggestions rather than additional orders. See the Over Ordering section of this guide for more information.

From/To Date: These enable you to enter a date range, and have Material Planning only analyze demand within this date range. If you enter one of these dates and leave the other one empty, then either all demand from or to the entered date will be analyzed.

Exclude existing…: This would ignore existing kits/works orders/purchase orders when making suggestions in these areas. So all of the demand would be assessed against the relevant stock level option and then suggestions generated regardless of current kits/works orders/purchase orders.

There are additional options that can be enabled in the MRP settings; please see the later section on the Material Planning tab in MRP Settings for details.

Once the options have been selected, the Run button can be selected.

The Show Previous Results button will display the previous results generated from the last material plan run, which could save time if you want to revisit suggestions yet to be actioned and don’t need to run the process again. This is not stored per user, so will display the results generated on the last run, regardless of who ran it and what options they used.


1.2. Results

The Material Planning run may take a short while to complete, but the progress will be indicated on the left.  You can run Material Planning while other users are in the system, but be advised that if new sales orders or purchase orders are being entered/amended while Material Planning is being run, then the resulting suggestions may change depending upon where it had got to at the time. It is also possible to minimize Material Planning while it is running if you need to be doing something else.

The Results of Material Planning are displayed on multiple tabs, depending upon which modules you have enabled and which options were selected when running it.

These tabs are: – Warnings, Reschedule Messages, Suggested Kits, Suggested Works Orders, Suggested Purchase Orders, Suggested PO (Supplier) and Suggested PO (Direct).


1.3. Warnings Tab

A list of warnings is displayed on the Warnings tab if the Enable warnings options were selected. Warnings such as purchase orders not arriving on time or works orders that may not be built on time, are displayed in this list.

To drill down on a warning item, the user can double click on an item to display the Stock Movements screen. From this screen you could view any existing orders, but you would need to exit Material Planning to go to the relevant module to amend any dates against them.

The warnings can be sorted by clicking on the column headers.


1.4. Reschedule Messages Tab

Rescheduling suggestions are displayed on the Reschedule Messages tab if the Enable rescheduling options were ticked.

Note that currently reschedule messages are only triggered for items that require a suggestion. So you won’t see any rescheduling messages for items where demand is not suggesting either works or purchase orders.

The reschedule messages can be sorted by clicking on the column headers.


1.5. Suggested Kits Tab

The Suggested Kits tab displays a list of suggested kits for stock items that have a kit designed for them that have a demand (either for sales orders/forecast and based on stock level options). These suggestions can be filtered using the filters at the top of the screen. Filters can be used for: –

  • Stock Item – the stock code of the kit item
  • Product Group – the product group that the kit item belongs in
  • Warehouse – the warehouse suggested for where the kit is built
  • Date from – the earliest date required for the kit suggestions
  • Date To – the latest date required for the kit suggestions
  • Reason – you can enter in some text here to search the Reason column, such as sales order number

The Kit suggestions can be sorted by clicking on the column headers.

Suggested kits are generated with a reference number beginning with SKIT, so that if any purchase orders are suggested for these kit suggestions, then this reference number will appear against the purchasing suggestion to explain the demand. The Date Required column will display either the Promised Delivery Date from the sales order, or else the date of the forecast as applicable. If the suggestion is to build a kit because of falling below the selected stock level, then the Date Required will be either the current date (if the current free stock level is already below this level) or the date at which the kit needs to be made.

The reason for the suggestion is displayed in the Reason column on the right hand side.

Highlighting a suggestion and then using the buttons at the bottom of the screen enable you to: –

<<< Shrink the column on the left to give more room to display the suggested kits
Monthly Trading Figures Open the Sage View Monthly Trading Figures screen for the Kit Item Code
Stock Item Balances Open the Sage View Stock Item Balances screen for the Kit Item Code
Stock Item Details Open the Sage Amend Stock Item Details screen for the Kit Item Code
View Details Open the Sicon Future Stock Movements screen for the Kit Item Code. This screen will detail why the suggestion has been made

Once you are satisfied with the reasoning behind the suggestions, you can use the Create Kits button in the bottom right hand corner to create the kits. A prompt will appear asking if you wish to amend the kits after they have been generated. You only need to tick the ones that you wish to immediately amend, the kits will still be created for the ones that you don’t select, once you click the Create button.

Clicking Cancel on this prompt will stop the kits from being generated at this time.

Once a kit has been created, then the suggestion will be removed from this screen.


1.6. Suggested Works Orders Tab

The Suggested Works Orders tab displays a list of suggested works orders for stock items that are set as built items and that have a demand (either for sales orders/forecast and based on stock level options). Suggested works orders are generated with a reference number beginning with SWO, so that if any purchase orders are suggested for these works order suggestions, then this reference number will appear against the purchasing suggestion to explain the demand. If the suggested works order has also triggered a subassembly suggestion directly for it, then it will be grouped together with the original suggestion, and these suggestions can be expanded by clicking the plus symbol to the left of the item code. As with normal works orders, linked subassembly suggestions with have the same suggestion reference number as their parent works orders, with the addition of a slash followed by a number to signify which level and number this suggestion has.

If you see an item name underlined and in blue text, this means that a works order comment has been recorded against this finished stock code, via the Works Order Comment field on the Comments tab on the stock item record. You can click on the underlined item code to see the works order comment displayed in a new window that will be displayed.

These suggestions can be filtered using the filters at the top of the screen. Filters can be used for: –

  • Stock Item – the stock code of the works order finished item
  • Product Group – the product group that the works order finished item belongs in
  • Warehouse – the warehouse suggested for where the works order is built
  • Due Date from – the earliest due date for the works order suggestions
  • Due Date to – the latest due date required for the works order suggestions
  • Reason – you can enter in some text here to search the Reason column, such as sales order number

The Works Order suggestions can be sorted by clicking on the column headers.

The Line Quantity column can be edited if you wish to amend the quantity against a suggestion before generating the works order. You can also edit the warehouse for the finished product on this suggestion, and the start date and due date of the works order.

The Due Date column will display either the Promised Delivery Date from the sales order, or else the date of the forecast as applicable. If the suggestion is to build a works order because of falling below the selected stock level, then the Due Date will be either the current date (if the current free stock level is already below this level) or the date at which the works order needs to be made.

The unit of measure used for the suggestion is taken from the stock unit of measure, unless one has been specified within the Production Unit of Measure field on the WOP/MRP section of the Sicon tab on the stock item. If one has been specified, this will be used instead of the stock unit of measure.

The reason for the suggestion is displayed in the Reason column on the right hand side.

Highlighting a suggestion and then using the buttons at the bottom of the screen enable you to: –

<<< Shrink the column on the left to give more room to display the suggested works orders
View Details Open the Sicon Future Stock Movements screen for the works order finished Item Code. This screen will detail why the suggestion has been made
Stock Item Details Open the Sage Amend Stock Item Details screen for the works order finished Item Code
Stock Item Balances Open the Sage View Stock Item Balances screen for the works order finished Item Code
Monthly Trading Figures Open the Sage View Monthly Trading Figures screen for the works order finished Item Code
Send To Excel Due to the functionality of this tab letting you expand and collapse the subassembly structure to the works order suggestion, you can’t right click and send the list of suggested works orders to Excel in the standard Sage way. If you click this button, then a prompt will appear asking if you want the subassemblies also sending to Excel, and then it will open Excel with the list of suggestions.
Calculate If you click this button, then an extra column appears after the Line Quantity column. Once it has calculated this against each suggestion, it will display a date that would be the earliest date that you could make this item with the current stock situation, based on component free stock and future movements.

Once you are satisfied with the reasoning behind the suggestions, you can use the Create Works Orders button in the bottom right hand corner to create the works orders. A prompt will appear asking if you wish to amend the works orders after they have been generated. You only need to tick the ones that you wish to immediately amend, the works orders will still be created for the ones that you don’t select, once you click the Create button.

Clicking Cancel on this prompt will stop the works orders from being generated at this time.

Once a works order has been created, then the suggestion will be removed from this screen.


1.7. Suggested Purchase Orders Tab

The Suggested Purchase Orders tab displays suggested purchase orders raised to meet demand from sales orders, forecasts, kit component lines, suggested kit component lines, live works order component lines, suggested works order demand component lines and the selected stock level option.

These suggestions can be filtered using the filters at the top of the screen. Filters can be used for: –

  • Stock Item – the stock code of the works order finished item
  • Product Group – the product group that the works order finished item belongs in
  • Warehouse – the warehouse suggested for where the works order is built
  • Purchase Ledger Analysis Code 1 – The first analysis code setup for supplier accounts, in the above screenshot it is called Discount Band
  • Supplier – The supplier account number of the supplier that the purchase orders are suggested for
  • Short Name – The short name of the supplier that the purchase orders are suggested for
  • Postcode – The postcode of the supplier that the purchase orders are suggested for
  • Reason – you can enter in some text here to search the Reason column, such as sales order number
  • Requested Date from – the earlier requested delivery date for the purchase order suggestions
  • Requested Date to – the latest requested delivery date for the purchase order suggestions
  • Create Date from – the earliest order date for the purchase order suggestions
  • Create Date to – the latest order date for the purchase order suggestions

The Purchase Order suggestions can be sorted by clicking on the column headers.

The PO Create Date column is the date that MRP is suggesting that the purchase order needs to be raised. So all suggestions with the current date displaying in this column should be reviewed today. Suggestions with a date in the future can be generated now, it doesn’t mean that they will arrive sooner than required as the Date Requested will show the supplier when you require these items to delivered. The supplier lead time is displayed in days in the next column, and this is the number of working days between the Date Requested for the suggestion, and the PO Create Date column. The Date Requested column will display either the Promised Delivery Date from the sales order, or else the date of the forecast or the due date of the works order as applicable. For suggestions to get you back to your stock level, this date will be the earliest date possible if you are currently below that level, or the date at which you will drop below that level. For information purposes, the supplier part number is also displayed (if set on the stock item), as well as the manufacturer.

The quantity displayed is how many you need to be ordering, in the unit of measure displayed in the next column. This unit of measure is either the stock unit of measure, or the Purchasing Unit of Measure selected on the WOP/MRP section of the Sicon tab on the stock item.

The warehouse column shows you the warehouse where the stock is required, followed by columns displaying the Free Stock Quantity, the Allocated Stock Quantity and the Quantity on Order for that warehouse.

Then the preferred supplier is displayed, followed by their currency. The Unit Price is either derived from the supplier information on the stock item (i.e. List price or Last Buying price). Alternatively, a price could be shown here that comes from the most recent purchase order for this stock item if no supplier has been setup for the stock item, or failing that, the average buying price. The Unit Price from column explains where it has derived the Unit Price displayed from.  The Month To Date, Year To Date and Last 12 Months columns show your usage of this item in these date ranges. The reason for the suggestion is in the last column.

The user has the ability to change certain values in the list against each suggested purchase order, before generating the purchase order.  These are Date Requested, Quantity, Warehouse, Supplier and Unit Price. When changing the supplier, it is possible to select from any supplier in the Purchase Ledger; the accounts listed immediately at the top of the list will be the suppliers set on the stock item.

Highlighting a suggestion and then using the buttons at the bottom of the screen enable you to: –

<<< Shrink the column on the left to give more room to display the suggested works orders
View Details Open the Sicon Future Stock Movements screen for the Item Code. This screen will detail why the suggestion has been made
Stock Item Details Open the Sage Amend Stock Item Details screen for the Item Code
Stock Item Balances Open the Sage View Stock Item Balances screen for the Item Code
Monthly Trading Figures Open the Sage View Monthly Trading Figures screen for the Item Code

Purchase orders can be generated by ticking the suggested purchase order line(s) and then selecting the Create Purchase Orders button. A prompt will appear asking if you wish to amend the purchase orders after they have been generated. You only need to tick the ones that you wish to immediately amend, the purchase orders will still be created for the ones that you don’t select, once you click the Create button.

Suggested purchase orders for the same supplier that are being generated at this point will be grouped together onto the same purchase order, if they are being delivered to the same warehouse.

If pre-allocations are enabled, the system will prompt for each item being purchased if you want to accept the pre-allocations for the new purchase order to the demand that requires it. If you tick the box on the bottom of this window labelled as Accept pre-allocation recommendations, then these pre-allocations will be automatically created without needing user confirmation. There is also a checkbox allowing you to indicate that landed costs should not apply to these items.

Alternatively, if you are using Sicon WAP, a Create Requisitions for WAP button is available which will post the selected suggestions into WAP as requisitions requiring authorization before they can be posted as purchase orders into Sage 200. After reviewing the confirmation window, click the Create button to proceed, or Cancel to return to the list of suggested purchase orders without posting this suggestion into WAP.

Once you have created the purchase orders or WAP requisitions, then the relevant lines will disappear from the list on the Suggested Purchase Orders tab, so you are only viewing suggestions that have not yet been actioned.


1.8. Suggested PO (Supplier) Tab

This tab only appears if you have selected the Run suggested supplier via stock purchase orders option on the Options tab when running Material Planning. It will display any suggested purchase orders that need to be generated to fulfil sales orders using the Sage from supplier via stock fulfilment method.

If any suggestions appear here, they can be reviewed and actioned using the same methods outlined in the Suggested Purchase Orders Tab.


1.9. Suggested PO (Direct) Tab

This tab only appears if you have selected the Run suggested supplier via stock purchase orders option on the Options tab when running Material Planning. It will display any suggested purchase orders that need to be generated to fulfil sales orders using the Sage from supplier direct to customer fulfilment method.

If any suggestions appear here, they can be reviewed and actioned using the same methods outlined in the Suggested Purchase Orders Tab.

Exiting Material Planning

When closing Material Planning, you will see a box displayed that prompts warning that any changes will be lost. This refers to any ticks you have recorded against any suggestions, but not yet actioned. If you continue and then re-open Material Planning, then all outstanding suggestions will be unticked.

All previous suggestions from the current run can be displayed again on re-opening Material Planning via the Show Previous Results button.


1.10. Stock Item Settings

There are stock item settings on the WOP/MRP section of the Sicon tab when amending a Stock Item in Stock Control.  These settings can relate to material planning and override options set within the Options tab of Material Planning.

Default Production Lead Time: This setting is relevant for built items, and adds a number of days to the date calculation on works orders. So if this was set to 4 days, then works order suggestions would be dated 4 working days before the date of the demand.  This acts as an override for any calculations that would be done based on the operations on the works order.

Default Supplier Lead Time: This setting is relevant for purchased components, and adds a number of days to the date calculation on purchase orders. It’s overridden by a supplier lead time being set on the relevant supplier entry on the Suppliers tab, so was intended for situations where supplier information was not being recorded on the stock item.

Make/Buy/Make or Buy: This setting only applies to stock items that have templates defined for the within Works Order Processing. So this setting is not relevant to items that are marked as being built items and have a bill of material defined for them.

Currently, Material Planning doesn’t prompt for the Make or Buy question when you run it, so you would need to change the option in the Preferred box before running Material Planning if desired.

When adding this item to a Works Order: This setting enables you to have a specific option set for this stock item that would override the default set in Works Order settings. It would only be relevant for a built item that is used as a sub-assembly. The choices are either to always create a sub-assembly, to always take from free stock if possible, or to choose via a prompt that will be displayed.

Group Suggested Purchase Orders: When running Material Planning, in the Options tab you can specify the date options to Group Selections Within for purchase orders. This setting would act as an override to that option for this stock item.

Add extra quantity setting activated: If this option is ticked, when works orders are suggested for this stock item then an extra quantity will be added to the finished quantity, to reflect the fact that additional product needs to be manufactured for testing purposes. The quantity added can be changed via the All Settings button within Works Order Settings, with the value being recorded on the setting with description of AddExtraQuantityWhenBuildAmount. Note that this setting is not stock code specific, so for stock items with this setting activated, they will all add the same quantity.

Economical Batch Size: For a built item, this size setting is the production quantity that a suggestion for a works order can be for this item. So if there was a demand for 3 of an item, but this field was set to 20, then the suggested works order would be for 20. If you needed more than 20, then the suggestion would be for 40, and so on.

Split by economical batch size: If you enable this and you have entered an economical batch size, then any suggestions for works orders would be split by the economical batch size. So a demand for 50, with an economical batch size of 20 would create three works orders for 20 each.

Do not round up last works order to economical batch size: If you have an economical batch size and the previous setting also enabled, then the final works order suggestion would be just for the remaining quantity, rather than for the economical batch size. So as per the example on the previous setting, you would have three works orders suggested, two for 20 and the third for 10.

Ignore free stock quantity in Material Planning: If this option is enabled for this stock item, then when running Material Planning, the stock level options setting selected on the Options tab of Material Planning would be overridden for this stock item to use Ignore current stock.

Ignore existing purchase orders in Material Planning: If this option is enabled for this stock item, then all existing purchase orders for this item will be ignored, overriding the setting on the Options tab for this stock item.

Do not include item in Material Planning: If this option is enabled, then this stock item will be ignored entirely by Material Planning.

Bulk Issue Item: This setting enables you indicate that this stock item should be treated as a bulk issue item. Bulk issue items appear as components on a works order, but are not allocated or issued to the works order itself, so do not feature in the costs of the finished item. They are items that no-one would actually pick (so are excluded from the picking list), such as low value items like glue or screws, but need to appear on the works orders so that Material Planning registers a demand against them.  When the works order is booked in, any bulk issue item components have their quantities on the works order set to zero.

Do not include in subcontract lists: This setting means that this stock item will not appear as an item available for selection when managing items being dispatched to subcontractors on a works order, via the Sub Contract tab.

Default component warehouse: Enables you to select a warehouse that should be used as the default component warehouse on suggested works orders for this stock item as the finished item.

Default finished item warehouse: Enables you to select a warehouse that should be used as the default finished item warehouse on suggested works orders for this stock item as the finished item.

Production unit of measure: Enables you to select the unit of measure that should be used for the finished item on suggested works orders from Material Planning for this stock item.

Purchasing unit of measure: Enables you to select the unit of measure that should be used for suggested purchase orders from Material Planning for this stock item.

On adding line to works order round quantity up to: When adding this item as a component on a works order, this option allows you to specify how many decimal places the value entered will be rounded to.

Round up purchasing quantity to: This setting allows you to specify the number of decimal places the value on a suggested purchase order for this stock item will be rounded to.

Label template: You can specify a label file that will be used for this stock item when printing labels.


1.11. Over Ordering

The Allow over ordering setting is available on the Options tab during the material planning process.  These options are used when generating suggested purchase orders and suggested works orders.

This setting enables you to indicate whether you want Material Planning to make a suggestion where you have existing works/purchase orders already in your system that do not fulfil some earlier demand on the date that needs it. This setting works alongside the settings for Enable rescheduling and Enable warnings to give you different options as to how you want to handle these situations.

If you run Material Planning with both over ordering and rescheduling suggestions enabled, then rescheduling suggestions will override the over ordering suggested works/purchase orders, preventing them from being suggested.

There is an option to allow over ordering for suggested works orders as well.  This is a separate option within the Options tab in Material Planning in the suggested works order section.  The theory for allowing over ordering for suggested works orders is the same as over ordering for suggested purchase orders.

The minimum order level and/or usual order quantity may affect the quantity on the suggested purchase order (if set on the preferred supplier), thus increasing stock levels even if Allow over ordering is not selected.

With the Allow Over Ordering setting enabled, and existing works/purchase orders arriving too late for the demand, if the lead time of the production/supplier was short enough to arrive in time, then an extra works/purchase order would be suggested to get the stock here in time. The end result of all of the stock movements would then result in you having too much stock – hence the setting being called Allow Over Ordering.

If the allow over ordering setting is not enabled, and if a later existing works/purchase order would fulfil the demand, and leave you on or above your selected Stock level option (e.g. minimum stock), then no suggestion would be made. Depending upon your warnings and rescheduling settings, you may receive either a warning informing you that the existing works/purchase order could not be made/arrive in time, or a rescheduling message advising that the existing works/purchase order could be pulled forward.

Note that even without having this setting enabled, it is still possible to receive suggestions that result in you having too much stock at the end of all of your stock movements. This is due to the fact that if a suggestion is triggered to meet some demand, then the quantity of that suggestion will be enough to fulfil that demand all by itself. Existing later works/purchase order quantities are not used to reduce the quantity of this new suggestion, if it has been triggered.

The default selection for this option is Off.

The following examples are for suggested purchase orders.  However, the theory is the same for suggested works orders.


1.12. Example when Over Ordering is turned On

In the following screenshot, a suggested purchase order is generated on the 26/04/2019 to meet the demand of sales order 0000005333.  However, there is an existing purchase order due to arrive on 13/05/2019, which results in a final stock level above the minimum stock level.  This purchase order is after the due date of the sales order, so the suggested purchase order is suggested in order to keep the stock level at or above minimum on 26/04/19. If the lead time of the supplier meant that the suggested purchase order couldn’t arrive earlier than the existing purchase order, then the suggestion would not have been made.


1.13. Example when Over Ordering is turned Off

In the following example, no suggested purchase order is generated for sales order 0000005333, because purchase order 0000003446 will push the stock level back to the minimum stock level; even though the purchase order is after the due date of the sales order.

A warning will be generated on the Warnings tab stating that the purchase order may not arrive on time, if the option for Enable warnings is selected when Material Planning is run.

If the option for Enable rescheduling is selected when Material Planning is run, then the Stock Movements results would be displayed with the newly calculated Reschedule Date, and the Rescheduling suggestion would be displayed on the Reschedule tab of the Material Planning results. In the screenshot below, due to the supplier lead time it is possible to reschedule the purchase order to the date that it is needed, so the suggestion is that the purchase order should be amended to change the requested delivery date to 26/04/2019.

NB: if the stock item is required for a works order, the item will show in the expediting report and will show in red or amber if stock may not arrive on time to fulfil the demand.


1.14. Example of too much stock when Over Ordering is turned off

It is possible to have suggestions that result in a final stock level figure that is above the selected stock level option once later existing purchase orders have arrived. In the following example, sales order 0000005333 requires 30 of this product on 26/04/19k, and we have 13 in stock at this time. There is an existing purchase order for 10 due to be received on 13/05/19. As the total result of these movements would be a final balance that is below our minimum stock level (it would end on minus 7 without any suggestion), then a suggestion is made for a new purchase order. As a suggestion has been triggered, this suggestion is for the full amount required to get us back to our stock level option (minimum stock), regardless of the quantity arriving a month later. So the total outcome of these movements would be to leave us with 10 in stock, which is above our minimum stock level.


1.15. Suggestion Dates

The dates that are used for generating the suggestions are based on the date of the demand. For a sales order line, this is either the promised delivery date or the expected dispatch date if different. The Expected dispatch date is the requested delivery date less the delivery buffer, which is either read from the default delivery buffer setting in MRP Settings or uses the buffer specified on the MRP tab of the customer account.

Demand dates for forecasts are the date of the forecast; demand dates for works order components are the start date of the works order. Demand dates for kit components are either the promised delivery date of the sales order line that the kit is linked to, or the current date if the kit is not linked to a sales order line.

Dates will be further influenced by production lead time in the case of suggested works orders, or supplier lead time in the case of suggested purchase orders.


2. Suggestion Quantites


2.1. Settings that Affect the Quantity of a Suggested Works Order

Stock level on the warehouse: If suggested works orders are generated for meeting minimum stock requirements, then raised suggested works orders will bring the stock level of the BOM stock item back up to the minimum stock level. Alternatively, you may be running Material Planning working from the Reorder level instead, or maintaining a stock level of zero.

NB: If stock levels are ignored for suggested works orders, then the above rule is ignored.

 

Economical batch size: The quantity of a suggested works order will always be a multiple of the economical batch size if the economical batch size is set.

Round quantity up to: This affects the component demand from a suggested works order.   Component demand lines from suggested works orders could be rounded up if the Round quantity up to settings is set on the relevant stock item.

Add extra quantity setting: This affects the component demand from a suggested works order.  The quantity of component demand lines from suggested works orders could be increased if the Add extra quantity setting is set on the stock item.  The amount of increase depends on the AddExtraQuantityWhenBuildAmount setting in Works Order Processing Settings.


2.2. Settings that Affect the Quantity of a Suggested Purchase Order

The rules below are applied to suggested purchase orders when running Material Planning:

Usual order quantity on preferred supplier: The quantity of a suggested purchase order will be a multiple of the usual order quantity of the preferred supplier.

Minimum order quantity on preferred supplier: The quantity of a suggested purchase order will be above the minimum order quantity set on the preferred supplier.

NB: If no preferred supplier is set on the stock item, then the above two rules will be ignored.

Stock level on the warehouse on the stock item: If Material Planning is set to use minimum stock levels when generating suggested purchase orders, suggested purchase orders will be raised if the quantity of the stock item will fall below the minimum level on the warehouse.  The quantity for the raised suggested purchase order will bring the stock level back up to the minimum level. Alternatively, you may be running Material Planning working from the Reorder level instead, or maintaining a stock level of zero.

NB: If stock levels are ignored for suggested purchase orders, then the above rule is ignored.


2.3. Warehouse Selection

If multiple warehouses are selected when running material planning, then the minimum/re-order stock levels on the warehouses for a stock item are added together.  Therefore, suggested works/purchase orders will be raised to bring stock levels up to the combined minimum/re-order stock level. If you do not wish the suggestions to be made with the warehouses combined, then you need to select the option to Separate suggestions per warehouse.


3. Previous MRP Results

The Show Previous Results button will display the previous results generated from the last material plan run, which could save time if you want to revisit suggestions yet to be actioned and don’t need to run the process again. This is not stored per user, so will display the results generated on the last run, regardless of who ran it and what options they used.


4. Capacity Plan

The tabs in the Capacity Plan are designed to assist you with managing your operations and your works orders in general. They provide a rough graphical representation of your scheduled works order operations in comparison with your availabilities of those resources, and can let you know when teams are overloaded. Operations can also be rescheduled by dragging them in a diary style view.

This screen is made up of seven tabs: – Rough Cut, Department Work Schedule, Overdue, Overloaded, Teams, Operations and Works Orders.

The Teams, Operations and Works Orders tabs all display a diary style view. At the top of these screens are the following icons:

The green arrows are used to step the dates forward or backward by the time selected as the displayed range. To the right of these are a go to today button, and then zoom in and zoom out buttons (which affect the rows displayed for time intervals when viewing single days or working weeks). The print button generates a printout of the current view.

Four views can be selected using the next icons, either Day View, Work Week View, Week View and Month View. Week and Month views do not display the time against the rows. The options to the right of these are Timeline View, which plots appointments in relation to time, and Gannt view, which is an alternative view with more days on it.

For the day and work week views, you can change the time scale between 60, 30, 15, 10, 6 and 5 minutes using the icon to the left of the wording of Time Scale Captions.

Auto Refresh can be enabled in these screens, and you can set the refresh interval in seconds.

A common feature about these screens is that when you are moving between dates in the main diary window, vertical bars displayed on the left and right of the displayed days will highlight in bold if either Previous or Next entries have been detected in the current view. This helps you to find the entries by scrolling to the left or right as appropriate.


4.1. Rough Cut

The Rough Cut screen lets you see how your available labour and machine resources capacity compare to the demand that has been scheduled for them. The screen has an overview graph at the top, which is then followed by separate graphs for each team. Each of these separate graphs has its own Refresh button, and clicking these will populate the relevant graph. A Refresh All button at the bottom of the screen will populate all of them.

The date ranges displayed in the graphs can be adjusted using a start date and number of weeks to display from there. These options are located above the Overview graph. The results can be moved a week forward or back by using the ‘<<‘ or ‘>>‘ buttons.

Labour demand and availability is shown in blue and red.  Machine demand and availability are shown in green and purple. If demand exceeds availability on any day, then this counts as an overload.

Availability is calculated using the work pattern defined on the relevant team multiplied by the number of people/machines in that team. If any absences or holidays have been recorded against the employee in a timesheet, then these entries will be deducted from their availability on the relevant day.

To drill down for a demand column on a particular day, double click on the relevant Demand column.  A list of works orders will be shown, which relate to the demand on that particular day. An Edit Works Order button is available at the bottom of the screen if you wish to change the dates on any of these works orders.


4.2. Department Work Schedule

The Department Work Schedule tab allows you to view boxes each displaying a list of current works orders based on their due dates. The three lists are split as Overdue, Due This Week and Due Next Week Onwards. When you first click on this tab, you will see all current works orders displayed but these can then be filtered by Job Manager or Area using the filter in the top right.

Against each works order displayed you can edit information in the following columns: –

Hours to Complete – You can enter an estimate of how much time is left to do on this works order

Job Manager – You can choose from your employee list to designate who is supervising the works order

Comments – You can update the Works Order Comments field

A Save button is available at the bottom of the screen to save any changes made.

The Print button will generate a list report of all current works orders showing their due dates, hours remaining and Job Manager.


4.3. Overdue

This tab gives you a list of all current works orders that are passed their due date.

The Edit Works Order button at the bottom takes you straight to the Amend Works Order screen for the selected works order.


4.4. Overloaded

When you click on this tab, a scan is performed of all current demand on your resources to see if there are any days where any resources are overloaded. You could then review this date on the Rough Cut tab for the relevant team to see the demand causing the overload, and potentially reschedule it.


4.5. Teams

With this screen you can view the operations that are scheduled against each team. Using the box beneath the calendar box, you can select which teams you wish to view.

If you select multiple teams, then each team will have its own row, which will be shaded with a different colour. Operations can be rescheduled in this screen by dragging them around on the relevant days. You may wish to use the view options above the diary to change the display if you need to work with the times that the operations are scheduled for.

Currently there is no link between the works order dates, and the dates of the operations on those works orders, so moving operations around will not update the works orders dates and vice versa.

If you double click on an operation entry, then the Maintain Operation window will appear if you wish to amend anything on that operation. This window will also display the relevant works order number at the top if you need to know which works order this operation relates to.


4.6. Operations

This screen will display the remaining time on operations after you have selected the relevant works orders from the box on the left hand side (or clicked Select All beneath it). There can be a slight delay while this diary is populated, so you may need to use the scroll bar to move around a little to see the operations as they populate the screen. Completed operations will not appear on this screen, so this can be used to monitor what is outstanding.

The colour that the operations appear with can be defined in the Scheduler Colour Maintenance screen, depending upon the phase that the operation has been defined against. Alternatively, if colours have been applied to operations via the use of Manufacturing Attributes on the Additional Information tab of a works order, then they will be displayed in that colour instead.

Operations can be rescheduled in this screen by dragging them around on the relevant days. Currently there is no link between the works order dates, and the dates of the operations on those works orders, so moving operations around will not update the works orders dates and vice versa. Note that if works order operations were originally combined on the same operation on the BOM as they have multiple resources against them, then they remain linked here. This means that if you move one of them on this screen, then the other linked operations will also move with them.

If you double click on an operation entry, then the Maintain Operation window will appear if you wish to amend anything on that operation. This window will also display the relevant works order number at the top if you need to know which works order this operation relates to.


4.7. Works Orders

This screen displays your works orders, using the start dates of the works orders and the due dates. To see them displayed on the screen, tick the Works Orders checkbox on the left hand side. There can be a slight delay while this diary is populated, so you may need to use the scroll bar to move around a little to see the works orders as they populate the screen. Note that this screen differs from the previous two in that they display operations, while this one will just have a single entry for each works order. Works Orders can be rescheduled in this screen by dragging and dropping them. Doing this will also update any operations on those works orders to reflect the new start and finish times.

The colour of the works order will be dependent on its status: –

New = Green

Part Allocated = Red

Allocated = Orange

Part Issued = Purple

Issued = Blue

Completed = Yellow


5. Future Stock Movements

This screen is also available from within Material Planning, and via the Stock Movements button on screens such as View Stock Item. Its purpose is to summarize all future expected stock movements that will impact your free stock level in the selected warehouse(s). As it is working with free stock, once stock is allocated (e.g. to a sales order), that demand will not be displayed in this screen as the starting Free Stock figure will already have taken this into account.

The stock movements will start with the Free Stock figure and then have a running total downwards, by date, displaying the resultant balance.  Each line can be drilled into by double clicking the line.  Some lines may be works orders, some sales orders and others purchase orders.

The Reschedule date column will only be accurate if the previous run of Material Planning had the option of Enable Rescheduling selected. If so, then this stock movements screen will be sorted in reschedule date order. Note that the Reschedule date is only provided for information purposes, the intention is that the user would update the dates on the relevant works order/purchase order to the reschedule date manually if they have confirmed that it can be rescheduled.

If you have selected the Include suggestions from last MRP run, then there may also be lines for suggestions from material planning or component demands from other works order suggestions.  These will be identifiable on the details columns by the fact that they will be preceded with the letter S.

The Warehouses button can be used to filter the screen to reflect movements for the selected warehouse(s), and beneath this are From and To date options to filter for a selected date range.

The fields displayed in the Stock Item Quantities section are totals based on the warehouses selected, while the supplier information is pulled through from the preferred supplier (if any) on this stock item. The Earliest date suggested purchase order can arrive based on lead time displays a date calculated based on current date plus lead time in working days.

The fields displayed in the Summary section are populated when you click on a sales order line in the Stock Movements window, and display the relevant information from that sales order.

The Delivery buffer days looks at either the default delivery buffer set in Material Planning Settings or the Customer delivery buffer on the MRP tab of the customer details (if populated) to calculate an Expected dispatch date for that sales order. This is the date that Material Planning will be using to aim for with regards to fulfilling demand for that sales order.

The buttons at the bottom of the screen provide access to the standard Amend Stock Item Details, Stock Item Balances and Monthly Trading Figures screens. Immediate access to the amend stock item details screen is very useful if this screen is displaying information related to the stock item supplier that needs to be updated.

The final button lets you open another window displaying the same information in a format where you can right click and send it to Excel. This is not available within the main window due to how the data is formatted.


6. Stock Running Balance

This screen displays predicted balances against stock items going forward. You can specify the warehouses that you want to include, filter for one or more product groups and select how many months to look ahead.

The information presented in here is effectively the same as from the Future Stock Movements screen but presented in a different format and giving you closing figures for each month selected. The Stock Movements button at the bottom of the screen will take you to that screen.


7. Forecasts

Forecasts can be entered into the system to reflect expected sales orders and create demand for them. As actual sales orders are placed, then this forecast can be reduced via a prompt displayed when the order is saved, if this option is enabled in  MRP Settings. Without this setting being selected, it is important to consider that once an order has been received, the correct procedure is to remove the forecast manually from this screen, otherwise the demand from the forecast and the order will be combined in the next run of Material Planning.

If you have already planned your own production plan outside of Sage, then you could import that production plan as a forecast, and this would then create purchase order suggestions based on the suggested works orders to match your production plan. You wouldn’t have to create these works orders suggestions at this time if you didn’t want to, but if you have a long lead time against some of your components, then this process would help you ensure that you are placing your purchase orders early enough to match your production plan.

Add, Edit and Remove buttons allow you to manually create or update existing forecasts.

Note that a forecast does not need to have a customer account selected against it. The other fields are all required though, being the date that the demand is required for, the item code or name, the quantity and the warehouse where you require the demand. These can all be edited for an existing forecast via the Edit button on the previous screen.

You can import forecasts via the main Forecast screen.  Imported forecasts will be added to the bottom of previous forecasts, not overwrite them.  Select the forecast csv file using the browse button (the ellipsis button) and then select the Import button to import the forecasts. The csv needs to be formatted into the same columns that you can see in the main window (Customer (optional), Date, Stock Item, Quantity and Warehouse).

To delete all forecasts, select the Delete All Forecasts button, or individual forecasts can be selected and then deleted with the Remove button. If you want an import to not be added to the bottom of any current entries, then you can simply delete them via the delete all button before importing your new forecast.


7.1. Reducing Forecasts on Sales Order Entry

If you have enabled the setting to Allow forecasts to be reduced on sales order entry, then as users enter sales orders that match an existing forecast, they will be presented with the following prompt:

The system has matched the forecast to the current order using the forecast date and matching it with the promised delivery date on the sales order line (it matches within the same calendar month). In this example, there is no customer specified against the forecast, so the customer on the sales order does not matter, but if there had been a customer on the forecast then it would have checked this against the customer on the order also. If the user entering the sales order ticks the box, then it would reduce the forecast quantity by the quantity on the sales order line (removing the forecast if this reduces it to zero).


7.2. Material Planning and Forecasts

Material Planning uses the forecasts when checking to create suggested works orders, suggested kits and suggested purchase orders.

Forecasts will be used in this process and where a forecast is a BOM item, a suggested works order may be generated, or a kit for a stock item with a kit designed for it.  Where a forecast is for a normal stock item, a suggested purchase order may be generated depending on stock levels.


8. Master Production Schedule

This screen is used to generate recurring suggestions that can be set as either daily, on a specified day of the week, or a date within a month. You can use different frequency options for different stock items. This enables you to enter an agreed production schedule, so you would then just use the Forecasts to reflect exceptional demands. When you run MRP, this would then register as a demand in the same way as Forecasts do. The demand from the Master Production Schedule will always be generated for the next six months from the current date when you run MRP, although this range can be changed via the MPS months to schedule setting on the Material Planning tab of 10.

When adding a new entry/editing an existing one, the following screen is presented:


9. Sales Over Lead Time

This will generate demand for MRP for items that have a lead time and have been sold within a date range that is less than that lead time. So as long as you keep selling an item, MRP will generate suggestions for it based on those sales within the lead time.

If you are also using Forecasts to generate demand, consideration must be given to whether the forecasts reflect standard sales, as this could lead to duplication of suggestions if Sales Over Lead Time is making the same suggestions.

There is a setting in MRP Settings than enables this feature, on the Material Planning tab and called Enable sales over lead time predictions.

So the items in the screenshot will generate a demand that will contribute to any suggestions in MRP. This demand can be viewed in the Future Stock Movements screen for this item, and will be reduced by any future dated sales orders that fall within the lead time.

E.g.  You have a 10-day lead time item, that you have sold 20 of within the last 10 days. Without any sales orders within the next 10 days, the Predicted Sales Over Lead Time would be a demand of 20. If you have a sales order already entered within the next 10 days for 5 of the item, then the Predicted Sales Over Lead Time demand would be reduced to 15.

Entries appearing in this screen are either dynamically generated, or have been manually entered as Fixed entries. You would create Fixed entries for new stock items where there is not currently a sales history, but you would like this screen to generate a demand for them in MRP. Only Fixed entries can be edited and deleted. The Sales Order Qty column displays how many are on sales orders within the lead time from the current date.


10. Purchase Requisitions in WAP

This screen displays details of outstanding purchase requisitions in Sicon WAP that have been generated from suggestions in Material Planning. You can use the filters at the top of the screen to choose the details that you are looking for, and then click the Search button to display the results in the top Purchase Orders box. Once this box has been populated with the results, clicking on a row in this box will display the lines on that requisition in the Purchase Order Lines box at the bottom.


11. Scheduler Colour Maintenance

This screen enables you to define colours to show against the different teams when viewing their operations in the Operations tab of the Capacity Planning screen based on the phase assigned to the resource against the operation, i.e. Setup, Runtime or Teardown. If you don’t need different colours for these three phases, then you could just set all three phases to use the same colour per team. This would then help see all of the operations for a particular team, as you would know what colour you are looking for.

These phases are set against the resource on the operation in Sage Manufacturing System Manager, on the Resources tab of the operation:

If you don’t set any colours against your team, then the colours assigned to the Default team value will apply to all operations appearing in the Operations tab of the Capacity Planning screen.


12. Stock Item Settings Import

This screen enables you to import the following fields from a csv file, which are stored in the WOP/MRP area of the Sicon tab on the Stock Item record:

Default Supplier Lead Time

Economical Batch Size

Split by Economical Batch Size

The final two fields that can be imported via this routine are found within the Supplier details on the Stock Item record: –

Usual Order Quantity

Minimum Order Quantity

The only field in the import file that is mandatory is the Stock Item Code, although you will also need to specify the Supplier Account Number if you are looking to import Usual Order Quantity or Minimum Order Quantity. If you are updating these fields, then bear in mind that any entries in the earlier columns on the same row will be ignored. So if you want to update all fields on the same stock item, you will need two rows for that item in your spreadsheet, one for the fields on the WOP/MRP area, and one for the supplier fields.

To perform the import, use the Find button to browse to your prepared import file. You can use the Example Import File button to generate two Excel files, one that explains the columns, and one that can then be saved as a csv file that is in the right format.

Once you have selected the import file, click the Check File button to perform a validation routine against your file. Once it has confirmed that the entries are correct, you can then click the Import button to perform the import.


13. MRP Settings

 


13.1. Material Planning TAB

Show advanced settings in Material Planning: Enabling this setting adds some additional options into the Material Planning screen when it is run.

This screenshot is for Advanced Works Order Settings, but these options also appear in the Purchase Order section and Kitting (if enabled). The Create suggestions for date in the past would backdate suggestions to a date prior to today if the demand was prior to the current date. In other words, if you don’t have this setting enabled, then demand for items prior to the current date would generate suggestions that were dated for the current date. Anything with the current date should be ordered/actioned today.

The other options in this advanced section allow you to include sales Proformas, quotes and orders that are on hold – otherwise these are all ignored for Material Planning suggestions. It is also possible to exclude the demand from sales orders if desired by choosing the Exclude sales orders option. These settings are replicated for works orders, purchase orders and kitting (if applicable), and could be set to different values in these three areas if desired.

Run Works Order process before Kitting process: If you have Kitting enabled, then ordinarily Material Planning would process Works Order suggestions after Kitting suggestions. Selecting this option would reverse the order in which this happens. The order that you need this to happen is dependent upon whether you have components on a kit that are manufactured items that would be built on a works order, or whether you have components on works orders that would be built as kits. Material Planning will create the demand for these components in the order dictated by this setting. So by default, it will run Kit Suggestions first. If you had works orders that did have kits as components, then you would enable this setting in order for the works orders to be suggested first, which would then create the demand for the kits. If you didn’t enable this setting, then the kits would not be suggested on the Material Planning run as it will finish kits before starting works orders, so won’t know about the demand from the works order while processing kits. You would need to run Material Planning twice to action this without this setting, the first run would be where you then create the suggested works order, and then the subsequent run would suggest that you need to make the kit.

Preallocate suggestions to reasons: Once suggestions from material planning are actioned, they will then be preallocated to the demand that caused their suggestions. For example, a suggested purchase order could be preallocated to components lines on one or more works orders, or to a sales order line if the item being purchased was being sold to a customer. When the purchase order is received, then a window would be displayed allowing the user booking it in to confirm where the items should be allocated to. If this option is not selected, then no preallocations will happen meaning that when stock is received into the system it will need to be manually allocated.

Preallocate suggested child works orders to suggested parent works orders: If a suggested works order was created, then the finished item on it could be preallocated to one or more works orders if the item being booked in was a component needed elsewhere. Without this option enabled, any subassembly works orders will be generated as independent works orders that are not directly linked to any parent works orders requiring that subassembly.

Use requested date of the sales orders in material planning: By default, the promised date is the field used for demand from sales orders, but by selecting this setting it would use requested date instead.

Default delivery buffer: This is a default number of working days to deduct from sales order line promised delivery dates to arrive at an expected dispatch date. This value will be overridden for a sales order if the applicable customer account has a value entered on their MRP tab.

Use multiple delivery dates on purchase order lines: When material planning is enabled on a Sage 200 system, then the standard Sage Multiple Dates button on purchase order lines is disabled. It can be re-enabled using this button, but Material Planning will not use any breakdown of dates on this purchase order line, it will only use the Requested delivery date for the whole of the line when calculating when this purchase order is expected to be delivered.

Use the default finished item warehouse set on the stock item for minimum stock suggested works orders where grouping is enabled, separate suggestions by warehouse is disabled, and the default warehouse is included in the warehouses to be processed: This is a specific setting to manage what finished item warehouse should be used with the combination of settings as specified in the description of the setting. It is a method to ensure that where you need to make items due to demand and availability in multiple warehouses being combined, you can ensure that they are all being made in the default finished item warehouse.

Only enabled WAP requisitions button: If you are using Sicon WAP to authorize your purchase requisitions before they can become purchase orders, then enabling this option will remove the Create Purchase Orders button from the Suggested Purchase Orders tab within Material Planning. This will then only leave the Create Requisitions for WAP button, ensuring that no-one can inadvertently click the wrong button and bypass WAP for the actioned suggestion.

Show next available date on sales orders: Enabling this option will activate an extra column when looking at a sales order, called Next Available which will initially be populated with the words ‘Not calculated’. Beneath the grid in the sales order screen is a Calculate button. Clicking this will trigger an update to the Next Available column where the system will calculate when the relevant stock item could next be available, based on current stock and either production lead time, or supplier lead time (including supplier lead times of components not currently in stock for built items). If this calculated date is either on or before the promised delivery date of the sales order line, then this date will be displayed in green. If it’s displayed in red, then the calculated next available date is after the promised delivery date.

Allow forecasts to be reduced at sales order entry: With this option enabled, when users enter sales orders for an item with a forecast that is in the same calendar month as the order promised delivery date and if any customer account has been specified that matches the customer on the order, then the user will be prompted if they wish to reduce the forecast by the order quantity.

Enable sales over lead time predictions: This option activates the Sales Over Lead Time suggestions that will then cause a demand for MRP.

Enable Sicon supply details for usual and minimum order quantities: With this setting enabled, the Sicon Material Planning Supply Details fields are then available if you wish to enter a Usual Order Quantity that is smaller than the Minimum Order Quantity. Without this setting enabled, then you only see the standard Sage Usual order quantity and Minimum order quantity fields (in the Supply Details section), but these fields will not allow a minimum order quantity greater than the usual order quantity.

MPS months to schedule: This setting enables you to indicate how many months you would like to include within the Master Production Schedule.


13.2. Stock and Warehouse TAB

Default component warehouse and Default finished item warehouse can be used to select the defaults that will be applied to works orders generated by Material Planning. These would be overridden if any default warehouses were set on the stock item (in the WOP/MRP area of the Sicon tab).

The Quarantine list of warehouses lets you select which warehouses should be excluded from Material Planning.


14. Reports

  • Future Stock Valuations Detail
  • Future Stock Valuations Summary
  • Firm and Suggested Purchase Orders
  • Capacity Plan

15. Enable Module

This screen is used to show all configured Sicon Add-ons and allows the entry of enable strings to allow use of a module.  When a new module enable string is provided, copy into the ‘Enable string’ field and then click Apply to save the changes.

If online enable strings have been activated these will self-populate.


16. Release Notes

The release notes page shows which release of the system includes new features or issues resolved.

With the release of the Sicon v19, our version numbering has changed slightly. Previously our add-on versions were numbered in the format 201x.18.0.1.  From Sicon v19, our modules will be numbered in the format 201x.190.0.1  This is because we have three Sicon releases planned per year and we will use the second group of digits to reflect these as xx1 and xx2. We use the third set of digits to reflect whether it is a release or a pre-release build and the fourth set then give the build number.

New features detailed in the Release Notes relating to Pre-Release versions will not be detailed in the current Help and User Guide until the end of development phase.

Manufacturing Manager Release Notes

17. New Features & Important Information





Sicon Main Menu