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 Tip & Tricks for TECHNOLOGY: Using Table Boosters to Speed Up Sessions & Processes

Kathy Barthelt 0 25646 Article rating: 5.0

To increase the speed of sessions and processes slowed by large amounts of data, you can use table boosters. These speed up access to specific database tables by loading the table, or a specified part of it, into memory. Table boosters are defined in the Table Boosters (tcmcs0598m000) session.

Tables

Table boosters are implemented for tables. By default, table boosters are not active. When you access a table, LN builds a list of tables for which you can activate the boosters in the Table Boosters (tcmcs0598m000) session.

Note: You can only activate table boosters for tables that have been accessed at least once.

For more information, refer to the LN - Performance, Tracing, and Tuning Guide (U9357).

Infor LX / BPCS Tips & Tricks for Executives

Finance | Operations | Technology

George Moroses 0 15532 Article rating: 5.0

Finance: Cost Rollup by Effective Date
Allow the load standard cost from routing and cost rollup programs to process as of a specified effective date.  With the addition of an optional effective date parameter to prompt screens for cost rollup CST500 and load standards from routing CST600. If entered, only consider bill of material components and routing operations with effective and discontinue dates that make them effective as of the entered parameter effective date.


Operations: Outside Operation Purchase Order Include Vendor Item Number
Copy the vendor item number from the vendor quote to purchase orders created automatically from outside operations of shop orders. During the process of automatically creating purchase orders from outside operations of shop orders, copy the vendor item number from the vendor quote to the purchase order line. With this change, looking at a purchase order that was created automatically for an outside operation of a shop order, the vendor item number from the vendor quote will be visible on the purchase order line.


Technology: Group Security for ILM501 Inbound Delivery Maintenance
Add function key / action code security to control who is authorized to create/revise/delete functions in ILM501 Inbound Delivery Maintenance.  With added Group Security, managers can control which users are authorized to create, change and delete deliveries in ILM501 Inbound Delivery Maintenance.

Infor LX / BPCS Tips & Tricks for OPERATIONS: Outside Operation Purchase Order Include Vendor Item Number

George Moroses 0 15384 Article rating: 5.0

Operations: Outside Operation Purchase Order Include Vendor Item Number

Copy the vendor item number from the vendor quote to purchase orders created automatically from outside operations of shop orders. During the process of automatically creating purchase orders from outside operations of shop orders, copy the vendor item number from the vendor quote to the purchase order line. With this change, looking at a purchase order that was created automatically for an outside operation of a shop order, the vendor item number from the vendor quote will be visible on the purchase order line.

Infor LN & Baan Tip: Propagating Unused Sub-Accounts

Kathy Barthelt 0 27616 Article rating: 5.0

You can use this procedure to find accounts that have a valid sub-accounts group but no corresponding general ledger chart account records. This action creates the general ledger chart account record for the account and sub-account combination. This action does not add the accounts to charts.

  1. Select Financials > Global Ledger > Setup > Finance Enterprise Group > Maintenance.
  2. Open the finance enterprise group and click the Sub Account tab.
  3. Select Actions > Propagate Unused Sub Accounts.
  4. Select the finance enterprise group and click OK.

Sub-accounts are added according to group if they have been defined on the accounts. The resulting account can be added to the charts.

Reskilling and Upskilling Your Staff – Why You Shouldn’t Ignore This

Kathy Barthelt 0 13448 Article rating: 5.0

According to the World Economic Forum, half of all employees will require significant reskilling or upskilling by 2025.

For many of you, your Infor ERP system was implemented 5, 10, 15, or even 20+ years ago. Now, there are only a handful of people left from that implementation, if any at all. Since most of your "how and why" walked out the door, how much longer can you rely on “tribal knowledge”? While many companies understand the importance of employee training, implementing that training remains a challenge. What’s the best way to proceed, you ask?

Reskill and upskill your staff with your go-to experts at Crossroads RMC!

Crossroads RMC's consultants deliver highly impactful, focused training that shows an immediate benefit. Contact us to discuss a training plan that is right for your business. Call us at 800.762.2077.

Training & Workshops:

Still not convinced? Check out this article which provides several great reasons to make training a priority for your staff: 12 Benefits of Training Employees In the Workplace.

First1617181921232425Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE
Ledger Account Blocked Error
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.

OPERATIONS
Absorbing Cost Items into Projects
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:

    • If needed, create the cost items.
    • Create a purchase order for the cost items without referencing a project number.
  4. Matching PO to Costs:

    • When matching the purchase orders in session tfacp2107m000, select "Add Costs" from the specific menu on the toolbar (you'll need to be in the matching details to access this).
    • This will open session tfacp1133s000, where you will enter the previously specified ledger account number.
    • Once done, the "PCS Transactions" option on the toolbar becomes available. Selecting this brings up session tipcs3140m000 (General Actual Project Costs).
       
  5. Disbursing Costs to Projects: In session tipcs3140m000, the PO costs for the cost items can be disbursed to any open and active project.

Since these are cost items, they won't go into stock. The key is ensuring that the cost disbursement ("Add Costs") is correctly linked to the appropriate project, giving users visibility of the cost items as general project costs.


TECHNOLOGY
Adding a Timestamp to LN Standard Tables
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:

  1. Enter the Tables: In this session, specify the tables for which you want to define timestamps.

  2. Convert and Reconfigure: Run the Convert to Runtime Data Dictionary (ttadv5215m000) session to convert the table definitions to the runtime data dictionary and reconfigure the tables.

  3. Restart Session: Log off and log back on to apply the changes.

IMPORTANT!
To avoid issues with locked tables, ensure that all users have logged off before starting the reconfiguration.

For more information, refer to the online help of the Convert to Runtime Data Dictionary (ttadv5215m000) session.

Previous Article Infor LN & Baan Tips & Tricks for FINANCE: Ledger Account Blocked Error
Next Article Infor LN & Baan Tips & Tricks for OPERATIONS: Absorbing Cost Items into Projects
Print
21768 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories