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 53999 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 113657 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 18737 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 23130 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 132239 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

Kathy Barthelt

Infor LN & Baan Year-End Processing Checklist for Period and Fiscal Year Closure

The conclusion of the fiscal year is inevitably a hectic period, making it crucial not to overlook essential tasks within your ERP system to ensure a seamless year-end close and set the stage for a successful start to the upcoming year. Below are critical items to include in your comprehensive checklist:

Year-End Close Process:

  1. Remove discontinued items.
  2. Eliminate sold purchase receipts.
  3. Clear lot attributes for sold lots.
  4. Update standard cost based on the current cost field (for environments without Manufacturing only).

Prepare for Year-End Close:

  1. Conduct a comprehensive physical inventory and update quantities before the actual year-end or establish a robust cycle-counting program.
  2. Review and post any applicable sales and purchase invoices/returns.
  3. Prepare users for a year-end push to complete all year-to-date inventory adjustments, receipts, and invoicing.
  4. Determine procedures for handling new year transactions without immediate posting.
  5. Establish new standard costs for the upcoming year (Manufacturing).
  6. Discuss cutoff dates for removing Archived BOMs and Closed/Canceled Mfg Orders (Manufacturing).

Finance Specific Items:

  1. Set up financial periods for 2024 (fiscal, reporting, and tax, as applicable).
  2. Open January period in 2024.
  3. Finalize any outstanding transactions from the current year (2023).
  4. Perform a soft-close for any open periods in 2023.

General Baan/LN Tips:

  1. Issue any pending old sales invoices.
  2. Resolve outstanding financial integration errors.
  3. Establish new integration mapping for 2024 as needed.
  4. Test the mapping in a controlled environment before the new year.
  5. Review and update jobs to ensure they will process in 2024.
  6. Determine, for cash-flow purposes, which purchase invoices won’t be paid until 2024.
  7. Verify that calendars are set up for the new year with holidays correctly indicated.
  8. Check jobs to ensure that any with hard-coded dates will point at the new year.

For additional insights and tips on year-end processing, refer to the relevant documents in the Infor Knowledge Base.

 KB 

 Content 

 1879191  

 Document including step by step procedure, possible error/warning messages, and more (Infor LN) 

 1147023 

 Step by step procedure description (Infor LN)

 1116239 

 Step by step procedure description (Infor LN)

 1117334

 Step by step procedure description (Infor LN; Portuguese)

 1171300 

 Step by step procedure description (Baan IV) 

If you require assistance or have any questions, feel free to reach out to us, and we'll gladly guide you through the necessary steps to ensure a thorough and accurate completion of your year-end processes. Contact us at 1.800.762.2077 or via email at solutions@crossroadsrmc.com. Your success is our priority, and we're here to help.

Previous Article Infor LN & Baan Tip: When is backflushing disabled in LN?
Next Article Infor LX / BPCS & Infor LN / Baan Tip: Time for the Notorious TRIO: Manual -  Physical -  Inventory
Print
68312 Rate this article:
2.5
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories