I just ran into a strange issue. Some Material Transfer stock entry I create (moving a product from warehouse A to warehouse B) generate an unbalanced entry.
Although on the actual form the values actually match:
I am using moving average for stock evaluation. At first I thought this was due to some rounding function, but turns out it’s not because the amount tends to increase for larger quantities:
This is for 25pcs of something:
This is for 50pcs of the same thing:
Can anybody shed some light on this? Cheers!
Can you please replicate the issue in demo.erpnext.com and provide a link of the document?
Thanks for replicating the issue in demo account. I checked into it and got the issue. It is related to field precision and rounding. But it is really difficult to fix immediately. To fix it, we have to major change in design and logic of valuation rate and how it is handling. The change is already in our to-do list. But it’s not really a easy fix.
For now, if you want to get rid off it, you can set precision of
valuation_rate field to 6.