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

Crossroads RMC to Exhibit at Inforum 2016

Crossroads RMC 0 28746 Article rating: No rating

Inforum 2016  returns as a three and a half-day event of educational seminars and workshops focused on the future of enterprise software and your business. This event is Infor’s premier event for 2016, and Crossroads RMC is excited to sponsor the event! Come see us in Booth 173 to learn about Crossroads MES and Analytics Dashboard solutions for the shop floor, our Services for Baan/LN and BPCS/LX, and see a demo of our latest solution, Analytics Dashboard, which can be connected to any ERP to provide up to the minute sales analysis data.

    
 

If ERP is plumbing for the Enterprise - How do we unplug it and keep it from making a huge mess?

David Dickson 0 38284 Article rating: 5.0

I have been working with ERP in various roles for over 30 years, directly involved in over a hundred implementations, while my company has been involved with over 400 more. Of course, in many ways the systems we use today are completely different from what we used in the ‘80s – back then it was green screens, simple transaction entry forms, and cumbersome updates (at best) to link what one department did with all the other areas that needed access to that information. Then there were those planning programs that took all the information along with various parameters the users needed to set and told us what to do.

The More Things Change, the More They Stay the Same

BPCS/LX TIP OF THE WEEK: GETTING A HANDLE ON DOWNTIME

Anthony Etzel 0 49404 Article rating: No rating

It is essential to capture a reason and duration for each downtime incident to enable the team to effectively prioritize and focus.

Start simple, and make sure every reason is clear (when compared with other reasons) and describes symptoms (as opposed to attempting to diagnose root causes). Remove reasons that aren’t regularly used and add reasons.

 

Baan/LN Tip of the Week: Getting a Handle on Downtime

Kathy Barthelt 0 87479 Article rating: No rating

It is essential to capture a reason and duration for each downtime incident to enable the team to effectively prioritize and focus.

Start simple, and make sure every reason is clear (when compared with other reasons) and describes symptoms (as opposed to attempting to diagnose root causes). Remove reasons that aren’t regularly used and add reasons.

BPCS/LX Tip of the Week: What Should I Consider When Analyzing my Sales?

Anthony Etzel 0 52297 Article rating: No rating

From a recent article published by M4B Marketing:

When analyzing your sales performance consider the following: 

  • Pricing changes eg. price increases or discounting
  • Competitors – competitors entering or exiting the market
  • New product or service launch growing sales
  • New product or service cannibalizing existing product or service sales
  • Customers moving between products or services
  • Changes in customer demand eg. increasing or decreasing
  • The segments and distribution channels you operate in
 

Baan/LN Tip of the Week: What Should I Consider When Analyzing My Sales?

Kathy Barthelt 0 2762513 Article rating: No rating

From a recent article published by M4B Marketing:

When analyzing your sales performance consider the following: 

  • Pricing changes eg. price increases or discounting
  • Competitors – competitors entering or exiting the market
  • New product or service launch growing sales
  • New product or service cannibalizing existing product or service sales
  • Customers moving between products or services
  • Changes in customer demand eg. increasing or decreasing
  • The segments and distribution channels you operate in
First106107108109111113114115Last

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