Kathy Barthelt / Monday, June 7, 2021 / Categories: Infor LN & Baan Tips, Support, Training & Workshops, Consulting, Finance, Manufacturing, Operations, Technology Infor LN & Baan Tip: How to deal with data growth of your ERP system… Spending time on managing ERP data can deliver huge benefits, not just in reducing storage costs, but also in improving the experience of business users. Proactively managing application data also helps accelerate key business processes which has a positive impact on customers, suppliers, and partners. Use these solutions to reduce the data growth and disk storage used on your system: • Use database compression. See Infor LN Data compression (B0050 US) for more information. • Using the varchar data type for string fields reduces the size of the database. Tables must be recreated for the varchar conversion. See solution 22923520 for the latest porting set. • Regular archiving history data will have a very positive effect on performance. The database growth will be limited and inserts in large tables will be faster. See the Infor LN User Guide for Archiving (U9352 US) for more information. Previous Article Check-Ups are important… Including Infor LN & Baan ERP Check-Ups! Next Article Infor LX & BPCS Tip: Transaction History – Did you know? Print 121257 Rate this article: 5.0 Kathy BartheltKathy Barthelt Other posts by Kathy Barthelt Contact author Facebook page Twitter Linked In YouTube Website
22Aug2017 BPCS/LX Tip of the Week: Shop Order Status Codes Tuesday, August 22, 2017 Read more Shop Order status codes have been improved to provide a more comprehensive view of the life cycle of a shop order. In addition to the previously existing ‘Shop Order Status Code’, the Production Status Code has been added. This code is designed to indicate progress and completion levels of each shop order. Valid codes are: ‘blank’ - no completed items 25 - a partial quantity has been reported 35 - the quantity reported is equal to or greater than the order quantity Optimize Your Manufacturing Today! Read more
15Aug2017 BPCS/LX Tip of the Week: Notes Maintenance Enhancements Tuesday, August 15, 2017 Read more The Notes Maintenance feature enhancement is made up note programs that are accessible from a central location. The Note Text Maintenance (SYS555), Note Type Maintenance (SYS553) and Multi Language Notes Maintenance (SYS556) programs are all available as menu options. The Notes Maintenance feature provides a way to create, revise, delete, and copy note text that are categorized by note types. The print options in Notes Maintenance permit a user to define documents for which the note is intended. This includes base LX documents and custom documents. In addition, the notes program provides a way to define notes by assigning document types. LX Notes allows the user to go to one location and customize print options, specify user documents, manage multi language notes and manage user-based note security through the defined Security Template program. Optimize Your Manufacturing Today! 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