I am aware from searching other forum discussions (and from experience) that the NCOA utility will overwrite the previous address, but that you can still find it in the Audit screen of the Transactions tab in the record. I'm curious if anyone has found a way to retrieve that data and create a Postal Address record, select "Previous Address" type and mark it "Inactive"? Or are there any other creative solutions to solve for 'x' here?
Any insight from the community would be greatly appreciated.
Thanks,
Michael Dorsey
Hi Michael,
We have exactly that! We created a custom script that we run after running the NCOA utility to add back the deleted address as an inactive address so we can see the old record. We don't change the address type in the process, just re-adding as an inactive address. If you or someone at your organization is familiar with running SQL queries I'm happy to send our script along.
Sara
Hi Sara! Can you send that custom script to the Berkshires of western Mass? I'm at mrymkiewicz@jacobspillow.org
Much thanks!