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
