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

Crossroads RMC Presents 4 Must-Attend Sessions at inPOWER 2024

September 23-26, 2024

George Moroses 0 10541 Article rating: 5.0

Crossroads RMC Presents 4 Must-Attend Sessions at inPOWER 2024
Empower Your Business with Innovation

September 23-26, 2024

As a Gold Sponsor, Crossroads RMC is thrilled to present four impactful LX Track sessions this year, designed to inspire and empower attendees to drive success within their organizations:

Infor LN & Baan Tips & Tricks for TECHNOLOGY: Adding a Timestamp to LN Standard Tables

Kathy Barthelt 0 30550 Article rating: 5.0

Table Timestamp Definitions (ttadv4136m000)

Use this session to define timestamps for Infor LN tables. A timestamp is an additional column that stores the date and time of the last change for each record.

Timestamps are utilized by features like the extraction logic of CPM Enterprise Analytics. They enable CPM to perform incremental data extractions. For example, CPM can use the timestamps to extract records that were changed during the last week in a weekly extraction process.

To Create Timestamps...

Infor LN & Baan Tips & Tricks for OPERATIONS: Absorbing Cost Items into Projects

Kathy Barthelt 0 20348 Article rating: 5.0

Operations: To absorb the cost of cost items into specific projects, you'll need to handle them as customized items. However, cost items cannot directly be defined as customized items. Customized items must be physical, either manufactured or purchased.

That said, it's still possible to absorb cost items into a project, although indirectly. Here's how:

  1. Set Up Ledger Account: First, create a new ledger account in session tfgld0508m000 and set the type to "PCS" (project) in the operations management integrations. This account will be used for matching and approving purchase orders for cost items.

  2. Create and Activate Projects: Ensure that the necessary projects are created and set to active status.

  3. Purchasing Cost Items...

Infor LN & Baan Tips & Tricks for FINANCE: Ledger Account Blocked Error

Kathy Barthelt 0 23190 Article rating: 5.0

When attempting to post to a ledger account, users may occasionally encounter an error indicating that the ledger account is blocked. To resolve this issue, navigate to the Chart of Accounts session (tfgld0508m000) and select the Miscellaneous tab. Once there, review the Blocking field. The available settings are:

  1. Free
  2. Blocked for manual input (integration transactions and other automatic transactions can be posted with this setting)
  3. Blocked for all purposes.

Infor News You Can Use: Infor Velocity Summit

October 1-2, 2024 (Las Vegas) & October 22-23, 2024 (Amsterdam)

Kathy Barthelt 0 10553 Article rating: 5.0

Antiquated technology has no place in today’s fast-moving world

To succeed, you need to move with velocity—this means not just moving fast, but with purpose and precision. Velocity-powered businesses measure success by the value created at every turn, not just by speed.

At the Infor Velocity Summit, we’ll unveil our latest innovations across generative AI, process intelligence, ESG, and more, distilled from our work with 60,000 customers and built for your industry, from the ground up.

Discover how possible happens>  https://www.infor.com/events/infor-velocity-summit

The Far-Reaching Impact of Disconnected Data: From Operations to the Executive Suite

Kathy Barthelt 0 11591 Article rating: 5.0

The Impact of Disconnected Data Across Your Organization

Operations Impact:

  • The warehouse manager’s spreadsheet tracking inventory levels and supplier shipments is disconnected from your ERP.
  • Dealer Portal Email orders need to be manually entered into the system.

Finance Impact:

  • Budgeting data is maintained in isolated spreadsheets, unlinked to quotes or sales figures in your ERP.
  • Open purchase orders and invoices need manual matching and approval, creating inefficiencies.

Technology Impact:

  • A large number of reports must be generated outside the ERP for teams to stay "up to date."
  • Valuable time is spent exporting ERP data for analysis in external data cubes.

Executive Impact:

  • Compiling an accurate picture of inventory and financial health is a struggle when data comes from multiple sources.
  • Lack of visibility to inventory shortages results in losing customers due to stockouts or delays.

Disconnected data refers to information stored separately from your main business system, such as your ERP. While this data holds value, the lack of integration creates challenges across your entire organization—often more than expected...

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Role-Based Security

George Moroses 0 16817 Article rating: 5.0

Role-Based Security introduces Role type profiles and allows combining the use of Role profiles with the traditional LX User type security profile functionality. The new Role type profile can be defined to allow or deny access to All Products, Attention Key, Products, Programs, and Transaction Effects. Facility, Warehouse, and Company securities are still defined solely by the User profile settings and are not affected by the assignment of a Role. Where applicable, the Role authority is displayed alongside the User authority on the security profile maintenance screens making it easy to see where there are differences in authority between the User and the assigned Roles. 

When Users are assigned to Roles, security access in LX becomes a combination of authorities granted or denied by the Role, plus any User Exceptions. User Exceptions override authorities set by the Roles. A User can also be assigned to more than one Role.

First7891012141516Last

Tips:  LX | BPCS | M3

Improves control over PO costing changes during invoice entry by replacing passive warnings with an intentional override action.

  • In ACP500D3 (Invoice Entry PO Costing), users previously could unintentionally accept changes by pressing ENTER, even when quantity to cost or amount to cost values had changed.

  • A new “F14 to Override” warning message replaces the old message:
    “Details have changed. Press enter again to accept data.”
    This ensures users acknowledge and confirm significant changes explicitly.

New System Parameter:

  • “Apply GRN Costing Tolerance for PO Costing” (optional):

    • Within tolerance: Displays the original message —
      “Details have changed. Press enter again to accept data.”

    • Outside tolerance: Triggers the new override requirement —
      “F14 to Override”

Benefits:

  • Enhances oversight and reduces unintentional cost acceptance.

  • Enables better control of PO costs when invoice details differ from expectations.

Last

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for TECHNOLOGY: Data Sharing Methods (Advantages and Disadvantages)

Depending on the multicompany scenario you choose, an implementation team must decide whether or not tables must be logically linked or if data must be synchronized in another way to achieve availability of data across various companies. 

There are 3 ways in which data may be shared among companies. Here are some advantages and disadvantages of each:

  1. Logical Table Linking - If two companies use the same physical data, the physical table exists, or is used, in only one company: the physical company. Each piece occurs only once: one instance of the same data. If the term logical table linking is used, users from multiple companies use a single physical instance of the data. If the company tables are on the same server, this can be accomplished by logical table linking. Access to specific data can be restricted, if required.

    • Advantages: Logical Table Linking takes place in real time; therefore, the moment a record is created or modified in one company, a record becomes available in all other linked companies as well. The setup and maintenance of logical table linking is easier than the setup and maintenance of data replication. Logical table linking is extremely reliable because this type of linking is independent of network connections and user interventions. 

    • Disadvantages: Table sharing implies that all attributes for a record are the same in all companies. Therefore, suppose you share the item table and, for a particular item in a company, the product class is XXX. In this case, in all other companies, the product class for this item must be XXX as well.

  2. Data Replication - In this situation, each company has exactly the same data, but each company has a unique copy of the data. The same piece of data exists in multiple (physical) places: multiple instances of the same data. The process to copy the data is called data replication.

    • Advantages: Rather than using table sharing by means of the logical linking of tables, you can replicate the content of tables between companies. The advantage is that, on company level, some (non-key) attributes of a record can differ by company. For example, if the bills of materials are replicated instead of shared, for each company, you can link a different warehouse to the bill of material. As a result, the bills of materials can be the same across all companies and only the warehouses differ. Using replication, you can also make only a subset of the records available in other companies. For example, if you replicate items between companies, in a sales company, for example, by means of the item group, you can only make end items available. In addition, you can replicate only a subset of items, for example, depending on the item group. Note that replication also requires that the referenced tables are replicated or shared.

    • Disadvantages: Replication is not in real time, and therefore, for processes that require real-time integrated data as the financial integration processes, replication is not an option. For replication, you also must take into account the sequence in which you replicate. First, you must replicate the child tables and then the parent tables, and therefore first the business partners and then the purchase contracts. During the replication process, the data must be frozen. This point is of particular importance if the replication process takes a lot of time.

  3. Manual Syncronization - If only a small number of records are the same between some companies, you can enter, maintain, and keep the records synchronized manually. Note that the more dynamic data is, the more difficult this process is. This solution is strictly procedural. Therefore, depending on the discipline of the users, the solution is error sensitive: data can be forgotten, updated too late, or typing errors may occur.

  • Advantages - The main advantage is the flexibility so that only the data that really must be shared can be kept synchronized. By manually keeping data synchronized, not all attributes of a record need to have the same value.

  • Disadvantages - The main disadvantage is that this method depends on user interaction. Therefore, the method depends on the user’s time - because the method is not a real time procedure and the user may forget to update the data - and users can make mistakes.

Previous Article Infor LN & Baan Tips & Tricks for EXECUTIVES
Next Article Infor LN & Baan Tips & Tricks for FINANCE: Cash Flow Statements (tfgld 0123m100)
Print
32904 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories