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

M3/Movex Tip of the Week: Year-End

Frank Petrasio 0 35218 Article rating: 5.0

Year-End is always a busy time!

So busy that it's easy to forget things that must be done in your ERP system to close out the year properly and set you up for a good start to the following year. Here are some things to add to your to-do checklist.

The year-end close process provides an opportunity to:

Infor M3 & Movex Tip of the Week: Views & Sorting Orders

Frank Petrasio 0 39761 Article rating: 5.0

One of the most common complaints from M3 users is that the wrong information is displayed on B (list) panels, or it is displayed in the wrong order. M3 provides a tool that allows users to personalize the display so only relevant information is seen without programming assistance from IT.

It is divided into two components:

Infor LN & Baan Tip of the Week: Reports to Analyze Company Performance

Kathy Barthelt 0 69417 Article rating: 5.0

You know what data you need to analyze your company’s financial and production health, but sometimes it's a struggle to get that data in a format that is meaningful. Here are some reports in Baan IV, Baan V, and Infor LN which you may find useful.

As is the case with most ERP reports, with each version progression from Baan IV, to Baan V, to LN, there are improvements in selection criteria and report content. Some may require some setup and others may require some formatting if you would like to export them to Excel.  Contact me if you have questions or need assistance.

BAAN & LN FINANCE & MANUFACTURING:

Infor LX & BPCS Tip of the Week: Reports to Analyze Company Performance

George Moroses 0 34868 Article rating: 5.0

You know what ERP data you need to analyze your company’s financial and production health, but sometimes it's a struggle to get that data in a format that is meaningful. Here are some reports in BPCS & Infor LX which you may find useful.

As is the case with most ERP reports, with each version progression from the earliest versions of BPCS to the latest version of Infor LX, there are improvements in selection criteria and report content. Some may require some setup and others may require some formatting if you would like to export them to Excel. Contact me if you have questions or need assistance.

BPCS & LX FINANCE & MANUFACTURING REPORTS:

The Best Baan | Infor LN Manufacturing Reports to Analyze Company Performance

Kathy Barthelt 0 67270 Article rating: 5.0

You know what ERP data you need to analyze your company’s production health, but sometimes it is a struggle to get that data in a format that is meaningful. Here are some reports in Baan & Infor LN which you may find useful.

As is the case with most ERP reports, with each version progression from the earliest versions of Baan to the latest version of Infor LN, there are improvements in selection criteria and report content. Some may require some setup and others may require some formatting if you would like to export them to Excel. Contact me if you have questions or need assistance.

BAAN & LN MANUFACTURING:

The Best BPCS | Infor LX Manufacturing Reports to Analyze Company Performance

George Moroses 0 35313 Article rating: 5.0

You know what ERP data you need to analyze your company’s production health, but sometimes it is a struggle to get that data in a format that is meaningful. Here are some reports in BPCS & Infor LX which you may find useful.

As is the case with most ERP reports, with each version progression from the earliest versions of BPCS to the latest version of Infor LX, there are improvements in selection criteria and report content. Some may require some setup and others may require some formatting if you would like to export them to Excel. Contact me if you have questions or need assistance.

BPCS & LX MANUFACTURING:

Manufacturing: How much time are you wasting on manual processes?

Crossroads RMC 0 30912 Article rating: 5.0

It tells us that there is a great need for a review of your manufacturing processes.

Manual processes around labor reporting, production completions, issuing of material, inspection approvals, serialization, and more can weigh down the entire shop floor team and can be the source of significant errors. Your business and your customers’ needs have changed and you are in a constant battle to keep up. It is hard to know which area to tackle first and where the greatest impact can be made.

That's where the Crossroads RMC Manufacturing Utilization Review comes in. Whether you're on an old version of BPCS or Baan, or the latest version of Infor LX or Infor LN, odds are there are aspects of Manufacturing / Production Control in the ERP system that doesn't fit your business's current strategy. Do you throw out the software and start with something new? Odds are that is overkill. Sometimes it just boils down to taking the time to understand how your current state matches up with your corporate strategy, understanding the gaps, and developing a plan to get you from point A to point B.

We have successfully helped companies transform their business in the areas of: 

  • Planning / Scheduling
  • Shop Floor Control
  • Final Assembly
  • Quality Control
  • Production Control
  • Forecasting
  • Work Centers / Routings / Bill of Materials

Our consultants have 30+ years of experience that bring about REAL...

The Best Baan IV | Baan V | Infor LN Financial Reports to Analyze Company Performance

Kathy Barthelt 0 64027 Article rating: 5.0

You know what data you need to analyze your company’s financial health, but sometimes it is a struggle to get that data in a format that is meaningful. Here are some reports in Baan IV, Baan V, and Infor LN which you may find useful.

As is the case with most ERP reports, with each version progression from Baan IV, to Baan V, to LN, there are improvements in selection criteria and report content. Some may require some setup and others may require some formatting if you would like to export them to Excel.  Contact me if you have questions or need assistance.

BAAN & LN FINANCE:

First4950515254565758Last

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

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories