Infor LN & Baan Tip of the Week: Reports to Analyze Company Performance

You know what data you need to analyze your company’s financial and production health, but sometimes it's 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)

BAAN & LN MANUFACTURING:

Baan IV

• Print Actual Cost by Production Order ticst0401m000
  • This report can be run at any time in the production order’s life to show how hours-spent and material-used compare between estimated and actual usage.
     
• Print Work Center Utilization By Week tiscf1402m000
  • This report shows capacity issues at work centers/machines which help identify production bottlenecks.

Baan V

• Print Estimated vs Actual Material Costs ticst0401m000
  • This report can be run at any time in the production order’s life to show how actual material-used compares to estimated usage.
     
• Print Estimated vs Actual Hour Costs ticst0402m000
  • This report can be run at any time in the production order’s life to show how actual hours-spent compares estimated hours.
     
• Print Work Center Utilization By Week tiscf1402m000
  • This report shows capacity issues at work centers/machines which help identify production bottlenecks.

Infor LN

• Print Estimated vs Actual Material Costs ticst0401m000
  • This report can be run at any time in the production order’s life to show how actual material-used compares to estimated usage.
     
• Print Estimated vs Actual Hour Costs ticst0402m000
  • This report can be run at any time in the production order’s life to show how actual hours-spent compares estimated hours.
     
• Utilization report from– Print Resource Order Plan cprrp0430m000
  • This report from Enterprise Planning will show all orders from planning and production. By incorporating both order types, capacity issues can be seen short range where planning has determined that new orders are needed, as well as long range where planners may find opportunities to shift work or even to plan machine maintenance.

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author Facebook page Twitter Linked In YouTube Website