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 80610 Rate this article: 5.0 Kathy BartheltKathy Barthelt Other posts by Kathy Barthelt Contact author Facebook page Twitter Linked In YouTube Website
8Apr2025 Infor LX/BPCS Tips & Tricks for FINANCE: Increase A/P Retention Days Tuesday, April 8, 2025 Read more This enhancement allows reconciled payables and payments to be retained in the system for over 200 years. It extends the retention period in A/P Application Control Maintenance (ACP180) to support up to five digits. This gives LX customers the ability to retain data online for significantly longer durations. Read more
8Apr2025 Infor LX / BPCS Tips & Tricks for EXECUTIVES: Tuesday, April 8, 2025 Read more FINANCE: Increase A/P Retention Day TECHNOLOGY: Search by Description in Segment Value List OPERATIONS: IDF Customer Order Inquiry Enhancements Read more
10Jun2025 Infor LN & Baan Tips & Tricks for EXECUTIVES Tuesday, June 10, 2025 Read more FINANCE: Rebuild History for Account Matching (tfgld1218m000) OPERATIONS: Copy Customized Product Structure to Standard Structure (tipcs2232m000) TECHNOLOGY: Authorization and Security: LN REST APIs Read more