George Moroses / Wednesday, June 24, 2020 / Categories: Infor ERP Tips, Infor LX & BPCS Tips, Partner News, Infor Infor LX & BPCS Tip of the Week: Journal Upload – EGLi EGLi users who maintain journal entries in a Microsoft Excel spreadsheet can use this utility to upload journal entries to EGLi. The Journal Upload installation program adds an Add-Ins tab to Microsoft Excel. This tab includes options to connect to the server where EGLi is installed and to open a spreadsheet template to use for manual journal entry. When the spreadsheet is complete, the Add-Ins tab is used to upload the spreadsheet. To install Journal Upload: The Power-Link Installation page has links to the Client installation programs and a link to download and install the Journal Upload utility. To access this page, use this link with your own values for system and NetLinkport: http://system:NetLinkport/Installs/ClientInstall/Install.html where system is the server where IDF is installed and NetLinkport is the Net-Link port, typically 36001 On the Power-Link Installation page, click the link provided to download and install EGLi Journal Upload. Follow the screen prompts to complete the installation on your PC. To verify the installation, open an Excel spreadsheet. Confirm that the Add-Ins tab is on the spreadsheet. See the Infor Enterprise General Ledger for System i Journal Upload Installation and Infor LX Configuration Guide. Previous Article Infor LN & Baan Tip: Open Transactions Check – LN 10.7 Next Article Infor will no longer support LX or BPCS on IBM i 7.2 after April 30, 2021 Print 51940 Rate this article: 5.0 George MorosesGeorge Moroses Other posts by George Moroses 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