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 121139 Rate this article: 5.0 Kathy BartheltKathy Barthelt Other posts by Kathy Barthelt Contact author Facebook page Twitter Linked In YouTube Website
14Mar2017 BPCS/LX Tip of the Week: When More = Less Tuesday, March 14, 2017 Read more Do you have bottlenecks in your process due to product changeovers or breakdowns? Maybe the answer is adding redundancy in the department where you are experiencing the problem. A duplicate machine setup can allow for double the capacity during high production periods. It can also eliminate the need to swap out tools or other materials due to different production runs. When breakdowns occur, equipment can be swapped out to keep production moving while repairs are being made. Planning for this keeps production levels high. Optimize Your Manufacturing Today! Read more
8Mar2017 BPCS/LX Tip of the Week: Web Services Wednesday, March 8, 2017 Read more Web Services can be very helpful for LX users to obtain updated information directly from the source, for example: LX users can use a web service to request a stock check on an item for which they are going to issue a purchase order. Users can get item availability and updated pricing before placing the order. LX users can also use a web service to get real time shipping charges from UPS, Fed Ex, etc. Once the user selects the appropriate freight charge, it can be added to the customer order while the order is being placed over the phone. 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