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

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

Kathy Barthelt 0 3194 Article rating: 5.0

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...

6 Ways Disconnected Data is Harming Your Business

Yikes!

Crossroads RMC 0 3118 Article rating: 5.0

Disconnected data – What is it?

no​ The spreadsheet that your warehouse manager has off to the side to track his inventory levels and expected shipments from your key suppliers.

no The email orders from your dealer portal waiting to be manually keyed into your ERP. 

Disconnected data is a set of information stored separately from the main system that is used to run your business (your ERP system). The data is valuable and lack of visibility to that data creates problems throughout the organization. Far more than you realize.

A 2023 study by enterprise automation provider Snaplogic and Vanson Bourne researchers showed the following:

Avoid Being a Quitter: How Crossroads RMC Can Help You Achieve Your Goals

Unlocking Success Infor LX/BPCS & Infor LN and Baan

Crossroads RMC 0 3550 Article rating: .2

Avoid Being a Quitter

As the calendar flips to January 1st, it marks the beginning of a new year filled with fresh opportunities and resolutions. It's that time when many of us set ambitious goals for ourselves, both personally and professionally. But, how often do these aspirations fizzle out before we even hit the second Friday of the year? It's so common that they even call it "Quitter's Day." However, it's not too late to stay on track and realize your ambitions. In this article, we'll focus on the professional side of goal-setting and how Crossroads RMC can be your ally in achieving manufacturing excellence.

Step 1: Make Your Goals Bite-Sized

Infor LX & BPCS Tip: System i Workspace AnyWhere information and Important Support Dates for IBM and Microsoft Products

George Moroses 0 3574 Article rating: 2.5

System i Workspace AnyWhere is a web application framework that provides a common user interface for Infor’s IBM i products.

*** We strongly recommend that you subscribe to this KB to receive automatic notification when it is updated ***

Latest Updates
System i Workspace AnyWhere - Feature Pack 22 is now available - see the Update History section below (as of January 4, 2024)

Infor LX / BPCS & Infor LN / Baan Tip: Time for the Notorious TRIO: Manual -  Physical -  Inventory

Crossroads RMC 0 5793 Article rating: 2.5

While it might be accurate (and I emphasize "might"), is a Manual Physical Inventory the optimal approach? Best practices unequivocally say otherwise!

A superior alternative is the adoption of Cycle Counting. Why choose Cycle Counting over a complete physical inventory? This method zeroes in on a selected stock range, allowing concurrent execution with a company's regular operations. Cycle Counts offers a streamlined approach to inventory management, minimizing disruptions to processes related to stock receipt, consumption, or dispatch.

The dreaded "freeze" is no longer a necessity, sparing your staff from extended holiday hours, and ensuring accurate inventory counts throughout the year! Crossroads RMC is poised to assist you in implementing Cycle Counting efficiently and effortlessly.

Contact us today to kickstart this transformative process at 800.762.2077.

RSS
135678910Last

Theme picker

Tips:  LX | BPCS | M3

Determining whether to use Master Production Schedule (MPS) planning or Material Requirements Planning (MRP) planning for items in Infor LX and BPCS involves understanding the nature of the items and their demand characteristics.

Master Scheduled Items typically encompass finished goods or service items. These items receive their requirements either from Independent demand, Dependent demand, or a combination of both...

Advanced Remittance Processing, ARP, provides an automated approach to your cash application process. ARP works together with Accounts Receivable to save valuable time and resources by automatically applying incoming payments to open receivables during daily batch processing. You can easily and efficiently resolve unapplied remittances online.

Advanced Remittance Processing (ARP) is an automatic cash application process that allows you to perform the following functions:

135678910Last

Theme picker

Tips: LN | Baan

Infor LN & Baan Period End & Fiscal Year End Processing Checklist

Year-end is always a busy time and it is easy to forget things that must be done in your ERP system to close out the year properly and also set you up for a good start to the following year. Here are some things that you should make sure to add to your to-do checklist:

The year-end close process provides an opportunity to:

_____ Remove discontinued items.

_____ Remove sold purchase receipts.

_____ Remove lot attributes for sold lots.

_____ Update standard cost based on current cost field (for environments without Manufacturing only).

Prepare for Year-End Close

_____ Conduct full physical inventory and update quantities before actual year-end or establish a strong cycle-counting program.

_____ Check for any applicable sales and purchase invoices/returns and post.

_____ Prepare users for a year-end push to complete all year-to-date inventory adjustments, receipts, and invoicing.

_____ Determine how to handle new year transactions without posting.

_____ Determine what new standard costs should be entered for the upcoming year. (Manufacturing)

_____ Discuss cutoff dates for removing Archived BOMS and Closed/Canceled Mfg Orders. (Manufacturing)

Finance Specific Items:

_____ Set up the financial periods for 2022 (fiscal, reporting, and tax, as applicable).

_____ Open period January in 2022.

_____ Finalize any outstanding transactions from the current year (2021).

_____ Soft-close any open periods in 2021.

General Baan/LN Tips:

_____ Issue any old sales invoices.

_____ Fix any outstanding financial integration errors.

_____ Set up new integration mapping for 2022 as needed.

_____ Test the mapping in a test environment prior to the new year.

_____ Review & update jobs as needed to ensure they will process in 2022.

_____ Determine for cash-flow purposes, what purchase invoices won’t be paid until 2022.

_____ Make sure that calendars are set up for the new year with holidays properly indicated.

_____ Check jobs to make sure any that are hard-coded with dates will point at the new year.


Want even more tips for year-end processing? See the following documents in the Infor Knowledge Base:

 KB 

 Content 

 1879191  

 Document including step by step procedure, possible error/warning messages, and more (Infor LN) 

 1147023 

 Step by step procedure description (Infor LN)

 1116239 

 Step by step procedure description (Infor LN)

 1117334

 Step by step procedure description (Infor LN; Portuguese)

 1171300 

 Step by step procedure description (Baan IV) 

Need help? Contact us and we’ll be happy to walk you through what needs to be done to ensure that everything is done correctly and completely. 1.800.762.2077 or solutions@crossroadsrmc.com

Previous Article Infor LN & Baan Tip: Using the “Use Up” Functionality in Infor LN
Next Article Infor LN & Baan | Infor LX & BPCS Tip: Time for the dreaded three words?
Print
15171 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Theme picker

Contact author

x

Categories