clearcorp team mailing list archive
-
clearcorp team
-
Mailing list archive
-
Message #00701
lp:~dr.clearcorp/openerp-costa-rica/6.1-fix_partner_ledger_open_invoices into lp:openerp-costa-rica/6.1
Diana Rodríguez Martínez has proposed merging lp:~dr.clearcorp/openerp-costa-rica/6.1-fix_partner_ledger_open_invoices into lp:openerp-costa-rica/6.1.
Requested reviews:
CLEARCORP drivers (clearcorp-drivers)
For more details, see:
https://code.launchpad.net/~dr.clearcorp/openerp-costa-rica/6.1-fix_partner_ledger_open_invoices/+merge/156405
[ADD] Add new module l10n_cr_account_financial_report_partner_ledger that fix partner ledger report
--
https://code.launchpad.net/~dr.clearcorp/openerp-costa-rica/6.1-fix_partner_ledger_open_invoices/+merge/156405
Your team CLEARCORP development team is subscribed to branch lp:openerp-costa-rica/6.1.
=== added directory 'l10n_cr_account_financial_report_partner_ledger'
=== added file 'l10n_cr_account_financial_report_partner_ledger/__init__.py'
--- l10n_cr_account_financial_report_partner_ledger/__init__.py 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/__init__.py 2013-04-01 20:05:26 +0000
@@ -0,0 +1,26 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# OpenERP, Open Source Management Solution
+# Addons modules by CLEARCORP S.A.
+# Copyright (C) 2009-TODAY CLEARCORP S.A. (<http://clearcorp.co.cr>).
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import account
+import wizard
+import report
+import account_account
=== added file 'l10n_cr_account_financial_report_partner_ledger/__openerp__.py'
--- l10n_cr_account_financial_report_partner_ledger/__openerp__.py 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/__openerp__.py 2013-04-01 20:05:26 +0000
@@ -0,0 +1,43 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# OpenERP, Open Source Management Solution
+# Addons modules by CLEARCORP S.A.
+# Copyright (C) 2009-TODAY CLEARCORP S.A. (<http://clearcorp.co.cr>).
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+{
+ 'name': 'Account Financial Report Partner Ledger',
+ 'description': "",
+ 'version': '1.0',
+ 'author': 'CLEARCORP S.A.',
+ 'category': 'Finance',
+ 'website': "http://clearcorp.co.cr";,
+ 'images': [],
+ 'depends': ['account' ],
+ 'init_xml': [],
+ 'demo_xml' : [],
+ 'update_xml': ['report/report.xml',
+ 'wizard/l10n_cr_partners_ledger_wizard_view.xml',
+ 'report_menus.xml',
+ 'account_view.xml',
+ ],
+ 'test': [],
+ 'active': False,
+ 'installable': True,
+ 'license': 'AGPL-3',
+}
=== added file 'l10n_cr_account_financial_report_partner_ledger/account_account.py'
--- l10n_cr_account_financial_report_partner_ledger/account_account.py 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/account_account.py 2013-04-01 20:05:26 +0000
@@ -0,0 +1,33 @@
+#-*- coding:utf-8 -*-
+##############################################################################
+#
+# OpenERP, Open Source Management Solution
+# Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>). All Rights Reserved
+# d$
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as published by
+# the Free Software Foundation, either version 3 of the License, or
+# (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import netsvc
+from osv import fields, orm
+import tools
+from tools.translate import _
+
+class AccountAccount(orm.Model):
+ _inherit = "account.account"
+
+ _columns = {
+ 'report_currency_id': fields.many2one('res.currency', 'Report Currency', help="Currency to show in the reports."),
+ }
\ No newline at end of file
=== added file 'l10n_cr_account_financial_report_partner_ledger/account_view.xml'
--- l10n_cr_account_financial_report_partner_ledger/account_view.xml 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/account_view.xml 2013-04-01 20:05:26 +0000
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data>
+ <!-- Accounts -->
+ <record id="l10n_cr_account_financial_report_view_account_form" model="ir.ui.view">
+ <field name="name">l10n.cr.account.financial.report.view.account.form</field>
+ <field name="model">account.account</field>
+ <field name="type">form</field>
+ <field name="inherit_id" ref="account.view_account_form"/>
+ <field name="arch" type="xml">
+ <data>
+ <field name = "currency_mode" position = "after">
+ <field name="report_currency_id" attrs="{'required':[('type','in', ('payable', 'receivable', 'liquidity'))]}"/>
+ </field>
+ </data>
+ </field>
+ </record>
+ <!-- End Accounts -->
+ </data>
+</openerp>
=== added directory 'l10n_cr_account_financial_report_partner_ledger/i18n'
=== added file 'l10n_cr_account_financial_report_partner_ledger/i18n/es_CR.po'
--- l10n_cr_account_financial_report_partner_ledger/i18n/es_CR.po 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/i18n/es_CR.po 2013-04-01 20:05:26 +0000
@@ -0,0 +1,266 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+# * l10n_cr_account_financial_report_partner_ledger
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.1\n"
+"Report-Msgid-Bugs-To: \n"
+"POT-Creation-Date: 2013-04-01 19:36+0000\n"
+"PO-Revision-Date: 2013-04-01 19:36+0000\n"
+"Last-Translator: <>\n"
+"Language-Team: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: \n"
+"Plural-Forms: \n"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: constraint:partners.ledger.webkit:0
+msgid "When no Fiscal year is selected, you must choose to filter by periods or by date."
+msgstr "Cuando no se selecciona ningún año fiscal, se debe elegir para filtrar por períodos o por fecha."
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:195
+msgid "')}</div>\n"
+" <div class=\"act_as_cell amount\" style=\"width: 115px;\">${_('"
+msgstr "')}</div>\n"
+" <div class=\"act_as_cell amount\" style=\"width: 115px;\">${_('"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:21
+msgid "No"
+msgstr "No"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: view:partners.ledger.webkit:0
+msgid "Layout Options"
+msgstr "Opciones de Diseño"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:168
+msgid "Curr."
+msgstr "Curr."
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:187
+msgid "')}</div>\n"
+" ## journal\n"
+" <div class=\"act_as_cell\" style=\"width: 70px;\">${_('"
+msgstr "')}</div>\n"
+" ## journal\n"
+" <div class=\"act_as_cell\" style=\"width: 70px;\">${_('"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:159
+msgid "Debit"
+msgstr "Débito"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:39
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:190
+msgid "Initial Balance"
+msgstr "Balance inicial"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:443
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:445
+msgid "Total for Accounts in "
+msgstr "Total de cuentas en "
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:145
+msgid "Journal"
+msgstr "Diario"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: constraint:account.account:0
+msgid "Error ! You can not create recursive accounts."
+msgstr "¡Error! No se pueden crear cuentas recursivas."
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:332
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:397
+msgid "Saldo"
+msgstr "Saldo"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:139
+msgid "Date"
+msgstr "Fecha"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:28
+msgid "Chart of Account"
+msgstr "Catálogo de cuentas"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:95
+msgid "Accounts in "
+msgstr "Cuentas en "
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:38
+msgid "Target Moves"
+msgstr "Movimientos destino"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:45
+msgid "From:"
+msgstr "Desde:"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:59
+msgid "To:"
+msgstr "Hasta:"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: model:ir.model,name:l10n_cr_account_financial_report_partner_ledger.model_account_account
+msgid "Account"
+msgstr "Cuenta"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: sql_constraint:account.account:0
+msgid "The code of the account must be unique per company !"
+msgstr "¡El código de la cuenta debe ser único por compañía!"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: model:ir.model,name:l10n_cr_account_financial_report_partner_ledger.model_partners_ledger_webkit
+msgid "Partner Ledger Report"
+msgstr "Reporte de Libro Mayor de Empresa"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: constraint:partners.ledger.webkit:0
+msgid "The fiscalyear, periods or chart of account chosen have to belong to the same company."
+msgstr "El año fiscal, períodos o plan contable elegidos deben pertenecer a la misma compañía."
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:157
+msgid "Credit"
+msgstr "Crédito"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:29
+msgid "Fiscal Year"
+msgstr "Año fiscal"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: model:ir.actions.act_window,name:l10n_cr_account_financial_report_partner_ledger.action_account_partners_ledger_menu_webkit
+msgid "Partner Ledger"
+msgstr "Libro Mayor de Empresa"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:37
+msgid "Accounts Filter"
+msgstr "Filtro de cuentas"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:161
+msgid "Manual Move"
+msgstr "Movimientos manuales"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:143
+msgid "Entry"
+msgstr "Apunte"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:149
+msgid "Label"
+msgstr "Etiqueta"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:70
+msgid "Custom Filter"
+msgstr "Filtro personalizado"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:21
+msgid "Computed"
+msgstr "Procesado"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:163
+msgid "Cumul. Bal."
+msgstr "Bal. Acumul."
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:151
+msgid "Rec."
+msgstr "Rec."
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:191
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:193
+msgid "')}</div>\n"
+" <div class=\"act_as_cell amount\" style=\"width: 100px;\">${_('"
+msgstr "')}</div>\n"
+" <div class=\"act_as_cell amount\" style=\"width: 100px;\">${_('"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: constraint:account.account:0
+msgid "Configuration Error! \n"
+"You can not select an account type with a deferral method different of \"Unreconciled\" for accounts with internal type \"Payable/Receivable\"! "
+msgstr "¡Error de configuración! \n"
+"¡No se puede seleccionar un tipo de cuenta con un método diferente de aplazamiento \"no reconciliadas\" para las cuentas con el tipo interno \"por pagar / por cobrar\"! "
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:34
+msgid "Periods Filter"
+msgstr "Periods Filter"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:141
+msgid "Period"
+msgstr "Período"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:32
+msgid "Dates Filter"
+msgstr "Filtros de fechas"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:134
+msgid "No Partner"
+msgstr "Sin empresa"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:183
+msgid "')}</div>\n"
+" ## period\n"
+" <div class=\"act_as_cell\" style=\"width: 70px;\">${_('"
+msgstr "')}</div>\n"
+" ## period\n"
+" <div class=\"act_as_cell\" style=\"width: 70px;\">${_('"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:153
+msgid "Invoice"
+msgstr "Factura"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: constraint:account.account:0
+msgid "Configuration Error! \n"
+"You can not define children to an account with internal type different of \"View\"! "
+msgstr "¡Error de configuración! "
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:147
+msgid "Partner"
+msgstr "Empresa"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:155
+msgid "Payments"
+msgstr "Pagos"
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:166
+msgid "Curr. Balance"
+msgstr "Balance Act."
+
+#. module: l10n_cr_account_financial_report_partner_ledger
+#: report:addons/l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako:21
+msgid "Opening Entries"
+msgstr "Opening Entries"
+
=== added directory 'l10n_cr_account_financial_report_partner_ledger/report'
=== added file 'l10n_cr_account_financial_report_partner_ledger/report/__init__.py'
--- l10n_cr_account_financial_report_partner_ledger/report/__init__.py 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/report/__init__.py 2013-04-01 20:05:26 +0000
@@ -0,0 +1,22 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# OpenERP, Open Source Management Solution
+# Addons modules by CLEARCORP S.A.
+# Copyright (C) 2009-TODAY CLEARCORP S.A. (<http://clearcorp.co.cr>).
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+import l10n_cr_account_report_partners_ledger
\ No newline at end of file
=== added file 'l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako'
--- l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.mako 2013-04-01 20:05:26 +0000
@@ -0,0 +1,480 @@
+<!DOCTYPE html SYSTEM "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
+<html xmlns="http://www.w3.org/1999/xhtml";>
+<head>
+ <style type="text/css">
+ .overflow_ellipsis {
+ text-overflow: ellipsis;
+ overflow: hidden;
+ white-space: nowrap;
+ }
+ ${css}
+ </style>
+</head>
+<body>
+ <%!
+ def amount(text):
+ return text.replace('-', '‑') # replace by a non-breaking hyphen (it will not word-wrap between hyphen and numbers)
+ %>
+ <%
+ setLang(user.context_lang)
+
+ initial_balance_text = {'initial_balance': _('Computed'), 'opening_balance': _('Opening Entries'), False: _('No')}
+ filter_type = ''
+ filter_data = []
+ %>
+
+ <div class="act_as_table data_table">
+ <div class="act_as_row labels">
+ <div class="act_as_cell">${_('Chart of Account')}</div>
+ <div class="act_as_cell">${_('Fiscal Year')}</div>
+ <div class="act_as_cell">
+ %if filter_form(data) == 'filter_date':
+ ${_('Dates Filter')}
+ %else:
+ ${_('Periods Filter')}
+ %endif
+ </div>
+ <div class="act_as_cell">${_('Accounts Filter')}</div>
+ <div class="act_as_cell">${_('Target Moves')}</div>
+ <div class="act_as_cell">${_('Initial Balance')}</div>
+ </div>
+ <div class="act_as_row">
+ <div class="act_as_cell">${ chart_account.name }</div>
+ <div class="act_as_cell">${ fiscalyear.name if fiscalyear else '-' }</div>
+ <div class="act_as_cell">
+ ${_('From:')}
+ %if filter_form(data) == 'filter_date':
+ ${formatLang(start_date, date=True) if start_date else u'' }
+ <%
+ filter_data.append(start_date)
+ filter_type = 'filter_date'
+ %>
+ %else:
+ ${start_period.name if start_period else u''}
+ <%
+ filter_data.append(start_period)
+ filter_type = 'filter_period'
+ %>
+ %endif
+ ${_('To:')}
+ %if filter_form(data) == 'filter_date':
+ ${ formatLang(stop_date, date=True) if stop_date else u'' }
+ <% filter_data.append(stop_date) %>
+ %else:
+ ${stop_period.name if stop_period else u'' }
+ <% filter_data.append(stop_period) %>
+ %endif
+ </div>
+ <div class="act_as_cell">
+ %if partner_ids:
+ ${_('Custom Filter')}
+ %else:
+ ${ display_partner_account(data) }
+ %endif
+ </div>
+ <div class="act_as_cell">${ display_target_move(data) }</div>
+ <div class="act_as_cell">${ initial_balance_text[initial_balance_mode] }</div>
+ </div>
+ </div>
+ <%
+ account_by_curr = get_accounts_by_curr(cr, uid, objects)
+ %>
+ %for currency in account_by_curr:
+ %if currency[0] != 'CRC':
+ <%currency_symbol = get_currency_symbol(cr, uid, currency[0]) %>
+ %endif
+ <%
+ currency_total_invoice = 0.0
+ currency_total_payment = 0.0
+ currency_total_debit = 0.0
+ currency_total_credit = 0.0
+ currency_total_manual_move = 0.0
+ currency_balance_accumulated = 0.0
+ %>
+
+ <div class="account_title bg" style="margin-top: 20px; font-size: 14px; width: 100%;">${_('Accounts in ')} ${currency[0]}</div>
+
+ %for account in currency[1]:
+ %if account.ledger_lines or account.init_balance:
+ <%
+ if not account.partners_order:
+ continue
+ account_total_invoice = 0.0
+ account_total_payment = 0.0
+ account_total_debit = 0.0
+ account_total_credit = 0.0
+ account_total_manual_move = 0.0
+ account_balance_accumulated = 0.0
+ account_balance_accumulated_curr = 0.0
+ %>
+
+ <div class="account_title bg" style="width: 100%; margin-top: 15px; font-size: 12px;">${account.code} - ${account.name} - ${account.report_currency_id.name or account.company_id.currency_id.name}</div>
+
+ %for partner_name, p_id, p_ref, p_name in account.partners_order:
+ <%
+ total_invoice = 0.0
+ total_payment = 0.0
+ total_debit = 0.0
+ total_credit = 0.0
+ total_manual_move = 0.0
+ accumulated_balance = 0.0
+ accumulated_balance_curr = 0.0
+ total_accumulated_balance = 0.0
+
+ partner_accumulated_balance = 0.0
+ partner_accumulated_balance_curr = 0.0
+
+ partner_accumulated_balance = account.init_balance.get(p_id, {}).get('init_balance') or 0.0
+ init_balance = 0.0
+ init_balance = get_initial_balance(cr, uid, p_id, account, filter_type, filter_data, fiscal_year, currency[0])
+ accumulated_balance = init_balance
+ %>
+ <div class="act_as_table list_table" style="margin-top: 5px;">
+ <div class="act_as_caption account_title">
+ ${ get_partner_name(cr, uid, partner_name, p_id, p_ref, p_name) or _('No Partner')}
+ </div>
+ <div class="act_as_thead">
+ <div class="act_as_row labels">
+ ## date
+ <div class="act_as_cell first_column" style="width: 50px;">${_('Date')}</div>
+ ## period
+ <div class="act_as_cell" style="width: 70px;">${_('Period')}</div>
+ ## move
+ <div class="act_as_cell" style="width: 70px;">${_('Entry')}</div>
+ ## journal
+ <div class="act_as_cell" style="width: 70px;">${_('Journal')}</div>
+ ## partner
+ <!--div class="act_as_cell" style="width: 60px;">${_('Partner')}</div-->
+ ## label
+ <div class="act_as_cell" style="width: 270px;">${_('Label')}</div>
+ ## reconcile
+ <div class="act_as_cell" style="width: 70px;">${_('Rec.')}</div>
+ ## Invoices
+ <div class="act_as_cell amount" style="width: 100px;">${_('Invoice')}</div>
+ ## credit
+ <div class="act_as_cell amount" style="width: 100px;">${_('Payments')}</div>
+ ## debit
+ <div class="act_as_cell amount" style="width: 100px;">${_('Credit')}</div>
+ ## Payments
+ <div class="act_as_cell amount" style="width: 100px;">${_('Debit')}</div>
+ ## Manual Move
+ <div class="act_as_cell amount" style="width: 115px;">${_('Manual Move')}</div>
+ ## balance cumulated
+ <div class="act_as_cell amount" style="width: 115px;">${_('Cumul. Bal.')}</div>
+ %if amount_currency(data):
+ ## currency balance
+ <div class="act_as_cell amount sep_left" style="width: 80px;">${_('Curr. Balance')}</div>
+ ## curency code
+ <div class="act_as_cell amount" style="width: 30px; text-align: right;">${_('Curr.')}</div>
+ %endif
+ </div>
+ </div>
+ <div class="act_as_tbody">
+ %if initial_balance_mode and (total_debit or total_credit):
+ <%
+ #partner_accumulated_balance = account.init_balance.get(p_id, {}).get('init_balance') or 0.0
+ #partner_accumulated_balance_curr = account.init_balance.get(p_id, {}).get('init_balance_currency') or 0.0
+ #balance_forward_currency = account.init_balance.get(p_id, {}).get('currency_name') or ''
+
+ #accumulated_balance += partner_accumulated_balance
+ #accumulated_balance_curr += partner_accumulated_balance_curr
+ %>
+ %endif
+ <div class="act_as_cell first_column" style="width: 50px;">${_('')}</div>
+ ## period
+ <div class="act_as_cell" style="width: 70px;">${_('')}</div>
+ ## move
+ <div class="act_as_cell" style="width: 70px;">${_('')}</div>
+ ## journal
+ <div class="act_as_cell" style="width: 70px;">${_('')}</div>
+ <div class="act_as_cell" style="width: 270px;">${_('Initial Balance')}</div>
+ <div class="act_as_cell" style="width: 70px;">${_('')}</div>
+ <div class="act_as_cell amount" style="width: 100px;">${_('')}</div>
+ <div class="act_as_cell amount" style="width: 100px;">${_('')}</div>
+ <div class="act_as_cell amount" style="width: 100px;">${_('')}</div>
+ <div class="act_as_cell amount" style="width: 100px;">${_('')}</div>
+ <div class="act_as_cell amount" style="width: 115px;">${_('')}</div>
+ <div class="act_as_cell amount" style="width: 115px;">${formatLang(init_balance)}</div>
+
+ <%total_accumulated_balance = init_balance %>
+
+ %for line in account.ledger_lines.get(p_id, []):
+ <%
+ label_elements = [line.get('lname') or '']
+ if line.get('invoice_number'):
+ label_elements.append("(%s)" % (line['invoice_number'],))
+ label = ' '.join(label_elements)
+
+ invoice_amount = 0.0
+ payment_amount = 0.0
+ credit_amount = 0.0
+ debit_amount = 0.0
+ MM_amount = 0.0
+
+ amount = get_amount(cr, uid, line, currency[0])
+ %>
+ <div class="act_as_row lines">
+ ## date
+ <div class="act_as_cell first_column">${formatLang(line.get('ldate') or '', date=True)}</div>
+ ## period
+ <div class="act_as_cell">${line.get('period_code') or ''}</div>
+ ## move
+ <div class="act_as_cell">${line.get('move_name') or ''}</div>
+ ## journal
+ <div class="act_as_cell">${line.get('jcode') or ''}</div>
+ ## partner
+ <!--div class="act_as_cell overflow_ellipsis">${line.get('partner_name') or ''}</div-->
+ ## label
+ <div class="act_as_cell">${label}</div>
+ ## reconcile
+ <div class="act_as_cell">${line.get('rec_name') or ''}</div>
+ ## Invoice
+ <div class="act_as_cell amount">
+ %if amount[0] == 'invoice':
+ <%
+ invoice_amount = amount[1]
+ total_invoice += invoice_amount
+ %>
+ ${ formatLang(invoice_amount or 0.0) }
+ %else:
+ ${'0.0'}
+ %endif
+ %if amount[2] != None and amount[0] == 'invoice':
+ ${' ('}${ formatLang(amount[2]) }${')'}
+ %endif
+ </div>
+ ## Payment
+ <div class="act_as_cell amount">
+ %if amount[0] == 'payment':
+ <%
+ payment_amount = amount[1]
+ total_payment += payment_amount
+ %>
+ ${ formatLang(payment_amount or 0.0) }
+ %else:
+ ${'0.0'}
+ %endif
+ %if amount[2] != None and amount[0] == 'payment':
+ ${' ('}${ formatLang(amount[2]) }${')'}
+ %endif
+ </div>
+ ## Credit
+ <div class="act_as_cell amount">
+ %if amount[0] == 'credit':
+ <%
+ credit_amount = amount[1]
+ total_credit += credit_amount
+ %>
+ ${ formatLang(credit_amount or 0.0) }
+ %else:
+ ${'0.0'}
+ %endif
+ %if amount[2] != None and amount[0] == 'credit':
+ ${' ('}${ formatLang(amount[2]) }${')'}
+ %endif
+ </div>
+ ## Debit
+ <div class="act_as_cell amount">
+ %if amount[0] == 'debit':
+ <%
+ debit_amount = amount[1]
+ total_debit += debit_amount
+ %>
+ ${ formatLang(debit_amount or 0.0) }
+ %else:
+ ${'0.0'}
+ %endif
+ %if amount[2] != None and amount[0] == 'debit':
+ ${' ('}${ formatLang(amount[2]) }${')'}
+ %endif
+ </div>
+ ## Manual move
+ <div class="act_as_cell amount">
+ %if amount[0] == 'manual':
+ <%
+ MM_amount = amount[1]
+ total_manual_move += MM_amount
+ %>
+ ${ formatLang(MM_amount or 0.0) }
+ %else:
+ ${'0.0'}
+ %endif
+ %if amount[2] != None and amount[0] == 'manual':
+ ${' ('}${ formatLang(amount[2]) }${')'}
+ %endif
+ </div>
+ ## balance cumulated
+ <%
+ accumulated_balance = (invoice_amount+payment_amount+credit_amount+debit_amount+MM_amount) or 0.0
+ total_accumulated_balance += accumulated_balance
+ %>
+ <div class="act_as_cell amount" style="padding-right: 1px;">${formatLang(total_accumulated_balance) }</div>
+ %if amount_currency(data):
+ ## currency balance
+ <div class="act_as_cell sep_left amount">${formatLang(line.get('amount_currency') or 0.0) }</div>
+ ## curency code
+ <div class="act_as_cell" style="text-align: right; ">${line.get('currency_code') or ''}</div>
+ %endif
+ </div>
+ %endfor
+ <div class="act_as_row lines labels">
+ ## date
+ <div class="act_as_cell first_column"></div>
+ ## period
+ <div class="act_as_cell"></div>
+ ## move
+ <div class="act_as_cell"></div>
+ ## journal
+ <div class="act_as_cell"></div>
+ ## partner
+ <div class="act_as_cell"></div>
+ ## label
+ <div class="act_as_cell">${_('Saldo')}</div>
+ ## reconcile
+ <!--div class="act_as_cell"></div-->
+ %if currency[0] != 'CRC':
+ ## invoice
+ <div class="act_as_cell amount">${currency_symbol} ${formatLang(total_invoice) }</div>
+ ## payment
+ <div class="act_as_cell amount">${currency_symbol} ${formatLang(total_payment) }</div>
+ ## credit
+ <div class="act_as_cell amount">${currency_symbol} ${formatLang(total_credit) }</div>
+ ## debit
+ <div class="act_as_cell amount">${currency_symbol} ${formatLang(total_debit) }</div>
+ ## manual move
+ <div class="act_as_cell amount">${currency_symbol} ${formatLang(total_manual_move) }</div>
+ ## balance cumulated
+ <div class="act_as_cell amount" style="padding-right: 1px;">${currency_symbol} ${formatLang(total_accumulated_balance) }</div>
+ %else:
+ ## invoice
+ <div class="act_as_cell amount">${company.currency_id.symbol} ${formatLang(total_invoice) }</div>
+ ## payment
+ <div class="act_as_cell amount">${company.currency_id.symbol} ${formatLang(total_payment) }</div>
+ ## credit
+ <div class="act_as_cell amount">${company.currency_id.symbol} ${formatLang(total_credit) }</div>
+ ## debit
+ <div class="act_as_cell amount">${company.currency_id.symbol} ${formatLang(total_debit) }</div>
+ ## manual move
+ <div class="act_as_cell amount">${company.currency_id.symbol} ${formatLang(total_manual_move) }</div>
+ ## balance cumulated
+ <div class="act_as_cell amount" style="padding-right: 1px;">${company.currency_id.symbol} ${formatLang(total_accumulated_balance) }</div>
+ %endif
+ %if amount_currency(data):
+ ## currency balance
+ %if account.report_currency_id:
+ <!--div class="act_as_cell amount sep_left">${formatLang(accumulated_balance_curr) | amount }</div-->
+ %else:
+ <div class="act_as_cell sep_left amount">${ u'-' }</div>
+ %endif
+ ## currency code
+ <div class="act_as_cell" style="text-align: right; padding-right: 1px;">${ account.report_currency_id.name if account.report_currency_id else u'' }</div>
+ %endif
+ </div>
+ </div>
+ </div>
+ <%
+ account_total_invoice += total_invoice
+ account_total_payment += total_payment
+ account_total_debit += total_debit
+ account_total_credit += total_credit
+ account_total_manual_move += total_manual_move
+ account_balance_accumulated += total_accumulated_balance
+ account_balance_accumulated_curr += account_balance_accumulated
+
+ currency_total_invoice += total_invoice
+ currency_total_payment += total_payment
+ currency_total_debit += total_debit
+ currency_total_credit += total_credit
+ currency_total_manual_move += total_manual_move
+ currency_balance_accumulated += total_accumulated_balance
+ %>
+ %endfor
+
+ <div class="act_as_table list_table" style="margin-top:5px;">
+ <div class="act_as_row labels" style="font-weight: bold; font-size: 12px;">
+ <div class="act_as_cell first_column" style="width: 300px;">${account.code} - ${account.name}</div>
+ ## label
+ <div class="act_as_cell" style="width: 302px;">${_("Saldo")}</div>
+ %if currency[0] != 'CRC':
+ ## invoice
+ <div class="act_as_cell amount" style="width: 100px;">${currency_symbol} ${ formatLang(account_total_invoice) }</div>
+ ## payment
+ <div class="act_as_cell amount" style="width: 100px;">${currency_symbol} ${ formatLang(account_total_payment) }</div>
+ ## credit
+ <div class="act_as_cell amount" style="width: 100px;">${currency_symbol} ${ formatLang(account_total_credit) }</div>
+ ## debit
+ <div class="act_as_cell amount" style="width: 100px;">${currency_symbol} ${ formatLang(account_total_debit) }</div>
+ ## manual move
+ <div class="act_as_cell amount" style="width: 115px;">${currency_symbol} ${ formatLang(account_total_manual_move) }</div>
+ ## balance cumulated
+ <div class="act_as_cell amount" style="width: 115px; padding-right: 1px;">${currency_symbol} ${ formatLang(account_balance_accumulated) }</div>
+ %else:
+ ## invoice
+ <div class="act_as_cell amount" style="width: 100px;">${company.currency_id.symbol} ${ formatLang(account_total_invoice) }</div>
+ ## payment
+ <div class="act_as_cell amount" style="width: 100px;">${company.currency_id.symbol} ${ formatLang(account_total_payment) }</div>
+ ## credit
+ <div class="act_as_cell amount" style="width: 100px;">${company.currency_id.symbol} ${ formatLang(account_total_credit) }</div>
+ ## debit
+ <div class="act_as_cell amount" style="width: 100px;">${company.currency_id.symbol} ${ formatLang(account_total_debit) }</div>
+ ## manual move
+ <div class="act_as_cell amount" style="width: 115px;">${company.currency_id.symbol} ${ formatLang(account_total_manual_move) }</div>
+ ## balance cumulated
+ <div class="act_as_cell amount" style="width: 115px; padding-right: 1px;">${company.currency_id.symbol} ${ formatLang(account_balance_accumulated) }</div>
+ %endif
+ %if amount_currency(data):
+ ## currency balance
+ %if account.report_currency_id:
+ <!--div class="act_as_cell amount sep_left" style="width: 80px;">${ formatLang(account_balance_accumulated_curr) | amount }</div-->
+ %else:
+ <div class="act_as_cell amount sep_left" style="width: 80px;">${ u'-' }</div>
+ %endif
+ ## curency code
+ <div class="act_as_cell amount" style="width: 30px; text-align: right; padding-right: 1px;">${ account.report_currency_id.name if account.report_currency_id else u'' }</div>
+ %endif
+ </div>
+ </div>
+ </div>
+ %endif
+ %endfor
+ <div class="act_as_table list_table" style="margin-top:5px;">
+ <div class="act_as_row labels" style="font-weight: bold; font-size: 12px;">
+ %if currency[0] != 'CRC':
+ <div class="act_as_cell first_column" style="width: 300px;">${_('Total for Accounts in ')} ${currency[0]}</div>
+ %else:
+ <div class="act_as_cell first_column" style="width: 300px;">${_('Total for Accounts in ')} ${company.currency_id.name}</div>
+ %endif
+ ## label
+ <div class="act_as_cell" style="width: 302px;"></div>
+ %if currency[0] != 'CRC':
+ ## invoice
+ <div class="act_as_cell amount" style="width: 100px;">${currency_symbol} ${ formatLang(currency_total_invoice) }</div>
+ ## payment
+ <div class="act_as_cell amount" style="width: 100px;">${currency_symbol} ${ formatLang(currency_total_payment) }</div>
+ ## credit
+ <div class="act_as_cell amount" style="width: 100px;">${currency_symbol} ${ formatLang(currency_total_credit) }</div>
+ ## debit
+ <div class="act_as_cell amount" style="width: 100px;">${currency_symbol} ${ formatLang(currency_total_debit) }</div>
+ ## manual move
+ <div class="act_as_cell amount" style="width: 115px;">${currency_symbol} ${ formatLang(currency_total_manual_move) }</div>
+ ## balance cumulated
+ <div class="act_as_cell amount" style="width: 115px; padding-right: 1px;">${currency_symbol} ${ formatLang(currency_balance_accumulated) }</div>
+ %else:
+ ## invoice
+ <div class="act_as_cell amount" style="width: 100px;">${company.currency_id.symbol} ${ formatLang(currency_total_invoice) }</div>
+ ## payment
+ <div class="act_as_cell amount" style="width: 100px;">${company.currency_id.symbol} ${ formatLang(currency_total_payment) }</div>
+ ## credit
+ <div class="act_as_cell amount" style="width: 100px;">${company.currency_id.symbol} ${ formatLang(currency_total_credit) }</div>
+ ## debit
+ <div class="act_as_cell amount" style="width: 100px;">${company.currency_id.symbol} ${ formatLang(currency_total_debit) }</div>
+ ## manual move
+ <div class="act_as_cell amount" style="width: 115px;">${company.currency_id.symbol} ${ formatLang(currency_total_manual_move) }</div>
+ ## balance cumulated
+ <div class="act_as_cell amount" style="width: 115px; padding-right: 1px;">${company.currency_id.symbol} ${ formatLang(currency_balance_accumulated) }</div>
+ %endif
+ </div>
+ </div>
+ %endfor
+</body>
+</html>
=== added file 'l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.py'
--- l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.py 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/report/l10n_cr_account_report_partners_ledger.py 2013-04-01 20:05:26 +0000
@@ -0,0 +1,184 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# OpenERP, Open Source Management Solution
+# Addons modules by CLEARCORP S.A.
+# Copyright (C) 2009-TODAY CLEARCORP S.A. (<http://clearcorp.co.cr>).
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import pooler
+
+from collections import defaultdict
+from report import report_sxw
+from osv import osv
+from tools.translate import _
+from datetime import datetime
+
+from openerp.addons.account_financial_report_webkit.report.partners_ledger import PartnersLedgerWebkit
+from openerp.addons.account_financial_report_webkit.report.webkit_parser_header_fix import HeaderFooterTextWebKitParser
+
+class l10n_cr_PartnersLedgerWebkit(PartnersLedgerWebkit):
+
+ def __init__(self, cursor, uid, name, context):
+ super(l10n_cr_PartnersLedgerWebkit, self).__init__(cursor, uid, name, context=context)
+ self.pool = pooler.get_pool(self.cr.dbname)
+ self.cursor = self.cr
+
+ self.localcontext.update({
+ 'get_amount': self.get_amount,
+ 'get_partner_name': self.get_partner_name,
+ 'get_accounts_by_curr': self.get_accounts_by_curr,
+ 'get_currency_symbol': self.get_currency_symbol,
+ 'get_initial_balance': self.get_initial_balance,
+ })
+
+ def get_accounts_by_curr(self, cr, uid, objects):
+ currency_names_list = []
+ accounts_curr_list = []
+ accounts_by_curr = []
+
+ for account in objects:
+ currency_name = account.report_currency_id.name
+ if currency_name not in currency_names_list:
+ currency_names_list.append(currency_name)
+
+ for currency_name in currency_names_list:
+ account_by_curr = []
+ for account in objects:
+ if account.report_currency_id.name == currency_name:
+ account_by_curr.append(account)
+ accounts_curr_list.append(account_by_curr)
+
+ i = 0
+ for currency_name in currency_names_list:
+ temp_tup = (currency_name, accounts_curr_list[i])
+ accounts_by_curr.append(temp_tup)
+ i += 1
+ print (temp_tup)
+
+ return accounts_by_curr
+
+ def get_amount(self,cr, uid, account_move_line, currency):
+ account_obj = self.pool.get('account.account').browse(cr,uid,account_move_line['account_id'])
+
+ obj_invoice = self.pool.get('account.invoice')
+ invoice_search = obj_invoice.search(cr,uid,[('move_id','=',account_move_line['move_id'])])
+ invoice = None
+ if invoice_search != []:
+ invoice = obj_invoice.browse(cr,uid,invoice_search[0])
+
+ obj_voucher = self.pool.get('account.voucher')
+ voucher_search = obj_voucher.search(cr,uid,[('move_id','=',account_move_line['move_id'])])
+
+ voucher = None
+ if voucher_search != []:
+ voucher = obj_voucher.browse(cr,uid,voucher_search[0])
+
+ res = ('none', 0.0, 0.0)
+
+ amount = 0.0
+ if currency != 'CRC':
+ amount = account_move_line['amount_currency']
+ else:
+ if account_move_line['debit'] != 0.0 :
+ amount = account_move_line['debit']
+ elif account_move_line['credit'] != 0.0 :
+ amount = account_move_line['credit'] * -1
+
+ # Invoices
+ if invoice:
+ if invoice.type == 'out_invoice': # Customer Invoice
+ res = ('invoice', amount)
+ elif invoice.type == 'in_invoice': # Supplier Invoice
+ res = ('invoice', amount)
+ elif invoice.type == 'in_refund': # Debit Note
+ res = ('debit', amount)
+ elif invoice.type == 'out_refund': # Credit Note
+ res = ('credit', amount)
+ # Vouchers
+ elif voucher:
+ if voucher.type == 'payment': # Payment
+ res = ('payment', amount)
+ elif voucher.type == 'sale': # Invoice
+ res = ('invoice', amount)
+ elif voucher.type == 'receipt': # Payment
+ res = ('payment', amount)
+ # Manual Move
+ else:
+ res = ('manual', amount)
+
+ if res[1] == None or (currency != None and res[1] == 0.0):
+ secundary_amount = (account_move_line['debit'] != 0.0) and account_move_line['debit'] or account_move_line['credit']
+ res = (res[0], 0.0, secundary_amount)
+ else:
+ res = (res[0], res[1], None)
+
+ return res
+
+ def get_partner_name(self,cr,uid,partner_name, p_id, p_ref, p_name):
+
+ res = ''
+ if p_ref != None and p_name != None:
+ res = res+p_ref+' '+p_name
+ else:
+ res = partner_name
+
+
+ return res
+
+ def get_currency_symbol(self, cr, uid, currency_name, context=None):
+ currency_obj = self.pool.get('res.currency')
+
+ currency_id = currency_obj.search(cr, uid, [('name', '=', currency_name)], context=context)[0]
+ currency = currency_obj.browse(cr, uid, currency_id)
+
+ return currency.symbol
+
+ def get_initial_balance(self, cr, uid, partner, account, filter_type, filter_data, fiscal_year, currency, context=None):
+ date_start = ''
+ initial_balance = 0.0
+
+ if filter_type == '':
+ date_start = fiscal_year.date_start
+ move_lines_id = self.pool.get('account.move.line').search(cr, uid, [('account_id', '=', account.id), ('partner_id', '=', partner), ('period_id.fiscalyear_id.date_start', '<', date_start), ('reconcile_id', '=', False)], context=context)
+ else:
+ if filter_type == 'filter_period':
+ date_start = filter_data[0].date_start
+ move_lines_id = self.pool.get('account.move.line').search(cr, uid, [('account_id', '=', account.id), ('partner_id', '=', partner), ('period_id.date_start', '<', date_start), ('reconcile_id', '=', False)], context=context)
+ elif filter_type == 'filter_date':
+ date_start = filter_data[0]
+ move_lines_id = self.pool.get('account.move.line').search(cr, uid, [('account_id', '=', account.id), ('partner_id', '=', partner), ('date', '<', date_start), ('reconcile_id', '=', False)], context=context)
+
+ move_lines = self.pool.get('account.move.line').browse(cr, uid, move_lines_id)
+
+ amount = 0.0
+ for move_line in move_lines:
+ if currency != 'CRC':
+ amount = move_line.amount_currency
+ else:
+ if move_line.debit != 0.0 :
+ amount = move_line.debit
+ elif move_line.credit != 0.0 :
+ amount = move_line.credit * -1
+ initial_balance += amount
+
+ return initial_balance
+
+HeaderFooterTextWebKitParser('report.account_financial_report_webkit.account.account_report_partners_ledger_webkit',
+ 'account.account',
+ 'addons/l10n_cr_account_financial_report_webkit/report/l10n_cr_account_report_partners_ledger.mako',
+ parser=l10n_cr_PartnersLedgerWebkit)
\ No newline at end of file
=== added file 'l10n_cr_account_financial_report_partner_ledger/report/report.xml'
--- l10n_cr_account_financial_report_partner_ledger/report/report.xml 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/report/report.xml 2013-04-01 20:05:26 +0000
@@ -0,0 +1,21 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data>
+
+ <!-- we do not use report tag has we can not set header ref -->
+ <record id="account_financial_report_webkit.account_report_partners_ledger_webkit" model="ir.actions.report.xml">
+ <field name="report_type">webkit</field>
+ <field name="report_name">account_financial_report_webkit.account.account_report_partners_ledger_webkit</field>
+ <field eval="[(6,0,[])]" name="groups_id"/>
+ <field eval="0" name="multi"/>
+ <field eval="0" name="auto"/>
+ <field eval="1" name="header"/>
+ <field name="model">account.account</field>
+ <field name="type">ir.actions.report.xml</field>
+ <field name="name">Partner Ledger Webkit</field>
+ <field name="report_rml">l10n_cr_account_financial_report_webkit/report/l10n_cr_account_report_partners_ledger.mako</field>
+ <field name="report_file">l10n_cr_account_financial_report_webkit/report/l10n_cr_account_report_partners_ledger.mako</field>
+ </record>
+
+ </data>
+</openerp>
=== added file 'l10n_cr_account_financial_report_partner_ledger/report_menus.xml'
--- l10n_cr_account_financial_report_partner_ledger/report_menus.xml 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/report_menus.xml 2013-04-01 20:05:26 +0000
@@ -0,0 +1,9 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data>
+ <menuitem icon="STOCK_PRINT" name="Partner Ledger"
+ parent="account.next_id_22" action="action_account_partners_ledger_menu_webkit"
+ groups="account.group_account_manager,account.group_account_user" id="account.menu_account_partner_ledger"/>
+
+ </data>
+</openerp>
=== added directory 'l10n_cr_account_financial_report_partner_ledger/wizard'
=== added file 'l10n_cr_account_financial_report_partner_ledger/wizard/__init__.py'
--- l10n_cr_account_financial_report_partner_ledger/wizard/__init__.py 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/wizard/__init__.py 2013-04-01 20:05:26 +0000
@@ -0,0 +1,23 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# OpenERP, Open Source Management Solution
+# Addons modules by CLEARCORP S.A.
+# Copyright (C) 2009-TODAY CLEARCORP S.A. (<http://clearcorp.co.cr>).
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import l10n_cr_partners_ledger_wizard
\ No newline at end of file
=== added file 'l10n_cr_account_financial_report_partner_ledger/wizard/l10n_cr_partners_ledger_wizard.py'
--- l10n_cr_account_financial_report_partner_ledger/wizard/l10n_cr_partners_ledger_wizard.py 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/wizard/l10n_cr_partners_ledger_wizard.py 2013-04-01 20:05:26 +0000
@@ -0,0 +1,43 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# OpenERP, Open Source Management Solution
+# Addons modules by CLEARCORP S.A.
+# Copyright (C) 2009-TODAY CLEARCORP S.A. (<http://clearcorp.co.cr>).
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import time
+
+from osv import fields, osv
+
+
+class l10n_cr_AccountReportPartnersLedgerWizard(osv.osv_memory):
+ """Will launch partner ledger report and pass required args"""
+
+ _inherit = "partners.ledger.webkit"
+ _name = "partners.ledger.webkit"
+ _description = "Partner Ledger Report"
+
+
+ def _print_report(self, cursor, uid, ids, data, context=None):
+ context = context or {}
+ # we update form with display account value
+ data = self.pre_print_report(cursor, uid, ids, data, context=context)
+ return {'type': 'ir.actions.report.xml',
+ 'report_name': 'account_financial_report_webkit.account.account_report_partners_ledger_webkit',
+ 'datas': data}
+
=== added file 'l10n_cr_account_financial_report_partner_ledger/wizard/l10n_cr_partners_ledger_wizard_view.xml'
--- l10n_cr_account_financial_report_partner_ledger/wizard/l10n_cr_partners_ledger_wizard_view.xml 1970-01-01 00:00:00 +0000
+++ l10n_cr_account_financial_report_partner_ledger/wizard/l10n_cr_partners_ledger_wizard_view.xml 2013-04-01 20:05:26 +0000
@@ -0,0 +1,30 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data>
+
+ <record id="l10n_cr_account_partner_ledger_view_webkit" model="ir.ui.view">
+ <field name="name">Partner Ledger</field>
+ <field name="model">partners.ledger.webkit</field>
+ <field name="type">form</field>
+ <field name="inherit_id" ref="account_financial_report_webkit.account_partner_ledger_view_webkit"/>
+ <field name="arch" type="xml">
+ <data>
+ <page string="Layout Options" name="layout_options" position = "replace">
+ <field name="amount_currency" invisible = "True"/>
+ </page>
+ </data>
+ </field>
+ </record>
+
+ <record id="action_account_partners_ledger_menu_webkit" model="ir.actions.act_window">
+ <field name="name">Partner Ledger</field>
+ <field name="type">ir.actions.act_window</field>
+ <field name="res_model">partners.ledger.webkit</field>
+ <field name="view_type">form</field>
+ <field name="view_mode">form</field>
+ <field name="view_id" ref="l10n_cr_account_partner_ledger_view_webkit"/>
+ <field name="target">new</field>
+ </record>
+
+ </data>
+</openerp>
=== removed directory 'l10n_cr_accounting_report_library'
Follow ups
