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 57595 Rate this article: 5.0 Anthony EtzelAnthony Etzel Other posts by Anthony Etzel Contact author Facebook page Twitter Linked In YouTube Website
21Mar2023 Infor LX & BPCS Tip: Ensure Correct Tax Code Usage on AP Invoices with this New Enhancement in LX Tuesday, March 21, 2023 Read more A new enhancement in LX adds the “A/P Invoice Tax Code new system parameter” to the Tax System Parameters, SYS810D. This company level system parameter determines whether Item / Vendor Tax Code is mandatory in the Accounts... Read more
1Mar2023 Infor LX & BPCS Tip: The Top 6 Benefits of CLD Wednesday, March 1, 2023 Read more The Configurable Ledger (CLD) is the central repository for a client’s financial accounting data. Did you know it can do all of the following?... Read more
17Jul2025 Infor LN & Baan Tips & Tricks for FINANCE:Â Moving calendar periods Thursday, July 17, 2025 Read more You can move monthly periods to a different parent period. For example, if you have a monthly calendar, you can create quarter periods and move months to the quarters. Select Financials > Global Ledger > Setup > Finance Enterprise Group > Maintenance. Open the finance enterprise group. Click the Calendar tab. Open the calendar for which you want to move periods. Click the Hierarchy tab. Select the periods to move. Select Actions > Move. Select the new parent period under which you want to move the periods. Click OK. Read more