Kathy Barthelt / Tuesday, May 28, 2019 / Categories: Infor LN & Baan Tips Infor LN / Baan Tip of the Week: Deleting Records To improve performance and reduce database growth, deleting records is highly effective. The disadvantage of deleting records is that data is no longer available. Usually, however, not all records need to be saved. For example, line activities are stored by warehouse. Normally, you do not need to keep these records. Therefore, after closing a warehouse order, line activities can be removed. The User's Guide for ERP LN Archiving describes several sessions you can use to delete old data. Other data such as items and business partners can be reviewed once in a while, after which you can delete the data you no longer need. For every order and contract table a session is available to archive and delete old orders. In these sessions, you can specify several characteristics to select the orders to be removed, such as date or status. Run these sessions on a regular basis. Previous Article Explore your IDF programs Next Article Infor LX / BPCS Tip of the Week: Optional Authority to Maintain Reason Codes Print 46310 Rate this article: 5.0 Kathy BartheltKathy Barthelt Other posts by Kathy Barthelt Contact author Facebook page Twitter Linked In YouTube Website Leave a comment Name: Please enter a name. Email: Please enter an email address. Please enter a valid email address. Comment: Please enter comment. I agree This form collects your name, email, IP address and content so that we can keep track of the comments placed on the website. For more info check our Privacy Policy and Terms Of Use where you will get more info on where, how and why we store your data. You must read and accept this rules. Add comment