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 80633 Rate this article: 5.0 Kathy BartheltKathy Barthelt Other posts by Kathy Barthelt Contact author Facebook page Twitter Linked In YouTube Website
14Jan2025 Infor LX/BPCS Tips & Tricks for EXECUTIVES Tuesday, January 14, 2025 Read more Technology: Reset Purchase Order In Use - Operations: Retain Lot Status on Shipped Resupply Orders - Finance: Inventory Period Balance Freeze - Read more
10Dec2024 Infor LX/BPCS Tips & Tricks: Infor's Product Lifecycle Policy Tuesday, December 10, 2024 Read more Are you up to speed on Infor’s Product Lifecycle Policy for your version of BPCS/LX? Review this document from Infor, and contact Frank Petrasio at Crossroads RMC with any questions about how this may impact your organization. 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