Discrepancies in vyuICGetItemStockUOM

Issue No: GRN-793
Created 11/6/2017 9:36:20 AM
Type Bug
Priority Minor
Status Closed
Resolution Fixed
Fixed Version 17.1, 17.3, 17.4
Description Issue :   1.Create a Scale in ticket for the distributions type DP and distribute.   2. Check the inventory stock - on hand and on storage qty   3. Do a settlement for the same scale in ticket .   4. This time *if* we check the inventory stock we can see that there is no impact happened in the on- storage and on-hand .     *If there is a settlement storage against a scale in ticket then* *it is considering different stock uom and it is not adjusting with the on storage and on hand qty*   *When there is a settlement then the on storage should decrease and on hand should increase,*   *instead of this settlement entry is showing as a different line in respective table*   The impact is below   findings from live   In Versallises when we were checking Live DPR we came across this issue   For the item Soybeans is returning 2 rows using below query. But it belongs only one item .   select strType,* from vyuICGetItemStockUOM where intCommodityId=3   In this case 245 bushel is settlement and it is showing as a different stock unit "lb" and different line. instead it should idealy adjust with the first.line .   !pastedImage_d85655_0.png!