Infor ERP Tips and Infor ERP News for Infor LX, BPCS, Infor ERP LX, Infor LN, Infor ERP LN, Baan, Infor M3, and Movex

Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Infor LX & BPCS Tip of the Week: Journal Upload – EGLi

George Moroses 0 54224 Article rating: 5.0

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:

  1.  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
     
  2. On the Power-Link Installation page, click the link provided to download and install EGLi Journal Upload.
     
  3. Follow the screen prompts to complete the installation on your PC.
     
  4. 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.

Infor LN & Baan Tip: Open Transactions Check – LN 10.7

Kathy Barthelt 0 116013 Article rating: 5.0

When closing a project, users were informed about open transactions blocking the closure process. To proactively check on open transactions, the Show Open Transactions option has been introduced in the Project Status (tppdm6107s000) session. With this option, issues can be resolved before changing the status.

Infor LX & BPCS Tip of the Week: LX 8.4 Enhancement – Company Security for ACR510

George Moroses 0 19233 Article rating: 5.0

This enhancement provides LX Company Security to Invoice Maintenance, ACR510. Only users authorized to the invoice company can view or maintain invoices.

User must be authorized to ACR as a product or ACR510 as an individual program in Security Master Maintenance, SYS600. Additionally, ACR510-01, displays all records, but if the user tries to revise or display a transaction record for a company the user is not authorized to, this error message is displayed: “User is not authorized to the transaction company.”

Infor LX & BPCS Tip of the Week: Item Deletion Option in IDF Enterprise Items

George Moroses 0 23407 Article rating: 5.0

Previously, users were unable to delete items in IDF Enterprise Items when they have inventory balances or the item is connected to ancillary records, such as sales history records. This feature added in LX 8.4 provides the ability to delete an item when sales history records are found but all sales history activity is zero.

When the user attempts to delete an item in IDF Enterprise Items that is tied to a sales history record, the panel displays a message that the item cannot be deleted. The user can then run the Delete Validation Report to determine which records are tied to this item that prevents the validation. If the item no longer has manufacturing activity but had old sales history, the item can be deleted.

Infor LN & Baan Tip of the Week: In Transit Inventory Report – LN 10.7

Kathy Barthelt 0 139762 Article rating: 5.0

A new In-Transit Inventory report can be printed in the Print In-Transit Inventory (whinr1410m300) session. The report provides an overview of company inventory that is on the move and not stored in a warehouse. This concerns only inventory that is transferred from one warehouse to another. Items that are shipped to, for example, customers or projects, or items that are issued to production lines or service departments are excluded.

The report shows item inventory....

First5859606163656667Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Crossroads RMC

End of Year E R P Checklist: Streamline Your Transition to the New Year

The end of the year is a busy time for everyone, but a little preparation can make the start of the next year smoother and more productive. Here's a checklist broken out by the department to help optimize your ERP system as you wrap up this year.

All Departments End of Year Checklist

_____1. Strategic ERP Review

  • Review and Update Reports and Dashboards
    • Evaluate standard reports and dashboards to ensure they align with current business requirements.
    • Adapt them to reflect changing priorities so the information remains relevant and actionable.

_____2. ERP Support and Maintenance

  • Address Outstanding Support Issues
    • Reach out to Crossroads RMC for unresolved support concerns or system issues.
    • Collaborate to resolve lingering problems and clear your to-do list before the year ends.

_____3. Training and Consulting Services

  • Assess Team Training Needs
    • Conduct a skills gap analysis to identify areas where your team may require additional ERP training.
    • Allocate resources for consulting services to help your team remain efficient and effective with the ERP system.

_____4. Future Investments

  • Evaluate New ERP Features or Modules
    • Review potential ERP investments to support business growth.
    • Align new features or modules with the organization’s current and future needs to maximize ROI and operational efficiency.


IT/Technology Checklist

_____1. Data Cleanup

  • Perform data deduplication to eliminate redundant entries.
  • Validate existing data to ensure accuracy and reliability. This reduces errors and boosts confidence in reporting.

_____2. Archive/Remove Obsolete Data

  • Archive or delete outdated data to improve system performance and reduce database clutter.
  • Streamlined data management enhances system usability and reduces search inefficiencies.

_____3. Monitor System Performance

  • Review system logs and performance metrics to identify bottlenecks.
  • Address any recurring lags or slowdowns to improve overall system efficiency.

_____4. Review User Access Controls

  • Audit user roles, permissions, and access rights for accuracy.
  • Remove or update access for users with altered responsibilities or those no longer with the organization.
  • This step mitigates cybersecurity risks and ensures compliance with data governance policies.

_____5. Test Emergency Recovery Procedures

  • Perform a test run of backup and recovery protocols to verify their effectiveness.
  • Ensure all critical data can be restored in the event of a disaster.

_____6. Prepare for Date-Dependent Processes

  • Audit scheduled jobs, scripts, and automation with hard-coded dates.
  • Update these dates to reflect the upcoming year to avoid disruptions in processes.

_____7. Bonus IT Tasks

  • Communicate planned system downtimes with all stakeholders in advance.
  • Document any changes made to the system during this period for future reference.
  • Encourage feedback from end-users on potential system improvements.

Operations Checklist

_____1. Critical Data Accuracy

  • Ensure critical data, such as inventory levels and customer information, is up-to-date and accurate to support efficient facility operations.
  • Remove discontinued items.
  • Delete sold purchase receipts.
  • Clear lot attributes for sold lots.
  • Non-Manufacturing Environments: Update the standard cost field based on current cost.

_____2. Inventory Management

  • Conduct a full physical inventory and update quantities before year-end or establish a cycle-counting program to maintain accuracy.
  • Prepare users for year-end completion of all inventory adjustments, receipts, and invoicing.
  • Determine processes for handling new-year transactions without immediate posting.

_____3. Purchase Orders & Contracts

  • Close out all purchase contracts and purchase orders (POs) to prevent further receipts against any contract line items.

_____4. Costing & Manufacturing Tasks

  • Decide on new standard costs for the upcoming year (for Manufacturing environments).
  • Establish cutoff dates for removing archived BOMs and closed/canceled manufacturing orders.

_____5. LX-Specific Tasks

  • Run PRF900 to update performance measurements and purge closed shop orders.

_____6. Fixed Assets & Depreciation

  • Review and update the depreciation schedule for fixed assets.
  • Verify depreciation expenses for the year have been accurately recorded.
  • For any new assets added during the year, ensure they are included in the depreciation schedule.

Finance Checklist

_____1. Period Closing & Reconciliation

  • Close financial periods and reconcile accounts to ensure financial data consistency and readiness for audits, tax filings, and other financial processes.
  • Set up financial periods for 2025 before the year begins.
  • Open the January 2025 period.
  • Finalize all outstanding transactions from 2024.

_____2. LN-Specific Tasks:

  • Perform a soft-close for any open periods in 2024.

_____3. LX-Specific Tasks:

  • Copy the CEA Book for the new year, ensuring all Journal Sources are set up. This ensures all required records are in place.
  • Run ACP920 (1099 Report) before ACP910 (Year End Close), as the Close Program clears 1099 Payments History.

_____4. Financial Cleanup

  • Address any old sales invoices and ensure they are properly closed.
  • Rectify any outstanding financial integration errors.
  • Set up and test new integration mappings for 2025 in a test environment.
  • Review and update jobs to ensure they are configured correctly for 2025 processing.
  • Identify purchase invoices for cash-flow management that won’t be paid until 2025.

_____5. Payroll Review

  • Verify employee payroll records and reconcile them with financial statements.
  • Ensure all employee information is up-to-date, including unpaid sick leave and vacation time, and carry over or adjust as necessary.

_____6. Accounts Receivable & Payable

  • Resolve any outstanding issues or unpaid invoices in customer or vendor accounts.
  • Record all payments and receipts to maintain accurate financial data.
  • Review outstanding receivables for potential bad debts.
    • Decide whether to carry them over into the new year.
    • Adjust the allowance for bad debts as necessary.

_____7. Bonus Financial Tasks

  • Verify that ERP calendars are set up for the new year with holidays correctly indicated.
  • Ensure proper mapping and testing of financial processes to avoid disruptions in the new year.

Taking these proactive steps will set your ERP system up for success in the coming year.

Print
9370 Rate this article:
5.0
Crossroads RMC

Crossroads RMCCrossroads RMC

Other posts by Crossroads RMC

Contact author

x

Categories