Scenario 3 – Import planned independent requirements and customer requirements

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.

Asprova1

This is the Data I/O table – the data setting for Planned Independent Requirement.

Asprova2

Click on the Field mapping to see the details. The format of the TSV file for Planned Independent Requirement is on the right side.

Asprova3

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.

Asprova4

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.

Asprova5

Do the same for item A, adjust the Auto-replenish flag to “Yes” and set “5000” as Production lot size MIN/MAX.

Asprova6

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.

Asprova7

Go to the Order table and import the inventory TSV files.

Asprova8

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

Asprova9

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.

Asprova10

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

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: