Before explaining Scenario 1, please ensure to watch first “21.01 Mixing – Packing – Inspection process” to study the basic function of Asprova.
In this scenario, Asprova will import planned order and production order from external files, and then schedule the imported manufacturing orders with finite capacity.
We will import order data from two TSV files.
In the initial screen view of Asprova, open the file “25.03 Scenario 1 – Import planned orders and production orders”.
Open the Data I/O settings from File.
This is the data input and output setting table for Planned Order.
The Internal table name is “Order”. The Data source is “Text file” where you can also choose OLEDB, which is connected with the database through a dropdown. The Folder Database is blank. The target file is the same as the project file. The External table name is “25.03 Planned Order (import).txt”. The Field and decimal is “Tab&Dot”.
Click the block on the right in Field mapping to see the link between Asprova and the external file.
The left side is the Order table of Asprova where the properties for the order are placed. The right side is the TSV file where the fields are placed. Connect the properties on the right side with properties on the left side.
Order code, Item code, EST (Earliest start time), Due date, Order quantity, Reported quantity -this is the format for the TSV file. The format of time is “yyyy/mm/dd hh:mm:ss”.
This is the DBIO of Production Order.
In Asprova, planned order has the same meaning as production order.
Please refer to the online help if you want to know the details of DBIO.
The highlighted file below is the TSV file for planned order. The order code is 2. The item code is “AX”. The due date is June 11th and the order quantity is 3000.
The highlighted file below is the TSV file for production order. The order code is 1. The item code is “A”. The due date is June 7th and the order quantity is 5000.
In ERP, MRP, the due date of June 7th is considered as a 4-day-fixed lead time from June 11th. Select the Order table and import the TSV file.
Two Manufacturing order was added to the Order table.
Switch to the Resource Gantt chart and press the Reschedule button to get the scheduling result. In the Gantt chart, you will be able to see the schedule that produces 3000 items of “AX” and produces 5000 items of “A”.
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).