report-openoffice: random debit,credit printing

ferdinand · **Joined:** Sat Sep 17, 2005 7:51 pm **Posts:** 648

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:** Wed Jul 09, 2008 6:31 pm **Posts:** 441

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:** Sat Sep 17, 2005 7:51 pm **Posts:** 648

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

ferdinand · **Joined:** Sat Sep 17, 2005 7:51 pm **Posts:** 648

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

ferdinand · **Joined:** Sat Sep 17, 2005 7:51 pm **Posts:** 648

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

sraps · **Joined:** Wed Jul 09, 2008 6:31 pm **Posts:** 441

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