Proposal summary

This is a proposal for removing the corresponding PO and ETA column value from the sales order.

Requirement 

Determine which sales orders are included in the corresponding PO and make sure the committed quantity equals the order quantity. If the condition is met, remove the corresponding PO value and the estimated time of arrival (ETA) from the corresponding sales order column.

Our Solution

1. We will run a user event script/workflow in the “Item receipt” record creation context.
2. When we create the item receipt, we will identify the purchase order that was used to receive the items.
3. Following the determination of the purchase order id. The purchase order id will be used to identify sales orders that have the purchase order value in the corresponding PO column.
4. if the sales order line contains the PO in the “corresponding column” then check the condition committed quantity and order quantity are equal.
5. If the condition is satisfied, we will remove the “corresponding PO” and “ETA” values from the sales order column.

Assumptions

1. Only sales orders with the statuses Pending Fulfillment, Partially Fulfilled, Pending Billing/Partially Fulfilled, Pending Billing are processed by the script.
2. The script only applies to sales orders created after the script has been deployed.