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 80644 Rate this article: 5.0 Kathy BartheltKathy Barthelt Other posts by Kathy Barthelt Contact author Facebook page Twitter Linked In YouTube Website
8Oct2024 Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Change SyncBillofMaterial BOD Tuesday, October 8, 2024 Read more This enhancement provides the ability to enable setting facility-specific bill of material BOD's accounting entity from the facility's stocking warehouse's company. The bill of material BOD can be consistent with the bill of resources BOD which sets its accounting entity from the company associated with the facility's stocking warehouse. Read more
8Oct2024 Infor LX/BPCS Tips & Tricks for EXECUTIVES: Tuesday, October 8, 2024 Read more TECHNOLOGY: Change SyncBillofMaterial BOD ... FINANCE: Override Exchange Rate ... OPERATIONS: Multi-Level Shop Order Release Due Dates ... 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