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 3471 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 3506 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 3898 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 3871 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 6404 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

Kathy Barthelt
/ Categories: Infor LN & Baan Tips

Infor LN & Baan Tip: Cost Component Setup

To break down an item’s standard cost, sales price, or valuation price, use cost components. With cost components, you can compare estimated and actual costs, calculate production variances, and analyze costs in Standard Cost Calculation.

If cost components are set up in a detailed way, detailed records exist in the Item - Calculated Valuation Prices (ticpr2540m000) session and the Item - Standard Valuation Prices (ticpr3540m000) session. Additional financial integration transactions are created because integration transactions are logged by cost component. A detailed cost component setup also causes additional cost details in domains such as Sales and Warehousing. This increases database growth and makes performance worse, especially during production completion and the item receipt process.

Reduce the number of cost components in the effective cost component structure, which is displayed in the Effective Cost Component Structure (ticpr0112m000) session, as much as possible. The minimum number is three aggregated cost components: one for material, one for operation, and one for surcharges. From a performance point of view, the following is advised:

Reduce the number of cost components

  • One operation cost component for all operation rates.
  • One cost component for all subcontracting rates.
  • One cost component for item and warehouse surcharges.
  • One cost component for actual labor rates (in People). Ensure you only use cost components that are required.

Use aggregated cost components
The standard cost is calculated by (detailed) cost component for a multilevel BOM. A similar calculation of valuation prices (actual prices) would result in a price structure with many cost components, especially for manufactured items. In case of a warehouse transfer, issue to WIP, and so on, postings are made for every cost component. However, this detailed cost information does not add functional value in Warehousing. If you aggregate cost components, the number of cost components in financial transactions is reduced. Therefore, aggregate operation cost, material cost, and surcharges to the three cost components that are defined in the Item - Costing (ticpr0107m000) session

If you do not enter a Standard Cost Component Scheme in the Item - Costing (ticpr0107m000) session, production order costs, production order variances, and surcharges are posted by aggregated cost component. This improves performance and decreases database growth.

Previous Article Infor LN & Baan Tip: Project Status Options
Next Article Infor ERP Tip: Top 5 Ways Modern Analytics Reduces Spreadsheet Risk & Inefficiency
Print
12632 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Theme picker

Contact author

x

Categories