Here is the situation:
 
We are running 2000.1 patch 4.
 
The inventory inquiry screen shows that I have 98 units allocated in my locations and allocation screens. The work orders show that I have a total allocation of 74units.  
 
I checked the inventory transactions and they indicate that we should only have 74 units allocated.
I ran a materials issued report(JC-E) out of the job costing module and is shows that I have issued the correct amount of material resulting in only having 74 units allocated.
 
I ran a material in wip report(JC-P) and it shows that I have not issued 24 units but have completed them. The reports do not seem to match.
 
To fix this problem I have been told to run a rebuild work order report and this does seem to fix it.
 
As I understand it the rebuild report does not actually change any system value and is more to do with costing.
 
My question is why is this happening? I have talked with DBA tech support and they do not understand what is happening. I am in hopes that Lynn will be able to shed some light on this issue.

Well, first of all, I would suggest you update to the latest version, you are running a 3 year old version of the software and a lot of things have been fixed in 3 years.  Version 2002.4 is a pretty solid version and the DBA patch file and the IS Tech support updates will continue to improve on it and fix any further things we find.
 
I will confirm that the Rebuild Work Order utility does not affect inventory value or anything but will correct what you are seeing.  What is happening is that for some reason, when you are issuing material the transaction record (WOMAT file) is being created but the allocation record (WOBOM file) is not being updated to reduce the remaining allocation by the issue quantity.  he Rebuild Work Order utility will recalculate the allocation remaining in WOBOM based on the transactions to the work order in WOMAT which is why the utility corrects the problem.

I would suspect it is more likely a program bug that has been fixed sometime in the last 3 years.