- Aug 18, 2006
Have one stock item that shows different quantities at the same date on two different reports:
- Valuation report on a particular date;
- Movement report over say a month.
How do you fix this as in theory any posted entry should affect both the same.
The error actually goes all the way back to October 2013.
The January BOM entry pulled stock into WIP, but didn't complete and remains active no matter what I try it remains active.The resulting difference shows in October 2013, but I have traced the transaction to a bill of materials manufacture in January 2018 which was entered by a branch.
Probably the result of a problematic VPN connection where the item draw was double processed somehow and posted to hell in the system.
Call centre solution - use the enquiries valuation by date "as it gives the correct values if you have multiple warehouses and back date transactions". This was before I found the BOM transaction.
How is it even possible for Reports-Movement Report and Reports-Valuation Report to show different values from the same data?
They're drawing information from different tables???
I can't return the draw as it shows zero quantity available (when each item does have stock).
Also, one item has been drawn twice.