Re-approved Purchase Orders does not pass through approval hierarchy

It is a standard functionality that when re-approving a Purchase Order whose document total is less than originally approved, the PO does not pass through the approval hierarchy.

To achieve the functionality where PO's whose Document Total has decreased after being approved would then pass through the Approval Hierarchy upon re-approval, the WF attribute mentioned should be set to a negative value.

Most commonly, the business requirement would that all PO’s pass through the Approval Hierarchy regardless of the reduction of the Document Total. In these cases the value for the attribute would be '-100'

The following SQL can be used to update the WF attribute.

update WF_ITEM_ATTRIBUTES

  set NUMBER_DEFAULT = -100

  where item_type = 'POAPPRV'

  and name = 'CO_H_PO_TOTAL_T';

After executing the above script, click commit button.

---X---