Fix data for MFG - Cost adjustments to all rebuild from screen

Issue No: MFG-3838
Created 11/21/2018 5:46:32 PM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 18.3
Description *Steps:*   # Get the latest Zeeland - Creston 01 db. # Install the i21_18.3.1121.476 on your local and upgrade the creston db to this version. # Run the [stock rebuild script|http://jira.irelyserver.com/secure/attachment/33827/Rebuild%20Stock.sql] from IC-6397. # Open Inventory Valuation -> click the Rebuild button. This will simulate when the user has to rebuild the stock again in the future after the data fix. ## Run this script to allow negative stocks. {noformat}update tblICItemLocation set intAllowNegativeInventory = 1{noformat} ## Fiscal month: October 2018 !pastedImage_d108543_0.png! ## Post Order: Periodic # It will show this error: !pastedImage_d108543_1.png!     *Notes:*   * The stock rebuild script works because it changes the date of all the work orders posted from mfg prior to calling the rebuild sp. !pastedImage_d108543_2.png!   *Expected:*   * Rebuilding the stock from the screen should not fail. * If it is a data issue, please provide a data fix. * Otherwise, fix {{uspMFRepostCostAdjustment}} so that cost adjustment will not fail when called by {{uspICRebuildInventoryValuation}} . * We need a permanent fix.