Dynamics NAV - Item quantities with Large Decimals > 5

Sometimes item stock will go into large fractions.
To resolve this, do a Departments/Financial Management/Inventory/Costing/Phys. Inventory Journal
Create a Batch
Calculate for your specific items that are giving trouble
Edit the Qty. (Phys Inventory) and set it to the closest higher amount to adjust the stock in to remove the small rounding.

You have to round transactions in the Warehouse entry 7312 to 5 dp to get the sums to calculate correctly.



select * into [CRONUS$Warehouse Entry_BAK] from [CRONUS$Warehouse Entry]

update [CRONUS$Warehouse Entry] set Quantity = round(Quantity,5), [Qty_ (Base)] = round([Qty_ (Base)],5)
where
[Qty_ (Base)] - round([Qty_ (Base)],5) <> 0
and [Item No_] in (
SELECT        [CRONUS$Warehouse Entry].[Item No_]
FROM            [CRONUS$Warehouse Entry] INNER JOIN
                         [CRONUS$Item] ON [CRONUS$Warehouse Entry].[Item No_] = [CRONUS$Item].No_
GROUP BY [CRONUS$Warehouse Entry].[Item No_], [CRONUS$Item].Blocked
HAVING        (SUM([CRONUS$Warehouse Entry].Quantity) - ROUND(SUM([CRONUS$Warehouse Entry].Quantity), 2) <> 0) AND ([CRONUS$Item].Blocked = 0)

)