Scenario 6 – Import BOM and Material

In this scenario, we will show you how to import to Asprova the Manufacturing BOM and Items data.

We will use the file “25.08 Scenario 6 – Import BOM and Material”.

Asprova1

This is the Data I/O table.

Asprova2

The item code is connected with the Item name at the Material (Import).

Asprova3

This is the actual Material (import) file. It includes the item code and item name.

Asprova4

This is the data I/O setting for M-BOM. This is its TSV file. In this file, you will see its product code, process number, process code, instruction code, input item and the required quantity.

Asprova5

Confirm the settings for Material and BOM in Data I/O table by checking the parameter setup below.

Verify that the Import column is set as “Yes (differential)” and Import property conversion expression column is set as “Instruction Type = I”.

Asprova6

This means that the Instruction type will be automatically set as Input instruction as soon as you import the file.

Asprova7

This is the Item table. You will see that the Item name is blank at the beginning. The Item name will be imported from the TSV file.

Asprova8

This is the Integrated Master Editor. The Use instruction will be maintained in Asprova and the Input instruction will be imported from ERP.

Asprova9

Let’s start importing the TSV files.

Asprova10

Once completed, the item name will be displayed in the Item table and the Input instruction has been imported. See table below.

Asprova11

Asprova12

Go to the Resource Gantt chart and press the Reschedule button to see the scheduling according to the imported BOM and items data.

Asprova13

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: