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 31650 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 38934 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 70311 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 42500 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…

First4243444547495051Last

Tips:  LX | BPCS | M3

Improves control over PO costing changes during invoice entry by replacing passive warnings with an intentional override action.

  • In ACP500D3 (Invoice Entry PO Costing), users previously could unintentionally accept changes by pressing ENTER, even when quantity to cost or amount to cost values had changed.

  • A new “F14 to Override” warning message replaces the old message:
    “Details have changed. Press enter again to accept data.”
    This ensures users acknowledge and confirm significant changes explicitly.

New System Parameter:

  • “Apply GRN Costing Tolerance for PO Costing” (optional):

    • Within tolerance: Displays the original message —
      “Details have changed. Press enter again to accept data.”

    • Outside tolerance: Triggers the new override requirement —
      “F14 to Override”

Benefits:

  • Enhances oversight and reduces unintentional cost acceptance.

  • Enables better control of PO costs when invoice details differ from expectations.

Last

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
22077 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories