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 Tip of the Week: Deleting Records

Kathy Barthelt 0 82024 Article rating: 5.0

To improve performance and reduce database growth, deleting records is highly effective. The disadvantage of deleting records is that data is no longer available. Usually, however, not all records need to be saved. For example, line activities are stored by warehouse. Normally, you do not need to keep these records. Therefore, after closing a warehouse order, line activities can be removed. The User's Guide for ERP LN Archiving describes several sessions you can use to delete old data. Other data such as items and business partners can be reviewed once in a while, after which you can delete the data you no longer need. For every order and contract table a session is available to archive and delete old orders. In these sessions, you can specify several characteristics to select the orders to be removed, such as date or status. Run these sessions on a regular basis.

Explore your IDF programs

Anthony Etzel 0 34162 Article rating: 5.0

If you haven't already, you may want to start to explore your IDF programs. Currently they provide the replacement for the 300 series inquiry programs. In addition, navigation drill downs are far superior to any green screen presentation of the data.

Consistently meet customer commitments without last minute surprises

George Moroses 0 24048 Article rating: 5.0

What if you had a solution that allowed you to consistently meet customer commitments without last-minute surprises and unexpected extra effort and cost?

We do this by preventing slippage — slippage is any break in the plan that disrupts both normal material flow and the rhythm of the plant that is preventable by timely key user intervention.
Click here to learn more about OTTO, On-Time Orders.

Crossroads RMC and FIFCO to partner on an Infor LX / ION Project

Anthony Etzel 0 42590 Article rating: 5.0

A quote from the Applications and Development Manager at FIFCO…

"FIFCO has a long standing relationship with Crossroads RMC. Over the past 20 years, Crossroads has been committed to our success. We chose Crossroads to implement ION for the technical expertise and in-depth knowledge they have of ERPLX. I have found this to be true of all the consultants I have worked with over the years from Crossroads. I hope for FIFCO USA and Crossroads RMC to continue their partnership for many more years to come."

BPCS / LX Tip of the Week: Inventory Period Balance Freeze

Anthony Etzel 0 58904 Article rating: 5.0

This enhancement provides clients the ability to store the opening/ending on hand balance for each Inventory period at the Item (IIM), Warehouse/Item (IWI) and Lot/Location (ILI) levels. Infor LX clients can back date inventory transactions into the immediate previously closed period, and thus update what was saved as the opening/ending balance throughout the current open period. 

Tracking the opening/ending/period balance for each inventory period can give users insights into the levels of inventory for each item, item/warehouse and item/warehouse/lot/location combination.

Crossroads RMC is proud to enter their 21st year in partnership with Paccar for Baan data collection

Kathy Barthelt 0 72385 Article rating: 5.0

In 1998, Paccar, Inc. chose Crossroads RMC to be their data collection partner for Baan IV. That partnership has grown over the years and now incorporates almost 200 data collection licenses and 15 different Crossroads applications that run on mobile devices throughout Paccar’s facility. This year, Paccar has elected to extend the Crossroads Data Collection - Web Collect to some of their 3rd party contractors in order to support an increase in production. With the installation of the Crossroads Data Collection - Web Collect, the subcontractors will be able to complete sub-assembly activities and inventory transfers all within Paccar’s Baan system which the subcontractors will be accessing via a point to point solution built for them.

Baan / LN Tip of the Week: Analyzing Inventory Adjustments – 10.6

Kathy Barthelt 0 73024 Article rating: 5.0

Want to understand the financial ramifications of inventory changes in Infor LN? 

Analyze Inventory Adjustments in-LN 10.6

Several display and print sessions are available.  In these examples, the item number used is 020000.

1--Adjustment Orders Session

Double click on the order line to get to the Lines detail.

In the Lines session, double click on the item to see the details.

The “Adjustment” tab provides the quantities.

First7273747577798081Last

Tips:  LX | BPCS | M3

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
56317 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories