WIP Adjustments & Approvals Using SQL Script v14.3

Discussion created by mike_c_lee on Apr 6, 2016
Latest reply on Jul 17, 2017 by Alok.kr1



I recently had a request to create WIP adjustments for several hundred transactions due to mismatches between the resource's stated and posted rates. In looking at this, I saw that there are two delivered stored procedures that handle the creation of WIP adjustments (REV_PRC_ADJWIPMODXFERXACTION)  and approving the adjustments ([SP_ADJWIPAPPROVELINEITEM). I was able to use these in a script that would perform all the needed adjustments based on a SQL cursor that retrieved the invalid transactions that I needed to update. I wanted to share this with the community because this definitely reduced the pain of doing all the adjustments manually.


Hope this can help!