Remove the CORRESPONDING PO and ETA Column Values from Sales Orders (update)-Proposal

Requirement 

Identify the sales orders when it’s ordered and committed quantities become equal and remove the corresponding PO and ETA column values from the sales orders item line. 

Our Solution 

1. We will develop a Map/Reduce script that executes twice in a day. 

2. So, the script will fetch all sales orders having at least one purchase order in their corresponding PO column using a saved search. 

3. Then process each sales order to check if the ordered and committed quantities are equal in each of the item lines that are having value in corresponding PO and ETA columns. 

4. Then we will remove the corresponding PO and ETA from the item line in which the ordered and committed quantities are same. 

5. We’ll also save the removed ETA and corresponding PO information in a CSV file and keep it in a file cabinet. 

Assumptions 

1. Only sales orders with the statuses Pending Fulfillment, Partially Fulfilled, Pending Billing/Partially Fulfilled, Pending Billing are processed by the script.