The Order Detail Report provides detailed information about sales and purchase order lines in iDempiere. It helps users view order details such as document information, business partner, product, quantities, pricing, and other related information for each order line.

The report is mainly used by Sales, Purchase, Warehouse, and Management teams to review order transactions, verify order details, and analyze sales and purchase activities.

Business Rules

• The report retrieves order detail information from the RV_OrderDetail database view.
• Each record in the report represents a single sales or purchase order line.
• The report can display both Sales Orders and Purchase Orders.
• Users can filter the report by Document Type, Business Partner, Product, and Date Ordered.
• When a Document Type is selected, only matching order lines are displayed.
• When a Business Partner is selected, only orders for that customer or vendor are displayed.
• When a Product is selected, only order lines for that product are displayed.
• When an Ordered Date is specified, only orders matching the selected date or date range are displayed.
• Multiple parameters can be used together to refine the report results.
• The report displays order details such as document information, business partner, product, warehouse, quantities, and pricing.
• The report is read-only and does not create or update any business data.
• Based on the available implementation, the report retrieves data directly from the RV_OrderDetail Report View and does not use a custom Java process.

Report Parameters

Order Details Report – Parameter Window

The Order Detail Report parameter window allows users to filter order records before generating the report. Users can select values such as Document Type, Business Partner, Product, and Date Ordered to view only the order details that match the selected criteria.

Parameter	Purpose	Filtering Behavior	Sample Data
Document Type	Order type	Filters document type	Standard Order
Business Partner	Customer/Vendor	Filters BP	Alpha Retail Solutions
Product	Product	Filters product	CIN_Cinthol Soap
Date Ordered	Order date	Filters order date	User preferred date

This helps users quickly find and analyze specific order transactions.

Report Output

• The Order Detail Report displays detailed information for sales and purchase order lines based on the selected report parameters. Each record represents a single order line.

The report helps users review order transactions, verify order details, and analyze sales and purchase activities based on the selected filters.

Introduction

The Order Detail Report provides detailed information about sales and purchase order lines in iDempiere. It helps users view order details such as document information, business partner, product, quantities, pricing, and other related information for each order line.

The report is mainly used by Sales, Purchase, Warehouse, and Management teams to review order transactions, verify order details, and analyze sales and purchase activities.

Business Rules

• The report retrieves order detail information from the RV_OrderDetail database view.
• Each record in the report represents a single sales or purchase order line.
• The report can display both Sales Orders and Purchase Orders.
• Users can filter the report by Document Type, Business Partner, Product, and Date Ordered.
• When a Document Type is selected, only matching order lines are displayed.
• When a Business Partner is selected, only orders for that customer or vendor are displayed.
• When a Product is selected, only order lines for that product are displayed.
• When an Ordered Date is specified, only orders matching the selected date or date range are displayed.
• Multiple parameters can be used together to refine the report results.
• The report displays order details such as document information, business partner, product, warehouse, quantities, and pricing.
• The report is read-only and does not create or update any business data.
• Based on the available implementation, the report retrieves data directly from the RV_OrderDetail Report View and does not use a custom Java process.

Report Parameters

Order Details Report – Parameter Window

The Order Detail Report parameter window allows users to filter order records before generating the report. Users can select values such as Document Type, Business Partner, Product, and Date Ordered to view only the order details that match the selected criteria.

Parameter	Purpose	Filtering Behavior	Sample Data
Document Type	Order type	Filters document type	Standard Order
Business Partner	Customer/Vendor	Filters BP	Kerala Digital Prints
Product	Product	Filters product	Cindhol_Soap
Date Ordered	Order date	Filters order date

This helps users quickly find and analyze specific order transactions.

Report Output

• The Order Detail Report displays detailed information for sales and purchase order lines based on the selected report parameters. Each record represents a single order line.

The report helps users review order transactions, verify order details, and analyze sales and purchase activities based on the selected filters.