In this scenario, Asprova implements the MRP (Material requirements planning) system
by importing data such as Planned Independent Requirement and Customer Requirement from external systems. Thus, making it possible to schedule sales orders.
In Asprova, both Planned Independent Requirement and Customer Requirement are called a Sales order.
Let us open the file 25.05 Scenario 3 – Import planned independent requirements and customer requirements.
This is the Data I/O table – the data setting for Planned Independent Requirement.
Click on the Field mapping to see the details. The format of the TSV file for Planned Independent Requirement is on the right side.
The contents are as follows: The Item name is “AX” and the quantity is 500. The due date is June 11th. The contents of the TSV file for Customer Requirement is as follows:
The order code is SalesOrder2. The due date is June 12th. This will be considered as the sales order.
Go to the Item table and set the auto-replenishment. Switch the Auto-replenish flag for “AX” to “Yes” and set “1000” as Production lot size MIN/MAX.
Do the same for item A, adjust the Auto-replenish flag to “Yes” and set “5000” as Production lot size MIN/MAX.
To run the MRP, we need the inventory data of the items “A” and “AX”. The file below is the TSV file of the inventory: The order code is “Inventory1”. The item is “A” and the quantity is 500. Another order code is “Inventory2”. The item is “AX” and the quantity is 100.
Go to the Order table and import the inventory TSV files.
Press the [Reschedule] button.
You will see in the Order table that the manufacturing order will be replenished automatically to produce 1000 items of “AX” and 5000 items of “A”.
Go to the Resource Gantt chart and see the result. You will see that the Sales Order1 uses the inventory of item “AX”, and then the auto-replenishment manufacturing order to prevent a shortage. AT the bottom part of the chart, you will see also the result of Sales Order2.
Asprova implements the MRP (Material requirements planning) system by importing such data as [Planned Independent Requirement] and [Customer Requirement] from external systems. Thus, Asprova makes possible the scheduling of sales orders.
To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s online help and its e-Learning videos at http://lib.asprova.com/ (see 25. ERP Interface).