I have a small client experiencing a strange problem. The held a
physical inventory that took several days to reconcile. After the
inventory was finally un-frozen, there were about 5 days worth of
transactions to enter. Customer orders were shipped, and reports were
ran (custom reports based on matltran - including matltran.trans-num).
Everything looked fine. When A/R went to invoice the first days
shipments, the orders showed not to have been shipped. Upon
investigation I found the material transactions were gone - totally
backed out - no other tables affected - no journals - not co-ship - no
coitems updated - no itemloc updated. All in all approx 120 matltrans
appeared to be created then backed out mysteriously.
I had them re-ship and everything was fine. This same problem occurred
for 2 of the 4 days worth of shipping. The rest was fine. The only thing
out of the ordinary was the volume of transactions (for this user) was
heavy due to the catch up.
Any ideas are welcomed - please respond directly .
System Specs :
Approx 30 users
DB size - approx 1GB - single volume
NT4.0 - service pak 3
SL 3.5b01b
Progress 8.3A
Compaq Proliant 3000
Mike Lacey
SSG, Inc.
physical inventory that took several days to reconcile. After the
inventory was finally un-frozen, there were about 5 days worth of
transactions to enter. Customer orders were shipped, and reports were
ran (custom reports based on matltran - including matltran.trans-num).
Everything looked fine. When A/R went to invoice the first days
shipments, the orders showed not to have been shipped. Upon
investigation I found the material transactions were gone - totally
backed out - no other tables affected - no journals - not co-ship - no
coitems updated - no itemloc updated. All in all approx 120 matltrans
appeared to be created then backed out mysteriously.
I had them re-ship and everything was fine. This same problem occurred
for 2 of the 4 days worth of shipping. The rest was fine. The only thing
out of the ordinary was the volume of transactions (for this user) was
heavy due to the catch up.
Any ideas are welcomed - please respond directly .
System Specs :
Approx 30 users
DB size - approx 1GB - single volume
NT4.0 - service pak 3
SL 3.5b01b
Progress 8.3A
Compaq Proliant 3000
Mike Lacey
SSG, Inc.