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

Analytics Dashboard Pre-configured views for Infor LX | BPCS | Infor LN | Baan | Infor M3

ERP Reports: Get EXACTLY what you need when you need it for as little as $125/user/month

Crossroads RMC 0 34380 Article rating: 5.0

Everyone understands the importance of ERP reporting, but what if you’re relying on the wrong reports?

Having access to ERP data in a usable format allows for a common understanding and the ability to take action based on what the data is telling you. What do you do if the way your data is presented is not useful, or flat out wrong?

How can your reports be wrong? That would mean that the data is wrong, wouldn’t it?
Not necessarily. Reports are wrong because they are stagnant. They represent the truth ONLY at the moment they are run. If that data is shared with others within your organization, the information the report(s) is trying to convey has already changed. Decisions are then made on bad information.

What is preventing you from upgrading your Infor LX or BPCS ERP System?

George Moroses 0 43168 Article rating: 5.0

Your answer to this question is likely customizations… customizations that were once the best thing since sliced bread but now have become the bane of your existence.

There is something you can do about it! 

Crossroads RMC has many options for LX & BPCS when dealing with customizations:

What is preventing you from upgrading your Infor LN or Baan ERP System?

Kathy Barthelt 0 79743 Article rating: 5.0

Your answer to this question is likely customizations… customizations that were once the best thing since sliced bread but now have become the bane of your existence.

There is something you can do about it! 

Crossroads RMC has many options for dealing with customizations:

The Importance of an Integrated System

Crossroads RMC 0 49055 Article rating: 5.0

I recently came across an article from CIO Magazine that talked about the various ways that your ERP system could be hurting your business. The single most important item on that list referenced ERP systems that weren’t integrated with other systems that housed mission-critical business data.

Having data in two (or more) systems that don’t talk to one another is like baking a pizza crust in one oven and the toppings in another. Once baked, you may have some good food to snack on, but it sure isn’t pizza! Pizza requires the cheese and sauce and spices to bake with the crust. One takes on the flavor of the other and when you take a bite, you get a complete representation of the flavors.   

That’s the value of an integrated ERP system. When you take a bite, you get a complete representation of the flavors…meaning, you get one version of the truth. Everything comes together to allow you to analyze critical business data in an efficient way with no disconnects.

Crossroads consultants have spent years developing integration expertise to tie countless different systems to Infor ERPs.

Here are some examples…

The largest independent bottling company in the United States announced a successful Go Live

George Moroses 0 38415 Article rating: No rating

Polar Beverages, Inc. of Worcester MA has just announced a successful ‘Go Live' that brings their Adirondack Beverages division, in Scotia NY into a corporate environment running on the Infor LX platform. All business functions will be handled through the Infor LX platform, including Manufacturing, Supply Chain, and Financials. 

In early 2017, 2 divisions of Polar in Worcester MA and Fitzgerald, GA began utilizing Infor LX. Crossroads RMC partnered with Polar by providing technical and application support throughout the duration of the project.

First5556575860626364Last

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