Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Resources Infor ERP Tips & News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Subscribe to newsletter

George Moroses
/ Categories: Infor LX & BPCS Tips, Services News, Support, Training & Workshops

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
33201 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses
Contact author

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

The system automatically performs offsets for requirements dates for components in the MPS/MRP calculations. It also performs offsets for calculation of material need dates at the time that shop orders are released.


To calculate the offset, the system takes the parent lead time from the Item Master and adjusts it by the bill of materials offset (plus or minus) for the component. This gives the lead time days for that specific component. The system starts with the due date of the parent and backs up and skips all non-work days in the shop calendar.


Note that the offset calculation uses only calendar records that have a blank work center (the calendar record applies to all work centers). See the information for the Shop Calendar Maintenance program SFC140, in your Shop Floor Control documentation for shop calendar details.

Read more

You can integrate Accounts Payable (ACP) with Purchasing. ACP requires more detailed information in the Vendor file than Purchasing requires. Accounts Payable automatically checks for a valid purchase order when you

match invoices to POs and receipts. Enter any outstanding active purchase orders through PO Release, PUR500, before you can match invoices in Accounts Payable.

 

Accounts Payable can also update the Actual Cost fields in the Inventory Master file directly from vendor invoices. You must provide the following information in order for Accounts Payable to complete this update:

▪ Define a type C inventory transaction.

▪ Enter a valid purchase order on the Invoice Entry header screen, ACP500D2-01, or in the Next Purchase Order field on the Invoice Entry: PO Costing screen, ACP500D3-01.

▪ Enter the information for the actual cost transaction on the appropriate lines.

Read more
FirstLast

Tips: LN | Baan

Categories