I’m trying to update the amount of an item by using the reconciliation tool but the numbers after that don’t match at all.
I don’t know if there is a bug or if there is something I don’t get. So right now I’m just trying to set the amount to zero and start all over again.
Here we go:
I have two batchs of an item. One of them, I did the reconciliation (after many attempts) by setting its value to zero and, in fact, its “Stock Levels” and its “Batch Quantitity” are zero and its status is empty.
But when I do the reconciliation to the other batch by setting its value to zero, this lead to “Stock Levels” zero but its “Batch Quantitity” goes to 485,726. When I open the Ledger, all the transactions leads to 485,726 even when I do the reconciliation to zero.
If I do the reconciliation to any other value (for example, 100), he adds this value to this 485,726 (this goes to 585,726) in the Ledger and the Stock Levels shows exactly the value I added (100). After that, if I do the reconciliation to zero, he goes back to 485,726 by removing the value I added before.
For what I see, it’s as the reconciliation tool didn’t know about this 485,726 so he does the math correct but not considering this value.
I have already search all the warehouse and all of them is empty for this item while the Ledger shows that the “Laboratório” warehouse has 485,726 of this batch.
Does anyone know what’s going on and how to solve it?