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

TECHNOLOGY: Facility Security Ranges

Previously, a user could complete the Cost Transfer (CST920) process for any range of facilities regardless of their security settings established in SYS600. This enhancement verifies the user security settings set up in SYS600 before processing cost transfers for a range of facilities in CST920. If the user has authority for a facility range, but there are facilities within that range that are not authorized, the program skips those facilities and completes the cost transfer process.

FINANCE: Expiration Date for Quotes and RMAs

A Cancel-by-Date has been added to the Quote Header and RMA Header panels. This optional field can limit how long a quote or authorization to return items for credit is valid.  

For quotes, this enhancement provides an optional end date for the quote. For RMAs, it provides an optional date by which the customer must return the items to receive the credit listed on the RMA.

The Cancel-By-Date prints on the Order Acknowledgement and RMA Acknowledgement to inform the customer of this important limitation to the quote or return authorization. 

An Order Entry user cannot copy the quote to create a new order if the Cancel By Date has caused the quote to expire.

OPERATIONS: Default Split Salesperson to Customer Orders

Sales commissions are based on combinations of the Primary, Split, and Line-Level salesperson and the commission codes defined for the customer and item. You can now define the Split Salesperson in the same master files as the Primary Salesperson. While the Primary Salesperson is mandatory, the Split Salesperson is optional. It defaults during Order Create using the identical hierarchy as Primary Salesperson. Using Split Salesperson provides more flexibility in the calculation of sales commissions. The ability to define a default Split Salesperson improves the accuracy of sales commission qualification and calculation and reduces maintenance and adjustments necessitated by corrections.

Previously, a user could complete the Cost Transfer (CST920) process for any range of facilities regardless of their security settings established in SYS600. This enhancement verifies the user security settings set up in SYS600 before processing cost transfers for a range of facilities in CST920. If the user has authority for a facility range, but there are facilities within that range that are not authorized, the program skips those facilities and completes the cost transfer process.

12345678910Last

Theme picker

Tips: LN | Baan

  • Are you tracking downtime? Is it done manually, or with some type of automation or application that gathers information in real-time, or is it based upon history?
  • If you are measuring team effectiveness by shift, you know there are significant differences between them. Have you figured out why?

One of our automotive customers was experiencing significant inefficiencies and difficulties with their receiving operations. After analyzing their operation, we discovered a disconnect between how they were tracking their incoming goods and what their ERP system thought was on hand.

This disconnect created time-consuming steps to process incoming material and determine where the material was needed. The manual process slowed production, caused additional staffing needs and hindered their ability to effectively get needed material to the assembly line. They chose to implement our data collection solution to automate the process.

Since implementing the solution, receiving and moving material was quicker, more accurate and efficient. This enabled the addition of another assembly line, increasing production volume – without adding staff.

Optimize Your Manufacturing Today!

I’m not talking “Modus Operandi,” which is a fancy way to say: “what’s your plan to get stuff done”.  I’m talking about Manufacturing Optimization. 

It is all about efficiency, and by that I mean doing more with less. Less labor, less time, less materials, while still delivering a high quality product on time.

The Three Secrets to Improving your MO

1. Identify the key metrics
You need benchmark data so you know what realistic goals are, then track them and publish your performance along with a brief comment from time to time on how things are trending and how you compare with others, particularly your primary competitors. The best thing about this is that it is a system that develops a life of its own.

2. Measure it
Automatically, people start to think about improving things. Then the fun part, stuff begins to improve by itself. Once in place, the system just hums along and the benefits appear, because it has motivated people to think about it, and figure out what they can do to make it better.

3. Communicate it
So if you publish gross profit numbers, explain to people how what they do affects the numbers. Employees tend to start to modify their behavior as a result, and look more critically at whether a given purchase is even necessary.

First116117118119121123124125Last

Theme picker

Categories