5

Items having quantity unit decimal precision more than 2 digits, in all transactions (Purchase order, Inventory adjustment journals, Picking list, Sales order, transfer order) by default AX will do the rounding off up to 2 decimals digits, even though there is decimal precision for quantity unit is set more than 2 digits exception is BOM Lines. There is Item quantity unit decimal precision is set 4 digits, now when creating the purchase order line for this item and enter the quantity in 4 decimal places (Say 37.8375) then it will rounding off up to 2 decimal digits (default) so the after product receipt the inventory is up with the 2 decimal rounding off value (as 37.84), Then now we are consuming from this inventory for production orders, where the consumption value is in 4 decimals (for e.g. say 0.0004), then the inventory transaction is showing -0.00 (consumption) but the inventory is consumed (as 0.0004) and On hand is still showing 37.84 is available, Now when in another production order trying to pick the inventory as 37.84, Ax is not allowing to pick this quantity and throwing the error as below "37.84 cannot be picked because only 37.84 is/are available from the inventory" Similarly we can’t do any Inventory adjustment (to make this inventory as zero except quantity adjustment directly) or Transfers orders with this quantity value (37.84), getting the same error. If there is by design rounding off in UI (as 0.00 during consumption of 0.0004)) then why it is deducting the value 0.0004 in SQL? Since it is deducting value (0.0004) in SQL and in UI still showing on hand value as (37.84) (round off) then why AX is not allowing to consume the value 37.84 in next production orders?

Category: Inventory
STATUS DETAILS
Needs Votes
Ideas Administrator

Reassigning this idea to the Inventory category.