Hi,
I'm looking for erase the "counterpart" in the general ledger.
I've tried to delete this part in this file: /usr/lib/python2.7/dist-packages/openerp/addons/account_financial_report_webkit/report/templates/account_report_general_ledger.mako

In this file i had comment all part of "counterpart" (like 3lines) --> doesn't work
Then i just deleted the file (account_report_general_ledger.mako) --> doesn't work

The PDF is still create all the general ledger. The file seems to be the wrong one.
Did i need to modify an other file may be? Which one?

Thanks for helping!

It seems the 8.0 version (did not test 7.0) of account_financial_report_webkit_xls trial balance ignores the period filter.

Querying on account codes must be done with =like instead of like.

This is fixed on the 9.0 branch: 46f806d

Hi,
I am on openerp version 7.0-20140804-231303-1 -installed via apt sources.list entry:
deb http://nightly.openerp.com/7.0/nightly/deb/ ./

The stacktrace:
http://pastebin.com/5fNiDbWb

Sorry I did not manage to find information on alternatives to resolving this problem - IRC, forums etc.
Thanks.

I thing there is an issue when using aged partner balance report.
I can not print on a specific date.

When I select the periode of June and the 22th of June a warning message is displayed.
[Field(s) until_date failed against a constraint: Clearance date must be the very last date of the last period or later.]

If I chose the month of May and the 22th of June, invoices of June are not displayed into the report.

Hi,

I've been testing MIS reports in version 7 (Backport) and experiencing performance issue when viewing the report, for ex:- below is the report I was trying to run against account move line object with more than a 1 million records. It takes more than 2 hours to present the data view..Is there something I need to be looking at..?

MIS Template

Thanks,
Naran

Problem statement

Mis builder currently uses CSS to adjust report presentation styles. This has two drawbacks:

• it is too technical for many users, steepening the learning curve
• while it works fine for HTML rendering (and PDF), it is hard to implement in excel export
• there is no mechanism to reuse styles across KPIs or reports

This is a proposal to deprecate CSS in favor of explicit style objects.

Proposed implementation

A new model mis.report.style with the following attributes (loosely inspired from CSS, but not too close in order to be easily applicable to various rendering methods):

• name (unique, required)
• color (html #RRGGBB format?)
• background-color (html #RRGGBB format?)
• font-style (normal|italic)
• font-weight (normal|bold)
• font-size (font-size:medium|xx-small|x-small|small|large|x-large|xx-large)
• indent-level: integer (>= 0)

Styles are global and shared across various reports.

mis.report.style must have a method to convert to CSS.

mis.report.style must have a method to convert to Excel through xslxwriter (OCA/reporting-engine#38) or xslwt (for report_xls).

mis.report.kpi default_css_style and css_style and becomes deprecated.

mis.report.kpi gains two new fiellds:

• style: a mis.report.style for the row style
• style_expression: an expression that returns a style name for the kpi style (TBC: is there a better idea?)

mis.report.instance.period may gain a style attribute for the column style (TBC).

Styles are applied in the following priority order:

• row (from mis.report.kpi:style)
• column (from mis.report.instance.period:style?)
• kpi (from mis.report.kpi:style_expression)

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-9.0

Modules to migrate

• account_journal_report_xls > account_journal_report - By @mreficent - #298
• account_move_line_report_xls
• account_financial_report_webkit > account_financial_report_qweb - By @jcoux - #211
• account_financial_report_webkit_xls > account_financial_report_qweb - By @jcoux - #211
• account_chart_report
• account_financial_report_horizontal - By @hbrunn - #249
• account_financial_report Not maintained
• account_tax_report_no_zeroes - Deleted as no more valid
• account_export_csv
• mis_builder - By @sbidoul - #189

Hi OCA members,

I got this error

<type 'exceptions.Exception'>,Required report does not exist: account.account_report_trial_balance_xls,<traceback object at 0x7fa771ad0ab8>

Best regards

Hi everyone,

If I not mistaken, there is template for profit and loss
(in account-financial-reporting/account_financial_report_webkit/report/templates), but there is no py file that call that template? Am I right or I just missing the where and how to call it?
I'm using odoo 8.

And then, I try to install account_financial_report_webkit in odoo 9, then it cannot find module file.
The error look like this because there is no more function called as common_report_header in odoo9 (I think)

File "/opt/odoo/extra_addons/account_financial_report_webkit/report/common_reports.py", line 29, in
from openerp.addons.account.report.common_report_header import common_report_header
ImportError: No module named common_report_header

when i test with mis_builder (9.0), i found some error at line no. 134 of "mis_report_instance_xslx.py".
show the following.

data_col_width = min(MAX_COL_WIDTH, max(*col_width.values()))
TypeError: 'int' object is not iterable

when i printed out show "col_width.values() is [10]" and not working.

help me some solution.

Thank you.

The module account_financial_report_webkit_xls exports the financial reports to Excel files.
It uses the xlwt library so it is compatible with the versions of Excel prior to 2007 which are known to support only 65536 rows per sheet.
65536 rows is a very low limit for reports such as a general ledger or partner ledger.

I propose to replace the xlwt library by openpyxl which allow to generate .xlsx files (Excel 2007+). Thus, the limit would be 1 048 576 rows.

The downside is that people with Excel versions prior to 2007 would not be able to open the files, but since Libreoffice 3.3.3+ can open the files, I don't consider that as a real problem.

Error, when print Trial Bance

execv() arg 2 must contain only strings

<type 'exceptions.TypeError'>,execv() arg 2 must contain only strings,<traceback object at 0x7fadc0ed4950>

Trace

Traceback (most recent call last):
  File "/data/opt/odoo/8.0/openerp/service/report.py", line 93, in go
    result, format = openerp.report.render_report(cr, uid, ids, object, datas, context)
  File "/data/opt/odoo/8.0/openerp/report/__init__.py", line 40, in render_report
    return registry['ir.actions.report.xml'].render_report(cr, uid, ids, name, data, context)
  File "/data/opt/odoo/8.0/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/data/opt/odoo/8.0/openerp/addons/base/ir/ir_actions.py", line 155, in render_report
    return new_report.create(cr, uid, res_ids, data, context)
  File "/opt/odoo/8.0/addons/report_webkit/webkit_report.py", line 376, in create
    result = self.create_source_pdf(cursor, uid, ids, data, report_xml, context)
  File "/data/opt/odoo/8.0/openerp/report/report_sxw.py", line 461, in create_source_pdf
    return self.create_single_pdf(cr, uid, ids, data, report_xml, context)
  File "/opt/0-community/account_financial_report_webkit/report/webkit_parser_header_fix.py", line 277, in create_single_pdf
    parser_instance=parser_instance)
  File "/opt/0-community/account_financial_report_webkit/report/webkit_parser_header_fix.py", line 153, in generate_pdf
    status = subprocess.call(command, stderr=stderr_fd)
  File "/usr/lib/python2.7/subprocess.py", line 522, in call
    return Popen(*popenargs, **kwargs).wait()
  File "/usr/lib/python2.7/subprocess.py", line 710, in __init__
    errread, errwrite)
  File "/usr/lib/python2.7/subprocess.py", line 1327, in _execute_child
    raise child_exception
TypeError: execv() arg 2 must contain only strings

Hi,

i installed the account_financial_reports_webkit without errors.
When trying to generate a trial balance or partner balance is get the following error

SyntaxError: JSON.parse: unexpected end of data at line 2 column 1 of the JSON data
https://my.domain/web/js/web.assets_backend/959b282:2965

when i go and have a look in the logs file i get the following:

[19/Aug/2015 08:42:42] "POST /web/action/load HTTP/1.1" 200 -
[19/Aug/2015 08:42:42] "POST /web/dataset/call_kw/trial.balance.webkit/fields_view_get HTTP/1.1" 200 -
[19/Aug/2015 08:42:43] "POST /web/dataset/call_kw/trial.balance.webkit/default_get HTTP/1.1" 200 -
[19/Aug/2015 08:42:43] "POST /web/dataset/call_kw/trial.balance.webkit/onchange HTTP/1.1" 200 -
[19/Aug/2015 08:42:43] "POST /web/dataset/call_kw/res.company/name_get HTTP/1.1" 200 -
[19/Aug/2015 08:42:43] "POST /web/dataset/call_kw/account.fiscalyear/name_get HTTP/1.1" 200 -
[19/Aug/2015 08:42:43] "POST /web/dataset/call_kw/account.account/name_search HTTP/1.1" 200 -
[19/Aug/2015 08:42:44] "POST /web/dataset/call_kw/account.journal/fields_view_get HTTP/1.1" 200 -
[19/Aug/2015 08:42:44] "POST /web/dataset/call_kw/account.journal/read HTTP/1.1" 200 -
[19/Aug/2015 08:42:51] "POST /web/dataset/call_kw/trial.balance.webkit/create HTTP/1.1" 200 -
WARNING import_8 openerp.models: Cannot execute name_search, no _rec_name defined on trial.balance.webkit
[19/Aug/2015 08:42:51] "POST /web/dataset/call_kw/trial.balance.webkit/search_read HTTP/1.1" 200 -
[19/Aug/2015 08:42:52] "POST /web/dataset/call_button HTTP/1.1" 200 -
[19/Aug/2015 08:42:52] "POST /web/dataset/call_kw/account.journal/read HTTP/1.1" 200 -
openerp.pooler: openerp.pooler.get_db_and_pool() is deprecated.
openerp.pooler: openerp.pooler.get_db_and_pool() is deprecated.
openerp.service.report: Exception: Missing account or period_ids
openerp.addons.web.controllers.main: An exception occured during an http request
openerp.http: returns an invalid response type for an http request
[19/Aug/2015 08:42:56] "POST /web/report HTTP/1.1" 500 -

When i look this error up, i found that every class should have a name attribute but this doens't seem to be correct.

Anyone has any pointers ?

Thnx in advance

MIS reports not installed, stuck while installing

If you install this module for the first time, the migration script will not be executed (in the older version this code section was under the method "def init" in account_move_line.py file and then it worked). Could you please explain me if or how it should work? or if the first installation has to be done somehow special? Or does it depend on the version of the odoo server?

Best regards

This occurs when exported from the wizard to xls, the report does not print correctly balance column.

Checking the report learn that the formula that calculates the total balance of the line, makes miscalculations because they do not have the initial balance column so goes the "D", and column takes Code / Ref.

Hello.

In vauxoo @hbto is planning migrate account_financial_report (the one which render with reportlab) to QWEb in order to maintain one set of reports with the official report engine, and considering some points that will need to be necessary to improve for v9.0.

The Idea is set this issue as open until we finish the job which will be done on this fork and is being planned to be done for next week.

• Somebody started this job?.
• Some ideas about what need to be improved are welcome (if any).

Regards.

How to reproduce:

Enable the following checkbox in the Open Invoices report wizard:

This is due to the method _group_lines_by_currency that is not migrated (it still tries to create a non-existant attribute grouped_ledger_lines).

I'm just reporting to warn about the bug presence, I have no time to fix it right now.

Travis fails because of broken test.

The modules in this repo need to be reviewed. There are many instances where the code can be cleaned up. Here is a small list.

• Long, indented functions
• Missing context propagations
• Non-english comments
• Non-english/non-translatable strings to the end-user
• Non-english variable names
• Coverage needs to be increased
• Duplicated code which can be factored
• A lot of commented out code

When generating the Aged Partner Balance report, we want to choose the date to compute the age of the invoices. The age could be based on:

• the invoice date
• the due date

Mockup of the wizard:

Hi, I was confronted to an hour-long module update on a large database, and realized that in that module we have a stored function field last_rec_date, which is recomputed by the init method of AccountMoveLine.

The SQL queries on init try to recompute the field on all records where it is null, which could already be the correct value. In my case I have 3 million move lines with last_rec_date null.

Are we sure that we need these queries in init?

Thanks!

The trial balance or general ledger generated from account_financial report_webkit do not show the proper Account Names for existing and renamed accounts from the Chart of Accounts. It shows instead their original names, which I don't know where it gets those from.

This behaviour only happens for existing accounts that have been renamed. Newly created accounts are displayed fine.

Odoo's original Trial Balance/General Ledger has no such issue, and every account name is displayed properly (both newly created or existing and renamed accounts).

I tried to install this module several different ways to odoo 8 stable nightly and it fails with no error. In the server log is this error:
Error details:
Field centralized does not exist

Error context:
View account.account.form.webkit

Hi,

Maybe it can't be consider an issue but i think is dangerous, the general method "_compute_init_balance" sum all move lines in the first special period but it doesn't check the state of its move, maybe we have to rewrite the query of this method from

self.cursor.execute("SELECT sum(debit) AS debit, sum(credit) AS credit, sum(debit)-sum(credit) AS balance, sum(amount_currency) AS curr_balance FROM account_move_line WHERE period_id in %s AND account_id = %s", (tuple(period_ids), account_id))

to

self.cursor.execute("SELECT sum(debit) AS debit, sum(credit) AS credit, sum(debit)-sum(credit) AS balance, sum(amount_currency) AS curr_balance FROM account_move_line INNER JOIN account_move on account_move_line.move_id = account_move.id WHERE account_move_line.period_id in %s AND account_id = %s AND account_move.state = 'posted'", (tuple(period_ids), account_id))

What do you think?
Regards

Hello,
I'll be porting those three modules for V8:
account_chart_report,
account_move_line_report_xls
account_journal_report_xls

Is there anyone already working on that?
Guillaume

Hi all,
I just checked only

account_tax_report_no_zeroes

But I think all modules here are only for v8 and not v9

Trial Balance, not show the amount in column debit and credit

When a mis.report.query has the aggregate function set to Sum and there are non-stored fields selected, it does not work, because Odoo's group by function does not support non-stored fields.

In presence of such fields, it must fallback transparently on the the searc_read method.

This can be done by testing the presence of non-stored fields here:

Hello,

wkhtmltopdf has moved the downloads provider from SourceForge to gna.org. As mentioned in the linked message, all earlier downloads have been removed from SourceForge and you are strongly advised to migrate to the new URLs. The following files in your repository will need to be updated:

• .travis.yml

It is recommended to either subscribe to the mailing list or Twitter feed to receive updates on new releases and further changes.

Thanks,
wkhtmltopdf maintainer

Impacted version :

• 7.0
• 8.0

Steps to reproduce :
0. Install module account_financial_report_webkit

1. Get alot of journal entries
2. Ask for a general ledger report with 'All posted Entries' as target moves
3. Wait for a loooong time

In the following file : https://github.com/OCA/account-financial-reporting/blob/7.0/account_financial_report_webkit/report/common_reports.py#L440

search on account_move_line are done with orm.
I think the following part is responsible of performance problem : [('move_id.state', '=', 'posted')]

Hello
Please, in the migrate method of account_financial_report_webkit, consider moving the reconcile_id/reconcile_partial_id not null check outside from the inner select.
In densely populated DDBB the query launches the inner select hundreds of thousand times for account_move_lines without reconcile_id nor reconcile_partial_id
Example:

UPDATE account_move_line as acm 
SET last_rec_date =
    (SELECT date from account_move_line
    WHERE reconcile_id =  acm.reconcile_id
    ORDER BY date DESC LIMIT 1)
WHERE last_rec_date is null and acm.reconcile_id IS NOT NULL;

Using the 7.0 branch of the account_financial_report_webkit module with openerp 7.0 (7.0-20140804-2) and wkhtmltopdf 0.12.1, printing a webkit financial report, such as General Ledger or Trial Balance results in a TypeError: translate_call() takes exactly 2 arguments (3 given).

Full traceback:

Webkit render

Traceback (most recent call last):
File "/opt/openerp/7.0/account-financial-reporting/account_financial_report_webkit/report/webkit_parser_header_fix.py", line 252, in create_single_pdf
**parser_instance.localcontext)
File "/usr/lib/python2.7/dist-packages/mako/template.py", line 397, in render
return runtime._render(self, self.callable_, args, data)
File "/usr/lib/python2.7/dist-packages/mako/runtime.py", line 764, in _render
**_kwargs_for_callable(callable_, data))
File "/usr/lib/python2.7/dist-packages/mako/runtime.py", line 796, in _render_context
_exec_template(inherit, lclcontext, args=args, kwargs=kwargs)
File "/usr/lib/python2.7/dist-packages/mako/runtime.py", line 822, in _exec_template
callable_(context, *args, **kwargs)
File "memory:0xb292b10", line 22, in render_body
<%
TypeError: translate_call() takes exactly 2 arguments (3 given)

We cannot port to v9 current reports as it is now in v8. The issue described here in details :
https://docs.google.com/document/d/1rB06fD5eF315oi6wXT0r8gOZyjL28QYEMIdxskpbxac/edit#

2 comments:

• We woud like to merge vauxoo reports with the current OCA financial reports in this branch since the goal is the same.
• Camptocamp has started some work (Port of the general ledger as example) and a PR will come very soon from @yvaucher

Hi,

The aged partner balance report is not aging correctly when partial allocations exists, the invoice amount is aged at the original amount and the partial allocation is completely ignored becuase it won't have any due date. Below are the screen shots ;- In the example, the invoice INV/6623 is allocated partially for the amount $648.96 and when the report is run, the aging has ignored the partial allocation and ages with the full amount.

1. Partial allocation

2. Aged partner balance - Detail List

Dear all,

I hope that this is the right place/module to post. I know OpenERP 6.04 very well and recently installed OCB 8.0 and 9.0 (as Odoo is becoming proprietary).

Please pardon my ignorance if this feature is already present in OCB.

When closing a year, accountants print a general balances with:

• Opening values
• Debit
• Credit
• Closing values

This allows to verify that the opening values are the same as in the end of the previous year and compare the balance with fiscal declarations (results, VAT, etc ...). In case of fiscal inquiry by the administration, such a balance is requested. It is a legal issue.

OCB can print a general balance with debit, credit and balance (in the end of the year). But we need also:

• opening values (including opening journal)
• closing values

Commercial software always print opening and closing values.
I suspect this feature is needed in every country and it would help a lot of people.

Odoo company never did the job of working on a compliant accounting, so I may pick-up myself this issue inside OCA. Please pick it up if you are interested.

Feel free to include this kind of report in the SPEC around accounting rework. I will join the accounting group later, sorry I could not attend the 2016/sprint in Italy (as I was not aware).

Kind regards,
Kellogs

Example: when printing the Aged Partner Balance in french, "Balance âgée des tiers" causes an execv() exception or is misprinted. The exact behaviour seems to depend on the locale under which the server runs.

This is due to this title being passed as a --header-left argument to wkhtmltopdf.

Does anyone knows if there is some best practice in this respect?

Problem statement

With large reports, such as a complete chart of account it can be desirable to express a parent/child relationship between KPI's and let the user fold/unfold parent KPI's on screen when using the mis builder widget.

Implementation proposal: backend

Add fields on mis.report.kpi

• parent_id
• fold_default: open|closed (default open)

A parent/child relationship does not imply any automatic computation.

The parent/child relationship may influence/enforce ordering of kpi's.

Implementation proposal: UI

• display folding icons (only if a KPI has children)
• automatically indent row labels based on parent-child relationship

Further possible improvements to be investigated

• it may be useful to provide the list of children kpi values in the computation context of a kpi
• it may be useful to improve the computation algorithm to compute children before parents, knowing that in many circumstances a visual folding implies a dependency on the children values

Provide an aged partner balance report with invoice details:

Mockup of the wizard:

This is fixed on the 9.0 branch: 4dd0aec

After having installed the module, I can't see any MIS example in the "MIS reports" menu

Did I miss something ?

Thanks

/account_financial_report_webkit/report/print_journal.py", line 129, in set_context
objects.sort(key=lambda a: (a.journal_id.code, a.period_id.date_start))
AttributeError: 'account.journal.period' object has no attribute 'sort'

Hi,

I am new to odoo and want to know if there is any drill down feature in this addon.
Could we click any of the output lines and go to the accounting entries screen?

Thanks a lot~

Mike

Hi,

When installing and running our internal unitests on the module account_financial_report_webkit_xls
in V7 of odoo I encountered such an error.

2014-11-21 22:39:02,552 27213 ERROR (_textremoved_)-Tests openerp.tools.yaml_import: ('Webkit error', 'The command 'wkhtmltopdf' failed with error code = 1. Message: The following diagnosis message was provided:\nThe switch --header-font-name, is not support using unpatched qt, and will be ignored.The switch --footer-font-name, is not support using unpatched qt, and will be ignored.Unable to load library icui18n "Cannot load library icui18n: (libicui18n.so.48: cannot open shared object file: No such file or directory)" \nThe switch --header-font-size, is not support using unpatched qt, and will be ignored.The switch --footer-font-size, is not support using unpatched qt, and will be ignored.The switch --header-left, is not support using unpatched qt, and will be ignored.The switch --header-spacing, is not support using unpatched qt, and will be ignored.The switch --footer-left, is not support using unpatched qt, and will be ignored.The switch --footer-right, is not support using unpatched qt, and will be ignored.The switch --footer-line, is not support using unpatched qt, and will be ignored.wkhtmltopdf: cannot connect to X server \n')

I'm not sure if this issue is covered unde your comment in the module that stated :

HTML headers and footers are deactivated for these reports because of
an issue in wkhtmltopdf
(http://code.google.com/p/wkhtmltopdf/issues/detail?id=656) Instead,
the header and footer are created as text with arguments passed to
wkhtmltopdf. The texts are defined inside the report classes.
""",
'version': '1.1.0',
'author': 'Camptocamp',

1. The link http://code.google.com/p/wkhtmltopdf/issues/detail?id=656 is broken
2. Can anyone provide additional feedback, I'm more on the functional than technical side of things.

Thanks in advance,
William

Messege: account_financial_report_webkit_xls/report/trial_balance_xls.py", line 254, in generate_xls_report
comparisons = current_account.comparisons

Hello,

We need to extend the mis_builder to handle what we call 'Operating Units', a new concept explained here:
https://docs.google.com/document/d/1iF2tKqCGjpZhTABU4oBT62sM08JFuNBXOtChbOSyBXQ/edit?usp=sharing

And corresponding repo here:
https://github.com/Eficent/odoo-operating-unit

We intend to use Mis_builder to filter a P&L or Balance Sheet by one or more specific operating units.

The problem we're facing is that in order to do that we must change the method 'get_aml_domain_for_dates' of class 'AccountingExpressionProcessor'. But since class 'AccountingExpressionProcessor' derives from 'object' and not from models.AbstractModel, we cannot call super in this method, fetch the values and then extend it with additional domain content. We can only monkey patch this method.

Any ideas of how to overcome this @sbidoul ?

Openerp 7.0 with all the code updated.

With wkhtmltopdf 0.12.2.1, webkit reports cut some rows at half at page breaks.

The same with 0.12.1 version doesn't cut rows.

I had this crash when clicking on the "Print" button of a Trial balance in a company that has an accentuated character in its name:

2016-05-29 23:02:23,672 1981 INFO absamad werkzeug: 192.168.10.201 - - [29/May/2016 23:02:23] "POST /web/dataset/call_kw/account.journal/read HTTP/1.0" 200 -
2016-05-29 23:02:24,022 1981 WARNING absamad openerp.pooler: openerp.pooler.get_db_and_pool() is deprecated.
2016-05-29 23:02:24,070 1981 WARNING absamad openerp.pooler: openerp.pooler.get_db_and_pool() is deprecated.
2016-05-29 23:04:16,417 1981 INFO absamad financial.reports.webkit: DEBUG ALEXIS command=['/usr/local/bin/wkhtmltopdf', '--quiet', '--encoding', 'utf-8', '--margin-top', '17.0', '--margin-bottom', '15.0', '--orientation', 'Portrait', '--page-size', 'A4', '--header-font-name', 'Helvetica', '--footer-font-name', 'Helvetica', '--header-font-size', '10', '--footer-font-size', '6', '--header-left', u'BALANCE DES COMPTES - Monast\xe8re Sainte-Madeleine - EUR', '--header-spacing', '2', '--footer-left', '30/05/2016 01:02:24', '--footer-right', u'Page [page] de [topage]', '--footer-line', '/tmp/tmpRth7M90.body.html', '/tmp/webkit.tmp.QPX1Ic.pdf']
2016-05-29 23:04:16,451 1981 ERROR absamad openerp.service.report: Exception: execv() arg 2 must contain only strings
Traceback (most recent call last):
  File "/home/openerp/erp/odoo/openerp/service/report.py", line 93, in go
    result, format = openerp.report.render_report(cr, uid, ids, object, datas, context)
  File "/home/openerp/erp/odoo/openerp/report/__init__.py", line 40, in render_report
    return registry['ir.actions.report.xml'].render_report(cr, uid, ids, name, data, context)
  File "/home/openerp/erp/odoo/openerp/api.py", line 256, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/openerp/erp/odoo/openerp/addons/base/ir/ir_actions.py", line 156, in render_report
    return new_report.create(cr, uid, res_ids, data, context)
  File "/home/openerp/erp/odoo/addons/report_webkit/webkit_report.py", line 377, in create
    result = self.create_source_pdf(cursor, uid, ids, data, report_xml, context)
  File "/home/openerp/erp/odoo/openerp/report/report_sxw.py", line 464, in create_source_pdf
    return self.create_single_pdf(cr, uid, ids, data, report_xml, context)
  File "/home/openerp/erp/account-financial-reporting/account_financial_report_webkit/report/webkit_parser_header_fix.py", line 279, in create_single_pdf
    parser_instance=parser_instance)
  File "/home/openerp/erp/account-financial-reporting/account_financial_report_webkit/report/webkit_parser_header_fix.py", line 155, in generate_pdf
    status = subprocess.call(command, stderr=stderr_fd)
  File "/usr/lib/python2.7/subprocess.py", line 522, in call
    return Popen(*popenargs, **kwargs).wait()
  File "/usr/lib/python2.7/subprocess.py", line 710, in __init__
    errread, errwrite)
  File "/usr/lib/python2.7/subprocess.py", line 1327, in _execute_child
    raise child_exception
TypeError: execv() arg 2 must contain only strings
2016-05-29 23:04:16,719 1981 ERROR absamad openerp.addons.web.controllers.main: An exception occured during an http request
Traceback (most recent call last):
  File "/home/openerp/erp/odoo/addons/web/controllers/main.py", line 70, in wrap
    return f(*args, **kwargs)
  File "/home/openerp/erp/odoo/addons/web/controllers/main.py", line 1586, in index
    request.session.db, request.session.uid, request.session.password, report_id)
  File "/home/openerp/erp/odoo/openerp/http.py", line 879, in proxy_method
    result = dispatch_rpc(self.service_name, method, args)
  File "/home/openerp/erp/odoo/openerp/http.py", line 115, in dispatch_rpc
    result = dispatch(method, params)
  File "/home/openerp/erp/odoo/openerp/service/report.py", line 34, in dispatch
    res = fn(db, uid, *params)
  File "/home/openerp/erp/report-print-send/base_report_to_printer/report_service.py", line 86, in exp_report_get
    return original_exp_report_get(db, uid, report_id)
  File "/home/openerp/erp/odoo/openerp/service/report.py", line 141, in exp_report_get
    return _check_report(report_id)
  File "/home/openerp/erp/odoo/openerp/service/report.py", line 119, in _check_report
    raise openerp.osv.orm.except_orm(exc.message, exc.traceback)
except_orm: (u'execv() arg 2 must contain only strings', (<type 'exceptions.TypeError'>, TypeError('execv() arg 2 must contain only strings',), <traceback object at 0x7f7678dcce60>))
2016-05-29 23:04:16,749 1981 INFO absamad werkzeug: 192.168.10.201 - - [29/May/2016 23:04:16] "POST /web/report HTTP/1.0" 500 -
2016-05-29 23:04:16,953 1980 INFO ? werkzeug: 192.168.10.201 - - [29/May/2016 23:04:16] "GET /web/static/src/img/warning.png HTTP/1.0" 304 -

The error message says "execv() arg 2 must contain only strings" ; it is probably caused by the fact that one of the arguments of command is unicode and not string. It is this post that help me spot the issue: http://stackoverflow.com/questions/30235962/how-do-i-fix-this-error-execv-arg-2-must-contain-only-strings-in-openerp-7-w

The option --header-left comes from the key additional_args in self.localcontext. It is set by account_financial_report_webkit/report/trial_balance.py line 63.

I don't know what is the real solution to this problem. I first tried a patch to encode in utf8 the elements of the "command" variable ; it avoids the crash, but the accentuated caracters are absent from the header. My second patch uses unidecode to replace the accentuated char by the equivalent regular char ; it is certainly not the right solution to this issue, but at least it works.

The Webkit partner ledger report in OpenErp 7 does not have the option box "one partner per page". Can this option be added as in the original OpenErp partner ledger report?