Hello:
When I run an inventory value report COL10003, shows -5,100 lbs with a negative value of $2,292.45. Our bin quantity however shows zero. The activity on this part was an adjustment on October 27 to write it up 5,100 lbs (a receipt was missed). Then on Dec 29, we did a full inventory count and this part was adjusted to zero. I see ledger entries were posted for both transactions. Why do I have -5,100 lbs on the inventory value report?
Thank you
@ImperialController thanks for your question!
It looks like the inventory value for that part at the beginning of October was negative $2,292.45. There was an inventory adjustment on 10-27 that brought the inventory value up to zero, then the cycle count which returned the value back to the negative amount you see now.
It would take a significant analysis to see where the inventory activity log and the bin value might have diverged. If you would like us to investigate this we would need to bill the time at actual. Let me know if that’s something you’d be interested in.
Thanks!
CetecERP Support
Hello and thank you for your response. Since we know that the quantity on hand is zero. Is is possible to have the -5,100 lbs and corresponding value over-written in the inventory value report as of December 31, 2025 to zero, so that it is correct going forward in the new year.