This can happen if large decimals are used on UofM's by mistake, causing inadvertent rounding to 5 dp in stock quantities.
- Identify the exact item, uofm and lot that is giving the problem
- In SQL, update the appropriate Qty_Base value to ensure sufficient stock is available on the line
update [CRONUS$Warehouse Entry]
set [Qty_ (Base)] = [Qty_ (Base)]+0.00001
where [Item No_] = '100001' and [Unit of Measure Code] = 'LB' and [Entry No_]=9317
No comments:
Post a Comment