I've seen this problem discussed in different places but I did not hear about a resolution.
I have discrepancies between the inventory valuation report and the stock status explorer.
I know that the inventory evaluation report is accurate. I reviewed the different statuses for the different reports and for a particular item it is saying that the quanitiy on hand is 2.3333 qty available is 0 and inventory valuation is 53. Reviewing the inventory transactions for that item for all of history shows that the 53 is right.
Is there a simple bug fix or resolution to this problem?
Also (maybe related or maybe not) the quantities available in transit warehouses are coming through as negative. While the Qty on Hand seems to be accurate. It seems to be that PendQtyIncrease in timWhseBinInvt has a lot of large negative numbers. I cannot find any open batches or entries that should be influencing the pendqtyincrease
---
With a little ingenuity and team work there's nothing we can't break together.
