Scenario 1 – Import planned orders and production orders

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.

asprova1

In the initial screen view of Asprova, open the file “25.03 Scenario 1 – Import planned orders and production orders”.

asprova2

Open the Data I/O settings from File.

asprova3

This is the data input and output setting table for Planned Order.

asprova4

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.

asprova5

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.

Asprova6

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.

Asprova7

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.

Asprova8

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.

Asprova9

Two Manufacturing order was added to the Order table.

Asprova10

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”.

Asprova11

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).

free_trial_button2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: