Merge lp:~openerp-dev/openobject-addons/6.1-opw-574929-ado into lp:openobject-addons/6.1

Proposed by Amit Dodiya (OpenERP)
Status: Approved
Approved by: Vinay Rana (OpenERP)
Approved revision: 6805
Proposed branch: lp:~openerp-dev/openobject-addons/6.1-opw-574929-ado
Merge into: lp:openobject-addons/6.1
Diff against target: 13 lines (+3/-0)
1 file modified
l10n_be/wizard/ (+3/-0)
To merge this branch: bzr merge lp:~openerp-dev/openobject-addons/6.1-opw-574929-ado
Reviewer Review Type Date Requested Status
Vinay Rana (OpenERP) (community) Approve
Xavier ALT Pending
Naresh(OpenERP) Pending
Review via email:

Description of the change


"[FIX] Error while opening the Annual Listing Of VAT-Subjected Customers wizard due to no customers while fetching data"

1). Install l10n_be module
2). Goto : Accounting/Reporting/Legal Reports/Belgium Statements
3). Open wizard "Annual Listing Of VAT-Subjected Customers" Without configuration of VAT number in customers.


To post a comment you must log in.
Revision history for this message
Vinay Rana (OpenERP) (vra-openerp) wrote :

The patch will solve the issue.

review: Approve
Revision history for this message
Naresh(OpenERP) (nch-openerp) wrote :


This bug was qualified as Confirmed on Trunk (means still existing and reproducible). A Merge Proposal for trunk was created to fix it. Here is the link to follow the MP on Launchpad and be informed once it's been merged in trunk: ... If this Merge Proposal could not be merged in v6.1 at the release of v7.0, it will be closed.

Naresh Soni

Unmerged revisions

6805. By Amit Dodiya<email address hidden>

[FIX] Error while opening the Annual Listing Of VAT-Subjected Customers wizard due to no customers while fetching data

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'l10n_be/wizard/'
2--- l10n_be/wizard/ 2012-02-15 13:18:16 +0000
3+++ l10n_be/wizard/ 2012-05-18 05:52:18 +0000
4@@ -65,6 +65,9 @@
6 partners = []
7 partner_ids =, uid, [('vat_subjected', '!=', False), ('vat','ilike','BE%')], context=context)
8+ if not partner_ids:
9+ raise osv.except_osv(_('Data Insufficient!'), _('No partner has a VAT Number associated with him.'))
11 cr.execute("""SELECT sub1.partner_id,, sub1.vat, sub1.turnover, sub2.vat_amount
12 FROM (SELECT l.partner_id,, p.vat, SUM(CASE WHEN c.code ='49' THEN -l.tax_amount ELSE l.tax_amount END) as turnover
13 FROM account_move_line l