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 and Crossroads RMC Partner to Drive Success at Ridewell

Anthony Etzel 0 36721 Article rating: 5.0

Earlier this year, Ridewell Corporation inked a deal with Infor to move their BPCS 4.05 CD system to Infor LX. As part of that deal, Crossroads RMC’s MES software was selected to provide shop floor automation. 

For the ERP upgrade, Infor reached out to Crossroads RMC to provide support for both Finance and Data Conversion due to our positive track record with 4.05 CD to LX migrations. Crossroads RMC has extensive migration experience and developed a methodology for converting legacy 4.05 CD GL into CEA. 

The process Crossroads RMC developed makes it cleaner, more manageable, and easy to embrace from the client perspective. Infor also engaged Crossroads RMC to provide technical support to manage the data conversion, utilizing the Infor utilities and converting Ridewell’s 4.05 CD data to standard LX.

IDF: Defining the Attributes for a New Object

Anthony Etzel 0 30413 Article rating: 5.0

Attributes are the fields you define in your System i file.

You can begin by building your attribute list in Integrator by synchronizing the object with the host. This process reads the file definition from the System i and builds your list of attributes. The synchronize process will automatically run and read the definitions for the first occurrence of this file name within the library list. You can repeat this process manually multiple times if you change the file definition on the host by using the ‘Synchronize with Host’ option. However, the synchronization process will not recognize changed field names.

Non on key field attributes: The integrator requires a unique key for each object. If the host file already has a key, the synchronization process will automatically identify fields as part of the key as well as add a sequence number to multiple key parts. If the file does not have a unique key, you must either create a keyed logical file or identify the key manually. Key fields are the default sort order for all list views for an object.

Why do you need OTTO? Let’s let our customers tell you…

George Moroses 0 26280 Article rating: 5.0

“Our priorities change daily. It’s important to manage the priorities instead of having someone here in the office constantly expediting. We don’t want to run MRP every day, that would just introduce nervousness, all plans and priorities are likely to change and the flood of recommendations would be unmanageable. We run MRP once a week and rely on OTTO to track the constantly shifting priorities day-to-day.”  
Production & Inventory Control Manager, Top U.S. Crane Manufacturer

Learn More About OTTO

Crossroads RMC is proud to announce the release of the following dashboard views that come STANDARD with the LX Analytics Dashboard

George Moroses 0 29993 Article rating: 5.0

Standard Analytics Dashboard Views: 

  • Sales Bookings (ECH)
  • Accounts Receivable (RAR)
  • Accounts Payable (APH)
  • Planned Orders (KFP)
  • Purchasing (HPH)
  • Shop Order Material (FMA)
  • Shop Order Operations (FOD)
  • CEA
  • Order Booking (ECS)
  • Labor History (FLT)
  • Sales History (SIH)
  • Material Status (IIM/ILI)

Click Here to Learn More

If you can't see everything that happens on your shop floor, you are at a competitive disadvantage

Anthony Etzel 0 31436 Article rating: 5.0

If you’re not able to see everything that happens on your shop floor in real-time, you’re at a HUGE competitive disadvantage! Your competitors are running MES. 

Crossroads MES software provides:

  • A user-friendly interface and an easy exchange of information between the shop floor users and your ERP database. 
  • Planners the ability to schedule work to a specific machine or work area. In addition, it allows for work to be re-sequenced and split for better flexibility in scheduling shop floor activities.
  • Factory workers with the ability to receive the work schedule electronically as well as interacting with it by reporting transactional activity.
  • The ability to electronically display Drawing, Process Instructions, and Quality Instructions so you can eliminate, or minimize, the need for some of the paper on the shop floor.
  • The ability to pass shop floor transactional activity to dashboard displays as well as the ERP system. 

Click here to learn more about Crossroads MES 

or Contact Anthony Etzel today to learn more.

Infor LN & Baan Tip of the Week: Job Groups in LN

Kathy Barthelt 0 84243 Article rating: 5.0

In a scenario where performing job A depends on the result of job B, it is hard to decide at what time job A must be scheduled, and how long job B runs. To handle dependent jobs, you can now create a job group. Use the Job Groups (ttaad5140m000) session to create a job group. A job group has a name, with the same characteristics as a job name, and a description. The Status and User of the job group are handled automatically.

After creating the job group, the jobs are added to the group, approximately in the order the jobs must be performed. The first job in the group (with the lowest Group Number) determines the handling of the whole job group, such as execution date and whether the job group is being repeated. If the job group is not repeating, the job group and all non-repeating jobs in the job group are deleted when the job group has run.

The dependencies of the jobs in the job group are also determined. A job in the job group can only depend on a job in the same job group with a lower job number.

You can use the specific options in the Job Groups (ttaad5140m000 andttams5640m000) sessions to change the status of the job group. The job group statuses have the same meaning as the status of the jobs and the same status changes are allowed.

Note: Job groups are only handled by the BSE service Job Scheduler Service.

A/P Payment Update in LX 8.3.4

Anthony Etzel 0 43260 Article rating: 5.0

A/P Payment Update in LX 8.3.4. ACP660B creates a file using a layout required by the bank; the file informs the bank to pay invoices. These conditions must be met to create the file:

  • FIM is an installed product in SYS821  ­
  • The user is authorized to FIM in SYS600 ­
  • The company is active in FIMCOMIT in SYS105  ­
  • The payment type is in BONPAYTP (SYS105)

Infor LX & BPCS Tip of the Week: LX 8.4 Database

Anthony Etzel 0 59706 Article rating: 5.0

The database in LX 8.4 has undergone a significant change from previous versions. The database has been created using SQL DDL language instead of the old DDS language. The newer format allows for LX to take better advantage of advances in IBM database technologies as they move forward. Additionally, LX will be better able to make changes to tables (aka files) in the future without causing very large MR explosions to replace all programs that use a specific table. To ease the impact of this significant change, the LX tables (aka physical files) have new names that are the same as the previous version file names but with a “P” at the end, for example IIM is now IIMP. The old file names now belong to SQL views that looks just like the tables. This change made it easier to upgrade all the LX programs without changing every reference to every file. Many of the logical files remain although some have been replaced by SQL indexes to improve performance.

First6869707173757677Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE: Currency Differences

When currency differences are posted, several parameters affect the way the entries in the General Ledger are created. This section explains the possible parameter settings:

  1. Ledger accounts by currency

  2. Writing off currency profits

  3. Fixed exchange rate

  4. Writing off currency differences for anticipated payments


1. Ledger accounts by currency
This parameter is recorded in the Finance Company Parameters (tfgld0503m000) session.

If the Ledger Accounts Currency Differences by Currency check box is selected, the (un)realized currency differences are posted to the ledger accounts defined in the Currency Difference Ledger Accounts by Currency (tfgld0119s000) session.

LN retrieves the related dimensions from these sessions:

  • General Ledger: Finance Company Parameters (tfgld0503m000)

  • Accounts Payable: Ledger Accounts by Business Partner Group (tfacp0111m000)

  • ACR: Ledger Accounts by Business Partner Group (tfacr0111m000)

If the Ledger Accounts Currency Differences by Currency check box is cleared, the currency differences are posted to:

  • General Ledger: the ledger accounts specified in the Finance Company Parameters (tfgld0503m000) session.

  • Accounts Payable/ Accounts Receivable: the ledger accounts recorded for the business partner group.


2. Writing off currency profits
This parameter is defined in one of these sessions:

  • ACP Parameters (tfacp0100m000)

  • ACR Parameters (tfacr0100s000)

If the Currency Profits check box is selected, the unrealized currency profits are posted as well as the unrealized currency losses. Unrealized currency losses are always posted when writing off currency differences.

3. Fixed exchange rates
For each invoice, the rate determiner defines:

  • Which date is used to determine the exchange rate.

  • If currency differences are calculated.

  • For which (home) currencies the currency differences are calculated.

The Rate Determiner is set in the Sales Invoices (tfacr1110s000) session or the Purchase Invoice Entry (tfacp2600m000) session.

Unrealized currency differences are written off in one of these sessions:

  • Write Off Currency Differences (tfacp2240m000)

  • Write Off Currency Differences (tfacr2250m000)

4. Writing off currency differences for anticipated payments
This parameter is defined in one of these sessions:

  • ACP Parameters (tfacp0100m000)

  • ACR Parameters (tfacr0100s000)

If the Currency Difference Anticipated Payments check box is selected, invoices with anticipated payments or anticipated receipts are considered for writing off currency differences.

OPERATIONS: Pegging Material Supply Lines for Operation and Product Subcontracting

For project pegged production orders, operations can be subcontracted. The material delivered to the subcontractor can be project pegged or anonymous. The subassemblies that are sent and retrieved are always project pegged. Costing breaks can apply to direct the costs of the subcontracted operation to a specific project cost account. If (production material) costing breaks are used, a purchase order line's peg can differ from the peg on the material supply line.

For product subcontracting, the subcontracted purchase orders can include materials that inherit the project pegs, or can include anonymous materials. The pegged materials are stored in inventory and are shipped to the subcontractor with project pegged orders.

In case of a project pegged order, a peg distribution is linked to the Purchase Order Material Supply Line in the Purchase Peg Distribution (tdpur5100m000) session. For a specific purchase order line (detail) and material sequence, the material supply line's Order and Consumption quantities are distributed across the peg distribution lines for combinations of project/budget, project element, and/or project activity. The peg information in the Purchase Peg Distribution (tdpur5100m000) session includes the line number for the peg in the distribution, the peg (project, element, activity), and the material supply line quantity by peg. The peg distribution cannot be manually created and must always be generated using the parent.

For operation subcontracting, the purchase order line, the material supply line, and the linked peg distributions are generated by Job Shop Control and can only be updated by Job Shop Control.

For product subcontracting, the purchase order line, the material supply line, and the peg distributions are generated by Procurement. A material supply line's peg distribution can be updated only from the parent, that is the purchase order line, the purchase order line peg distribution, or the material supply line. If a purchase order line's distribution line is changed, and no quantities are received or consumed yet, the pegged fields on the linked material supply lines are synchronized to the updated distribution line in the Purchase Order Material Supply Lines (tdpur4116m000) session. However, if a different quantity distribution is applicable, the quantities of the material supply lines' distribution lines are redetermined in the Purchase Peg Distribution (tdpur5100m000) session.


TECHNOLOGY: Load Audit Tables for Profile (ttaud3220s000)

Use this session to load tables for an audit profile.

Usually this session is run from the Specific menu of the Audit Tables by Profile (ttaud3120m000) session. The selected profile in that session is displayed in the first line of the current session.

The result of loading the tables depends on the selection level you use in the current session. For each element on the lowest selection level, a line is created in the Audit Tables by Profile (ttaud3120m000) session. For example, if you select a package and a number of modules, a line is created for each module. Because you did not specify the tables, the All check box is selected.

Field Information

  • Profile: The audit profile for which the tables are loaded.
    Note: If you start the current session from the appropriate menu of the Audit Tables by Profile (ttaud3120m000), the profile displayed is the profile that is selected in that session.
  • Package: The package that contains the tables you want to load.
  • Module: The module that contains the tables you want to load.
  • Table: The tables you want to load.
  • Audit Type: The audit type that must be set for the tables that are loaded.
    Note: You can either select Always, or Changed. However, it is also possible to determine the audit type per field. This is the Not Applicable option in the Audit Tables by Profile (ttaud3120m000) session. If you want to set the audit type per field, you must change the audit type to Not Applicable after the tables are downloaded, and then specify the audit type per field in the Audit Fields by Table (ttaud3125m000) session.

Previous Article Infor LN & Baan Tips & Tricks for OPERATIONS: Subcontracting Overview
Next Article Infor LN & Baan Tips & Tricks for FINANCE: Currency Differences
Print
255 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories