Welcome, Guest. Please Login.
05/09/25 at 16:31:19
News:
Home Help Search Login


Pages: 1
Send Topic Print
PO "Lost Record" (Read 594 times)
geo@jps
Browser
*




Posts: 39
PO "Lost Record"
07/26/04 at 07:51:19
 
All,
 
We have a PO that looks to be normal, but when we try to transact against it it shows a "Lost Record".
 
Any idea how to recover it?
 
Thanks,
 
George
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: PO "Lost Record"
Reply #1 - 07/26/04 at 08:02:53
 
What exactly is the message and what do you mean by saying it "looks normal"?
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
geo@jps
Browser
*




Posts: 39
Re: PO "Lost Record"
Reply #2 - 07/26/04 at 08:34:41
 
Ah, the truth finally came out from the folks actually using DBA here.
 
The PO (for some unknown reason) is in the system twice - the same number both times.
 
When they tried to receive against it, it "locked up" several times and they shutdown DBA using CTRL-ALT-DEL - but the received parts did appear when looking in inventory but listed as a "-Lost-" under PO.
 
Apparently they somehow managed to receive parts into the system, but now if they try to Enter Purchase Order Invoices it isnt there and says Invalid PO.
 
We have now tried to once again receive parts on it and the system has been running for an hour with approx 2 Million records Read, 1/2 Million record inserted and 1/2 Million records Updated and is still going.
 
Should we let this keep on running?
 
How should we try to fix this (remove both POs and start over)?
 
Thanks,
 
George
 
 
 
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: PO "Lost Record"
Reply #3 - 07/26/04 at 10:25:57
 
No, you need to kill it and delete the records.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print