Difference in accounting and inventory analysis due to rounding

[Kinner Vachhani]

Consider following e.g to populate bug

The PO is a purchase of 221 items at €25.26.
Currency rate: 22/05: 1.163000

If we calculate without any rounding:

Value of 1 item in GBP: 21.71969
Value of 221 items: 221*21.71969 = 4800.0515

However, rounding is applied to the price:

Value of 1 item in GBP: 21.72
Value of 221 items: 221*21.72 = 4800.12

For the accounts to be verifiable, the amount shown in the balance sheet account must match the value of stock in the warehouse, calculated using the formula

value=qty in stock*average price
This number can be seen by looking at Inventory Analysis (Warehouse->Reporting->Inventory Analysis)

The number on the balance sheet can be verified by looking at

Accounting->Journal Entries->Journal Items
 Filter: Account=5020 Name:<enter product code> (Note this does not work if a manual price update has been used - it fails
 to record the product name in this instance)
We can see that the Journal Item is for £4800.12, whereas the Inventory Report uses the rounded average price, resulting in a value of £4800.05.