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 Tips & Tricks for FINANCE: Using Dimensions

Kathy Barthelt 0 41082 Article rating: 5.0

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 l

Infor LX/BPCS Growth with Connected eCommerce & Tax Automation

Frank Petrasio 0 994 Article rating: 5.0

Is your current Infor LX or BPCS system holding back your growth? It doesn't have to.

In 2026, staying competitive means moving beyond manual workflows and data silos. Crossroads RMC has partnered with Aleran and Avalara to provide an integrated, end-to-end solution designed specifically for manufacturers and distributors in the Infor LX and BPCS market.

Transform Your Operations from Quote to Cash

This powerful partnership enables you to maximize your existing ERP investment without the need for a total overhaul.

  • Aleran: Modern B2B eCommerce
    • 24/7 Digital Catalog: Provide a fully branded shopping experience that connects directly to your LX/BPCS data.
    • Self-Service Portals: Empower customers and dealers with real-time access to inventory, quotes, and order history.
    • Streamlined CPQ: Simplify complex product configurations and pricing to accelerate sales cycles.
  • Avalara: Automated Tax Compliance

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

George Moroses 0 1206 Article rating: 5.0

This enhancement: 

  • Provides an ability for LX to integrate with Infor Federation Services (IFS) to automate provisioning of users.
  • Activates LX exit points during maintenance of LX business roles and business units to publish the SyncSecurityRoleMaster BOD which can be received by IFS as LX-specific roles in addition to the three IFS predefined LX-specific roles: LX-SystemAdministrator (corresponding to LX security type S = LX Security Officer); LX-SystemManager (corresponding to LX security type M = LX Security Manager); and LX-User (corresponding to LX security type U = LX User).
  • Enables support for LX receiving an inbound SyncSecurityUserMaster BOD (sent from IFS) and creating or revising the associated LX user (or security manager or security officer). This enhancement also supports creating an IBMi user profile which can then be defined as an LX user (or security manager or security officer).
  • Activates LX exit points during maintenance of LX users (and security managers and security officers) to send the ProcessSecurityUserMaster BOD to IFS requesting creation or revision of a user on behalf of LX.
  • Automates sending revised LX user authorities to corresponding System i Manager (SiM) tasks which can then be uploaded to System i Workspace (SiW).

Infor LX/BPCS Tips & Tricks for OPERATIONS: IDF RMA Inquiry

George Moroses 0 1394 Article rating: 5.0

This enhancement provides a robust RMA Inquiry capability. The base RMA Inquiry application delivers role-based functionality to support customer service, sales, pricing and business analysis functions.

The IDF RMA Inquiry presentation enhances a number of customer service and data analysis functions.

  • RMA List provides filters that allow sorting and sequencing by any displayed data field, such as RMA number, customer number, Total RMA amount, request date, good thru date, Customer reason code, Disposition reason code, Q/C reason code.
  • RMA Line List provides filters that allow sorting and sequencing by any displayed data field, such as item number, request date, extended amount, net price, Customer reason code, Disposition reason code, Q/C reason code.
  • RMA detail cards provide additional details about the RMA, as well as about any orders that will result from the RMA.


IDF RMA Inquiry provides significant enhancement to several business roles:

Customer service personnel, customer service managers responsible for handling customer complaints and negotiating return conditions with the customer Warehouse personnel, warehouse manager at the return warehouse. Billing personnel, billing managers responsible for processing credits to the customer and handling questions related to the RMA, return and eventual credit.

Managers responsible for analysis of returns related to reasons for returns, resulting replacement orders, recommendations for improving pricing or internal processes to reduce returns.

Infor LX/BPCS Tips & Tricks for FINANCE: Archive Net Price for Deleted Lines

George Moroses 0 1159 Article rating: 5.0

Infor LX now stores the Net Price for a deleted line, so that the information is available for later analysis.

If an order line is canceled, LX stores the current Net Price in a new Net Price Archive field. The Net Price Archive field is updated whether the line is deleted through Line Entry (ORD700D2) or Fast Line Entry (ORD700DA), or the entire transaction is deleted through Order, Quote or RMA Directory (ORD700D1).

The Net Price Archive field can be useful when analyzing the reasons for canceled order lines. Users can define Cancellation Reason Codes related to pricing. Review of the archived Net Price, along with other values from canceled order lines such as Order Quantity and Selling Unit of Measure, Cancellation Reason Code, Request Date, Price Book Date, Item Number and Customer Number, can lead to adjustments to pricing structures, promotion qualifiers or other actions that can avoid loss of revenue on future orders, or follow-up actions to recover the canceled line.

124678910Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE: Can accounts receivable invoices be uploaded into LN using Excel?
Yes, this is possible, by following the steps below:

1. Maintain a batch

2. Maintain an invoice headerexport it, add an additional invoice header to the Excel file, and import it

3. Maintain an invoice line for the first invoice, export it, add additional invoice lines to the Excel file and import it
 

Below the above steps are described in detail.

1a. Open the transactions (tfgld1101m000) session and create a batch.

1b. Insert a transaction type, used for creating sales invoices, like ACR, and open it.

2a. The Sales Invoices (tfacr1110s000) session starts. Maintain the invoice header and save it. For example sales invoice ACR 4497.

2b. In the Actions menu select Export and Import -> Advanced Export (fields: All tabs).

2c. In the excel file created during previous step, add the headers for the invoices to be uploaded. Notice if for the transaction type the Documents in Fixed Sequence checkbox is ticked in the Transaction Types (tfgld0511m000) session, the document number for the not-yet existing invoices to be imported in LN should be equal to the default series for this transaction type. Otherwise, so if the Documents in Fixed Sequence checkbox is not ticked, the desired document numbers can be maintained in the excel file.

2d. In the Sales Invoices (tfacr1110s000) session in the Actions menu select Export and Import -> Settings, and make sure the Import Only in This View checkbox is NOT ticked. Then select in the Actions menu select Export and Import -> Import, select the excel file as saved in the prior step, and import it. Afterwards the invoice headers should be visible in the Sales Invoices (tfacr1110s000) session.

3a. Navigate to the first invoice, select Lines. The Transactions (tfgld1102m300) session opens. Maintain at least 1 line and save it.

3b. Open the line created in the prior step. Notice the detailed version of the Transactions (tfgld1102m300) session opens.

3c. In the Actions menu select Export and Import -> Advanced Export (fields: All tabs).

3d. In the excel file created during previous step, add lines for the header invoice numbers as available in the Sales Invoices (tfacr1110s000) session (as per step 2d).

3e. In the detailed version of the Transactions (tfgld1102m300) session in the Actions menu select Export and Import -> Import, select the excel file as saved in the prior step, and import it.


OPERATIONS: MPS Planned vs. MRP Planned
When deciding what items should be MPS (Master Production Schedule) planned and what items should be MRP (Material Requirements Planning) planned, it's crucial to understand the nature of the items and their demand sources. Here's a breakdown:

  • Master Scheduled Items:

    • Master Scheduled Items are typically finished goods or service items.
    • These items receive their requirements from both Independent and Dependent demand sources.
       
  • Independent Demand:

    • Independent demand cannot be calculated from higher-level demand in the product structure.
    • It is driven by forecasts or actual customer orders, primarily applicable to Finished Goods or Service parts sold to customers.
       
  • Dependent Demand:

    • Dependent demand is derived from higher-level demand in the product structure.
    • It includes components, raw materials, and sub-assemblies.
    • Dependent demand items are not typically part of Master Production Scheduling (MPS).
       
  • Service Parts:

    • Service parts can have both independent demand from forecasts or customer orders and dependent demand from higher-level demand if they are used in sub-assemblies or other products.
       
  • Cumulative Lead Time:

    • Cumulative Lead Time is a concept used in MPS.
    • It combines the fixed lead time and variable lead time required to produce a product.
    • It represents the longest path through a Bill-of-Materials (BOM).
    • Your ERP system will calculate the cumulative lead time (Critical Path) based on MPS setup options.
       
  • Infor LN Approach:

    • Infor LN does not differentiate between MPS and MRP planning.
    • It uses Enterprise Planning (EP) with one set of planned orders.
    • While you can set up items and generate orders at plan levels, it's not always necessary.
    • In theory, you could treat plan level 1 similar to MPS items.
       
  • Defining Independent Demand in LN:

    • In LN terms, independent demand is demand not related to other planned items.
    • Dependent demand comes from related planned items higher up in the BOM structure.
       
  • COLT (Cumulative Order Lead Time):

    • COLT exists in the purchase and manufactured planned items.
    • It considers non-critical and critical lead times based on components marked as critical.
    • Once calculated, COLT can be used to update the order and planning horizons of a planned item.

Relevant Sessions:

In Baan IV:

  • Maintain Item Data (tiitm0101m000)
  • Generate MPS (timps3201m000)
  • Maintain Master Production Schedule (timps3101m000)
  • Display Planned Inventory Movements by Item (timrp1510m000)
  • Display Planned MRP Purchase Orders (timrp1521m000)

In Baan V:

  • Plan Item Data (cprpd1500m000)
  • Item Master Plan (cprmp2101m000)
  • Time-Phased Overview (cprrp0520m000)

In Infor LN:

  • Item – Planning (cprpd1100m000)
  • Item Master Plan (cprmp2101m000) - Same as Master MPS if used


TECHNOLOGY: Are you running the latest Infor components?
Always good to stay on top of new releases for your various Infor components. Here is a list of knowledge base articles that you can check for the components listed below:

For the last Infor LN, Infor Baan5, and Infor Baan4 porting set see KB 22923520

For the last BaanIVc 6.1c porting set see KB 22923521  No fixes are made based on the 6.1c porting set.

For the last Worktop set see KB 22881488 For the last BW set see KB 22881483 For the last EME set see KB 22866552 For the last Office integration set see KB 22867312 For the last Dynamic Form Editor see KB 22881485

For more information and assistance, you can contact Crossroads RMC at 800.762.2077 or via email at solutions@crossroadsrmc.com.

Previous Article Infor LN & Baan OPERATIONS Tip: MPS Planned vs. MRP Planned
Next Article Infor LN & Baan Tip & Tricks for TECHNOLOGY: Infor LN Rest API
Print
43768 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories