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 Tip of the Week: Job Groups in LN

Kathy Barthelt 0 37883 Article rating: 5.0

In a scenario where performing job A depends on the result of job B, it is hard to decide at what time job A must be scheduled, and how long job B runs. To handle dependent jobs, you can now create a job group. Use the Job Groups (ttaad5140m000) session to create a job group. A job group has a name, with the same characteristics as a job name, and a description. The Status and User of the job group are handled automatically.

After creating the job group, the jobs are added to the group, approximately in the order the jobs must be performed. The first job in the group (with the lowest Group Number) determines the handling of the whole job group, such as execution date and whether the job group is being repeated. If the job group is not repeating, the job group and all non-repeating jobs in the job group are deleted when the job group has run.

The dependencies of the jobs in the job group are also determined. A job in the job group can only depend on a job in the same job group with a lower job number.

You can use the specific options in the Job Groups (ttaad5140m000 andttams5640m000) sessions to change the status of the job group. The job group statuses have the same meaning as the status of the jobs and the same status changes are allowed.

Note: Job groups are only handled by the BSE service Job Scheduler Service.

Read more

A/P Payment Update in LX 8.3.4

Anthony Etzel 0 33138 Article rating: 5.0

A/P Payment Update in LX 8.3.4. ACP660B creates a file using a layout required by the bank; the file informs the bank to pay invoices. These conditions must be met to create the file:

  • FIM is an installed product in SYS821  ­
  • The user is authorized to FIM in SYS600 ­
  • The company is active in FIMCOMIT in SYS105  ­
  • The payment type is in BONPAYTP (SYS105)
Read more

Infor LX & BPCS Tip of the Week: LX 8.4 Database

Anthony Etzel 0 30000 Article rating: 5.0

The database in LX 8.4 has undergone a significant change from previous versions. The database has been created using SQL DDL language instead of the old DDS language. The newer format allows for LX to take better advantage of advances in IBM database technologies as they move forward. Additionally, LX will be better able to make changes to tables (aka files) in the future without causing very large MR explosions to replace all programs that use a specific table. To ease the impact of this significant change, the LX tables (aka physical files) have new names that are the same as the previous version file names but with a “P” at the end, for example IIM is now IIMP. The old file names now belong to SQL views that looks just like the tables. This change made it easier to upgrade all the LX programs without changing every reference to every file. Many of the logical files remain although some have been replaced by SQL indexes to improve performance.

Read more

Crossroads RMC is Proud to Announce Product Certification for Baan IV to Avalara!

Kathy Barthelt 0 31811 Article rating: 5.0

Crossroads RMC is pleased to announce that our Baan IV integration to AvaTax has officially been certified by Avalara! This means that all Baan IV, Baan V and Infor LN customers now have an automated solution for sales and use tax!

AvaTax provides sales and use tax calculations in real time including rate determination, returning filing, remittance and exemption certificate management. 


Want to learn more? Please contact Kathy Barthelt for more details
Read more

1st Infor LN 10.7 Implementation for Crossroads RMC!

Kathy Barthelt 0 23359 Article rating: 5.0

We are proud to announce our first Infor LN 10.7 implementation in partnership with Infor Consulting Services for LOOP, Inc. (Louisiana Offshore Oil Port Services). As part of this project, Crossroads RMC will be providing Finance and Data Migration as well as Infor OS / Ming.le consulting services.

Learn More about Crossroads RMC Consulting Services and our knowledgeable Consultants!

Read more

Infor LN & Baan Tip of the Week: Credit Checks for Business Partners

Kathy Barthelt 0 36328 Article rating: 5.0

Did you know that you have several options for credit checks for your business partners?

Action-several options are available:

  • Always Hold (Credit)—the order will always be held until released
  • Never Hold (Credit)-the order will never be held
  • Check Credit—a credit check is performed at time of sales order entry, release to invoicing or at confirm shipment.  When this status is used, the check can be performed at one or all three steps.  The steps are only visible with this status.
  • Always Hold (Overdue Invoices)—the order will be held for overdue invoices until released.

Link the credit rating to the invoice to a business partner in the credit control session. You may also enter a credit limit. A credit limit of zero means unlimited credit.

Read more

The Security Model in IDF

Anthony Etzel 0 25918 Article rating: 5.0

By applying security to an object, you can control which users can view the object and which users can create, change, delete or copy the object.

Basic object security allows you to control who can display or maintain an object. Advanced object security allows you to control selectively who can create, change, delete, or copy an object.

In the basic model, all of the maintenance activities are permitted to those users who are authorized to maintain the object. Use the basic security model if you want a user who can change an object to also be able to create or delete the object. Use the advanced security model if you need to restrict some users to changing the object but not creating or deleting the object.

Read more
RSS
First5455565759616263Last

Theme picker

Tips:  LX | BPCS | M3

Role-Based Security introduces Role type profiles and allows combining the use of Role profiles with the traditional LX User type security profile functionality. The new Role type profile can be defined to allow or deny access to All Products, Attention Key, Products, Programs, and Transaction Effects. Facility, Warehouse, and Company securities are still defined solely by the User profile settings and are not affected by the assignment of a Role. Where applicable, the Role authority is displayed alongside the User authority on the security profile maintenance screens making it easy to see where there are differences in authority between the User and the assigned Roles. 

When Users are assigned to Roles, security access in LX becomes a combination of authorities granted or denied by the Role, plus any User Exceptions. User Exceptions override authorities set by the Roles. A User can also be assigned to more than one Role.

Read more
12345678910Last

Theme picker

Tips: LN | Baan

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

Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE: Can accounts receivable invoices be uploaded into LN using Excel?
Yes, this is possible, by following the steps below:

1. Maintain a batch

2. Maintain an invoice header, export 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.


OPERATIONS: MPS Planned vs. MRP Planned
When deciding what items should be MPS (Master Production Schedule) planned and what items should be MRP (Material Requirements Planning) planned, it's crucial to understand the nature of the items and their demand sources. Here's a breakdown:

  • Master Scheduled Items:

    • Master Scheduled Items are typically finished goods or service items.
    • These items receive their requirements from both Independent and Dependent demand sources.
       

  • Independent Demand:

    • Independent demand cannot be calculated from higher-level demand in the product structure.
    • It is driven by forecasts or actual customer orders, primarily applicable to Finished Goods or Service parts sold to customers.
       

  • Dependent Demand:

    • Dependent demand is derived from higher-level demand in the product structure.
    • It includes components, raw materials, and sub-assemblies.
    • Dependent demand items are not typically part of Master Production Scheduling (MPS).
       

  • Service Parts:

    • Service parts can have both independent demand from forecasts or customer orders and dependent demand from higher-level demand if they are used in sub-assemblies or other products.
       

  • Cumulative Lead Time:

    • Cumulative Lead Time is a concept used in MPS.
    • It combines the fixed lead time and variable lead time required to produce a product.
    • It represents the longest path through a Bill-of-Materials (BOM).
    • Your ERP system will calculate the cumulative lead time (Critical Path) based on MPS setup options.
       

  • Infor LN Approach:

    • Infor LN does not differentiate between MPS and MRP planning.
    • It uses Enterprise Planning (EP) with one set of planned orders.
    • While you can set up items and generate orders at plan levels, it's not always necessary.
    • In theory, you could treat plan level 1 similar to MPS items.
       

  • Defining Independent Demand in LN:

    • In LN terms, independent demand is demand not related to other planned items.
    • Dependent demand comes from related planned items higher up in the BOM structure.
       

  • COLT (Cumulative Order Lead Time):

    • COLT exists in the purchase and manufactured planned items.
    • It considers non-critical and critical lead times based on components marked as critical.
    • Once calculated, COLT can be used to update the order and planning horizons of a planned item.

Relevant Sessions:

In Baan IV:

  • Maintain Item Data (tiitm0101m000)
  • Generate MPS (timps3201m000)
  • Maintain Master Production Schedule (timps3101m000)
  • Display Planned Inventory Movements by Item (timrp1510m000)
  • Display Planned MRP Purchase Orders (timrp1521m000)

In Baan V:

  • Plan Item Data (cprpd1500m000)
  • Item Master Plan (cprmp2101m000)
  • Time-Phased Overview (cprrp0520m000)

In Infor LN:

  • Item – Planning (cprpd1100m000)
  • Item Master Plan (cprmp2101m000) - Same as Master MPS if used


TECHNOLOGY: Are you running the latest Infor components?
Always good to stay on top of new releases for your various Infor components. Here is a list of knowledge base articles that you can check for the components listed below:

For the last Infor LN, Infor Baan5, and Infor Baan4 porting set see KB 22923520

For the last BaanIVc 6.1c porting set see KB 22923521  No fixes are made based on the 6.1c porting set.

For the last Worktop set see KB 22881488 For the last BW set see KB 22881483 For the last EME set see KB 22866552 For the last Office integration set see KB 22867312 For the last Dynamic Form Editor see KB 22881485

For more information and assistance, you can contact Crossroads RMC at 800.762.2077 or via email at solutions@crossroadsrmc.com.

Previous Article Infor LN & Baan OPERATIONS Tip: MPS Planned vs. MRP Planned
Next Article Infor LN & Baan Tip & Tricks for TECHNOLOGY: Infor LN Rest API
Print
4395 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt
Contact author

Theme picker

Contact author

x

Categories