| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Accounting (accountant)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 874 |
| Technical Name |
oe_sale_invoice_summary_report |
| License | LGPL-3 |
| Website | https://www.oaklandmena.com |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Accounting (accountant)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 874 |
| Technical Name |
oe_sale_invoice_summary_report |
| License | LGPL-3 |
| Website | https://www.oaklandmena.com |
| Versions | 16.0 17.0 18.0 19.0 |
User Guide
This guide explains how to generate and view the Sale Invoice Summary Report.
1. Access the Report
- Navigate to the Invoicing or Accounting module and look for a menu item named Sale Invoice Summary Report.
2. Open the Report Wizard
- Clicking the menu item will open a new pop-up window (a wizard) with filtering options.
3. Set Filters
Use the following options to filter the report:
- Period: Choose a predefined period or select a custom date range.
- Start Date and End Date: If you select a custom period, enter the start and end dates.
- Customers: Select one or more customers to include in the report. Leave this blank to include all customers.
- Invoices: Select one or more specific invoices. Leave this blank to include all invoices.
4. Generate the Report
You can generate the report in two ways:
- To view the report on the screen, click the Generate Report button. The report will be displayed in a detailed list view.
- To download the report as an Excel file, click the Print Excel Report button. A file download wizard will appear, from which you can save the file to your computer.
5. View Invoice Details
- In the on-screen report, click the View Invoice button next to any line item to open the corresponding invoice record in a new form view.
6. Cancel
- To close the wizard without generating the report, click the Cancel button.
Frequently Asked Questions
1. How is the gross profit calculated?
Gross profit is calculated as the total revenue from the sale minus the total cost of the goods sold. The report uses the fields price_total (total revenue) and total_cost to compute the gp (gross profit) and gp_percentage.
2. Can I filter the report by sales person?
The report view displays the sales person associated with each invoice line. While the initial wizard doesn't have a direct filter for sales person, you can use the built-in search and grouping functionalities in the on-screen report to filter by this field.
3. What is the "View Invoice" button for?
This button is a convenient shortcut that allows you to quickly view the original invoice document in its full form without having to leave the report.
4. What information is included in the Excel report?
The Excel report includes a grand total and detailed line items with columns for Sales Person, Customer, Country, Invoice Reference, Invoice Date, Product Details, Unit Price, Quantity, Total Price, Total in Company Currency, Total Cost, Gross Profit (GP), and GP Percentage.
5. What does "Total in Company Currency" mean?
This field represents the total revenue of a sales line converted to the company's base currency, which is especially useful for businesses dealing with multiple currencies.
Module Support & SLA
For any support related to this Odoo module, please contact us at apps@odooerp.ae
Our standard response time (SLA) for support queries is between 12 to 48 hours.
Our standard response time (SLA) for support queries is between 12 to 48 hours.
Please log in to comment on this module