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

This enhancement simplifies access to LX programs that are available through System i Manager (SiM), as well as Workflow for System I (WFi). This provides an easy way to promote common WFi business processes from one LX environment (for example, test or environment) to another LX environment (for example, production). 

LX also provides a set of four-character task codes that can be used within SiM, System i Workspace (SiW), and WFi, for default programs in LX. These predefined LX task codes begin with 0,1,2,3, or 4. Users can specify task codes for their custom programs that are flagged as valid menu options in LX, but these task codes cannot begin with 0,1,2,3, or 4. Users can specify the task codes in Infor LX Object Master Maintenance, SYS625D. This enhancement provides simplified access to LX programs that are flagged as valid menu options in System i Manager and Workflow for System i environments. In SYS625D, The user can also specify task codes in SYS625D for customized programs that are flagged as valid menu options.

Users are no longer limited to backing up or saving files to a tape or diskette.They can now use a Save File (SAVF) to save data and objects. LX programs that perform saves and/or backups were modernized to add a new SAVF option.  

There were numerous places in LX where users are prompted to save a file or library. These screens have options for tape or diskette. Diskette refers to the old 8” diskettes used on System/38. These devices are outdated and virtually obsolete. The current means of saving objects on the IBM i, is through the use of a Save File (SAVF). This compresses the data into a single object that can be saved and is easily transferred between systems.

These objects were modified and/or created for this enhancement:

  • Backup Simulation (FOR630C, FOR630D, FOR630FM, FOR640HT, and FOR630HT)
  • Month End Close (INV903D, INV903FM, INV901C, and INV903HT)
  • Purge YTH/Restore Archived Lots (INV912C, INV912D, INV912DHT, and INV912FM)
  • Purge and Save ITH records (INV932C, INV932D, INV932FM, and INV932HT)
  • Labor Ticket Save (SFC905D, SFC905FM, SFC901C, and SFC905HT)
  • Backup Infor LX Files (SYS700C, SYS700D, SYS700FM, and SYS700HT)
  • Backup Infor LX Programs (SYS710C, SYS710D, SYS710FM, and SYS710HT)
  • Backup Infor LX Source (SYS740C, SYS740D, SYS740FM, and SYS740HT)
  • Save File Name Selection (SYS912D, SYS912FM, and SYS912HT)


Benefit

Use the Backup Simulation to copy a simulation file to a SAVF or tape. Users may want to do this to transfer simulation data from one system to another, from site to site, or to save the data before permanently deleting it from the system.

First6970717274767778Last

Theme picker

Tips: LN | Baan

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:

12345678910Last

Theme picker

Categories