How to use the financial reports system to create a legal statement
7. STEPS TO CREATE YOUR REPORT
3. FEATURES COMPARISON FINANCIAL VS CUSTOM REPORTS
1. How to use the financial reports system to create a legal statement PIERRE VYNCKE, R&D DEVELOPER
2. SUMMARY Financial Reports vs Custom Reports 1 Demo 2 Steps to create your own report 3 Q&A 4
11. Financial Report Line object III Reports lines based on the sum on a domain : Domain field : An Odoo domain on the account move line object. Formula field : Extra object available, namely sum. The sum of the account move lines in the domain. Groupby field : Group the account move lines by one of their columns
4. Financial Very easy to create (XML) Ready to use Only works with amls Only with sums over a period Custom More advanced (Python) Possibilities are much more open FEATURES COMPARISON I
9. Financial Report Line object I All report lines : name and code parent_id : another account.financial.report.line sequence : sets their display order level : determines the layout
10. Financial Report Line object II Formula field Assigns a value to the balance column (and debit and credit column if applicable – seperated by ;). Available objects : Ndays : number of days in the selected period (for reports with a date range). Another report : referenced by the code of the other report. Use .balance to get its balance value (also available is .credit, .debit and .amount_residual)
13. Odoo firstname.lastname@example.org +32 (0) 2 290 34 90 www.odoo.com R&D and services office Chaussée de Namur 40 B - 1367 Grand Rosière Sales office Avenue Van Nieuwenhuyse 5 B - 1160 Brussels Thank You For any question : email@example.com
8. Financial Report object One account.financial.report object per report : name : Name (title) of the report debit_credit : Toggles debit and credit columns (default = False) report_type : date_range (Profit & Loss) no_date_range (Balance Sheet) date_range_extended (Aged Partner Balances) date_range_cash (Cash Method by default)
12. Financial Report Line object IV Other useful fields : financial_report_id : For the root financial report line. Must link to the related accout.financial.report object (the field parent_id should then be left empty). figure_type : Type of the result of the formula. Can be float (default), percents or no_unit. green_on_positive : Used when computing the comparison column. True (default) if growth is good (displayed in green) or not. special_date_changer : If a specific line in a report should not use the same dates as the rest of the report. Can be normal (default), from_beginning (start date is the epoch, eg. unnaffected earnings line in a balance sheet) or to_beginning_of_period (start date is the epoch and end date is the start date of the selected period) show_domain : How the domain of a line is displayed. Can be foldable (default, hidden at the start but can be unfolded), always (always displayed) or never (never shown). hide_if_zero : False by default. If true and the line result is null, hides the line. action_id : Many2one linking to an action that will be executed when clicking on the line name in the report.
5. FEATURES COMPARISON II Most account reports are financial reports : Profit and Loss Balance Sheet Cash Summary Executive Summary Aged Partner Balances Most localizations reports are also financial reports : Belgian Profit & Loss Belgian Balance Sheet Belgian VAT Statement Custom reports are few : Bank Reconciliation (works with bank statement lines not move lines) General Ledger (more columns, initial balance line) Generic Tax Report (columns not sum of domain) Belgian Partner VAT Listing (columns not sum of domain) Followups (more options, more columns, actions, ...)
- 2890 Total Views
- 1943 Website Views
- 947 Embeded Views
- Social Shares
- 0 Likes
- 0 Dislikes
- 0 Comments
- 0 Facebook
- 0 Twitter
- 0 Google+
- 3 m.facebook.com
- 7 www.odoo.com
- 1 www.tinyerp.org
- 1 accounts.odoo.com
- 4 onlinesync.odoo.com
Keynote: Odoo 9 New Features39927 Views .
Odoo 9 New Design- The rationales behind it11135 Views .
Open Source Licenses8201 Views .
Shipper integration - UPS, DHL, FedEx7135 Views .
UX best practices to create your module5759 Views .
Keynote: Odoo Strategy 20155557 Views .
How to use Odoo in a Restaurant5324 Views .
Odoo 9: New Business Model5175 Views .
Odoo cms Performance Comparison and Optimisation4172 Views .
Odoo 9 New Design- Usability Methodology3663 Views .
How A/B testing can help you optimize your website3658 Views .
New Odoo Apps store: How to use it3433 Views .
First steps in Odoo dev3405 Views .
Advanced barcodes management3289 Views .
Advanced Features of the API3257 Views .
How to use Odoo in the textile industry3049 Views .
How to use Odoo in a service company2997 Views .
Contributing to the Odoo Community Association (OCA)2989 Views .