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/l10n_be_partner_vat_listing.py (+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: mp+106310@code.launchpad.net

Description of the change

Hello,

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

Steps:
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.

Regards,
Amit

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 :

Hello,

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 https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-opw-574929-port-mma/+merge/132323 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.

Thanks,
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/l10n_be_partner_vat_listing.py'
2--- l10n_be/wizard/l10n_be_partner_vat_listing.py 2012-02-15 13:18:16 +0000
3+++ l10n_be/wizard/l10n_be_partner_vat_listing.py 2012-05-18 05:52:18 +0000
4@@ -65,6 +65,9 @@
5
6 partners = []
7 partner_ids = obj_partner.search(cr, 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.'))
10+
11 cr.execute("""SELECT sub1.partner_id, sub1.name, sub1.vat, sub1.turnover, sub2.vat_amount
12 FROM (SELECT l.partner_id, p.name, 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