Negative Balance Value

[Francisco_Buendia]

Hello team,

How can be fixed a negative Balance Value when Balance Qty is zero or not negative?

I’ve being trying with Stock Entry and Reconciliation Tool, but with no succes.

Any thoughts would be appreciated.

[jignesh_shah]

Did you found any cause /solution to the issue ?

[Francisco_Buendia]

Not a good one, sorry.

[rtdany10]

This happens when the item valuations get messed up.
Check your failed background job logs and see if repost item valuation job is there.

Go to Repost Item Valuation List and see if there are documents stuck in In Progress mode.

More reference here:

How to validate Stock Balance report when report shows 0 Balance Qty but nonzero Balance Value?

yes, I found the cause of the issue, that was erpnext calculate wrong valuation rate when make sales invoice return on the past transaction but that issue solved later on updates, now the solution i need to cancel the past sales invoice return transaction then amend and submit because there is no tool or doctype to repost item valuation rate in version-12 regards