__openerp__.py

   1 # -*- encoding: utf-8 -*-
   2 ##############################################################################
   3 #
   4 #    Authors: Nicolas Bessi, Guewen Baconnier
   5 #    Copyright Camptocamp SA 2011
   6 #
   7 #    This program is free software: you can redistribute it and/or modify
   8 #    it under the terms of the GNU Affero General Public License as
   9 #    published by the Free Software Foundation, either version 3 of the
  10 #    License, or (at your option) any later version.
  11 #
  12 #    This program is distributed in the hope that it will be useful,
  13 #    but WITHOUT ANY WARRANTY; without even the implied warranty of
  14 #    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15 #    GNU Affero General Public License for more details.
  16 #
  17 #    You should have received a copy of the GNU Affero General Public License
  18 #    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  19 #
  20 ##############################################################################
  21 {
  22     'name': 'Financial Reports - Webkit',
  23     'description': """
  24 Financial Reports - Webkit
  25 ==========================
  26
  27 This module adds or replaces the following standard OpenERP financial reports:
  28  - General ledger
  29  - Trial Balance (simple or comparative view)
  30  - Partner ledger
  31  - Partner balance
  32  - Open invoices report
  33  - Aged Partner Balance
  34
  35 Main improvements per report:
  36 -----------------------------
  37
  38 The General ledger: details of all entries posted in your books sorted by account.
  39
  40 * Filter by account is available in the wizard (no need to go to the
  41   Chart of Accounts to do this anymore) or by View account (the report
  42   will display all regular children accounts) i.e. you can select all
  43   P&L accounts.
  44 * The report only prints accounts with moves OR with a non
  45   null balance. No more endless report with empty accounts (field:
  46   display account is hidden)
  47 * initial balance computation on the fly if no open entry posted
  48 * Thanks to a new checkbox in the account form, you will have the
  49   possibility to centralize any account you like.  This means you do
  50   not want to see all entries posted under the account ‘VAT on sales’;
  51   you will only see aggregated amounts by periods.
  52 * Counterpart account is displayed for each transaction (3 accounts max.)
  53   to ease searching.
  54 * Better ergonomy on the wizard: important information is displayed in
  55   the top part, filters are in the middle, and options are in the
  56   bottom or on a separate tab. There is more specific filtering on
  57   separate tabs. No more unique wizard layout for all financial
  58   reports (we have removed the journal tab for the GL report)
  59 * improved report style
  60
  61 The partner ledger: details of entries relative to payable &
  62 receivable accounts posted in your books sorted by account and
  63 partner.
  64
  65 * Filter by partner now available
  66 * Now you can see Accounts then Partner with subtotals for each
  67   account allowing you to check you data with trial balance and
  68   partner balance for instance. Accounts are ordered in the same way as
  69   in the Chart of account
  70 * Period have been added (date only is not filled in since date can be
  71   outside period)
  72 * Reconciliation code added
  73 * Subtotal by account
  74 * Alphabetical sorting (same as in partner balance)
  75
  76 Open invoice report : other version of the partner ledger showing
  77 unreconciled / partially reconciled entries.
  78
  79 * Possibility to print unreconciled transactions only at any date in
  80   the past (thanks to the new field: `last_rec_date` which computes
  81   the last move line reconciliation date). No more pain to get open
  82   invoices at the last closing date.
  83 * no initial balance computed because the report shows open invoices
  84   from previous years.
  85
  86 The Trial balance: list of accounts with balances
  87
  88 * You can either see the columns: initial balance, debit, credit,
  89   end balance or compare balances over 4 periods of your choice
  90 * You can select the "opening" filter to get the opening trial balance
  91   only
  92 * If you create an extra virtual chart (using consolidated account) of
  93   accounts for your P&L and your balance sheet, you can print your
  94   statutory accounts (with comparison over years for instance)
  95 * If you compare 2 periods, you will get the differences in values and
  96   in percent
  97
  98 The Partner balance: list of account with balances
  99
 100 * Subtotal by account and partner
 101 * Alphabetical sorting (same as in partner balance)
 102
 103
 104 Aged Partner Balance: Summary of aged open amount per partner
 105
 106 This report is an accounting tool helping in various tasks.
 107 You can credit control or partner balance provisions computation for instance.
 108
 109 The aged balance report allows you to print balances per partner
 110 like the trial balance but add an extra information :
 111
 112 * It will split balances into due amounts
 113   (due date not reached à the end date of the report) and overdue amounts
 114   Overdue data are also split by period.
 115 * For each partner following columns will be displayed:
 116
 117   * Total balance (all figures must match with same date partner balance report).
 118      This column equals the sum of all following columns)
 119
 120    * Due
 121    * Overdue <= 30 days
 122    * Overdue <= 60 days
 123    * Overdue <= 90 days
 124    * Overdue <= 120 days
 125    * Older
 126
 127 Hypothesis / Contraints of aged partner balance
 128
 129 * Overdues columns will be by default  be based on 30 days range fix number of days.
 130   This can be changed by changes the RANGES constraint
 131 * All data will be displayed in company currency
 132 * When partial payments, the payment must appear in the same colums than the invoice
 133   (Except if multiple payment terms)
 134 * Data granularity: partner (will not display figures at invoices level)
 135 * The report aggregate data per account with sub-totals
 136 * Initial balance must be calculated the same way that
 137   the partner balance / Ignoring the opening entry
 138   in special period (idem open invoice report)
 139 * Only accounts with internal type payable or receivable are considered
 140   (idem open invoice report)
 141 * If maturity date is null then use move line date
 142
 143
 144 Limitations:
 145 ------------
 146
 147 In order to run properly this module makes sure you have installed the
 148 library `wkhtmltopdf` for the pdf rendering (the library path must be
 149 set in a System Parameter `webkit_path`).
 150
 151 Initial balances in these reports are based either on opening entry
 152 posted in the opening period or computed on the fly. So make sure
 153 that your past accounting opening entries are in an opening period.
 154 Initials balances are not computed when using the Date filter (since a
 155 date can be outside its logical period and the initial balance could
 156 be different when computed by data or by initial balance for the
 157 period). The opening period is assumed to be the Jan. 1st of the year
 158 with an opening flag and the first period of the year must start also
 159 on Jan 1st.
 160
 161 Totals for amounts in currencies are effective if the partner belongs to
 162 an account with a secondary currency.
 163
 164 HTML headers and footers are deactivated for these reports because of
 165 an issue in wkhtmltopdf
 166 (http://code.google.com/p/wkhtmltopdf/issues/detail?id=656) Instead,
 167 the header and footer are created as text with arguments passed to
 168 wkhtmltopdf. The texts are defined inside the report classes.
 169 """,
 170     'version': '1.1.0',
 171     'author': 'Camptocamp',
 172     'license': 'AGPL-3',
 173     'category': 'Finance',
 174     'website': 'http://www.camptocamp.com',
 175     'images': [
 176         'images/ledger.png',],
 177     'depends': ['account',
 178                 'report_webkit'],
 179     'init_xml': [],
 180     'demo_xml' : [],
 181     'update_xml': ['account_view.xml',
 182                    'data/financial_webkit_header.xml',
 183                    'report/report.xml',
 184                    'wizard/wizard.xml',
 185                    'wizard/balance_common_view.xml',
 186                    'wizard/general_ledger_wizard_view.xml',
 187                    'wizard/partners_ledger_wizard_view.xml',
 188                    'wizard/trial_balance_wizard_view.xml',
 189                    'wizard/partner_balance_wizard_view.xml',
 190                    'wizard/open_invoices_wizard_view.xml',
 191                    'wizard/aged_partner_balance_wizard.xml',
 192                    'wizard/print_journal_view.xml',
 193                    'report_menus.xml',
 194                    ],
 195     # tests order matter
 196     'test': ['tests/general_ledger.yml',
 197              'tests/partner_ledger.yml',
 198              'tests/trial_balance.yml',
 199              'tests/partner_balance.yml',
 200              'tests/open_invoices.yml',
 201              'tests/aged_trial_balance.yml'],
 202     #'tests/account_move_line.yml'
 203     'active': False,
 204     'installable': True,
 205     'application': True,
 206 }