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: Interest Invoices

Kathy Barthelt 0 9471 Article rating: 5.0

You can generate interest invoices for paid invoices, partially paid invoices, and unpaid invoices. In addition, after you generate and send an interest invoice, you can generate a subsequent interest invoice for the next period.

Setting up interest invoicing: You can set up interest invoicing in Accounts Receivable and the General Ledger.
To set up interest invoicing, use these sessions:

  • Invoice-to Business Partner (tccom4112s000)

For invoice-to business partners...

Infor LX/BPCS Tips & Tricks for FINANCE: Creating Configurable Macros (CEA)

George Moroses 0 13265 Article rating: 5.0

You can create new macros in the Infor LX Configurable Enterprise Financials CEA107. 

On the Macro Definition window, you define the source file and the field in which you perform an arithmetic or special operation. For example, you can create a macro to accrue sales commission based on revenue. Your source file and field are the Invoice Line History (SIL) file and the G/L revenue (ILREV) field. 

Select Functions to access the Macro Functions window, on which you define the arithmetic, character, or special operation to process against the defined source field. In the previous example of accrued sales commission, you enter an arithmetic operation of multiply (*) and an operand value for the percentage, such as 0.05 for five percent. 

Note:  Previously created user defined macros will have to be updated to include any expanded field sizes in V84. 

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Setting Up User Groups (CEA)

George Moroses 0 10252 Article rating: 5.0

To utilize the Security Rules Optimization feature, a system administrator can assign security codes to 100 pre-defined user groups. User groups are created in the Group Security Maintenance (SYS603) program. All users assigned to this group possess the same level of security.   

A system administrator can assign security codes for up to 100 of the user groups. All user groups over 100 are still administered by all security reject/allow rules assigned to them but are not able to utilize the optimized process. 

Each of the security codes and access levels are assigned to user groups and are mapped to the account strings and stored in the Account Cross Reference (CEA106D1) file.   

Once security codes have been assigned, the system administrator must: 

  • Determine which level each group is allowed access.

  • Determine which segment values/account strings are assigned to which user groups.

  • Create security rules for specific segment values/account strings and assign these groups to the created rules.

  • Select the rules to be processed.  Processing can be done in either batch mode or interactively.

  • The Security Rules flag must be on in the CEA Control Parameters program before any rules are effective. 

Infor LX/BPCS Tips & Tricks for OPERATIONS: Lot Expiration Date

George Moroses 0 9256 Article rating: 5.0

This feature provides a parameter that allows the user to enter expiration dates on the Inventory Transaction Posting screen, INV500, and Purchase Order Receipts screen, PUR5505, when they have received a lot controlled item that is not QMS controlled. This new field allows an expiration date to be entered and not overridden. A system parameter was added to Advanced Process Industries Parameters, API820D. When the parameter is set to Yes, a new lot expiration date is available in the Inventory Transaction Posting, INV500D2, and Purchase Order Receipts, PUR550D2, screens.

Infor News You Can Use: LN NAUG Face-to-Face Annual Meeting 2025

May 13-15, 2024 | Chicago Marriott - Naperville IL

Kathy Barthelt 0 6608 Article rating: 5.0

We are delighted to invite you to the 2025 Annual LN NAUG Face-to-Face Event —a special premier event for Infor LN and Baan users of North America. This is your chance to connect with fellow users, share experiences, and shape the future.

  • Learn from the Best: Engage with industry leaders and experts through keynote sessions and panel discussions.
  • Increase your Skills: Participate in collaborative breakout sessions to explore available solutions.
  • Network & Connect: Build relationships with other customers, potential collaborators, and industry pioneers.


Register today to claim Early Bird pricing through March 31, 2025.
https://www.lnnaug.org/events/2025-f2f-annual-meeting 

 

123578910Last

Tips:  LX | BPCS | M3

Item Facility Master has a new attribute to define the override inspection days lead time CICP.ICINSD.

  • When an item facility has a defined override inspection days lead time, that value will be used instead of the system parameter inspection days lead time.

MRP exception report, MRP200B
Purchase planning report, PUR285B
Purchase order / Requisition maintenance, PUR500D3
Purchase order consolidation / release, PUR640B1
Vendor splits, PUR653B

This enhancement improved the subfile utilized in MRP320D Master Schedule Detail Inquiry -SCR001 by expanding the subfile with data rather than clearing the subfile as user pages. This change provides full support for the WebTop 4.8 Grid decorator.

This enhancement updated the approach used to populate the subfile to allow a deployed Webtop Grid to function correctly. There is no visible or user-impacted change to the way the program functions.

This enhancement provides improved functionality and full support of a Webtop grid applied to the subfile.

Last

Tips: LN | Baan

Kathy Barthelt
/ Categories: Infor LN & Baan Tips

Infor LN & Baan Tip: Cash Flow Functionality and Setup

A cash flow statement provides a historical view of the movement of cash within a company. This statement offers an overview of both the origins and destinations of cash, aiding management in evaluating the company's ability to fulfill short-term financial obligations. To differentiate between various sources and uses of cash, reason codes can be utilized. When interacting with cash transactions in relevant sessions, users have the option to input or review the corresponding cash flow reason. The cash flow statement organizes cash transactions based on these reasons. LN software system maintains year-specific opening balances for cash flow transactions. Should the need arise, users can manually input opening balances in the Opening Balance Cash Flow (tfgld2118m000) session.

To set up the cash flow statement, use the following sequence of sessions:

  1. Group Company Parameters (tfgld0101s000): If you want to generate cash flow statements in any of the financial companies of the group, you must select the Cash Flow Statement check box.
  2. Reasons (tcmcs0105m000): Define reason codes for the sources and uses for cash that you want to distinguish. The Reason Type must be Cash Flow.
  3. Purchase Types (tcmcs2101m000): For the purchase types related to cash transactions, select the default cash flow reasons.
  4. Sales Types (tcmcs2102m000): For the sales types related to cash transactions, select the default cash flow reasons.
  5. Chart of Accounts (tfgld0108s000): For ledger accounts used for cash transactions, select the default cash flow reason in the Cash Flow Reason field. The ledger accounts must have level zero and must not be a text account, an intercompany account, or an integration account.


To enter and view cash flow transactions: Transactions that must be included in the cash flow statement must have a cash flow reason linked to them. For most transactions, ERP LN derives the default cash flow reason from the sales type, the purchase type, or the ledger account.

If you manually enter cash transactions, you can enter a cash flow reason. You can view cash flow transactions in the following sessions:

  1. Cash Flow History (tfgld2519m000): This session displays, for one cash flow reason, the opening balance, the closing balance, and the movement during one financial period.
  2. Cash Flow Transactions (tfgld1523m000): This session lists the transactions by cash flow reason.

In both sessions, on the Specific menu you can click Opening Balance to start the Opening Balance Cash Flow (tfgld2118m000) session. Use this session to view the calculated opening balances for a cash flow reason or to enter manually an opening balance, if necessary.


To print the cash flow statement: Use the Print Cash Flow Transactions (tfgld1419m000) to print the cash flow statement. You can print the report for one financial company and one fiscal year, and for a range of financial periods and cash transaction reasons.

To print the cash flow statement, use the following sequence of sessions:

  1. Cash Flow History (tfgld2519m000): On the Specific menu, click Cash Flow Transactions. The Cash Flow Transactions (tfgld1523m000) session starts.
  2. Cash Flow Transactions (tfgld1523m000): Click Print. The Print Cash Flow Transactions (tfgld1419m000) session starts.
  3. Print Cash Flow Transactions (tfgld1419m000): To print the cash flow statement, in the Report field, select Cash Flow Reason Transactions.


Other related KBs which would be helpful in Cash Flow process queries:
1998168 How to link child Cash Flow Reason Group to Cash Flow Reason

Previous Article Infor LN & Baan Tip: Considerations for Release to Warehousing for a Cost Item
Next Article Infor LN & Baan Tip: All About Invoicing Methods
Print
39863 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories