openerp-india team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

** Changed in: openobject-addons
       Status: Expired => Invalid

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1036056

Title:
  [6.1] periodical processing, > send followup email

Status in OpenERP Addons (modules):
  Invalid

Bug description:
  There is a bug in the postgres view. I pasted the code for the view
  below. I am unsure why this view is generated this way. You see the
  very first select,  SELECT l.partner_id * 10000 + l.company_id AS id,
  When you SELECT l.partner_id * 10000 it will give error from postgres.
  integer is out of range. Working if I change the value to 1000


  -- View: account_followup_stat_by_partner

  -- DROP VIEW account_followup_stat_by_partner;

  CREATE OR REPLACE VIEW account_followup_stat_by_partner AS 
   SELECT l.partner_id * 10000 + l.company_id AS id, l.partner_id, min(l.date) AS date_move, max(l.date) AS date_move_last, max(l.followup_date) AS date_followup, max(l.followup_line_id) AS max_followup_id, sum(l.debit - l.credit) AS balance, l.company_id
     FROM account_move_line l
     LEFT JOIN account_account a ON l.account_id = a.id
    WHERE a.active AND a.type::text = 'receivable'::text AND l.reconcile_id IS NULL AND l.partner_id IS NOT NULL
    GROUP BY l.partner_id, l.company_id;

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1036056/+subscriptions