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

5 WARNING SIGNS Your Disconnected Business Systems Are Costing You Money

Crossroads RMC 0 9677 Article rating: 5.0
  1. You Can’t Track Project Costs in Real-Time
    If you're waiting until after a project wraps up to find out whether it was profitable, that’s a major red flag. Without real-time cost tracking, you're making critical decisions in the dark.

  2. Quoting and Estimating Are Slow, Manual, or Inconsistent
    Does it take hours—or even days—to build a custom quote because you're pulling information from multiple systems? That lost time translates directly into lost sales opportunities.

  3. You Rely on Spreadsheets for Critical Operations
    Spreadsheets are useful—until they’re not. Issues like version control problems, accidental overwrites, and human error can lead to costly mistakes.

  4. Scheduling and Inventory Management Are Disconnected from Financials
    If your production and finance teams aren’t working from the same data, it’s only a matter of time before you face delays, stockouts, or budget overruns.

  5. You Don’t Have a Real-Time View of Project Profitability
    Without live costing tied directly to jobs, small losses can accumulate unnoticed, until it's too late.

Disconnected data refers to information stored outside your core business systems, like your ERP. While this data has value, a lack of integration causes inefficiencies and misalignment across your organization, often more than you realize.

The Cost of Disconnected Data...

Infor LN & Baan Tips & Tricks for TECHNOLOGY: Authorization and Security - LN REST APIs

Kathy Barthelt 0 12768 Article rating: 5.0

In typical LN REST API integrations, permissions and authorizations are not implemented or rarely used. To ensure smooth data exchange and avoid errors, it is recommended to disable the authorization and security settings.

Recommendation:

  • In the Authorization and Security Parameters session (tcsec0100m000):

    • Clear the Authorization and Security Enabled check box.

    • Clear all check boxes under Authorization Enable for on the Enabling tab.

Why This Matters:

  • Enabling authorization and security without proper setup can lead to errors and blocked transactions during integration.

  • For example, work center permissions may interfere with:

    • Creating new shifts

    • Booking machine hours

    • Read more

Infor LN & Baan Tips & Tricks for OPERATIONS: Copy Customized Product Structure to Standard Structure (tipcs2232m000)

Kathy Barthelt 0 10923 Article rating: 5.0

This functionality allows you to copy the product structure of a customized item to a standard item.

Note: When a customized structure is copied to a standard structure, the Customized check box in the Items session (tcibd0501m000) is cleared.

Item Types:

  • Standard Items: Identified by a regular item code.

  • Segmented Items: Consist of a project code segment and an item base segment (i.e., the customized item’s item code). Segments are defined in the Item Code Segmentation session (tcibd0500m000).

Only components valid for the specified Effectivity Unit will be copied.

Copy Options:

  • Target Routing Code
    Enter the code of the standard routing to which the customized structure should be copied.

  • Copy Product Structure
    Choose whether to:

    • Copy the entire structure

    • Copy only the first level

    • Perform the copy interactively

  • Reference Date
    Only parts of the product structure valid on this date will be copied.

  • Copy E-Item Relationships
    If selected, related E-item records will be copied.

  • Copy All Components and Effectivity Statements
    If selected, unit effectivity is copied to the standard structure. You can specify the unit.
    Exceptions related to routings and operations (that meet date effectivity) are also copied.

  • Alternative Material
    If selected, alternative BOM components are included in the copy.

  • Use-Up Material
    If selected, use-up materials from BOM components are included.

Infor LN & Baan Tips & Tricks for FINANCE: Rebuild History for Account Matching (tfgld1218m000)

Kathy Barthelt 0 12708 Article rating: 5.0

Use this session to rebuild the ledger account history for account matching. This is particularly useful if you’ve recently defined a ledger account, on which transactions already exist, as a matchable account.

You can specify the fiscal year and period for which you want to rebuild the account matching history.

Note: This session can also be used to remove unmatched transactions if you decide to stop performing account matching for a specific ledger account.

Field Information

Selection Range

  • Use Job Reference Date
    If selected, Infor LN uses the Job Reference Date as the basis for rebuilding history data.

  • Job Reference Date
    Specifies the date and time used for the rebuild process.
    Enabled only if "Use Job Reference Date" is selected.

  • Financial Company
    The financial company for which you want to rebuild a ledger account history.

  • Ledger Account
    The specific ledger account to rebuild.

  • Fiscal Year
    The fiscal year for which you want to rebuild the ledger account matching history.


     

Infor LX/BPCS Tips & Tricks for FINANCE: Override Warning in Invoice Entry PO Costing

George Moroses 0 16933 Article rating: 5.0

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.

Infor LX / BPCS Tips & Tricks for OPERATIONS: Auto Calculate Vendor Delivery Date

George Moroses 0 5691 Article rating: 5.0

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.

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: User Provisioning

George Moroses 0 6615 Article rating: 5.0

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

First910111214161718Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

TECHNOLOGY & FINANCE: Archiving Finalized Transactions

To support correct archiving in a multicompany structure, the following rules apply:

  • Each company must have its own archive company. Companies cannot share an archive company.
  • The structure of archive companies must be an exact copy of the live environment.
  • A company must keep the same archive company until the end of its lifetime. Once data has been archived, you cannot change the archive company.

If extra archiving capacity is required, it is recommended that you set up a second archiving environment, which must also be an exact copy of the live environment. Define the companies of the second archive environment as the archive companies of the companies of the first archive environment. If necessary, a third and more archiving environments can be set up. You must then archive the data from each archive company to its archive company in the second archiving environment, and so on.

When you archive the data, LN builds an array with all the companies of the group and the archive company linked to each company. If any of the companies in the group does not have an archive company, LN reports an error and aborts the archiving process.

Batches and batch lines are only archived and/or deleted if you perform archiving and deletion in the company in which they exist. This is always the source company. Any intercompany documents and related finalized transactions that belong to the batch are not archived and/or deleted until the target company is archived.

If the batch has been deleted from the live environment, such intercompany documents and transactions will then temporarily exist without a batch in the live environment until the target company’s transactions are archived. Therefore, it is recommended to archive all the companies of a group within a short time.

Finalization runs are also archived. A finalization run can only be deleted from the live environment if all the attached batches have also been deleted.

Financial documents are archived and/or deleted if you perform archiving and deletion in the company in which they exist. For each document, LN searches whether a related intercompany document exists.

If the document’s transaction type indicates that the document numbering does not have to be in a fixed sequence, the document is not deleted from the live environment, to avoid duplicate document numbers.

A finalized transaction is not deleted from the live environment if the fiscal year of the transaction does not equal the fiscal year of the batch and the fiscal year of the transaction cannot yet be archived. If the Archive option is selected, the related batch, batch line, and document are copied to the archive company and retained in the live environment.

If a transaction is still referenced by open sales orders or purchase orders, it is marked as Deleted but not actually deleted. The related batch, batch line, and document are copied to the archive company and retained in the live environment. They are deleted when the referenced open transactions are closed and archived, for example, when you run the Archive/Delete Fully Paid Purchase Invoices (tfacp2250m000) session

If the transaction’s ledger account is a matchable account, any related matching data is also archived.

During the archiving process, the originating company of the finalized transaction is replaced with the originating company’s archive company. In this way, the archive environment will not contain references to the live environment.

During archiving, intercompany document relations are also copied to the archive environment. In the archive environment, these relations are updated in such a way, that each document in the relation refers to the environment in which the document actually exists. In the live environment, the document relation is retained until all related finalized transactions are deleted. For invoice-related transactions, this only occurs during the removal of fully-paid invoices. The document relation is also updated in the live environment, in order to refer to the archived document if all related finalized transactions have been removed from the live environment.

After the normal archiving process, an additional archiving step is performed in which all transactions and documents in the live company that arise from intercompany postings, are archived. During this step, intercompany relations are archived and/or deleted as described earlier.

Batches, batch lines, and documents that have the Deleted status are deleted from the live environment, unless the document’s transaction type indicates that the document numbering does not have to be in a fixed sequence. Such documents are not deleted from the live environment, to avoid duplicate document numbers.

OPERATIONS: Simulated Purchase Prices (ticpr1170m000)

Use this session to define simulated purchase prices for purchased items per site.

Field Information:

  • Cost Calculation Code - price calculation code
  • Item

The raw materials, subassemblies, finished products, and tools that can be purchased, stored, manufactured, and sold.

An item can also represent a set of items handled as one kit, or which exist in multiple product variants.

You can also define nonphysical items, which are not retained in inventory but can be used to post costs or to invoice services to customers. The examples of nonphysical items:

  • Cost items (for example, electricity)
  • Service items
  • Subcontracting services
  • List items (menus/options)
     
  • ​Site - The site for which the purchase price is simulated.
  • Purchase Currency - The currency of the simulated purchase price.
  • Simulated Price - Purchase price

The simulated purchase price and currency are recorded twice.

  • Simulated Price Multi Currency - The purchase price in multiple currencies.

The simulated purchase price and currency are recorded twice. The amount in this field is related to the price of the supplier.

  • Unit - Purchase price unit
  • Cost Component - The cost component that must be of the type Material Costs.

Note: The cost component specified in this field does not become part of the standard cost detail structure if it is part of the cost component scheme of the selected item. If calculations are performed with a calculation code not used for actualization (simulations only), the simulated purchase price is mapped to the cost component defined in the records for this session.

  • Latest Price - The purchase price that is displayed on the most recent invoice received for the selected purchased item.

  • Average Price - The average purchase price which is based on cumulative purchases or on the current inventory, as specified in the Method of Calculating Average Purchase Price field of the Purchase Order Parameters (tdpur0100m400) session.

Previous Article Infor LN & Baan Tips & Tricks for TECHNOLOGY: Table Sharing with a Multi-Company Setup - Using a Master Data Company
Next Article Infor LN & Baan Tips & Tricks for TECHNOLOGY & FINANCE: Archiving Finalized Transactions
Print
3534 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories