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 LN & Baan Tips & Tricks for TECHNOLOGY: Application Personalization

Kathy Barthelt 0 12467 Article rating: 5.0

Users can personalize sessions and apply special formatting to the data displayed in sessions. The personalizations and formatting settings that are specified by the users are stored on the LN server. Administrators can maintain these settings.

  • Session personalizations

    Users can personalize sessions in various ways. users can, for example, hide fields, change labels, customize the toolbar, and move fields to another tab. Administrators can maintain the personalizations defined by the users. For example, an administrator can export personalizations to an XML file, import personalizations from an XML file, and copy personalizations to another user, to a DEM role, or to a company number.

  • Report personalizations

    You can use the Report Designer (ttstppersrep) to personalize the layouts and style of reports, without modifying the standard reports or using an external reporting solution. The changes are stored as personalizations.

    You can also generate new reports that are based on a selection of fields from the application data model. These reports are generated in the extensibility package. You can personalize these reports in the Report Designer (ttstppersrep), or modify them in Infor LN Studio.

    For details, see the Infor LN Report Designer Development Guide
     
  • Conditional formatting

    users can define conditions to apply special formatting to the data displayed in LN sessions. The users can define multiple conditions per session and different types of formatting, such as a specific color for particular fields or rows, and a warning symbol for particular rows. Administrators can maintain the formatting settings specified by the users and can define system-wide formatting settings.

Infor LN & Baan Tips & Tricks for OPERATIONS: Deleting Purchase Orders

Kathy Barthelt 0 15036 Article rating: 5.0
  • If Finances is implemented, we recommend that you do not delete order data in a fiscal year that has not yet been fully closed. This is because the GRINYA process uses information that would be deleted by this action. For best results, check whether the logistical balance for non-invoiced receipts matches the balance of the GRINYA accounts for the periods up to which you want to delete purchase order data.
  • When a purchase order is canceled, you can only delete the purchase order and the related tables. If only a purchase order line is canceled, the line can be deleted and archived.

You cannot delete a purchase order (line) if:

  • The linked warehouse order is closed but cannot be removed.
  • The purchase order is linked to a PCS project that is not yet archived. When the PCS project is archived, the purchase data is also archived and you can delete the purchase order.
  • A consignment replenishment order is not yet consumed completely.
  • The invoice is yet to be completely matched and approved.
  • The invoice amount is not yet inserted as turnover history.
  • The sales order or service order that is linked to the purchase order line, and for which an internal invoice must be sent from the purchase office to the sales office or service office, is not yet invoiced. In this case, you cannot delete the purchase order line before the sales order or service order is invoiced.

Infor LN & Baan Tips & Tricks for FINANCE: Cash Forecast Reports and Inquiries

Kathy Barthelt 0 10310 Article rating: No rating

To produce the cash flow forecast, the combined information from the following is used:

  • Customer and supplier accounts
  • Open sales and purchase orders
  • Purchase quotations
  • Purchase requisitions
  • Standing orders
  • Projects
  • Financial budgets

You can use the bank balances of the bank relations that are maintained in the Bank Relations (tfcmg0510m000) session, to generate the reports with details of cash inflows and outflows of the company for a specified period of time.

You can also manually specify the Opening Balance for the cash forecast. Use the sessions below to print and generate the reports:

  • Cash Forecast Summary by Date Range/Currency (tfcmg3518s000)
  • Print Cash Forecast Details by Date Range/Currency (tfcmg3412m000)
  • Print Cash Forecast Summary by Period/Currency (tfcmg3410m000)
  • Cash Forecast Summary by Date/Currency (tfcmg3519s000)
  • Print Detailed Cash Forecast in Cash Forecast Currency (tfcmg3413m000)
  • Cash Forecast Components by Date/Currency (tfcmg3520m000)
  • Print Forecast Components by Date/Currency (tfcmg3420m000)

Infor LX/BPCS Tips & Tricks for OPERATIONS: Override inspection days lead time at item-facility

George Moroses 0 6171 Article rating: 5.0

Item Facility Master has a new attribute to define the override inspection days lead time CICP.ICINSD.

  • When an item facility has a defined override inspection days lead time, that value will be used instead of the system parameter inspection days lead time.

MRP exception report, MRP200B
Purchase planning report, PUR285B
Purchase order / Requisition maintenance, PUR500D3
Purchase order consolidation / release, PUR640B1
Vendor splits, PUR653B

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Improve WebTop Grid Support for MRP320D Master Schedule Detail Inquiry

George Moroses 0 5656 Article rating: No rating

This enhancement improved the subfile utilized in MRP320D Master Schedule Detail Inquiry -SCR001 by expanding the subfile with data rather than clearing the subfile as user pages. This change provides full support for the WebTop 4.8 Grid decorator.

This enhancement updated the approach used to populate the subfile to allow a deployed Webtop Grid to function correctly. There is no visible or user-impacted change to the way the program functions.

This enhancement provides improved functionality and full support of a Webtop grid applied to the subfile.

Infor LX/BPCS Tips & Tricks for FINANCE: IDF Ledger Book Journal Line Analysis

George Moroses 0 2845 Article rating: 5.0
  1. This enhancement added the IDF Ledger Book Journal Line Analysis business object for displaying reference information on summarized journal lines. This enhancement provided Ledger Book Journal Line Analysis business object and a bi-directional relationship to Ledger Book Journal Line Source.
  2. This enhancement provides the user with detailed reference information on summarized journal lines for analysis purposes.

✨ You're Invited: LN NAUG Face-to-Face Annual Meeting 2025

May 13–15, 2025 | Naperville, IL

Kathy Barthelt 0 766 Article rating: No rating

Why You Should Attend

LN NAUG Face-to-Face is the must-attend gathering for Infor LN and Baan ERP users across North America. Join fellow ERP professionals, decision-makers, and industry experts for three days of knowledge-sharing, innovation, and networking you won't find anywhere else.

💡 Get Inspired by real-world success stories from LN users

🤝 Connect with peers and solution providers shaping the future of Infor LN

📈 Level Up your ERP strategy with sessions on automation, analytics, integration, and more


Visit Crossroads RMC's Booth

Explore what’s new and what’s next with Crossroads RMC:

🔹 AI Consulting – Unlock insights and transform your ERP processes
🔹 Visual Job Execution Software (VJES) – Train new employees faster, work smarter
🔹 LN Integration Services – Seamlessly connect systems for maximum efficiency
🔹 Help Desk Services for Infor LN – Support that understands your business
🔹 …and more!


🎟️  Don’t miss out — register now and reserve your spot at LN NAUG 2025!

Meet the Experts - EDI: A Competitive Advantage for Manufacturers

Frank Petrasio 0 2333 Article rating: 5.0

Discover how Electronic Data Interchange (EDI) can elevate your manufacturing operations and give you a competitive edge. Join Sarah Butler, UniLink's Director of Professional Services, and a panel of ERP and EDI experts as they demystify EDI for Infor XA, LN, and LX users and share actionable strategies for successful implementation. You’ll learn how EDI simplifies document exchange to boost efficiency and eliminate errors while adapting to diverse customer requirements for seamless adoption. Discover best practices for onboarding trading partners, mapping, testing, and maintaining EDI integrations to ensure compliance with major distributors and retailers. By the end of the discussion, you’ll be equipped with the knowledge to streamline your operations, improve communication, foster stronger trading partnerships, and position your business for long-term success. Panel will include:

  • Randy Kenney, Product Manager | Guide Technologies
  • Frank Petrasio, Director, IBMi Group | Crossroads RMC
  • Phil Harley, CTO and General Manager | UniLink
  • Mitch Copman, Director of Sales & Marketing | UniLink
  • Sarah Butler, Director of Professional Services | UniLink


[Watch Video]

12345678910Last

Tips:  LX | BPCS | M3

How can I use an alternate item on a shop order?

The best way is to have the approved alternate item appear on the Bill of Material just after the standard item with a zero required quantity. Now the alternate item will appear on the Shop Order. So, if the standard item is not available, the alternate item can be issued to the shop order.

When the shop order is closed out, one item will have an unfavorable variance while the other shows a favorable variance. This is an easy way to provide alternate items provided engineering approves and they are part of the Bill of Material.

FirstLast

Tips: LN | Baan

George Moroses

Infor LX & BPCS Tip: PowerLink

PowerLink is a Windows-based client for end-users within the Infor Development Framework (IDF). PowerLink allows exports/imports from/to the ERP database, but how much do you really know about it? Here is some helpful information about PowerLink.​

Why does PowerLink sometimes fail to export all records?
There's not a finite amount of records that PowerLink can export. However, PowerLink export was never intended to handle large volumes of data. It was designed as a quick snapshot of a fairly small subset and a simple view of the user's PowerLink card. 

What is the maximum amount of data that can be exported?
The maximum number of records is only limited by the system resource like memory, etc. When the system runs out of resources, an OutOfMemory error should occur. In previous testings, we have exported +1 million records, although the size of records differs greatly between business objects, the total size of the data could be an issue. For larger volumes of data, customers should investigate other tools such as the iSeries Access "Data Transfer from iSeries Server" feature to download directly to Excel.

How do I know if the size of the data is an issue?
1. When exporting to an external file (text, HTML) then importing to Excel: You can easily check the output (text, HTML) to see if the intermediate output has all the records. This can be done by visual inspection or through the use of column totals. Simply compare between the output and what you see in PowerLink. If the exported file has all the records, then the problem is definitely Excel.
2. When exporting to clipboard, then copy/paste to Excel: There is a clipboard export size limit that is controlled through client preferences. Check the exported data in the clipboard, and see if it contains all the records or only partial records due to the size limitation set in client preferences. If limited, change the client preferences using Customize from the Main browser > Preferences > Miscellaneous tab > Limit Clipboard Export, and try the export again. If the clipboard has all the records the problem is in Excel, which we don't have jurisdiction over.

Suggestions for improving the export process. 

  1. Reduce the number of columns seen in the view. This will serve to reduce the data being exported and may increase the number of records that can be exported. 
     
  2. Reduce the complexity of the view. If the view has one column that lives on a related object, then it has to build SQL behind the scenes to get that related record. If all of the columns come from a single business object, then the processing will be significantly faster.
     
  3. Export to HTML, which can be opened directly by Excel, Access, and many other programs. This reduces the processing of the export formatting because PowerLink needs only to put begin and end tags around each data element. This will also preserve column alignment when Excel or other programs open the file.
     
  4. Unless you are exporting a fairly small volume of data, export to a file, not clipboard. Clipboard is held in memory until the entire view is read, and records are written to the file as they are retrieved.
     

 Also see KB 1357068 for more information about testing your view.

Print
48671 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories