Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Resources Infor ERP Tips & News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Subscribe to newsletter

Infor LN & Baan Consulting News: So we put our hands up, like the ceiling can’t hold us…

Kathy Barthelt 0 32552 Article rating: 5.0

Crossroads RMC partnered with Hunter Douglas Architectural Ceilings and Walls to upgrade their LN system from LN 10.2 to LN 10.6. This upgrade was undertaken primarily as a result of unsupported hardware/operating system versions at Hunter Douglas. Despite an extremely tight deadline, Crossroads and Hunter Douglas partnered to complete this upgrade from start to finish in under 4 months. Phase 2 is planned to kick off in late Q1 of 2020, which will focus on specific areas of the business for process improvement and the implementation of Avalara’s Avatax software.

Learn about Crossroads RMC's Consulting Services

Read more

Infor LN & Baan Tip of the Week: Customer Defined Fields

Kathy Barthelt 0 82071 Article rating: 4.3

Customer Defined Fields (CDFs) can be added to tables, screens, reports and BODs and validation and calculation logic can be defined around those fields.

Use the CDF concept to store additional data in the standard Infor LN tables. The CDF definitions are stored separately from the table definitions in the Data Dictionary. For the end user, the CDFs behave in the same way as the standard fields, if defaulting, validations, etc. are built using the CDF logic of the table extension point. The session extension point also has features for the CDFs.

CDFs are configured per package combination. This implies that when moving your companies from one package combination to another, the CDF definitions must be present in the target package combination. Otherwise you lose the data in the CDFs.

Read more

Crossroads RMC is proud to introduce our new Production Order Variance Reports package for Infor LN

Kathy Barthelt 0 72285 Article rating: 5.0

The package includes numerous reports and sessions to view the variances in a way that Finance can identify problems based on the Finance Integration Transactions in the General Ledger.

There are a few main sessions with many detailed sessions linked to them. The reports can be run from the main Print Production Order Variance Reports or in the individual detailed session.

Sessions included in the report package:

1. Print Finalized Trans – Variance Reports.

a. Financial Trans. by L/Acct – Prod. Order Variances - Recap

b. Financial Trans. by L/Acct – Prod. Order Variances – Details

2. Update Production Order Variances (updates special variance table).

3. Production Order Variance Overview – Main view

a. Production Order Variance Details

b. Price Variance Details – Material Variances

c. Price Variance Details – Operation Variances

d. Efficiency Variance Details – Material Variances

e. Efficiency Variance Details – Operation Variances

f. Efficiency Variance Details – Reject Variances

g. ACO Variance Details – Reject Variances

h. Accept Production Order Variances

i. Un-accept Production Order Variances

j. Finally Accept Production Order Variances

4. Print Production Order Variance Reports:

a. Production Order Variance – Overview

b. Production Order Price Variance – Material Revaluation

c. Production Order Price Variance – Operation Revaluation

d. Production Order Efficiency Variance – Material

e. Production Order Efficiency Variance – Operation

f. Production Order Efficiency Variance – Rejects

g. Production Order ACO Variance – Rejects-Additional Costs

5. Delete Production Order Variances (used to redo a month)

Contact Kathy Barthelt to learn more.

Read more
Have you missed deadlines or lost a valuable customer due to orders not being shipped on-time? Have you missed deadlines or lost a valuable customer due to orders not being shipped on-time?

Have you missed deadlines or lost a valuable customer due to orders not being shipped on-time?

George Moroses 0 32657 Article rating: 5.0

OTTO helps you consider all of the factors that affect your ability to deliver on-time.
Make plans happen with OTTO.

Request your free 30 day trial today and add value to your current ERP, without altering, changing, or revising the source data. 800.762.2077

Read more

ION News: Crossroads RMC uses the ION process to deliver data to/from LX 8.3.5

George Moroses 0 33324 Article rating: 5.0

Crossroads RMC is currently working with a customer in the food and beverage industry to develop 18 inbound and outbound customized BOD messages using the ION process to deliver data to/from LX 8.3.5.

All of the messages will be using the standard OAGIS (Open Applications Group Integration Specification) BOD Message. The OAGIS is a widely accepted standard within the industry which specifies a standard way of passing data in and out of applications using an XML format. 

Some of the BOD Messages that we will be processing are:

  • Item Master
  • Purchase Order
  • Receipts
  • Accounts Payable Invoices
  • Vendor information
  • Notifications messages

This project kicks off in February 2020 with milestone deliveries throughout the year.

Read more

How Do I Determine If MES Is Right For My Business?

George Moroses 0 36796 Article rating: 5.0

There are certain key questions that must be answered to determine whether or not an MES system would benefit your organization: 

  • How do you analyze OEE?
  • Is there an opportunity to reduce WIP inventory, indirect labor, downtime, waste or scrap?
  • What is the cost and impact of producing and distributing shop paper including drawings and work instructions?
  • Would you like to go paperless on your shop floor?
  • How are your continuous improvement initiatives tied to your ERP?
  • Is Management requesting real time production status reporting via dashboards or drilldown reports?
  • What different “islands of automation” exist on your shop floor?

The answers to each of these questions could have a significant impact on the profitability of your business. Want to quantify your results? Contact George Moroses today to schedule your FREE MES ROI Analysis.

Read more

Consulting News: How comprehensive is the Crossroads RMC ERP business audit & how does it work?

George Moroses 0 43867 Article rating: 5.0

Our Infor LX Practice just finished a Supply Chain and Manufacturing audit for one of our customers. During that engagement, several areas of the business were identified that could benefit from additional training and consulting support. 

Areas of significance were:

  • Purchasing
  • Customer Service
  • Billing
  • Inventory
  • Costing
  • Bills of Materials and Routings
  • Material Requirements Planning
  • Shop Floor Control

Several manual procedures and “tribal knowledge” systems were discovered. The evaluation was done by two consultants who spent time with key users during two onsite visits. The next step in the process will involve working with the client to prioritize the list of items identified and develop a strategic plan focused on growth and efficiency.

Read more

Infor LX & BPCS Tip of the Week: Order processing enhancement – LX 8.4

George Moroses 0 63825 Article rating: 5.0

Restrict Over-shipments to Customers

  • System parameter option controls when over shipments are allowed

Options to:

  • Continue current process with warning message
  • Give error message
  • Automatically correct to quantity available for shipment
     
  • Option to revise the order quantity so that pricing, promotions, credit checking load planning and other processes reflect the actual quantity
  • Allows better control of exceptions for over shipments
  • Ensures that pricing, promotions are correctly based on actual order quantity
Read more
First5455565759616263Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt
/ Categories: Infor LN & Baan Tips, Finance, Operations, Technology, Executive

Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE: Use of Electronic Bank Statements

All actions required for converting, validating, matching, and posting electronically received bank statements can be performed within a single session:

  • Bank Statement Workbench (tfcmg5610m100)
  • Bank Statement (tfcmg5610m000)

Alternatively, you can use the sequence of electronic bank statement sessions outlined below.

Steps to Process Electronic Bank Statements:

  1. Convert Electronic Bank Statements (tfcmg5202m000)
    Convert the received bank file to a format that LN can process. LN stores the converted bank statement files in the directory specified in the Path For EBS Archive field of the Bank Relations (tfcmg0510m000) session. In the Pathname EBS File field, you must add the file name. To add the current date to the file name, append a tilde (~) to the file name.

  2. Validate Bank Statements (tfcmg5202m000 / tfcmg5510m000 / tfcmg5511m000)
    Validate the converted electronic bank statement.

  3. Match Bank Statements (tfcmg5210m000)
    Automatically match as many of the imported statements (status Validated) as possible with open items. LN can match the statements with sales invoices, purchase invoices, and anticipated payment documents.

    Matching Options:

    • Match - Surplus on Aging / Unallocated (Default value)
    • Match - Surplus on Unallocated
    • Match - Surplus to be allocated Manually
    • Allow Underpayments
    • Use Payment Difference Tolerance
       

  4. Matching Results (tfcmg2500m100)
    Review the results of the matching process.

    To handle an unmatched amount, you can:

    • Manually add an unallocated payment or receipt line.
    • Reconcile the surplus with remaining open entries of the business partner.
       

  5. Post Bank Statements (tfcmg5210m100)
    Post the bank transactions to the General Ledger.

    Update the business partner’s bank account number and other details in the Bank Account by Pay-by Business Partner (tccom4115s000) session, based on the details read from the bank statement file.

OPERATIONS: What is Statistical Inventory Control (SIC) and How Does It Work?

Statistical Inventory Control (SIC) is an inventory-controlled order system designed to maintain stock levels based on predefined thresholds, rather than being demand-driven like EP (Enterprise Planning). Since SIC relies on inventory levels, it may lead to higher stock levels. To minimize financial risks, SIC is best suited for:

  • Low-cost items.
  • Items with predictable demand or short lead times.


Applications of SIC

  • Low-Cost Items: Particularly effective for inexpensive goods.
  • Predictable Demand or Short Lead Time: Suitable when demand patterns are stable or lead times are minimal.
  • Warehouse-Specific Planning: Useful for planning by warehouse rather than across the supply chain.
  • Trading Industries: Commonly employed in sectors like supermarkets.
  • Immediate Demands: Effective for items required immediately by customers.
  • Ease of Use: Simple to implement and manage.


Limitations of SIC

  • Does not account for dependent demand from planned orders (e.g., MPS/MRP/INV).
  • Does not generate distribution orders.
  • Ignores time-phased planned orders.
  • Lacks forecast consumption techniques.
  • Uses both nettable and non-nettable warehouses.

How SIC Works

SIC operates based on the Reorder Point, Stock Levels, and Order Method.

Triggering SIC

When Economic Stocks (calculated as On-Hand Inventory + On-Order – Allocated Stocks) on the Horizon Date fall below the Reorder Point, SIC triggers the creation of:

  • Planned Purchase Advice.
  • Planned Production Advice.


Order Methods in SIC

The quantity for these advices is determined by the Order Method, which can be one of the following:

  • Replenish to Maximum Stock
  • Fixed Order Quantity
  • Economic Order Quantity (EOQ)
  • Lot-for-Lot

Example: SIC in a Supermarket

Scenario: Managing stock for Ice Cream (1 Kg Pack)

  • Current Stock: 10 PCs
  • Reorder Point: 5 PCs
  • Safety Stock: 2 PCs
  • Lead Time: 1 Day
  • Order Method: Replenish to Maximum (Maximum Stock: 20 PCs)
  • Maximum Anticipated Consumption: 3 PCs/Day

Process:

  1. Customer purchases reduce the stock.
  2. When stock reaches 5 PCs, SIC is triggered.
  3. A Purchase Advice is generated for 15 PCs to replenish stock to the maximum level (20 PCs).
  4. During the lead time (1 day), the remaining 3 PCs (excluding Safety Stock) meet customer demands.
  5. In emergencies, Safety Stock can also be utilized.

Statistical Inventory Control offers a practical approach for managing inventory levels, particularly in industries with predictable demand or fast-moving items. However, its limitations make it less ideal for complex or time-phased planning scenarios.

TECHNOLOGY: Archiving Data from tipcs300 and ticst300 Tables

1. Archiving tipcs300

  • Using Session tipcs2260m000:
    • When archiving PCS projects, selecting the "Archive Financial data" option ensures that:
      • Records in tipcs300 are archived to the archiving company.
      • Records are deleted from the original company.
    • If records remain in tipcs300:
      • They may belong to projects that have not been archived.
      • The project may have been archived without selecting "Archive Financial data."
    • Verify there are no errors during the archiving process.
  • Using Session tipcs3500m001:
    • The session "Delete Financial Transactions by Project" can delete records from tipcs300.
    • Note: This session is not for archiving; it removes records without copying them to the archiving company.

2. Archiving ticst300

  • Using Session ticst0250m000:
    • The session "Archive Production Orders" allows:
      • Archiving and deleting records from the original company.
      • Only deleting records from the original company.
    • When executed:
      • Records in ticst300 associated with archived orders are removed.
      • Remaining records belong to unarchived orders.

Previous Article Infor LN & Baan Tips & Tricks for TECHNOLOGY: Archiving Data from tipcs300 and ticst300 Tables
Next Article Infor LN & Baan Tips & Tricks: Action Required - Infor LN Cloud Edition - Fonts Update!
Print
58675 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt
Contact author

Contact author

x

Categories