(11-14-2017, 04:32 AM)afcouling Wrote: I have also found a discrepancy between the sum of all entries in my Stock GL account and the Stock Valuation total. The stock valuation is only 1% less than the Stock GL balance (about £400), but annoying all the same.
Dave, did you managed to identify the cause of your issue? How did you fix the problem?
Andy.
What we had found was the difference was an issue with the decimal points when it gets posted to the GL there is only two decimal points, and when it is posted to the stockmaster and stockmoves there more than two for example we have an item that is .023333 X 100 would be 2.3333 in the stockmoves and stockmaster, but when post to GL it would be 2.33 so over time the stockmaster would show more value.
We have not found a resolve to the issue we just deal with it every month making a
manual entry in the gl.
Would like to find a resolve for this itis also an issue in with Sales Tax in the US as most taxing bodies have more than two decimal points in there percentages.
Thanks
Dave
