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

Baan/LN Tip of the Week: Optionally Include Tax Amounts In Order Balance

Kathy Barthelt 0 94597 Article rating: No rating

In Baan IV, the order balance amount always includes the tax amount. Consequently, the tax amount must be recalculated every time an order line is modified in order to update the balance correctly. If the tax provider is activated, this requires an API call for every re-calculation of tax.

 

In Infor LN, users can select or clear the new Include Tax in Order Balance check box in the COM Parameters (tccom0000s000) session to indicate whether users want to include tax amounts in the order balance amount. This parameter has an effect on various sessions in Order Management.

BPCS/LX Tip of the Week: Product Routing

Anthony Etzel 0 68396 Article rating: No rating

Defining the Product Routing first requires the items to be setup in the Item Master file. Other master files also need to be defined prior to creating the routing.
These include:

  • The Facility defined with a SYS program
  • The Warehouses defined with an INV program
  • Locations defined with an INV program
  • The Machines (required if using capacity planning or an MES interface) defined with an MDM program

After the above data is set up, the Department file and Work Center files can be setup in MDM. Now you are ready to define a product route.

Baan/LN Tip of the Week: Month End – Miscellaneous To-Do’s

Kathy Barthelt 0 97273 Article rating: No rating
  • Print Sales Order History Information
    • all invoices processed through sales
  • Check Inventory Valuation
    • this should tie out to your inventory accounts
  • Print Integration Information
    • see all postings from WIP to finished goods
  • Print G/L Transaction Information
    • print specific transaction types for any GL account
  • Print Lot Control Information
    • will show where serial numbers were used

BPCS/LX Tip of the Week: What is Lean Make to Order?

Anthony Etzel 0 74791 Article rating: No rating

This is a simple way to go from the customer order to making the order and shipping the order. It involves a few simple steps:

  1. Receive and enter the customer order
  2. Automatic credit review
  3. Automatic release of the shop order tied to the customer order
  4. Issue material, report labor to the production order receipt
  5. Pick the order, ship the order, invoice the customer

 

With lean, you can skip processing the demand through MRP. You can go directly from the customer order to the shop order creation.

Baan/LN Tip of the Week: Optionally Include Tax Amounts In Order Balance

Kathy Barthelt 0 167997 Article rating: No rating

In Baan IV, the order balance amount always includes the tax amount. Consequently, the tax amount must be recalculated every time an order line is modified in order to update the balance correctly. If the tax provider is activated, this requires an API call for every re-calculation of tax.

In Infor LN, users can select or clear the new Include Tax in Order Balance check box in the COM Parameters (tccom0000s000) session to indicate whether users want to include tax amounts in the order balance amount. This parameter has an effect on various sessions in Order Management.

BPCS/LX Tip of the Week: Top Down Shop Order Schedule

Anthony Etzel 0 74861 Article rating: No rating

In ERP LX, this function is called Backward Scheduling. This is a simple, easy way to create and release shop orders associated with the end item.

The result is a shop calendar with the associated order start dates. Setting up ERP LX properly with correct Queue Times, Setup and Run Times, along with Move Times, will result in accurate shop order start dates.

Baan/LN Tip of the Week: Back Dating Cycling Counting Orders

Kathy Barthelt 0 102445 Article rating: No rating

Cycle Count Orders cannot be directly “back dated” in Baan IV, Baan V or LN, however, there are some work-arounds.

In Baan IV you can do an inventory adjustment and back date. Just set all dates on the adjustment to the date you want and Baan will post the adjustment in that period.

In LN you can do a Cycle Count/ Adjustment and again back date and Baan will post to that period.

 

Unfortunately, there is no work-around for Baan V.

First115116117118120122123124Last

Tips:  LX | BPCS | M3

Improves control over PO costing changes during invoice entry by replacing passive warnings with an intentional override action.

  • In ACP500D3 (Invoice Entry PO Costing), users previously could unintentionally accept changes by pressing ENTER, even when quantity to cost or amount to cost values had changed.

  • A new “F14 to Override” warning message replaces the old message:
    “Details have changed. Press enter again to accept data.”
    This ensures users acknowledge and confirm significant changes explicitly.

New System Parameter:

  • “Apply GRN Costing Tolerance for PO Costing” (optional):

    • Within tolerance: Displays the original message —
      “Details have changed. Press enter again to accept data.”

    • Outside tolerance: Triggers the new override requirement —
      “F14 to Override”

Benefits:

  • Enhances oversight and reduces unintentional cost acceptance.

  • Enables better control of PO costs when invoice details differ from expectations.

Last

Tips: LN | Baan

Kathy Barthelt

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


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
20016 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories