Description |
1. Data correction
2. Fix the problem. Error is only for few items. May take time to investigate and fix. So not setting as a blocker. They should be good to go if we fix the data for now.
!pastedImage_d40929_0.png! select (select strItemNo from tblICItem where intItemId = tblICInventoryTransaction.intItemId) ItemNo, dblUnitOnHand, tblICInventoryTransactionStock
from tblICItemStock inner join
(select intItemId, sum(dblQty*dblUOMQty) tblICInventoryTransactionStock from tblICInventoryTransaction group by tblICInventoryTransaction.intItemId) tblICInventoryTransaction
on tblICInventoryTransaction.intItemId = tblICItemStock.intItemId
where dblUnitOnHand <> tblICInventoryTransactionStock
|