c2c-oerpscenario team mailing list archive

["Ferdinand @ Camptocamp" <694868@xxxxxxxxxxxxxxxxxx>]

the provided statement includes unreconciled payments and other unreconciled move lines - not what is usually called "aged receivables"
so either we call the graph "unreconciled move lines on receivables accounts" (or similar)
or we change the statetment to "aged customer invoices"

IMHO this statment (join with invoices) returns the desired  rows - all
values are (obviously)  negative using the provided statement - hence to
get a nice "upside" graph (debit - credit) should be used


SELECT line.account_id,line.partner_id ,debit-credit as balance ,line.date, reconcile_id, line.state
FROM account_move_line AS line, account_account as ac, account_invoice as ai, account_move as am
                        WHERE (line.account_id=ac.id) AND ac.type='receivable' 
                             AND ac.active and reconcile_id is null 
                             AND am.id = line.move_id 
                             AND am.id = ai.move_id

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/694868

Title:
  [6.0] finance dashboard - aged receivables wrong, unreadable- 

Status in OpenObject Addons Modules:
  Incomplete

Bug description:
  1) IMHO aged receivalbes show wrong values
per definition theses are overdue customer payments 
basically these should be only positive (or only negative) values ....
I do not understand the content of the graph

what would be of interest are unpaid and overdue receivables

2) presenting data this way gives an unreadable x-axis (data are from 1,5 years)

I suggest to limit the x-axis to 13 or 26 weeks (3 or 6 month)  + one bar for "older"