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
Posts: 100
Veteran Member

    Does anyone know how I can restore it?

    JonA
    Veteran Member
    Posts: 1163
    Veteran Member
      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
      Posts: 100
      Veteran Member
        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...