report-openoffice: random debit,credit printing

ferdinand · Joined: 17 Sep 2005 Posts: 636

we had to adapt invoices and print all unreconciled invoices

o is the invoice

Code:

..
for each="l in o.partner_id.other_move_line_ids"
..l.debit , l.credit
/for
(o.partner_id.debit-o.partner_id.credit)
...

the unreconciled invoices (moves) are printed correctly, but the balance (debit - credit returns random results - mostly the value of the last
line, rarely the correct balance, sometimes first line debit - last line credit.
the partner financial account tab shoes the correct payables and receivables

any idea ?

sraps · Joined: 09 Jul 2008 Posts: 313

1. What type (model) of object is "o"? Do you have loop on "objects" - something like:

for each="o in objects"

otherwise ...if you use "o" directly, still "printing" list of multiple objects, "o" will point to first object in a list.

2. What variable is not what you expect? (l.debit, l.credit or o.partner_id.debit-o.partner_id.credit)

Kaspars
-------------------------
http://kndati.lv

ferdinand · Joined: 17 Sep 2005 Posts: 636

it seems to be a problem starting the report from Koo
GTK and WEB work fine

ferdinand · Joined: 17 Sep 2005 Posts: 636

how can I check which parameters / context are passed to openoffice report ?

ferdinand · Joined: 17 Sep 2005 Posts: 636

setting postgresql.conf
log_statement = 'all'
shows the statements
see problem description
https://bugs.launchpad.net/openobject-client-kde/+bug/531212

sraps · Joined: 09 Jul 2008 Posts: 313

It seems, that it is related purely to Koo client. Where some extra domain is being passed...

As we do not use Koo, I am afraid I will not be able to help in this.

Kaspars
------------------------
http://kndati.lv