Try ERPNext Buy Support Partners Foundation

Value Difference - Stock Balance vs Stock in Hand


There is a difference in Value for Stock-in-Hand (Shown in Balance Sheet) vs Stock Value in Stock Balance Report

Stock In Hand (as Shown in Balance Sheet) : 4,66,69,001.12
Stock Value (as Shown in Stock Balance Report) : 4,66,67,065.81
Total Value of Negative Stock (as Shown in Stock Balance Report) : -4,782.78
Total Value as Stock Analytics : 4,66,54,965.22

How do I check for erroneous Entries or Records, if any?

Or is this because I have certain negative stock in my System?. If this is the case, even then, the value does not match. The total value of Negative stock does not equal the difference between the above two values.

I also facing this problem as described in Value of some items in stock analytics and stock balance are different.

Surprisingly all the figures are different then others.


Looks like we’re facing the same issue.

Its surprising that no one have responded so I don’t think I must have been resolved.

We are getting quite big difference in the value of Stock in Hand in Chart of account AF current date and also Stock In Hand in Trial balance against year end when comparing these values to Stock balance.

Trial Balance Values are Matching General Ledger Values
But the above report’s values are not matching with Stock Balance and its causing the client to not get auditors approval.

Have anyone else faced the same on latest V11 ? We’re still investigation but cannot find the reason of difference in core reports