Issue in details: In the Stock Balance Report, I am getting an item with 0 Balance Qty and negative Balance Value after I did a Stock Reconciliation. Tho the same item has a correct Balance Value in the Stock Ledger.
The Stock Balance of the Item on 9/30/2024
The Stock Ledger of the Item on 9/30/2024
How I reached to this: this is my first attempt to implement the Stock Module, the business was running for 6 month and we are getting correct sales, returns and purchases. But the stock is a miss, the business is about repacking the fruits and reselling it. So I am doing multiple Stock Reconciliations in an attempt to fix it.
My Question: Why I am getting a negative Balance Value in the Stock Balance Report for an Item with 0 Balance Qty after the Stock Reconciliation? How to fix it? Should not the Stock Balance and the Stock Ledger show a similar numbers?
Hi,
Check the if any “Repost Item Valuation” is in queue or not yet posted.
Alternatively Create Entry for “Repost Item Valuation” for subjected Item and Post it. Once the Process of Repost Item Valuation is completed, check the reports again.
Thanks,
Divyesh M.
I checked all the ones related to the Stock Reconciliation are done. This is done a week ago.
Hi,
Please create one more Item and Warehouse combination in current date and post it.
Thanks,
Divyesh Mangroliya
1 Like
Thanks, I did not know that i can do that, but Balance Value in the Stock Balance did not change
Both report are getting data from the same basis , balance value of stock ledger entry just open the stock ledger entry and check the balance value , for the same warehouse ,sometimes this is occured when valuation rate is different from current average, repost item valatuion will resolve it.
1 Like
It makes since for both to be the same, and revaluating the rate have to fix it. But I do not know why it does not work for my case.
Hi,
Try reposting Item valuation in past date. Also, note that reposting of Item Valuation may take longer time depending upon the number of transactions.
Thanks,
Divyesh Mangroliya
1 Like
i did two yesterday, one at the date that the mismatching appeared, and the other on 2ed Dec
this is the stock ledger
based on the Stock reconciliation at the 5th row, should not i expect an opening stock value with maximum -4
