Skip to end of metadata
Go to start of metadata

INTRODUCTION TO COMPIERE REPORTS AND PROCESSES

This Chapter details the Reports and Processes in Compiere. All of these are pre-defined in the basic installation. Compiere provides the basic Reports that are necessary for analyzing your current position as well as provide the details of an entity's status.

Compiere also provides a number of processes. Some will be used on a regular basis while other will be used only in exceptional circumstances (e.g. after changing your accounting structure).

In this Chapter all of these Reports and Processes will be listed along with their parameters and outputs.

REPORTS

Reports in Compiere are pre-defined and comprised of two components, parameters and a print format. If desired, you can modify the print format used in a Report.

For additional information on modifying Print Formats, refer to the Info and Reporting chapter.

Order Management

Report                Order Detail

Description         Lists details for Orders, including lost sales. It can be run for Sales Orders or Purchase Orders.

Menu Location   Order Management > Sales Order

Parameters        Document Type

                           Business Partner

                           Product

                           Date Ordered (range)

Report                Open Orders

Description         Lists Orders with quantities not delivered or not invoiced.

Menu Location   Order Management> Sales Order

Parameters        Business Partner

                           Product

                           Sales Transactions (flag)

Report                Order Transactions

Description         Lists Sales Order Transactions

Menu Location   Quote to Invoice > Sales Order

Parameters        Date Range

                           Sales Transactions (flag)

Report                Shipment Details

Description         Lists Customer shipment header and line with locator information. It can be used to create a consolidated pick list.

Menu Location   Order Management > Shipment

Parameters        Warehouse

                           Business Partner

                           Movement Date range

                           Locator Key

                           Document Status

Report                Cash Journal Details

Description         Lists Details of a Cash Journal(s.)

Menu Location   Order Management > Customer Payment

Parameters        Cash Book

                           Organization

                           Account Date range

Procurement

Report                RfQ Unanswered

Description         Lists Responses from open RfQs that are not marked as Complete.

Menu Location   Procurement > RfQ

Parameters        RfQ Topic

                           RfQ

                           Response Date range

Report                RfQ Response

Description         Lists Responses from open RfQs that are marked as Complete.

Menu Location   Procurement > RfQ

Parameters        RfQ Topic

                           RfQ

Report                Open Requisitions

Description         Lists Requisitions that are not marked as Complete.

Menu Location   Procurement > Requisition

Parameters        Warehouse

                           User/Contact

                           Product

                           Date Required range

Report                Material Receipt Details

Description         Lists Material Receipt Header and Lines with Locator information.

Menu Location   Procurement > Receipt

Parameters        Warehouse

                           Business Partner

                           Movement Date range

Report                Receipts not Matched

Description         Lists Material Receipts that are not completely matched to Vendor Invoices.

Menu Location   Procurement > Receipt

Parameters        Organization

                           Date Received range

                           Business Partner

                           Product

Material Management

Report                Vendor Selection

Description         Lists Products that are supplied by more than one Vendor.

Menu Location   Material Management > Material Management Rules

Parameters        None

Report                Transaction Details

Description         Lists Transaction Details (shipments, receipts, material movements, etc.) and includes Instance Details (serial no, lot.)

Menu Location   Material Management > Material Management Rules

Parameters        Movement Type

                           Movement Date range

                           Product Category

                           Product

                           Locator

                           Lot

                           Lot No

                           Serial No

Report                Product Transaction Value

Description         Lists Products Transaction details with current Vendor price.

Menu Location   Material Management > Material Management Rules

Parameters        Movement Date range

                           Product Category

                           Business Partner

                           Search Key (product)

Report                Product Transaction Summary

Description         Lists summarized Transactions for stored Products.

Menu Location   Material Management > Material Management Rules

Parameters        Movement Date range

                           Warehouse

                           Movement Type

                           Product

Report                Replenish Report

Description         Lists suggest reorder quantities for stocked products based on replenishment rules and current Vendor order variables.

Menu Location   Material Management > Material Management Rules

Parameters        Warehouse                          

                           Business Partner

                           Create (Inventory Move, Requisition or Purchase 

                           Order)

                           Document Type

Report                Open Confirmations

Description         Lists Confirmations that have not been completed.

Menu Location   Material Management > Material Management Rules

Parameters        Warehouse

                           Confirmation Type

                           Business Partner

                           Sales Order

Report                Open Confirmations Details

Description         Lists Confirmation lines that have not been completed.

Menu Location   Material Management > Material Management Rules

Parameters        Warehouse

                           Confirmation Type

                           Business Partner

                           Sales Order

Report                Storage Details

Description         Lists Storage information including Product instance data.

Menu Location   Material Management > Material Management Rules

Parameters        Warehouse

                           Locator

                           Product Category

                           Product

                           Lot

                           Lot No

Report                Inventory Valuation Report

Description         Lists Products with their on hand quantities and values for the selected valuation date.

Menu Location   Material Management > Material Management Rules

Parameters        Warehouse

                           Currency

                           Price List Version

                           Valuation Date

Report                Material Reference

Description         Lists a cross reference of where Material receipts are used or where Customer Shipments are sourced.

Menu Location   Material Management > Material Management Rules

Parameters        Search Order

                           Search Invoice

                           Search Shipment/Receipt

Costing

Report                Product Cost Summary

Description         Lists the summarized product cost for a product.

Menu Location   Costing

Parameters        Accounting Schema

                           Product Category

                           Product

                           Search Key (range)

                           Tax

Report                Product Cost

Description         Lists the product cost for a product, cost type and cost element.

Menu Location   Costing

Parameters        Accounting Schema

                           Cost Type

                           Product Category

                           Product

                           Search Key (range)

                           Cost Element

                           Tax

Report                Product Cost Detail

Description         Lists the product with individual invoice cost allocation.

Menu Location   Costing

Parameters        Accounting Schema

                           Product Category

                           Product

                           Search Key (range)

Invoice Inquiry

Report                Invoice Transactions (Acct)

Description         Lists Invoice transactions by Accounting Date.

Menu Location   Invoice Inquiry

Parameters        Organization

                           Account Date range

                           Sales Transactions (flag)

Report                Invoice Transactions (Doc)

Description         Lists Invoice transactions by Document Date.

Menu Location   Invoice Inquiry

Parameters        Organization

                           Document Date range

                           Sales Transactions (flag)

Report                Invoice Details and Margin

Description         Lists Customer and Vendor Invoice Details with margin.

Menu Location   Invoice Inquiry

Parameters        Business Partner Group

                           Business Partner

                           Product Category

                           Product

                           Date Invoiced range

                           Sales Transaction

Report                Daily Invoice

Description         Lists Invoices summarized by day.

Menu Location   Invoice Inquiry

Parameters        Date Invoiced range

                           Sales Transaction (flag)

                           Representative

Report                Weekly Invoice

Description         Lists Invoices summarized by week.

Menu Location   Invoice Inquiry

Parameters        Date Invoiced range

                           Sales Transactions (flag)

                           Representative

Report                Weekly Invoice Product Cat

Description         Lists Invoices summarized by Product and week.

Menu Location   Invoice Inquiry

Parameters        Date Invoiced range

                           Product Category

Report                Weekly Invoice Product

Description         Lists Invoices summarized by Product and week

Menu Location   Invoice Inquiry

Parameters        Date Invoiced range

                           Product

Report                Monthly Invoice

Description         Lists Invoice summarized by month

Menu Location   Invoice Inquiry

Parameters        Date Invoiced range

                           Sales Transactions (flag)

                           Representative

Report                Monthly Invoice Product

Description         Lists Invoices summarized by Product and month.

Menu Location   Invoice Inquiry

Parameters        Date Invoiced range

                           Sales Transactions (flag)

                           Product

Report                Monthly Invoice Product Cat

Description         Lists Invoices summarized by Product Category and month.

Menu Location   Invoice Inquiry

Parameters        Date Invoiced range

                           Sales Transactions (flag)

                           Product Category

Report                Monthly Invoice Vendor

Description         Lists Invoice summarized by Vendor and month.

Menu Location   Quote to Invoice >Invoice Inquiries

Parameters        Date Invoiced range

                           Business Partner

                           Product

Report                Quarterly Invoice Product

Description         Lists Invoices summarized by Product for a quarter.

Menu Location   Invoice Inquiry

Parameters        Date Invoiced range

                           Sales Transaction

                           Product

Report                Quarterly Invoice Customer by Vendor

Description         Lists Invoices summarized by Customer and Vendor for a quarter.

Menu Location   Invoice Inquiry

Parameters        Date Invoiced range

                           Business Partner

Report                Quarterly Invoice Customer by Product

Description         Lists Invoices summarized by Customer and Product for a quarter.

Menu Location   Invoice Inquiry

Parameters        Date Invoiced range

                           Sales Transaction (flag)

                           Business Partner

                           Product Category

Cash Management

Report                Business Partner Open

Description         Lists the open invoices and payments for a Business Partner.

Menu Location   Cash Management

Parameters        Business Partner

Report                Invoice Tax

Description         Lists Invoice Tax Lines with Business Partner tax information.

Menu Location   Open Items

Parameters        Organization

                           Date Invoiced range

                           Account Date range

                           Tax

                           Document Type

Report                Open Items

Description         Lists all Open (unpaid) Invoices for a Business Partner and Date Range.

                          Invoices paid via Cash Journals will remain Open until the Cash Journal is processed.

Menu Location   Cash Management

Parameters        Business Partner

                           Sales Transaction (flag)

                           Days Due range

Report                Aging

Description         Lists Open Items grouped into selected aging buckets.

                          (In it ally all available buckets will display. Modify the Print Format to display only the desired aging buckets.)

Menu Location   Cash Managements

Parameters        Due Date

                           Sales Transaction (flag)

                           Currency

                           Business Partner Group

                           Business Partner

                           List Invoices (flag)

Report                Invoice Not Realized Gain/Loss

Description         Lists Open not fully paid invoices with the open amount, the GL amounts and the revalued amounts.

                           If you select a (GL) Document Type, a GL Journal is created.

Menu Location   Cash Management

Parameters        Accounting Schema

                           Revaluation Conversion Type

                           Revaluation Date

                           AP-AR

                           Currency

                           Document Type

Report                Payment Details

Description         Lists type adjusted payments (receipts positive, payments negative) with allocated and available amounts.

Menu Location   Cash Management

Parameters        Bank Account

                           Business Partner

                           Document Type

                           Allocated

Report                Allocation

Description         Lists Invoices allocated to Payments and Cash Journals.

Menu Location   Cash Management

Parameters        Business Partner

                           Invoice

                           Document Status

Report                Unallocated Invoices

Description         Lists Invoices that are not allocated to a Payment.

Menu Location   Cash Management

Parameters        Business Partner

                           Document Type

Report                Unallocated Payments

Description         Lists Invoices that are not allocated to a Payment.

Menu Location   Cash Management

Parameters        Business Partner

Report                Unrecognized Payments

Description         Lists Payments not reconciled with a bank statement.

Menu Location   Cash Management

Parameters        Bank Account

                           Transaction Date (range)

                           Transaction Type

Financial Management

Report                Statement of Accounts

Description         Displays the beginning balance and transactions for a date range.

Menu Location   Financial Management > Financial Reporting

Parameters        Accounting Schema

                           Period

                           Account Date range

                           Organization

                           Account

                           Business Partner

                           Product

                           Project

                           Activity

                           Sales Region

                           Campaign (note: Accounting Dimensions available for selection will depend, in part, on the Elements enabled for the Accounting Schema)

                           Update Balances (flag)

Report                Trial Balances

Description         Displays a Trial Balance for a given period or date range

Menu Location   Financial Management > Financial Reporting

Parameters        Accounting Schema

                           Period

                           Account Date range

                           Organization

                           Account

                           Account Key range

                           Business Partner

                           Product

                           Project

                           Activity

                           Sales Region

                           Campaign (note: Accounting Dimensions available for selection will depend, in part, on the Elements enabled for the Accounting Schema)

                           Update Balances (flag)

Project Management

Report                Project Lines not Issued

Description         Lists Project Lines (for work order or asset projects) where lines have not been issued.

Menu Location   Project Management

Parameters        Project

Report                Project POs not Issued

Description         Lists Project Lines with generated Purchase Orders (for work order or asset projects) which are not issued.

Menu Location   Project Management

Parameters        Project

Report                Project Margin (Work Order)

Description         Lists Margin for a Project Line (planned revenue) compared to project issues (actual effort and costs.)

Menu Location   Project Management

Parameters        Project

                           Accounting Schema

Report                Project Cycle Report

Description         Reports on common Project Phases of a Cycle Step Phase weighted by a Cycle's relative weight.

Menu Location   Project Management

Parameters        Project Cycle

Report                Project Details Accounting Report

Description         Lists the Accounting Fact Details related to a Project.

Menu Location   Project Management

Parameters        Accounting Schema

                           Project

Report                Project Line Details

Description         Lists the Project and Line details, amounts and probabilities.

Menu Location   Project Management

Parameters        Project Type

                           Status

                           Processed

Performance Analysis

Report                Accounting Fact Details

Description         Lists Accounting Details

Menu Location   Performance Analysis

Parameters        Accounting Schema

                           Organization

                           Account Date range

                           Period

                           Account

                           Account Key range

                           Business Partner

                           Product

                           Tax

Report                Accounting Fact Daily

Description         Lists Accounting Details summarized by Accounting Date.

Menu Location   Performance Analysis

Parameters        Accounting Schema

                           Organization

                           Account Date range

                           Period

                           Account

                           Account Key range

                           Business Partner

                           Product

                           Tax

Report                Accounting Fact Period

Description         Lists Accounting Details summarized by Period.

Menu Location   Performance Analysis

Parameters        Accounting Schema

                           Organization

                           Account Date range

                           Period

                           Account

                           Account Key range

                           Business Partner

                           Product

                           Tax

Sales and Marketing

Report                Commission Run Detail

Description         Lists amount details and Order/Invoice details for a Commission Run.

Menu Location   Sales and Marketing

Parameters        Commission

                           Commission Run

                           Commissioned B. Partner

                           Business Partner

                           Product

Report                Leads Weekly

Description         Lists Leads by source and week.

Menu Location   Sales and Marketing

Parameters        Source

                           Create On range

Report                Leads Monthly

Description         Lists Leads by source and month.

Menu Location   Sales and Marketing

Parameters        Source

                           Create On range

Partner Relations

Report                Business Partner Detail

Description         Lists the details of a Business Partner including addresses and contacts.

Menu Location   Partner Relations > Business Partner Rules

Parameters        Name

                           Contact Name

Labels
  • None