ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Repeatable >> SM-J-D Changes on hand qty's
http://www.istechforum.com/YaBB.pl?num=1103299862

Message started by Ron on 12/17/04 at 08:11:01

Title: SM-J-D Changes on hand qty's
Post by Ron on 12/17/04 at 08:11:01

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?