** 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
_______________________________________________
Mailing list: https://launchpad.net/~openerp-india
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-india
More help : https://help.launchpad.net/ListHelp
