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

It’s Mid-January, and IT’S GO TIME!

Infor LX | BPCS | Infor LN | Baan

Crossroads RMC 0 10909 Article rating: 5.0

The calendar is fresh, the resolutions are set, and the opportunities are endless!

But before you dive headfirst into tackling your to-do list, take a moment.

Pause.

Now is the perfect time to reflect and plan your ERP strategy.

What’s an ERP Strategy?

An ERP strategy is a roadmap for the steps you should take before, during, and after implementing an ERP system. It’s designed to ensure your ERP delivers on its promise of functionality and success—the backbone of running your business effectively.

Think of it like planning a road trip:

  • Which cities will you visit?
  • Where will you stay?
  • What landmarks do you want to explore?

Without a plan, you’re winging it. While spontaneity might work for a vacation, it’s risky when it comes to your ERP system.

A poorly executed road trip might waste time or cause frustration, but a poorly executed ERP strategy? That can hinder your business growth, create inefficiencies, and lead to costly mistakes.

What if:

Infor LN & Baan Tips & Tricks for Finance: Problem Invoices

Kathy Barthelt 0 60940 Article rating: 5.0

You can use a problem code to indicate that a problem exists for a sales invoice. If the invoice-to business partner notifies you about a problem with the invoice and does not pay it, you can link a problem code to the invoice.

In the direct debits procedure, problem invoices are automatically discarded. For each problem code, you can set an option to prevent linked invoices from being selected on reminder letters.

Infor LN & Baan Tips & Tricks for Technology: Using audit files in the Exchange module

Kathy Barthelt 0 54850 Article rating: 5.0

The audit server logs all database actions that change the contents of a table in so-called audit files. The Exchange module can use these audit files, which are useful in a multisite environment because the databases on all sites must have identical data. These audit files can also be used in data conversions.

Only the updates in a specific period are exchanged, which leads to an improvement in performance. Specify this period in the Export Data (Non-Regular) (daxch0233m000) and Export Data (on a Regular Basis) (daxch0234m000) sessions. Changes such as insert, update, and delete are processed and written into the ASCII files. Actions such as drop, clear, and create tables are ignored.

Audit control data is added to the resulting ASCII file. This data consists of a batchline ID, transaction ID, sequence ID, and an indicator. The control data is added at the beginning of each line and is formatted like other data fields such as the enclosing and separator characters.

An update writes two lines to the ASCII file. One line contains the key fields and old values of the updated fields. The other line contains the new values of the key fields and updated fields, even if a key field does not change.

The batchline ID is used for recognition when processing the ASCII files. The transaction and sequence IDs are used to ensure that the transactions are replayed in the same order as on the exporting site. The indicator defines the type of action that is executed on the table. Use the letter I to insert; use the letter D to delete; use the letter U to update with old values; and use the letter N to update with new values.

Infor LN & Baan Tips & Tricks for Operations: Copying EBOMs - Which copying method should I use?

Kathy Barthelt 0 61279 Article rating: 5.0

To determine which copying method you must use, answer question 1 and follow the instructions.

Question 1: Is the source component a project item (that is, is a project defined in the first segment of the item code)?

  • If the answer is yes, proceed with question 3.
  • If the answer is no, proceed with question 2.


Question 2: Is the target component a project item?

  • If the answer is yes, select copy method NonProj Item to Proj Item.
  • If the answer is no, proceed with question 4.

Question 3: Is there a relationship with the same project?

  • If the answer is yes, select copy method EBOM to Production BOM Only.
  • If the answer is no, proceed with question 4.


Question 4: Is there a relationship with the target item?

  • If the answer is yes, proceed with question 5.
  • If the answer is no, select copy method No Copy Action.


Question 5: Does the item exist already?

  • If the answer is yes, select copy method EBOM to Production BOM Only.
  • If the answer is no, select copy method Copy E-Item to Item.

Infor LX / BPCS Tips & Tricks for Finance: Inventory Period Balance Freeze

George Moroses 0 23709 Article rating: 5.0

Users can now freeze period-end balances at the end of a fiscal period. You can now store the opening/ending on hand balance for each Inventory period at the Item (IIM), Warehouse/Item (IWI) and Lot/Location (ILI) levels. This information can then be used for inventory tracking and valuation purposes, as well as other ad hoc financial and audit reporting requirements. Infor LX clients can backdate inventory transactions into the immediate previously closed period, and thus update what was saved as the opening/ending balance throughout the current open period.

First1516171820222324Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for FINANCE: Using Dimensions

You can independently define dimensions and use them to prepare analyses of ledger account transactions and balances. You can use up to 12

dimension types. You can define a name and an entire structure of dimension codes for each of these dimension types. There is no relationship between the dimension types.

For example, you can set up these dimensions:

  • Dimension Type 1 = Cost center
  • Dimension Type 2 = Item group
  • Dimension Type 3 = Business unit
  • Dimension Type 4 = Geographical area
  • Dimension Type 5 = Activities

You can separately define the dimension structure for each of these dimension types, in other words, you can set up a dimension structure for the cost centers, a structure for item groups, and so on.

You can define the number of dimension types that you use in the Group Company Parameters (tfgld0101s000) session. If you have several financial companies in a company group, the dimension types used apply to all the companies in the group.

You can name the dimension types and define linked objects in the Dimension Type Descriptions (tfgld0102m000) session. You can then define the dimension codes to be used in each company in the Dimensions (tfgld0510m000) session. You can also make multilevel dimension structures with totals and subtotals. You can build a dimension hierarchy of up to ten levels.

In the Dimensions (tfgld0510m000) session, you can define the dimensions for each dimension type, and link the dimensions to parent dimensions and child dimensions.

Dimensions are always used together with ledger accounts. For each ledger account, you can define which dimension type or types are linked to the ledger account in the Chart of Accounts (tfgld0508m000) session. For each dimension type, you must select whether the dimensions type is MandatoryOptional, or Not Used by the ledger account.

When you enter a transaction, you must first state the ledger account. Then you must enter a dimension for each Mandatory dimension type that is linked to the ledger account, and you can enter a dimension for each Optional dimension type.

For example, the sales revenues ledger account is linked to dimension type 2 (item group) and dimension type 4 (area). The dimension type 1 (cost center) and dimension type 3 (business unit) are not used for the ledger account. The freight costs ledger account is linked to only dimension type 1 (cost center). The other dimension types are not used for the ledger account.

For each dimension type, you can define one dimension with an empty dimension code. If the dimension type is Optional for a ledger account, LN posts transactions for which no dimension is specified to this dimension. In this way, differences between the ledger history and the dimension history can be avoided.

In the Cross Validation Rules (tfgld0151m000) session, you can define the ranges of allowed dimensions by ledger accounts. You cannot change the dimension range for a ledger account that occurs in an unfinalized batch.

You can create transactions for Financials from the integration with other LN packages. You can enter these transactions into ledger accounts and into dimensions. You can define the assignment to ledger accounts through the Mapping Scheme (tfgld4573m000) session.

You can use the dimensions to split the transactions on the customer and supplier control accounts by departments, persons responsible for the revenues, costs, properties, debts, and so on.

The dimensions also provide the basis for the cost allocation in the Cost Accounting module. In CAT, you can allocate the costs (and any revenues) within a dimension type from one dimension code to another and from one dimension type to another.

Previous Article Infor LN & Baan Tips & Tricks for EXECUTIVES
Next Article Infor LN & Baan Tips & Tricks for TECHNOLOGY: High Contrast Skin
Print
46478 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories