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 57429 Rate this article: 5.0 Anthony EtzelAnthony Etzel Other posts by Anthony Etzel Contact author Facebook page Twitter Linked In YouTube Website
9Jul2014 BPCS/LX Tip of the Week: Changing the Master Schedule Wednesday, July 9, 2014 Read more You can change your master schedule by specifying the type of master schedule update to perform. You can run a Net Change or Regenerative Schedule. You also have the ability to clear the lower level requirements out of the Planned and Firm-Planned Order file. Read more
3Jul2014 BPCS/LX Tip of the Week: What is Lean Make to Order? Thursday, July 3, 2014 Read more This is a simple way to go from the customer order to making the order and shipping the order. It involves a few simple steps: Receive and enter the customer order Automatic credit review Automatic release of the shop order tied to the customer order Issue material, report labor to the production order receipt Pick the order, ship the order, invoice the customer With lean, you can skip processing the demand through MRP. You can go directly from the customer order to the shop order creation. 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