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

Kathy Barthelt

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 The Best BPCS | Infor LX Financial Reports to Analyze Company Performance
Next Article Manufacturing: How much time are you wasting on manual processes?
Print
23216 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

Did you know that you can set up one-time vendors in LX? One Time Vendor (1,A): Specify Y to indicate that this vendor is a one-time vendor. Otherwise, could you specify N. The system removes a one-time vendor's information from the Vendor Master file after all transactions are reconciled. If this vendor already exists as a one-time vendor, you can specify N to change the vendor to a regular vendor.

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

1345678910Last

Theme picker

Tips: LN | Baan

A serialized item is a physical occurrence of a standard item that is given a unique lifetime serial number. This enables tracking of the individual item throughout its lifetime, for example, through the design, production, testing, installation, and maintenance phases. A serialized item can consist of other serialized components.

In Service, a serialized item can be a customer-specific or owner-specific installation. Installation groups are a group of installations/serialized items such as photocopiers, computers, air conditioners, forklifts, lathe machines, and even aircraft.

A serialized item is identified by both the item code and serial number. You can set up the mask used to generate the serial numbers so the serial number includes some fields of the item data, such as the item group and the manufacturer.

In a multi-company structure, the companies can share the serialized item data. All the service departments in the various companies can refer to the same serialized items.

The serialized item can originate from a sales order or a project. The details of a serialized item indicate their origin, for example, by using specific sets of serial numbers for items that originate from sales orders and from projects. Serialized items can also originate from an as-built structure or directly from the production bill of material in Manufacturing.

In Service...

Are you striving to create shipping labels that cater to all your customers' needs? Do you require specific details on your shipping labels for particular items or product lines?

According to recent research, the global barcode label printer market was valued at $2.6 billion in 2022 and is estimated to reach $4.3 billion by 2032, exhibiting a CAGR of 5.2% from 2023 to 2032.

Crossroads RMC's RMClabel software automates the printing of customer-specific and item-specific labels...

1345678910Last

Theme picker

Categories