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 FINANCE Tip: Is it possible to upload accounts receivable invoices into LN using Excel?

Kathy Barthelt 0 11496 Article rating: 5.0

Yes, this is possible, by following the steps below:

1. Maintain a batch

2. Maintain an invoice headerexport it, add an additional invoice header to the Excel file, and import it

3. Maintain an invoice line for the first invoice, export it, add additional invoice lines to the Excel file and import it
 

Below the above steps are described in detail...

Infor News You Can Use | The business case for moving your ERP to the cloud and choosing MT deployment

Kathy Barthelt 0 5653 Article rating: 5.0

As more companies invest in cloud computing for their business software and migrate their ERP systems to the cloud, many are considering whether single-tenant or multi-tenant cloud deployment is the best choice.

In this executive brief, Infor outlines insights from the analyst community on the growth of cloud technology, key distinctions between single- and multi-tenant deployments, and why the multi-tenant option for ERP may be the best move for your business.

Learn more>

Tick-Tock... It's time to get more out of your ERP

Crossroads RMC 0 6332 Article rating: 5.0

As crazy as it sounds, we’re about to enter the 2nd half of 2024. How are you doing on your 2024 goals? Planning for 2025 projects?

Maybe it's time to get more out of your Infor ERP system.

⇒⇒ TIME TO UPGRADE?

Is an upgrade to the latest version of your ERP the goal for 2024/2025? If so, Crossroads RMC brings 40 years of industry experience to the table to ensure that your upgrade achieves the results you’re looking for and does so on time and within budget.

Crossroads RMC's team of expert consultants will:

  • Review your custom components to see what can be eliminated
  • Provide an analysis of the specific benefits that your company can achieve by upgrading
  • Train your users on the latest functionality
  • Support your users on the old version while the project team focuses on the upgrade project
  • Handle the entire upgrade project from start to finish
  • Supplement your existing project team with 1-2 key resources
  • Develop the integration to that 3rd party system that is a MUST-HAVE when you upgrade


⇒⇒ NOT UPGRADING?

Infor LX/BPCS Tips & Tricks for FINANCE: Prevent Voiding of Selected Invoices

George Moroses 0 7727 Article rating: 5.0

This enhancement prevents users from voiding invoices after they have been selected for payment. If a user selects an invoice for payment and another user voids the invoice during the payment process, it can produce erroneous and duplicate records. The ACP500 programs were modified to check the status of an invoice before it can be voided. If the invoice has been selected for payment, a message is generated, and the invoice cannot be voided.

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Update User Security in IDF

George Moroses 0 6858 Article rating: 5.0

Automatically synchronize security changes from LX to IDF, replacing CPYSECIDF. This new process synchronizes users in IDF with those in core LX security whenever a user’s security settings are changed. When a user is deleted from an LX environment, they can also be automatically removed from the IDF environment. Changes to a user’s access to programs in LX are mirrored in IDF. Access to Companies, Facilities, and Warehouses are also synchronized. Additionally, when Business Roles or Business Units access is changed, all users assigned to those roles or units are updated in IDF security.

Infor LX/BPCS Tips & Tricks for OPERATIONS: Copy Shop Order

George Moroses 0 6497 Article rating: 5.0

In the Shop Order Selection program, action 3=Copy is available. This action allows copying any shop order except for flow orders or campaign orders. Instead of copying from the parent item's bill of material and routing, the new shop order’s materials and operations will be copied from the selected shop order. Note that if the existing shop order is linked to a customer order or line, this linkage will not be copied to the new shop order.

Infor News You Can Use | Have you upgraded to Infor LX 8.4.2 yet?

George Moroses 0 5967 Article rating: 5.0

Unlock industry capabilities

The latest version of Infor LX, release 8.4.2, provides core enhancements, an expanded database, and global modernization to meet market changes.

  • IDF serves as a rapid development platform with extensibility that enables release transparency and allows your IT team to eliminate legacy queries and custom reports

  • Advanced functions like embedded warehouse management, collaboration with logistics server providers and suppliers, and vendor-managed inventory are all included as standard and designed to support all of your supply chain needs

  • Embedded tools like document management, notifications, and workflows improve collaboration and productivity across teams

Infor LN / Baan Tips & Tricks for EXECUTIVES

Kathy Barthelt 0 9268 Article rating: 5.0

Finance: Propagating Unused Sub-Accounts

You can use this procedure to find accounts that have a valid sub-accounts group but no corresponding general ledger chart account records. This action creates the general ledger chart account record for the account and sub-account combination. This action does not add the accounts to charts.

  1. Select Financials > Global Ledger > Setup > Finance Enterprise Group > Maintenance.
  2. Open the finance enterprise group and click the Sub Account tab.
  3. Select Actions > Propagate Unused Sub Accounts.
  4. Select the finance enterprise group and click OK.

Sub-accounts are added according to group if they have been defined on the accounts. The resulting account can be added to the charts.

Operations: Best Practices for Purchase Order Archiving / Deleting

Here are some best practices to follow if you are considering archiving or deleting purchase order data:

  • If Financials is implemented, we recommend that you do not delete order data in a fiscal year that has not yet been fully closed. This is because the GRINYA process uses information that would be deleted by this action. For best results, check whether the logistical balance for non-invoiced receipts matches the balance of the GRINYA accounts for the periods up to which you want to delete purchase order data.
  • When a purchase order is canceled, you can only delete the purchase order and the related tables. If only a purchase order line is canceled, the line can be deleted and archived.
  • Purchase contracts must be archived before purchase orders can be archived.

You cannot delete a purchase order (line) if:

  • The linked warehouse order is closed but cannot be removed.
  • The purchase order is linked to a PCS pr
RSS
First2345791011Last

Theme picker

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.

123457910Last

Theme picker

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
23537 Rate this article:
5.0
Crossroads RMC

Crossroads RMCCrossroads RMC

Other posts by Crossroads RMC

Theme picker

Contact author

x

Categories