• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

So I just accidentally deleted an IC81...

 2 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
SCMaster-jk2
Veteran Member Send Private Message
Posts: 100
Veteran Member
10/19/2015 3:41 PM

Does anyone know how I can restore it?

JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
10/19/2015 4:15 PM
I would first look at your test product line. Hopefully a copy of prod data has been recently applied to test. Then you can just query all the fields you need and upload to prod. If that's not a practical solution you could query the ICAUDIT table for any itemloc records deleted on that day. That will at least give you all the items that were on the par. But you'll have to reconstruct all the par levels, UOMs, GL cats, source records, etc. But again you may be able to get that from your test system even if the copy isn't recent.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
SCMaster-jk2
Veteran Member Send Private Message
Posts: 100
Veteran Member
10/22/2015 3:27 PM
Sigh... test wasn't updated so I can't pull from there. I was able to run a query against ICAUDIT and at least get all the items but that doesn't help since I don't remember par levels and such. I spoke with IT and they think maybe they'll be able to get a backed up version of ITEMLOC. Here's hoping...