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 104569 Rate this article: 5.0 Kathy BartheltKathy Barthelt Other posts by Kathy Barthelt Contact author Facebook page Twitter Linked In YouTube Website
10Jun2025 Infor LX / BPCS Tips & Tricks for OPERATIONS: Auto Calculate Vendor Delivery Date Tuesday, June 10, 2025 Read more Enhances purchase order efficiency by automatically calculating the Vendor Delivery Date based on user input. When a purchase order line is created, the user enters the item, order quantity, and Due Date. LX automatically calculates the Vendor Delivery Date, adding buffer time for quality control, testing, and inspection activities. If the Due Date is revised, an informational message prompts the user to review and potentially update the Vendor Delivery Date. Enhancements: A new PUR820 system parameter enables automatic recalculation of the Vendor Delivery Date. Instead of a manual reminder, PUR500 now issues a message: “Vendor Delivery Date recalculated,” showing the updated date. Benefits: Eliminates the need to manually review and update the Vendor Delivery Date. Removes the need to delete and recreate PO lines to trigger automatic date calculation. Read more
10Jun2025 Infor LX/BPCS Tips & Tricks for TECHNOLOGY: User Provisioning Tuesday, June 10, 2025 Read more Enables integration between LX and Infor OS Federation Services (IFS) to automate user provisioning. Bi-directional user synchronization between Infor OS and LX: Infor OS user creation or changes automatically create or update users in LX. IBM i user profiles can be created if needed. Updates to SYS600 user data are reflected in Infor OS. Security Role Integration: LX Security Roles and Units are published as IFS Security Roles via SyncSecurityRoleMaster BODs. LX receives inbound SyncSecurityUserMaster BODs from IFS to create or update user records in SYS600. SYS600 Exit Points trigger ProcessSecurityUserMaster BODs to request user creation or updates in IFS on behalf of LX. Available Versions: 8.3.5, 8.4.1, 8.4.2 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