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

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.

Previous Article Infor LX & BPCS Tip of the Week: Reports to Analyze Company Performance
Next Article Infor M3 & Movex Tip of the Week: Views & Sorting Orders
Print
31396 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

Sometimes the best ideas have to be tabled due to competing priorities. That doesn’t mean that the idea was bad. Revisit previously suggested cost savings ideas, or ideas to make a manual process more efficient. Now could be the right time to do something great!

Optimize Your Manufacturing Today!

 

This new feature provides the ability to resolve or reset a purchase order or requisition that is no longer being processed, but the system still indicates it is ‘in use’. We all remember those situations where we could never figure out how the order got hung up.

What we previously had to do was run a behind the scenes script to reset the flag so the order was again accessible. This enhancement provides the ability to resolve the issue and resume processes quickly.

This option is now on the PUR menu, and the user can select the Purchase Order/Requisition in Use Maintenance, PUR940D. The user then enters an order or requisition to remove the “In Use” status.

 

Optimize Your Manufacturing Today!

First9495969799101102103Last

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