1. Download the sample format for sales orders. Every row is a different sales order.
2. Download the sample format for the procurements. Every row is a different procurement. Stock has no purchase order.
3. Modify sales orders file including all your sales orders for one item. Follow the file format.
4. Modify procurements file including all your ongoing pruchase orders and stock for one part. Follow the file format.
5. Drag And drop sales order files on the sales orders area. Do the same with procurements file on its area.
6. Press the button "Schedule".
7. Dowload the procurement status using download button.
It is a tool to deliver on time.
Procurements will be allocated to the sales orders starting by earlier delivery date.
Planned date will be adjusted in case a procurement allocated to a sales order is coming later than sales order original delivery date.
In case there is no enough stock, a purchase order suggestion will be created taking the procurement period set in the "Procurement period (days)" field to calculate the procurement availability.
I do not provide any support to this tool. Anyway, you can send your suggestions or opinions to sergio.charles@erpmentorit.com