Infor ERP Tips and Infor ERP News for Infor LX, BPCS, Infor ERP LX, Infor LN, Infor ERP LN, Baan, Infor M3, and Movex

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 54213 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 115861 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 19206 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 23370 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 139244 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....

First5859606163656667Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Crossroads RMC

Dashboards vs. Reports – What do they offer and which do I need?

Companies are collecting oceans of data, and struggle with transforming it into usable information. Most businesses focus on two methods of sharing data - the report and the dashboard. While these two terms mean many things to many people, it is important to understand what these terms mean and how the report and dashboard have similar features but they are not the same thing.  

What is a Report?

A report is meant to be used to gather detailed intelligence on the operations within an organization, thus a report can be either very broadly covering a wide scope of related information, or narrowly focusing on details of a single item, purpose, or event. All of this information, while presented in a report, is meant to be a snapshot in time.

Quite often, a report is built within the ERP system itself and often is constrained by the graphical and user limitations within the ERP. More often than not, large amounts of data are exported to Excel where added features allow for better manipulation of the data to a format that is digestible by users. Regardless, the data is only valid for that moment and time.

What is a Dashboard?

A dashboard is a graphical interface that provides at-a-glance views revolving around answering a central question. For example, an executive may ask you for up-to-the-minute details on "how the business is doing?". The answer to that question is as complex as the organizational structure of the company, but it is probably very simply measured with approximately 10 metrics. Those 10 metrics can likely be analyzed in chart form, and can and should be combined into one chart when the numbers are relatable or are on a similar scale. All these things should be considered when building a dashboard.

Dashboards, similar to the one in your vehicle, display critical data. Imagine driving down the road and having to push a bunch of buttons to find out how much fuel you have left, or having to pull over and pop the hood to check the oil pressure. It would be dangerous and a waste of your precious time. Your car's control panel or dashboard displays the most crucial information in an easy-to-use, graphical way.

How do Dashboards and Reports differ?

First, a report contains much more detailed information. Where a dashboard might provide a CEO with information on how the entire company’s sales are progressing, a corresponding report will give the CFO or VP of Sales the ability to see how each sales region or even salesperson is performing and make leadership decisions. Just like responsibility, data will get more granular as the organizational hierarchy goes down. The C-Suite might be interested in the detailed data, but for seeing a snapshot of high-level information, the dashboard is the desired mode.

Second, a report is much longer than a dashboard. Not only in the amount of detail but also visually. Tables and charts that live within a report can take up many pages. Furthermore, a report will likely require the reader to scroll through many screens or click from page to page.

A dashboard should confine its display to a single screen with no need for scrolling or switching among multiple screens. Something powerful happens when we see things together, all within eye span. Likewise, something critical is compromised when we lose sight of some data by scrolling or switching to another screen to see other data.

When an individual dashboard has so much information on it that scrolling is required, the power of the dashboard is diminished because the information that lives there is intended to be viewed together. Each piece of information on the dashboard is meant to give the reader the ability to answer part of the central question of the dashboard. These charts combine to answer the question, so if the reader can’t see them together, making them work together is much more difficult.

To sum it up, a report is a more detailed collection of tables, charts, and graphs and it is used for a much more detailed, full analysis while a dashboard is used for monitoring what is going on. The behavior of the pieces that make up dashboards and reports are similar, but their makeup itself is different. A dashboard answers a question in a single view and a report provides information. Put in another way, the report can provide a more detailed view of the information that is presented on a dashboard.  

With dashboards, you can empower your entire team with data insights in real-time information, so your data is never stale. Users can create and share custom views of your data on the fly, in minutes.

With powerful Dashboards, you can:

  • Create pie charts, graphs, interactive maps, and more with just a few clicks.
  • Build a dashboard once and make it instantly available on any device.
  • Tell a story with your data with your own custom layouts, colors, and commentary—all with no coding and changes available instantly to users.
  • Know you always have current reports with real-time data updates.
  • Access your dashboards from anywhere–computer, tablet, or phone.
     

Manufacturing

Enlarge Production Summary Dashboard Enlarge Work Center Job Step Status


Finance

Enlarge Accounts Receivable Dashboard


Materials

Enlarge Inventory Dashboard Enlarge Sales History Dashboard


 

Analytics Dashboard for Infor LX & BPCS>

Analytics Dashboard for Infor LN & Baan>

Contact us today to learn how dashboards can help you go fast, go big, and go bold.

Print
30494 Rate this article:
5.0
Crossroads RMC

Crossroads RMCCrossroads RMC

Other posts by Crossroads RMC

Contact author

x

Categories