Anthony Etzel / Tuesday, July 9, 2019 / Categories: Infor LX & BPCS Tips Infor LX & BPCS Tip of the Week: LX 8.4 Database The database in LX 8.4 has undergone a significant change from previous versions. The database has been created using SQL DDL language instead of the old DDS language. The newer format allows for LX to take better advantage of advances in IBM database technologies as they move forward. Additionally, LX will be better able to make changes to tables (aka files) in the future without causing very large MR explosions to replace all programs that use a specific table. To ease the impact of this significant change, the LX tables (aka physical files) have new names that are the same as the previous version file names but with a “P” at the end, for example IIM is now IIMP. The old file names now belong to SQL views that looks just like the tables. This change made it easier to upgrade all the LX programs without changing every reference to every file. Many of the logical files remain although some have been replaced by SQL indexes to improve performance. Previous Article Crossroads RMC is Proud to Announce Product Certification for Baan IV to Avalara! Next Article A/P Payment Update in LX 8.3.4 Print 57425 Rate this article: 5.0 Anthony EtzelAnthony Etzel Other posts by Anthony Etzel 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