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

BPCS/LX Tip of the Day: Inventory Management

Anthony Etzel 0 73273 Article rating: No rating

Establishing the Quantity On-Hand and the Quantity Available.

LX maintains buckets for information associated with the following inventory transactions for each item:

  • Opening Balance
  • Issues
  • Receipts
  • Adjustments
  • Allocations for the Customer
  • Allocations for Manufacturing


The on hand quantity does not include any allocations. To arrive at the on hand quantity, start with the opening balance, less any issues, plus any receipts, then add or subtract any adjustments. Available inventory is the on-hand less any allocations.

 

 

Read more

Baan/LN Tip of the Day: Chart of Accounts

Kathy Barthelt 0 106375 Article rating: No rating

Zero sublevel accounts are posting level accounts. All others are parent accounts. Once the balances have been updated in the child ledger accounts, the parents are automatically updated.

Inquiries and reports can be printed or displayed either by child accounts or by parent accounts. On line drill-down is possible from either child or parent.

Read more

BPCS/LX Tip of the Day: Cycle Counting Part 2

Anthony Etzel 0 74912 Article rating: No rating

Understanding: The Cycle Count Alternative

The best way to cycle count is to count the same number of items each day and at the same time each day. The goal is to count your “A” items 4 times a year. The “A” items should be those item that are about 80% of the total inventory value and 20% of the total items. Consider creating your own cycle count schedule then instead of using the cycle count transaction, use the inventory adjustment transaction. The item balance is changed at the time the transaction is keyed. The transaction list can be used for the reconciliation process.

Read more

Baan/LN Tip of the Day: Company Calendar

Kathy Barthelt 0 103159 Article rating: 5.0

Baan uses the company calendar in the following modules to determine the start and end dates for planned orders:

  • Master Production Scheduling
  • Material Requirements Planning
  • Capacity Requirements Planning
    (All three combined in a single planning module for Baan V and LN)
  • Shop Floor Control

The calendar provides the valid working days, number of shifts per day and the number of hours in a day.

Baan allows for a single calendar for the whole company or for a calendar for each work center.

Read more

BPCS/LX Tip of the Week: Cycle Counting Part 1

Anthony Etzel 0 81697 Article rating: No rating

Understanding: The Cycle Count Transaction

If you rely on BPCS to provide you with a cycle count list, the number of items could vary from day to day from a few items to count, to several. So the person doing the cycle counting may spend a few minutes to a few hours counting items. After the cycle count is complete, the balances are not changed until the reconciliation is complete. This process could take some time before the balances are changed.

The cycle count transaction process is similar to the physical inventory transaction process.

Read more

Baan/LN Tip of the Week: GRINYA

Kathy Barthelt 0 109109 Article rating: 3.0
GRINYA is one of the more complex issues in ERP Finance. GRINYA is the tracking via ledger account of the value of items received on a purchase order that have not been matched to a supplier invoice.

Baan solutions for Baan IV and V were incomplete. To take full advantage of the current GRINYA reconciliation process, check Infor solution #107147, which contains the GRINYA user manual and a link to download the software for your version of Baan. For ERP LN, look at Document Code U8942C US.

It is called User Guide for Reconciliation and Analysis. If you are not running the latest GRINYA solutions, patching will require a good amount of time in filling the Interim tables this solution runs from. Infor has posted several procedural write ups, so check the Support Site and read up before tackling this for the first time.
Read more

BPCS/LX Tip of the Week: Work Center & Machine Locations

Anthony Etzel 0 81297 Article rating: No rating
For either file, you must specify a valid location code as defined in the Location Master File.

If the machine master locations are blank, then the work center locations are used. There are cases where you may want to do a combination between the two in defining the locations.

Let’s say the end item has one operation. The operation is at work center 510 and Machine A is in the work center. You have locations setup in both the Work center file and the Machine master File. You report 100 complete at the work center without specifying the machine.

In this case, the inventory will be processed based on the locations defined in the work center file. If the transaction included the machine number, then the locations in the machine file would be used.
Read more
First116117118119121123124125Last

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.

Read more
Last

Tips: LN | Baan

Kathy Barthelt
/ Categories: Infor ERP Tips, Infor LN & Baan Tips, Finance

The Best Baan IV | Baan V | Infor LN Financial Reports to Analyze Company Performance

You know what data you need to analyze your company’s financial health, but sometimes it is a struggle to get that data in a format that is meaningful. Here are some reports in Baan IV, Baan V, and Infor LN which you may find useful.

As is the case with most ERP reports, with each version progression from Baan IV, to Baan V, to LN, there are improvements in selection criteria and report content. Some may require some setup and others may require some formatting if you would like to export them to Excel.  Contact me if you have questions or need assistance.

BAAN & LN FINANCE:

Baan IV –

Customer Statistics Module

  • Print Customer Statistics by Customer/Credit Analyst (tfcmg3400m000)
    • Prints Average Days Payment, Amount Paid, Average Days Outstanding, Amount Open, Discounts Allowed and Discounts Taken.  
       
  • Print Average Days Outstanding (tfcmg3401m000)
    • Prints Open Amount and Average Days Outstanding.
  • Print Average Receipt Days (tfcmg3402m000)
    • Prints Amount Paid and Average Number of Days for a Payment.


Cash Forecasting Module

  • Print Cash Forecast Summary by Period/Currency (tfcmg3410m000)
    • Prints Total Cash coming in from Sales Invoices, Sales Orders, Sales Quotes, Project Orders, and Budgets. Prints Total Cash going out from Purchase Invoices, Purchase Orders, Standing Orders, and Budgets.
       
  • Print Cash Forecast Summary by Date/Currency (tfcmg3411m000)
    • Prints the same as above but by a specific date.
       
  • Print Cash Forecast Details by Period/Currency (tfcmg3412m000)
    • Prints the same as above but by each period across in columns.
       
  • Prints Detailed Cash Forecast in Home Currency (tfcmg3413m000)
    • Prints each item, purchase order, sales order, etc, with forecast in home currency.


Baan V –

  • Print Finalized Transactions Ledger Account – tfgld1406m000
    • Output can be run to show transactions (debit/credit) by ledger account, transaction type, and time periods. This can be run by range of ledger account and/or range of periods.
  • Print Integration Transactions -tfgld4410m000
    • This has 3 options: a short version of the report, a standard version, and a version by company/ledger account.

Infor LN -

  • Print Finalized Transactions Ledger Account – tfgld1406m000
    • Output can be run to show transactions (debit/credit) by ledger account, transaction type, and time periods. This can be run by range of ledger account and/or range of periods.
  • Print Integration Transactions by Business Flow – tfgld4482m100
    • Output can be run to show all transactions (debit/credit) by business object (production/purchasing/sales)

Previous Article How well does your ERP Serve your Manufacturing team?
Next Article The Best Baan | Infor LN Manufacturing Reports to Analyze Company Performance
Print
62131 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt
Contact author

Contact author

x

Categories