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 85787 Rate this article: 5.0 Contact Kathy BartheltKathy Barthelt Other posts by Kathy Barthelt Contact author Facebook page Twitter Linked In YouTube Website Contact author Message sent. Name: Please enter your name. Please enter your name. Email: Please enter a valid email address. Please enter a valid email address. Please enter your email. Subject: Please enter a subject Please enter a subject Company: Please enter company name. City: Please enter City name. Region: Please enter Region name. Country: Please enter Country name. Telephone: Please enter telephone. Mobile: Please enter mobile number. Message: Please enter the message. Please solve captcha Please solve captcha. Close x
15Sep2015 BPCS/LX Tip of the Week: Work Center & Machine Locations Tuesday, September 15, 2015 Read more
10Feb2026 Infor LN & Baan Tips & Tricks for EXECUTIVES Tuesday, February 10, 2026 Read more FINANCE: Copy Received Purchase Invoices (tfacp1210m000) OPERATIONS: Production Order Parameters TECHNOLOGY: Audit Configuration Management Read more