I hope you can help me please
Having set up standard costing, I have entered items data and location standard cost on the inventory records
Item ABC632 for example
I have a qty on hand of 24 and the location standard cost is 3.19608696 (therefore total value is 24 x 3.19608696 = 93.98608704)
I make an inventory adjustment using Transactions>Inventory>Adjust Inventory - accessing the Inventory Adjustment form. On the IA form, I can see that the system has rounded up the cost per unit to 2 decimals places. The current value for the starting qty of 24 as above is rounded to £93.99 (not displayed to 7 decimal places, which is what I expected to happen give that stanard cost is being used)
The estimated unit cost is also rounded to 3.20 per unit (again, not to 7 decimal places as expected)
I adjust my inventory by a reduction in qty of 5 (-5 x standard cost of 3.19608696 = (19.5804348)
**but when I save the inventory adjustment the value is (19.60) *** this is a whole 2 pence difference per unit
and over thousands of units across a 12 month period could be material for auditors
Why does this happen please? How can I ensure that the standard cost is used for calculations and postings so as to avoid and under or over statements of value in the accounts?