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.
Go to the Data I/O table and select the Field mapping of “Purchase requisition (Export)”.
This is the format of the TSV file for purchase requisition.
The due date is connected with the end time of the order.
Let’s export the due date as the end time.
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].
Switch to the Order table and run the Reschedule button.
You will then see that the purchase order has been auto-replenished with 10000 items of Item “X”.
Go to the Resource Gantt chart to check on the purchase order.
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.
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).