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 LX & BPCS Tip of the Week: Journal Upload – EGLi

George Moroses 0 52551 Article rating: 5.0

EGLi users who maintain journal entries in a Microsoft Excel spreadsheet can use this utility to upload journal entries to EGLi. The Journal Upload installation program adds an Add-Ins tab to Microsoft Excel. This tab includes options to connect to the server where EGLi is installed and to open a spreadsheet template to use for manual journal entry. When the spreadsheet is complete, the Add-Ins tab is used to upload the spreadsheet.

To install Journal Upload:

  1.  The Power-Link Installation page has links to the Client installation programs and a link to download and install the Journal Upload utility. To access this page, use this link with your own values for system and NetLinkport: http://system:NetLinkport/Installs/ClientInstall/Install.html  where system is the server where IDF is installed and NetLinkport is the Net-Link port, typically 36001
     
  2. On the Power-Link Installation page, click the link provided to download and install EGLi Journal Upload.
     
  3. Follow the screen prompts to complete the installation on your PC.
     
  4. To verify the installation, open an Excel spreadsheet. Confirm that the Add-Ins tab is on the spreadsheet. 


See the Infor Enterprise General Ledger for System i Journal Upload Installation and Infor LX Configuration Guide.

Infor LN & Baan Tip: Open Transactions Check – LN 10.7

Kathy Barthelt 0 57277 Article rating: 5.0

When closing a project, users were informed about open transactions blocking the closure process. To proactively check on open transactions, the Show Open Transactions option has been introduced in the Project Status (tppdm6107s000) session. With this option, issues can be resolved before changing the status.

Infor LX & BPCS Tip of the Week: LX 8.4 Enhancement – Company Security for ACR510

George Moroses 0 17689 Article rating: 5.0

This enhancement provides LX Company Security to Invoice Maintenance, ACR510. Only users authorized to the invoice company can view or maintain invoices.

User must be authorized to ACR as a product or ACR510 as an individual program in Security Master Maintenance, SYS600. Additionally, ACR510-01, displays all records, but if the user tries to revise or display a transaction record for a company the user is not authorized to, this error message is displayed: “User is not authorized to the transaction company.”

Infor LX & BPCS Tip of the Week: Item Deletion Option in IDF Enterprise Items

George Moroses 0 21348 Article rating: 5.0

Previously, users were unable to delete items in IDF Enterprise Items when they have inventory balances or the item is connected to ancillary records, such as sales history records. This feature added in LX 8.4 provides the ability to delete an item when sales history records are found but all sales history activity is zero.

When the user attempts to delete an item in IDF Enterprise Items that is tied to a sales history record, the panel displays a message that the item cannot be deleted. The user can then run the Delete Validation Report to determine which records are tied to this item that prevents the validation. If the item no longer has manufacturing activity but had old sales history, the item can be deleted.

Infor LN & Baan Tip of the Week: In Transit Inventory Report – LN 10.7

Kathy Barthelt 0 63128 Article rating: 5.0

A new In-Transit Inventory report can be printed in the Print In-Transit Inventory (whinr1410m300) session. The report provides an overview of company inventory that is on the move and not stored in a warehouse. This concerns only inventory that is transferred from one warehouse to another. Items that are shipped to, for example, customers or projects, or items that are issued to production lines or service departments are excluded.

The report shows item inventory....

First5253545557596061Last

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

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories