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

Your Enterprise Resource Planning software lies at the heart of your business

Friedman | MAPICS | XA and more

George Moroses 0 29541 Article rating: 5.0

How your ERP is utilized is critical to operating a stable, well understood and effective business system. Knowing the current state of your system will enable you to make decisions to either better utilize your current ERP version or upgrade.

Crossroads RMC’s Utilization Review helps you flush out issues and areas for improvement. Our findings have resulted in minor procedural changes to a full reimplementation, or system upgrade.

If your business requirements and your resources have undergone a major change since your original implementation, it is time to take a look at your ERP system to see if it is being utilized properly. The Crossroads RMC Utilization Review is designed to work with your people to identify the best way to apply the powerful capabilities within the Manufacturing, Supply Chain and Financial modules within your ERP software to best suit the needs of your business, not only today, but in years to come.

Learn more>

Dashboard Displays Current Production Data and Increases Production by 10-20%

Crossroads RMC 0 35732 Article rating: 5.0

Did you know that you can improve the performance of your shop floor simply by displaying how your shop floor workers are doing? Studies show that a 10-20% increase in production can be achieved by simply displaying current production data to your workers via dashboards. 

Using the Crossroads RMC's Analytics Dashboard, you can display performance metrics in a grid, graph, chart, or any way that makes sense. Learn how

Learn more about Analytics Dashboard for Infor LN/Baan >

Learn more about Analytics Dashboard for Infor LX/BPCS/M3 >

Infor LN & Baan Integrations:

It's okay, you can admit it. You have spreadsheets and separate databases that you’re keeping on the side that may or may not be tied to Baan/LN.

Kathy Barthelt 0 34543 Article rating: 5.0

Do you wish they were integrated so that you didn’t have to manually go into each system to report on the data or look up information? Are you running into problems because you don’t have exposure to all of the data that is critical to running your business?

Crossroads RMC has a team of integration experts who can create the integration you’ve been dreaming about… AND we have developed RMCconnector to allow for quick and easy translation data from your front end system into a format accepted by your back end ERP. 

Contact us today to discuss how we can help you eliminate those spreadsheets and tie those “one-off” systems directly to your ERP system. 800.762.2077

Partner News: Avalara’s 2020 sales tax changes webinar is now available

George Moroses 0 31057 Article rating: 5.0

Now that 2020 has arrived, it's time to make sure you’re prepared for all of the changes that 2019 brought in the world of sales tax.

Avalara’s 2020 Sales Tax Changes Webinar is now available to arm you with knowledge on the biggest changes that have taken effect, plus give you a preview of the changes we anticipate this year. 

In this webinar you’ll hear Scott Peterson, Avalara’s VP of U.S. Tax Policy, cover:

  • The current state of sales and use tax in the U.S.
  • Which states have enacted economic nexus, and what’s expected to change in 2020
  • New requirements for marketplace sellers (Amazon, Etsy, etc.)
  • A look at cross-border ecommerce and what international sellers must know about sales tax 

Avalara 2020 Sales Tax Changes Webinar>

Infor LN & Baan Consulting News: So we put our hands up, like the ceiling can’t hold us…

Kathy Barthelt 0 34062 Article rating: 5.0

Crossroads RMC partnered with Hunter Douglas Architectural Ceilings and Walls to upgrade their LN system from LN 10.2 to LN 10.6. This upgrade was undertaken primarily as a result of unsupported hardware/operating system versions at Hunter Douglas. Despite an extremely tight deadline, Crossroads and Hunter Douglas partnered to complete this upgrade from start to finish in under 4 months. Phase 2 is planned to kick off in late Q1 of 2020, which will focus on specific areas of the business for process improvement and the implementation of Avalara’s Avatax software.

Learn about Crossroads RMC's Consulting Services

Infor LN & Baan Tip of the Week: Customer Defined Fields

Kathy Barthelt 0 85829 Article rating: 4.3

Customer Defined Fields (CDFs) can be added to tables, screens, reports and BODs and validation and calculation logic can be defined around those fields.

Use the CDF concept to store additional data in the standard Infor LN tables. The CDF definitions are stored separately from the table definitions in the Data Dictionary. For the end user, the CDFs behave in the same way as the standard fields, if defaulting, validations, etc. are built using the CDF logic of the table extension point. The session extension point also has features for the CDFs.

CDFs are configured per package combination. This implies that when moving your companies from one package combination to another, the CDF definitions must be present in the target package combination. Otherwise you lose the data in the CDFs.

Crossroads RMC is proud to introduce our new Production Order Variance Reports package for Infor LN

Kathy Barthelt 0 76596 Article rating: 5.0

The package includes numerous reports and sessions to view the variances in a way that Finance can identify problems based on the Finance Integration Transactions in the General Ledger.

There are a few main sessions with many detailed sessions linked to them. The reports can be run from the main Print Production Order Variance Reports or in the individual detailed session.

Sessions included in the report package:

1. Print Finalized Trans – Variance Reports.

a. Financial Trans. by L/Acct – Prod. Order Variances - Recap

b. Financial Trans. by L/Acct – Prod. Order Variances – Details

2. Update Production Order Variances (updates special variance table).

3. Production Order Variance Overview – Main view

a. Production Order Variance Details

b. Price Variance Details – Material Variances

c. Price Variance Details – Operation Variances

d. Efficiency Variance Details – Material Variances

e. Efficiency Variance Details – Operation Variances

f. Efficiency Variance Details – Reject Variances

g. ACO Variance Details – Reject Variances

h. Accept Production Order Variances

i. Un-accept Production Order Variances

j. Finally Accept Production Order Variances

4. Print Production Order Variance Reports:

a. Production Order Variance – Overview

b. Production Order Price Variance – Material Revaluation

c. Production Order Price Variance – Operation Revaluation

d. Production Order Efficiency Variance – Material

e. Production Order Efficiency Variance – Operation

f. Production Order Efficiency Variance – Rejects

g. Production Order ACO Variance – Rejects-Additional Costs

5. Delete Production Order Variances (used to redo a month)

Contact Kathy Barthelt to learn more.

First6263646567697071Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan FINANCE Tip: Is it possible to upload accounts receivable invoices into LN using Excel?

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.

1a. Open the transactions (tfgld1101m000) session and create a batch.

1b. Insert a transaction type, used for creating sales invoices, like ACR, and open it.

2a. The Sales Invoices (tfacr1110s000) session starts. Maintain the invoice header and save it. For example sales invoice ACR 4497.

2b. In the Actions menu select Export and Import -> Advanced Export (fields: All tabs).

2c. In the excel file created during previous step, add the headers for the invoices to be uploaded. Notice if for the transaction type the Documents in Fixed Sequence checkbox is ticked in the Transaction Types (tfgld0511m000) session, the document number for the not-yet existing invoices to be imported in LN should be equal to the default series for this transaction type. Otherwise, so if the Documents in Fixed Sequence checkbox is not ticked, the desired document numbers can be maintained in the excel file.

2d. In the Sales Invoices (tfacr1110s000) session in the Actions menu select Export and Import -> Settings, and make sure the Import Only in This View checkbox is NOT ticked. Then select in the Actions menu select Export and Import -> Import, select the excel file as saved in the prior step, and import it. Afterwards the invoice headers should be visible in the Sales Invoices (tfacr1110s000) session.

3a. Navigate to the first invoice, select Lines. The Transactions (tfgld1102m300) session opens. Maintain at least 1 line and save it.

3b. Open the line created in the prior step. Notice the detailed version of the Transactions (tfgld1102m300) session opens.

3c. In the Actions menu select Export and Import -> Advanced Export (fields: All tabs).

3d. In the excel file created during previous step, add lines for the header invoice numbers as available in the Sales Invoices (tfacr1110s000) session (as per step 2d).

3e. In the detailed version of the Transactions (tfgld1102m300) session in the Actions menu select Export and Import -> Import, select the excel file as saved in the prior step, and import it.

Previous Article Infor LN / Baan Tips & Tricks for EXECUTIVES
Next Article Infor LN & Baan TECHNOLOGY Tip: Are you running the latest Infor components?
Print
34840 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories