Monday, September 21, 2020

NAV/BC - Columbus To-Increase - Insufficient quantity to complete this action. The base quantity in the bin is x. 0.00001 units are not available for Bin Code y

 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