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

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 LX & BPCS Tip: What prevents tax from being calculated on a purchase order?
Next Article Planning for Growth – What you need to do first to be successful
Print
15097 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

TECHNOLOGY: Facility Security Ranges

Previously, a user could complete the Cost Transfer (CST920) process for any range of facilities regardless of their security settings established in SYS600. This enhancement verifies the user security settings set up in SYS600 before processing cost transfers for a range of facilities in CST920. If the user has authority for a facility range, but there are facilities within that range that are not authorized, the program skips those facilities and completes the cost transfer process.

FINANCE: Expiration Date for Quotes and RMAs

A Cancel-by-Date has been added to the Quote Header and RMA Header panels. This optional field can limit how long a quote or authorization to return items for credit is valid.  

For quotes, this enhancement provides an optional end date for the quote. For RMAs, it provides an optional date by which the customer must return the items to receive the credit listed on the RMA.

The Cancel-By-Date prints on the Order Acknowledgement and RMA Acknowledgement to inform the customer of this important limitation to the quote or return authorization. 

An Order Entry user cannot copy the quote to create a new order if the Cancel By Date has caused the quote to expire.

OPERATIONS: Default Split Salesperson to Customer Orders

Sales commissions are based on combinations of the Primary, Split, and Line-Level salesperson and the commission codes defined for the customer and item. You can now define the Split Salesperson in the same master files as the Primary Salesperson. While the Primary Salesperson is mandatory, the Split Salesperson is optional. It defaults during Order Create using the identical hierarchy as Primary Salesperson. Using Split Salesperson provides more flexibility in the calculation of sales commissions. The ability to define a default Split Salesperson improves the accuracy of sales commission qualification and calculation and reduces maintenance and adjustments necessitated by corrections.

Previously, a user could complete the Cost Transfer (CST920) process for any range of facilities regardless of their security settings established in SYS600. This enhancement verifies the user security settings set up in SYS600 before processing cost transfers for a range of facilities in CST920. If the user has authority for a facility range, but there are facilities within that range that are not authorized, the program skips those facilities and completes the cost transfer process.

12345678910Last

Theme picker

Tips: LN | Baan

The Wrap Toolbar option has been added. You can use this option to wrap toolbar buttons to the next line if it becomes too narrow to add on the same line. If this option is selected, every session has the option available in the Personalization menu. This gives the user the possibility to change the wrapping state of the toolbar per session. This setting is saved as a personalization. You can configure this option in the Tools Parameters (ttaad0100m000) session and for specific users in the User Data Template (ttams1110m000) session.

Note: LN UI 12.2.6 or later is required.

What will you do when your ERP is no longer supported in 2021?

This is a confusing time for many companies with respect to their ERP system.

"Will I still be able to run my current version?"
"What happens if I want to stay on my version?"
"What options do I have?"

Crossroads RMC is here to help you sort through the confusion and get you to a place where you feel confident about your ERP future.

Let's get started with how we can help. I want Crossroads RMC to…

  • Conduct an Infor ERP Utilization Review – Should I consider moving to the latest version of LX in the cloud, or on prem? If I don’t, what are my options?
     
  • Set up an Infor ERP Demo System – I want to give my employees a chance to try out the latest version to see if it would be of benefit.
     
  • Train My Employees – I want to ensure that we’re operating based on best practices.
     
  • Integrate My ERP to External Systems – My company uses separate systems that don’t talk to one another and that is really inefficient.
     
  • Brainstorm With Me – I’m not sure what to do. I need to talk through some scenarios with someone who has been there, done that.
     
  • Support My Users – I’m short-staffed. I may upgrade, or I may stay where I’m at. Either way, I could use someone to handle our ERP issues. Please help!

Contact us at 800.762.2077 or click here to request a free phone consultation and we'll get you back on track.

First4950515254565758Last

Theme picker

Categories