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 | Infor LN Manufacturing Reports to Analyze Company Performance

You know what ERP data you need to analyze your company’s production health, but sometimes it is a struggle to get that data in a format that is meaningful. Here are some reports in Baan & Infor LN which you may find useful.

As is the case with most ERP reports, with each version progression from the earliest versions of Baan to the latest version of Infor 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 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 The Best BPCS | Infor LX Manufacturing Reports to Analyze Company Performance
Next Article Infor LX & BPCS Tip of the Week: Reports to Analyze Company Performance
Print
28986 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

If it is necessary to pause sending and receiving of BOD messages on your IBM i during your month end process, it is best practice for the document flows that point to the IBM i to guarantee delivery of BOD messages. Once the month end process has been completed, you will need to Resume the ‘Receiving’ and ‘Sending’ Active Connection Points so your documents will continue to process.

Pausing Sending messages

To pause sending messages to ION:

  1. Select Connect > Active Connection Points.
  2. Select the connection point that must be paused for sending messages.
  3. In the Sending Paused column, click Pause. The page is automatically refreshed and the Sending Paused checkbox is selected. A Resume button becomes available. 

Sending of messages by this connection point is stopped....

The database in LX 8.4 has undergone a significant change from previous versions. The database has been created using SQL DDL language instead of the old DDS language. The newer format allows for LX to take better advantage of advances in IBM database technologies as they move forward. Additionally, LX will be better able to make changes to tables (aka files) in the future without causing very large MR explosions to replace all programs that use a specific table. To ease the impact of this significant change, the LX tables (aka physical files) have new names that are the same as the previous version file names but with a “P” at the end, for example IIM is now IIMP. The old file names now belong to SQL views that looks just like the tables. This change made it easier to upgrade all the LX programs without changing every reference to every file. Many of the logical files remain although some have been replaced by SQL indexes to improve performance.

First6061626365676869Last

Theme picker

Tips: LN | Baan

Table Timestamp Definitions (ttadv4136m000)

Use this session to define timestamps for Infor LN tables. A timestamp is an additional column that stores the date and time of the last change for each record.

Timestamps are utilized by features like the extraction logic of CPM Enterprise Analytics. They enable CPM to perform incremental data extractions. For example, CPM can use the timestamps to extract records that were changed during the last week in a weekly extraction process.

To Create Timestamps...

Operations: To absorb the cost of cost items into specific projects, you'll need to handle them as customized items. However, cost items cannot directly be defined as customized items. Customized items must be physical, either manufactured or purchased.

That said, it's still possible to absorb cost items into a project, although indirectly. Here's how:

  1. Set Up Ledger Account: First, create a new ledger account in session tfgld0508m000 and set the type to "PCS" (project) in the operations management integrations. This account will be used for matching and approving purchase orders for cost items.

  2. Create and Activate Projects: Ensure that the necessary projects are created and set to active status.

  3. Purchasing Cost Items...

12345678910Last

Theme picker

Categories