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

DASHBOARDS for IBM i WEBINAR

See it. Understand it. Discuss it.

Anthony Etzel 0 7813 Article rating: 5.0

Are your numbers telling the full story? Discover the power of dashboards in our recorded webinar from 5/2/2024: "Unlocking Business Insights with Dashboards" Numbers are just the tip of the iceberg; the real insights lie beneath, in the 'how' and 'why'. Imagine presenting your manager with a dashboard that not only showcases the figures but also unveils the backstory behind them. Picture revealing that the 3rd shift was short-staffed for over a week, or that a material shortage caused order fulfillment delays, or that quality issues triggered extensive rework, impacting subsequent production runs. How do you unearth all this crucial information without consulting every individual involved?

The Answer:  D A S H B O A R D S !

[Watch Video] Webinar: Business Insights Made Easy With Dashboards...

Webinar: Business Insights Made Easy With Dashboards - Infor LX/BPCS

Thursday, May 2, 2024 - 12:00-1:00 (US/Central)

George Moroses 0 10057 Article rating: 5.0


  

Join Crossroads RMC
& the InforIBMi-Series Community

Business Insights Made Easy With Dashboards

Learn how easy it is to create and use dashboards to gain valuable insights into the data you use daily to run your business.

Join our webinar: Thursday, May 2, 2024 at 12:00pm Noon (US/Central) for 1 hour.

Register →


Presenter: Anthony Etzel

Streamline Your Data Management with Crossroads RMC's Analytics Dashboard for LN & Baan

Kathy Barthelt 0 10269 Article rating: 5.0

To enhance effective team communication and streamline data management, it's crucial for all team members to use a common language and work from a shared playbook. When decisions are based on disparate data sources, such as individual spreadsheets or isolated data repositories, it can hinder effective communication.

For manufacturers who deal with extensive data daily, keeping track of key departmental metrics can be challenging. This is where Crossroads RMC's Analytics Dashboard solution can make a significant difference. Our Analytics Dashboard is designed to simplify tasks by consolidating essential information into a single, easily accessible location, allowing you to access critical real-time data effortlessly.

With our powerful dashboards, you can achieve the following:

DATA: See it. Understand it. Discuss it.

Crossroads RMC 0 13509 Article rating: 5.0

We’ve all heard author and management consultant Peter Drucker’s famous quote “If you can’t measure it, you can’t manage it.”  

What’s the right way to manage “It” though? Is it enough to put the data in the hands of the responsible manager and wait for change to occur? Does the manager have a pulse on everything that went into those numbers?

Your numbers tell a story, but there is a lot of...

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

Crossroads RMC 0 24541 Article rating: 5.0

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?

Infor ERP Tip: Top 5 Ways Modern Analytics Reduces Spreadsheet Risk & Inefficiency

Infor LX | BPCS | Infor LN | Baan

Crossroads RMC 0 23187 Article rating: 5.0

Spreadsheets are often the tool of choice for many organizations to store and arrange information for financial planning, analytics, compliance, and more. Ironically, for many business processes that involve managing data, it creates the exact opposite effect––silos of information and inefficiency. And because it stores organizational data in a readily sharable way, there is a high risk of exposing confidential information.

Read this Infor best practice guide to discover the top five business processes that a modern data and analytics architecture can automate and deliver far more value than spreadsheet-driven techniques.

Infor Best Practice Guide: 5 Ways Modern Analytics Reduces Spreadsheet Risk and Inefficiency

Manufacturing vs. Operations vs. Finance: Who WINS?

Infor LX | BPCS | Infor LN | Baan

Crossroads RMC 0 18663 Article rating: 5.0

Manufacturing Goals: develop high-quality products and services in response to the demands of the market, improve efficiency and maximize capacity utilization.

Operations Goals: utilize resources, labor, material, and equipment effectively in order to match supply and demand.

Finance Goals: analyze revenue growth opportunities, control costs, and maximize profitability.

So, who WINS?

Infor LN & Baan: BIG DATA - Keeping Track of Key Metrics

Kathy Barthelt 0 24675 Article rating: 5.0

In order to communicate effectively as a team, everyone needs to speak the same language and operate off the same playbook. If decisions are made based on the data or the view of data that individuals are maintaining through their own spreadsheets or other data silos, then communication is negatively impacted.

Manufacturers need to review large amounts of data every day, making it difficult to keep track of key metrics within your department.

That’s where Crossroads RMC’s Analytics Dashboard solution comes in. Our Analytics Dashboard was developed to make tasks easier by putting all of the key information in one convenient location so you can view all of your crucial data in real-time. 

With powerful dashboards, you can...

12345

Theme picker

Tips:  LX | BPCS | M3

Users can now freeze period-end balances at the end of a fiscal period. You can now store the opening/ending on hand balance for each Inventory period at the Item (IIM), Warehouse/Item (IWI) and Lot/Location (ILI) levels. This information can then be used for inventory tracking and valuation purposes, as well as other ad hoc financial and audit reporting requirements. Infor LX clients can backdate inventory transactions into the immediate previously closed period, and thus update what was saved as the opening/ending balance throughout the current open period.

When a lot is completely shipped on a customer order, the Lot Status is changed to Z. Since a resupply order must still be received in the To Warehouse to complete the transaction, do not update the lot status when the resupply order is shipped. If a lot is completely shipped on a resupply order, LX no longer updates the lot status to Z, because the shipped lot retains its current lot status, the additional steps, no additional steps are required to receive it in the To Warehouse.

1345678910Last

Theme picker

Tips: LN | Baan

You can use a problem code to indicate that a problem exists for a sales invoice. If the invoice-to business partner notifies you about a problem with the invoice and does not pay it, you can link a problem code to the invoice.

In the direct debits procedure, problem invoices are automatically discarded. For each problem code, you can set an option to prevent linked invoices from being selected on reminder letters.

The audit server logs all database actions that change the contents of a table in so-called audit files. The Exchange module can use these audit files, which are useful in a multisite environment because the databases on all sites must have identical data. These audit files can also be used in data conversions.

Only the updates in a specific period are exchanged, which leads to an improvement in performance. Specify this period in the Export Data (Non-Regular) (daxch0233m000) and Export Data (on a Regular Basis) (daxch0234m000) sessions. Changes such as insert, update, and delete are processed and written into the ASCII files. Actions such as drop, clear, and create tables are ignored.

Audit control data is added to the resulting ASCII file. This data consists of a batchline ID, transaction ID, sequence ID, and an indicator. The control data is added at the beginning of each line and is formatted like other data fields such as the enclosing and separator characters.

An update writes two lines to the ASCII file. One line contains the key fields and old values of the updated fields. The other line contains the new values of the key fields and updated fields, even if a key field does not change.

The batchline ID is used for recognition when processing the ASCII files. The transaction and sequence IDs are used to ensure that the transactions are replayed in the same order as on the exporting site. The indicator defines the type of action that is executed on the table. Use the letter I to insert; use the letter D to delete; use the letter U to update with old values; and use the letter N to update with new values.

1345678910Last

Theme picker

Categories