Sales, Production and Purchase Scheduling

This article explains how a user can run scheduling from sales orders to purchase orders, using automated replenishment production.

In this sample, the factory produces bolts “AX”. The final product “AX” is made from items “A” and “X”. Product “A” can be produced by supplying the raw material “M1” to the “Cut” process, then passes through “Press” and “Inspection” operations. To finally make the product “AX”, product “A” has to go through “Assembly” and “Inspection” operations with product “X”. These processes can be viewed in the Graphical Master display.

On the other hand, confirming details can be done in the Spreadsheet display. This is where order, production, setup, time constraints (e.g. waiting time) and auto-replenishment details are registered. Auto-replenishment is a function that automatically registers replenishment orders to prevent shortage of a raw material. This is setup in the item table – set the auto-replenishment flag of the item to “Yes (one-to-one production)” for manufacturing orders to be set into a one-to-one scheme with the sales orders. This is also where the production lot size is set. Production lot size is the minimum or maximum amount of stocks that can be produced or ordered. Obtain method can be set as either “Prefer to produce” if items will be produced or “Prefer to purchase” if items will be purchased.

Example of “Prefer to produce”:

5000 items of “A” have to be made at once so its production lot size Min/Max should be set to 5000 and obtain method as “Prefer to produce”. The 5000-items manufacturing order will be automatically registered when “A” is about to run out.

Example of “Prefer to purchase”:

The raw material “M1” is a purchase item with a lot size from 1 to 100. Therefore Purchase lot size Min is set to 1 and the Purchase lot size Max is set to 100. A purchase order will be automatically registered when “M1” is about to run out.

As soon as all these setup are registered, you can now run the re-schedule button and see orders being replenished automatically. The result is displayed at the Resource Gantt chart.


To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at (see 21. Try out sample data).


%d bloggers like this: