EBS - v4 - MPS and MRP EN
Entersoft Business Suite® 4.0
User guide
- The scheduled material requirements are the result of the grouping by item, by WH and by requirement date.
- The quantity results from the sum of individual requirements taking into consideration the stock availability, as defined from the selected criteria.
- The execution of this action also results to the supplier determination. A main supplier is suggested but the user may choose an alternative supplier.
- Based on the selected supplier’s lead time (delivery days) the required time for the issue of the purchase order is calculated, in order for the item to be available on time. The calendar used is the company’s default calendar and the calculations are based on ESGODateAnalysis (see section 1.1.3 Working days)
- The minimum order quantity is counted in.
Image 42: Material requirements planning
Via the dialog box shown in Image 42, the user can select the date up to which the requirement planning will run. Optionally, this action offers the possibility for segmental requirement planning and therefore may lead to better control on the results of the planning. The segmental planning helps in the revisions even if they are short-term.
The scheduling action is executed progressively per date starting from the first requirement date, and in order to create the material requirement entries it does the following:
- Groups the requirements per item, required date and WH. Via the production scheduling form, immediate access is given to the requirements it has resulted from.
- Suggests a Supplier based on the user’s previous selection
Image 43: Scheduled material requirement
- Calculates the order’s quantity. In order for this to happen, it:
- Totals the relevant requirement quantities, in the field “Requirement quantity”
- Based on the selections made about the available stock of products (Section 1.3.3), it finds the available balance for the item on the final requirement date and utilizes this stock as far as possible (available stock that was used).
- Based on the options for the available stock of products (Section 1.3.3) it locates the available balance for the item on the final requirement date and it uses as far as possible this available balance (available stock that was used). In another replenishment entry for a future date for the same item this quantity, which according to the plan has been used, will be subtracted from the available balance.
- The spare quantity that will be ordered (meaning a quantity that exceeds the required quantity) will update the Progressive balance of the future entries for the same item. The spare quantity can be due to a user change on the Final quantity. Thus, if for example the user selects to order 10 extra items, when the Production stock scheduling continues in future dates for the requirement planning of the same item, it will consider those 10 items as available for use (Progressive balance used)
- Based on the above, the Suggested Quantity for order is formed and the Final one is suggested. The user may change this quantity.
- Based on the suggested Quantity, the desired requirement date, the supplier lead time and the working days, the Suggested order date is calculated and the Final order date is recommended.
- Based on the above, the sum of material requirements planning entries is created (Image 44)
Image 44: List of material requirements entries
Περιεχόμενα
Recalculation of MRP entries
As aforementioned, the user is able to modify, per entry, the final order quantity. This modification may affect the available progressive balance of future entries for the item. For this reason, the application will suggest the recreation (or else recalculation) of future entries (Image 45). Similarly, the modification of the final order date will result in the same suggestion.
Image 45: Recalculation of future entries
The change of Supplier may affect the supplier lead time, the order minimum quantity and thus, the order quantity and the order date. Therefore, if the user selects another supplier, the application will inform us accordingly, in order to proceed to necessary actions (Image 46)
Image 46: Modification of main supplier
Even if the user does not proceed with the automatic update, he can continue with the recalculation through the 
button, which is available next to the Supplier field.
The modification of the final date means that the entire entry has to be recalculated, since it is possible that on the new date the available stock, the progressive scheduled balance and so on, will be substantially different. The recalculation is feasible via the message box and also via the 
button, which is available on the right of the field: final requirement date.
Obviously, the application does not run automatic updates without the user permission, since the user modifies the original suggestion, as it is possible that the quantities and dates will be also formed from ad hoc factors that have not been depicted in the application.
Due to the severe effect the above changes may have on the data planning of future entries, the deletion of future entries and the re-execution of the requirements planning are suggested.
Alternatively, the option of bulk recalculation of selected entries is available (Image 47).
Image 47: Bulk recalculations
Issue purchase orders and supply requests
The required materials entries can be used for the bulk creation of supply requests or purchase orders, via the corresponding available actions. Via these actions, the user is able to group the production requests (Image 48) by (a) categorizing the selected entries by family, group, category, sub-category, item (or independently for supply requests) and (b) by date, on a date order level, on an order week level and on a smaller order date level (or independently for supply requests). Additionally, the user can select the document type and the series he wishes to use for the supply request or order creation.
Image 48: Create supply requests / purchase orders | Parameters
The created purchase orders / supply requests are viewable in the relevant form section. The option of deleting these requests is also available (Image 49).
Image 49: Viewing and deleting selected purchase orders / supply requests
Check balance
Via the “Check balance” section, we are able to track the stock for an item based on the final requirement date. The stacked chart depicts the synthesis of the available stock (expected, actual, progressive, safety) and shows how much of the stock has been used to cover the demand. By clicking on the expected stock, the application returns a list with the relevant expected orders to suppliers for the particular item.
This diagram allows us to check when the available stock reaches the safety stock level and therefore helps us to proceed on time to the necessary actions, regarding the purchase orders and the supply requests.
Image 50: Check balance per item
Customization: Adjusting the application to specific needs
Requirements selection criteria
Every group of criteria corresponds to scroller parameters.
- Requirements based on production scheduling: This concerns scrollers that are in the section MRP-Master production schedule views (ESMMMRPPlannedProducts)
- Requirements based on sales budget sheets: This concerns scrollers that are in the section MRP-Budget sheet views (ESMMMRPTradeGoodsForecast)
- Requirements based on sales orders: This concerns scrollers that are in the section MRP-Sales orders views (ESMMMRPInOrder)
During the creation of alternative scrollers for each one of the above requirement categories, the following actions should take place:
Scroller columns
Each scroller has specific columns regarding the name in filter. The columns mentioned below are mandatory. Specifically:
- fRequirementItemGID: the Item’s GID
- RequirementSourceType: the requirement’s source where 1 sales order, 2 budget sheet, 3 production planning.
- fRequirementSourceGID => the source’s GID
- fRequirementBOMGID => the Bill of Material GID
- RequirementQuantity=> the requirement’s quantity expressed in the main MU
- RequirementDate => the requirement date
- fRequirementRoutingRegionGroupCode => the Geographical Zone Group where the requirement needs to be delivered to. This specific information is not further utilized.
If when creating a view, a column is not needed, you should set the content to null. (Attention! Not an empty space)
Checking for previous requirement inclusion in planning
It should be checked that the entries each view returns are not already included in the specific requirements plan. The application “keeps” the current’s plan GID as a parameter in the executed view and thus makes this check possible.
Choices about availability of materials and goods
This concerns scrollers that are in the section MRP-Stock on-hand views (ESMMMRPOnHand). Each view has to have specific columns regarding the name in filter. The below columns are mandatory. Specifically:
- fItemGID: the Item’s GID
- CurrentStock: Current stock
- SafetyStock: Safety stock
- Expected: Expected stock (i.e. from orders, production and selected WH)
- OnHandStock: Current stock (CurrentStock) + Expected stock (Expected) – Safety stock (SafetyStock)
If when creating a view, a column is not needed, you can set the content to zero.
Attention to the existence of non-viewable, defined as parameters for the date calculation of the OnHandStock and of the item’s GID that is being used by the application.
Default supplier
This concerns scrollers that are in the section MRP-default supplier views (ESMMMRPDefaultSupplier). Each view should concern alternative suppliers for the item, and should have specific, mandatory columns regarding the name in filter. Specifically:
- fItemSupplierGID: the alternative supplier entry GID (defined as parameter)
- fItemGID: the item’s GID (defined as parameter)
- MainSupplierGID: the main supplier’s GID
- DeliveryDays: supplier delivery days for the item
- MinOrderQty: minimum supplier order quantity for the item
- fItemSupplierMUCode: supplier Measurement Unit for the item
- fItemMUCode: item’s Measurement Unit
