Epicor Prophet 21® Wholesale Distribution Software - Purchase Order to Sales Order Script Project

​

The idea behind this project was to match up incoming production orders to outgoing sales orders based on FIFO logic. So first PO in would be assigned to the earliest due Sales Order out.

 

The end result of it was a function that was utilized in a couple different ways. We set up a report using this data that allowed you to see exactly when all the items needed for sales orders would be arriving in. We also incorporated this logic onto the Order Ack form. Each line on a sales order that had a PO for that item coming in would show the anticipated date that item would be available for that order.