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 LX & BPCS Tip of the Week: Reports to Analyze Company Performance

You know what ERP 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 BPCS & Infor LX which you may find useful.

As is the case with most ERP reports, with each version progression from the earliest versions of BPCS to the latest version of Infor LX, 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.

BPCS & LX FINANCE REPORTS:

BPCS:

  • GLD240 - General Ledger - Trial Balance
    • This report allows you to produce a menu-driven Trial Balance that shows Opening and Closing balances, and Activity, for any range of Profit Centers and accounts in the GL Master. 
  • GLD250 - Journal Entry Audit Report
    • This report answers the Audit need. It provides Journal detail for selected Journal Sources and includes Reference fields that tie GL transactions to the Subsystem source. 

Infor LX

  • CLD220 - General Ledger - Trial Balance
    • This report allows you to produce a menu-driven Trial Balance that shows Opening and Closing balances, and Activity, for any account range from a customized Chart of Accounts. Year and Period selectivity, along with Journal Source choices, allow for as focused a view of an organization's GL activity as an accounting department needs. 
  • CLD285 - CEA Audit Report
    • This report answers the Audit need. It provides Journal detail for all Account Strings selected and includes Reference fields that tie GL transactions to the Subsystem source.


BPCS & LX MANUFACTURING REPORTS:

BPCS / Infor LX:

  • CST270 – Shop Order Cost Variance & WIP Report
    • This is by far the best total picture of what happened on any Shop Order from several perspectives (cost/efficiency/overall performance).
       
  • INV220 – Stock Status Summary & INV210 – Turnover Analysis
    • ​Both of these reports give you a view of how your inventory is moving to use as a measurement of the Planning Settings and which items need closer review.
Previous Article The Best Baan | Infor LN Manufacturing Reports to Analyze Company Performance
Next Article Infor LN & Baan Tip of the Week: Reports to Analyze Company Performance
Print
34920 Rate this article:
5.0

Contact

George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

Tips: LN | Baan

Use this session to define simulated purchase prices for purchased items per site.

Field Information:

  • Cost Calculation Code - price calculation code
  • Item

The raw materials, subassemblies, finished products, and tools that can be purchased, stored, manufactured, and sold.

An item can also represent a set of items handled as one kit, or which exist in multiple product variants.

You can also define nonphysical items, which are not retained in inventory but can be used to post costs or to invoice services to customers. The examples of nonphysical items:

  • Cost items (for example, electricity)
  • Service items
  • Subcontracting services
  • List items (menus/options)
     
  • ​Site - The site for which the purchase price is simulated.
  • Purchase Currency - The currency of the simulated purchase price.
  • Simulated Price - Purchase price

The simulated purchase price and currency are recorded twice.

  • Simulated Price Multi Currency - The purchase price in multiple currencies.

The simulated purchase price and currency are recorded twice. The amount in this field is related to the price of the supplier.

  • Unit - Purchase price unit
  • Cost Component - The cost component that must be of the type Material Costs.

Note: The cost component specified in this field does not become part of the standard cost detail structure if it is part of the cost component scheme of the selected item. If calculations are performed with a calculation code not used for actualization (simulations only), the simulated purchase price is mapped to the cost component defined in the records for this session.

Categories