For the past 5 years we have never been able to run the consolidate inv transactions program without it randomly changing on hand qty's.  I have reported this problem many times to DBA and the only answer I get is that it works fine for them or they don't know what is causing the problem.
 
We just put on the ISTS programs this month and I tried it again but the same problem exist.  We are on version 2004.1 with ISTS update 10/8/04 and Pervasive 8.
 
Here is what I did:
 
1. I made a copy of our current company for this test.
2. Ran fix binary zeros
3. Ran reconcile inventory program
4. Ran consolidate inv. trans. for 9/1/99-9/30/99 for all items
5. Ran reconcile inventory program and got a report showing that O/H qtys were changed for 9 items
 
6. Deleted the test company
7. Created another test company and repeated the test
8. This time the reconcile report changed O/H qty's for 12 items. Only 5 of the items are the same on both reports, but the qty's are different for the 5 items.
 
Example:
 
1st reconcile report shows:
 
$ T BKICLOC  00820 W    Location had trxns with UOH of 98713.00 but BKICLOC UOH WAS 71641.00; chgd BKICLOC UOH.
 
2nd reconcile report shows:
 
$ T BKICLOC  00820 W    Location had trxns with UOH of 98473.00 but BKICLOC UOH WAS 71401.00; chgd BKICLOC UOH.
 
Any thoughts on what is causing this?