Reallocate Log Enhancement V2.0

Requirement

Need to track the Sales Order from the the Item are reallocated

Also need to get the Old and current committed quantity on ales Order on the Log record

Solution

We cannot use the Load Trigger since there will not be any data upon loading the page. Because the load trigger is before the user is selecting the Item and the Locations.

So we found an alternative solution to make use of the trigger before and after submission.

• On before submission, we can grab the old committed quantities of the sales orders and place them on the script field.
• On after submission, we can get them from the script field and create custom log records with the current committed quantity and the old committed quantity of the sales order.
• The log record can be created for the following lines on Reallocate Item page
  • Ticked OR
  • Not ticked AND Quantity Committed is Empty

Note/Risks:

1. There will be three fields for Committed qty on the log record
   1. Old Committed Qty : Committed Qty from the SO before Reallocation
   2. Qty Committed : Quantity Committed entered by the user on the Reallocation Page
   3. Current Committed Qty : Committed Qty from the SO after Reallocation
2. If the same item is added in SO more than once, then Total Committed Qty from all lines will be considered for Old and Current Committed Qty
3. The Reallocate item page submission may take more time due to the script.

Time

12 Hours