Lawson table purge -financials

Legacy Contributor

Hi,

I have been searching for the best sequence for purging financial tables. I have the Supply chain down pat and includes AP. I am interested in best practice sequence of table purges which I assume to be GL followed by AM and AC but am hoping to see a specific list if one of you out there has done this before and has been giving the proper sequence from Lawson.

If so, please let me know.

Thank you,

Jim

Legacy Contributor

I don't think you have to do the finance purge in any particular order, at least we don't. For GL, our purging/archiving is primarily GLTRANS. For AM, we do just the disposals. For AC, our process is different. We have two jobs that we run that combine AC, AR, BR and GM data. At the end of 2013, we did a purge/archive of the 2009 and 2010 asset disposals and GLTRANS for 2009 and 2010. We performed our first purge/archive of AC. The record selection is based on the XX status we put on the activity on AC10. We do a preliminary query of AC10 before the archiving, perform the archive and then add back the records on AC10 and change the status to XP to identify them as previously archived. We do this so they do not reuse an activity number that would mess with our reporting data warehouse. We keep 5 years of archived data in another environment but our data warehouse for reporting still has all the data. Our goal is to have 2 years plus the current year for SCM and FN but are currently carrying 3 years plus the current year. We will do another archive in the Sept to Dec time frame.