Scenario 5 – Export Purchase Requisition

In this scenario, we will export the “Purchase requisition”:

  • We will figure out the required quantities of purchasing items and auto-replenish the manufacturing orders
  • We will schedule the time to place an order and the due date.
  • We will export to the external file the scheduled due dates and quantities of purchasing items.

We will start with the last state of Scenario 4.Using the purchase item “X”, switch the Auto-replenish flag to “Yes” in the Item table. Set “Prefer to purchase” as Obtain method and “10000” as Purchase lot size MIN/MAX.

Asprova1

Go to the Data I/O table and select the Field mapping of “Purchase requisition (Export)”.

Asprova2

This is the format of the TSV file for purchase requisition.

Asprova3

The due date is connected with the end time of the order.

Asprova4

Let’s export the due date as the end time.

Asprova5

Click on the Export filter expression to set the Export filter expression. Switch the Export to “Yes (all)” and set “Type==P” as [Export filter expression].

Asprova6

Switch to the Order table and run the Reschedule button.

Asprova7

 

You will then see that the purchase order has been auto-replenished with 10000 items of Item “X”.

Asprova8

Go to the Resource Gantt chart to check on the purchase order.

Asprova9

The lead time for purchasing is 24hours where the start time means the time to place an order and the end time means the due date. The due date for this purchase order is 10:40 on June 10th as stated in the box above.

Let’s export this. The file “25.07 Purchase Requisite (Export)” will be created and the data of the purchase order will be the output. It is the plan that will purchase 10000 items of “X” at 10:40 on June 10th.

Asprova10

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: