openerp-india team mailing list archive

["Kyle Waid - http://www.gcotech.com" <1036056@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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;

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
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):
  New

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