Add Order 2 – Copy and Auto Fill

In order to paste the data from the prototype datasheet to Asprova, we should adjust the column of the [Order table] in the same way the columns are placed in the prototype datasheet. The order of the columns in Asprova can be moved through drag-and-drop. In this sample, change the order to the following: Order code, Item, Order quantity, Due date, Customer, ERPLot, the same as the columns of the prototype datasheet.

assu1

Save the settings as a new style to keep the change in order.

Assu2

Copy the data of the “Order” sheet and paste it into the Order table.

Assu3

Assu4

In Asprova, when you select and copy rows in a table window, the objects corresponding to those rows will be placed in the clipboard as a whole and the copied data will be inserted and pasted as a whole. The table below shows the pasted manufacturing orders from the prototype datasheet. You will notice that the same column order is displayed.

In a similar manner, copy the data of the Inventory sheet and paste it into the Order table.

Assu5

Assu6

In the Order table, you will see that the order type of the code “Z01-A” inventory is not set properly. Switch the order type of order into Inventory (Absolute).

Assu7

To set the priority of the manufacturing orders, change the priority code in the Priority column to 90 to start the order 01 as early as possible. Set the same in order 02, and in 03 and 04. To copy the value in the upper cell, just press “CTRL + D”. Then change the order of 07 to 20 in order to make the order a filling order.

Assu8

Also, change the display color of the orders to make them easy to see on the Gantt chart. Set the display color of order 01 to 1 and order 02 to 2. Use the Auto-fill function of Excel to update the display color of the other orders – highlight the first 2 cells then drag the highlighted portion down to the cell you want to update

Assu9

Assu10

To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning website and check the video tutorials under “23. User Interface”. You may also refer to the online help for other keyboard shortcuts.

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: