ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> PO "Lost Record"
http://www.istechforum.com/YaBB.pl?num=1090857079

Message started by geo@jps on 07/26/04 at 07:51:19

Title: PO "Lost Record"
Post by geo@jps on 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

Title: Re: PO "Lost Record"
Post by Lynn Pantic on 07/26/04 at 08:02:53

What exactly is the message and what do you mean by saying it "looks normal"?

Title: Re: PO "Lost Record"
Post by geo@jps on 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

Title: Re: PO "Lost Record"
Post by Lynn Pantic on 07/26/04 at 10:25:57

No, you need to kill it and delete the records.