c2c-oerpscenario team mailing list archive

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

Sorry, I do not understand and can not agree to provide wrong
information to accountants!

OpenERP loses credibility providing wrong or unusable information - the
worst scenario we need.

account_report.py

class report_aged_receivable(osv.osv):

1) SUM(credit-debit) is wrong - receivables are always debit-credit !!!

2) "aged" means overdue - this is not checked
hence either the title or the code must be changed!

3) the data returned seem to be wrong

the simplified report statement

SELECT SUM(credit-debit),date FROM account_move_line AS line, account_account as ac
                        WHERE (line.account_id=ac.id) AND ac.type='receivable'
                            AND (reconcile_id IS NULL) AND ac.active group by line.date
;
returns exactly 2 (correct) lines  but with wrong sign - see (1)
    sum    |    date    
-----------+------------
  -6720.00 | 2008-12-31
 -15918.00 | 2010-10-29


the graph returns weekly values back to 2005 - no idea what is calculated here

-- 
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:
  Won't Fix

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"