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

Baan/LN Tip of the Week: Are you Doing These Things For Month End?

Kathy Barthelt 0 85074 Article rating: No rating

Accounts Receivable:

  • Check A/R Aging Balance with Trial Balance.
  • Check for Detailed Customer Transactions.

Accounts Payable:

  • Check A/P Aging Balance with Trial Balance.
  • Check Open Purchase Orders for Potential Accruals and A/P Reconciliation.
  • Check for Registered Purchase Invoices (Not Matched or Approved).
  • Print Listing of all Purchase Invoices Entered for Period.

Tip of the Week: Tips to Attain Greater Inventory Accuracy

Anthony Etzel 0 53779 Article rating: No rating
  1. Record data regarding your inventory as soon as the items arrive at your door/receiving dock. With information, you can make decisions. Without it, you waste money, time and effort.
  2. Leverage data collection, label generation and RFID solutions to make your life easier.
  3. Set inventory accuracy goals for the business and for employees.
  4. Train your employees so they know what is expected of them, and how to best perform their job and therefore how best to maintain accurate inventory counts.
  5. Count the inventory – and do it regularly. Find a method that works best for your employees, and for your business.

Tip of the Week: Tips to Attain Greater Inventory Accuracy

Kathy Barthelt 0 68864 Article rating: No rating
  1. Record data regarding your inventory as soon as the items arrive at your door/receiving dock. With information, you can make decisions. Without it, you waste money, time and effort.
  2. Leverage data collection, label generation and RFID solutions to make your life easier.
  3. Set inventory accuracy goals for the business and for employees.
  4. Train your employees so they know what is expected of them, and how to best perform their job and therefore how best to maintain accurate inventory counts.
  5. Count the inventory – and do it regularly. Find a method that works best for your employees, and for your business.

BPCS/LX Tip of the Week: Changing the Master Schedule

Anthony Etzel 0 51182 Article rating: No rating

You can change your master schedule by specifying the type of master schedule update to perform. You can run a Net Change or Regenerative Schedule.

You also have the ability to clear the lower level requirements out of the Planned and Firm-Planned Order file.

Baan/LN Tip of the Week: Switching to a Difference Series

Kathy Barthelt 0 70233 Article rating: No rating

In general, you can enter a different series in the order field if you have an available series. To add a new series, find the appropriate group in the First Free Number session, and add a new series and first free number (usually 1).

In Baan IV, go to the Maintain First Free Numbers Session (under Common, Tables, Maintain Logistics Tables, Maintenance 1). Groups are easily identified (e.g., Purchase Order, Sales Order, etc.).

In Baan V, go to the First Free Number Session (under Common Data, Tables, Logistics). There are number groups (e.g., 570 may be for Purchase Orders, 650 may be for Sales Orders, etc.).

In LN, go to the First Free Number Session (tcmcs0150m000 – it is in different places in the menu under different Feature Packs). There are number groups (e.g., 210 may be for Purchase Orders, 310 may be for Sales Orders, etc.).

Hoffmaster Clintonville Plant Goes Live with Crossroads MES & LX

Anthony Etzel 0 32213 Article rating: No rating

On March 1, 2016, Hoffmaster’s Clintonville plant went live with Crossroads MES and LX. The goal of the project was to convert from another ERP to LX and replace a green screen MES system that required the manual recording of production and labor activity keyed from shop floor terminals.

Hoffmaster achieved their goal by completing a successful data conversion and detailed prototyping of LX and Crossroads. The project team remarked that the Crossroads MES implementation was by far the easiest part of the project. One of the critical requirements of the chosen MES solution was to verify UPC and UCC label formats that called for in-line labeling of product packages and cases. Crossroads MES satisfied that requirement, and also provided an interface to finished goods inventory via the scanning of LPN numbers when reporting production.

The Clintonville plant is a leading manufacturer of disposable tabletop products.

BPCS/LX Tip of the Week: Actual Costs for Manufactured Items

Anthony Etzel 0 52373 Article rating: 5.0

In LX, the actual costs that can be set up fall into three categories: Material, Labor, and Overhead. If your LX database is set up properly with the LX cost accounting, you should be able to identify:

  • How much the item should cost
  • How to track the cost of work underway
  • How much the item actually did cost
  • Why the job cost varied from the expected cost
     

Capturing the data to track activity with associated costs can be time-consuming. With an MES solution, the information you need for costing is tracked instantly.

Baan/LN Tip of the Week:GRINYA Reconciliation – What Could Go Wrong?

Kathy Barthelt 0 76957 Article rating: No rating

One common GRINYA issue would be incorrectly entered Integration Setups.

Check the Baan or LN manual for recommended Integration setups. If such a mistake were to occur, it is important to know for what period of time the Integration was in error.

To ensure, it’s recommended that the Integrations Setup tables should be audited either through Baan/LN or Database Auditing. Corrections can be quickly calculated when an exact timeframe can be determined.

First101102103104106108109110Last

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 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
20601 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories