infor.com
concierge
infor u
developer portal
Home
Groups
Lawson - Financials Product Customer Community [READ ONLY]
Lawson table purge -financials
unknown
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
Find more posts tagged with
Infor Lawson Financials Group - Discussion
Comments
unknown
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.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Popular Tags
Infor Lawson Human Resources Group - Discussion
Infor Lawson Technology Group - Discussion
General Discussions
VISUAL - Enterprise General Discussions
Infor Lawson Supply Chain Management - Discussion
Process Automation (IPA) - General Discussions
Pegasus - Partner General Discussions
Infor Lawson Supply Chain Group - Discussion
Infor Lawson Financials Group - Discussion
Infor EPM Discussions