OpenERP Addons (modules)

Comment 12 for bug 551630

Hi,

This is a Bug report on Financial reporting of OpenERP that has to be fixed for 5.0 in order to be "usable" in a real accounting context. All the following comments has been discussed with Fabien Pinckaers, Luc Maurer, Quentin De Paoli, and me.

We decided to fix those minimal requirements (fixes or improvements) in the stable and all "nice-to-have" for the 6.0. This bug report will be for 6.0. Here you find the one for 5.0 : https://bugs.launchpad.net/openobject-addons/+bug/583666

1. All financial reports
---------------------------
---------------------------

Wizard changes for all financial report
------------------------------------------------
Filter :
Filters have to be refactorized and period filters isn't working. Every reports should have same filtering options.
We need those filter :
- 'start date end date' and 'start period and end period'.
- No need for both options (the m2m period+date) => only by date / by period / none => by default “none”
- Period really based on period and not on dates => actually the filter by period does not consider period, but date of periods…. Select must be done on periode_id IN (ids).

IMPROVE SPEED
-----------------------
100'000 Account move line should be printed out in less than the OpenERP-Client timeout !

Especially in :
- the General Ledger
- the Aged Partner Balance

2.Account balance
------------------------
------------------------

Mandatory/bugs => 5.0.11
----------------------------------
Wizard:
Change filter like chapter 1

For 6.0 version
-------------------------
Wizard:
- add an option to have a new column “currency balance amount” => amount and currency code => check box
- add comparison with other fiscal year

Presentation:
- Add “currency balance amount” and “currency code” columns if related check box is active

3.General ledger
---------------------
---------------------

Mandatory/bugs => 5.0.11
----------------------------------
Presentation:
- Replace “balance amount” by “cumulative balance amount” and make a cumulative total for each line

For 6.0 version
-------------------
- add “with opening balance" => to have a new line with the sum of all entries that are before the begin date/periode used for the filter
- Use the “Display history” check box => add a new select field (see quentin notes)

4.Partner balance
---------------------------
---------------------------

Mandatory/bugs => 5.0.11
----------------------------------
Wizard:
- Set the default value for “fiscal year” = actual fiscal year (year that contain the actual date).
- add "balance date" => by default = actual date
- add new option for the moves selection : “partner with movement / balance <> 0 / all” => by default = “balance <>0”
- add a new check box “with starting balance” => by default “true” that report the starting balance
- Make it also available on the partner (automatic selection of the partner) => important to have good informations (take care if multi-selection to select all)

Presentation :
- same layout than general ledger and account balance

Calculation:
- selection of client vs supplier accounts based on the internal account type
- add a new computed field “rec_max_date” on account_move_line which is False if not fully reconciled => if fully reconciles = the max date of all the entries with same reconcile number of this entry line => to know when it has been paid because you have to know what was exactly the situation at a given time (!!! Do not use the reconciliation date !!!)

The value are the SUM of move_line that
- account internal type = client and/or supplier (depending the choice made by the user)
- and journal/period <> “End of year entry journal” (see fiscal year)
- and move_line.date = into the selected fiscal year
- and move_line.date >= begin date/period and move_line.date <= end date/period
- if “with starting balance” = true => or move_line.date < begin date/period and (rec_max_date = false or rec_max_date > “balance date”)
- sum of debit, credit, debit-credit => total by account and by partners

5.Partner ledger
---------------------
---------------------

Mandatory/bugs => 5.0.11
---------------------------
Wizard:

- By default the value for “fiscal year” = actual fiscal year (year that contain the actual date).
- add "balance date" (situation at date…)=> by default = actual date
- add new option for the moves selection “partner with movement / balance <> 0 / all => by default = “balance <>0”
- add a new check box “with starting balance” => by default “true”
Make it also available on the partner (automatic selection of the partner) => important to have good informations (take care if multi-selection to select all)

Presentation :
- same layout than general ledger and account balance

Calculation :

The value are the LIST of move_line that
- account internal type = client and/or supplier (depending the choice made by the user)
- and journal/period <> “End of year entry journal” (see fiscal year)
- and move_line.date = into the selected fiscal year
- and move_line.date >= begin date/period and move_line.date <= end date/period
- if “with starting balance” = true => or move_line.date < begin date/period and (rec_max_date = false or rec_max_date > “balance date”)
- if “Include reconcile entries” = false => and (rec_max_date = false or rec_max_date > “balance date”)
- group by partners

For 6.0 version
--------------------

- Add sort option (date, entry number, amount, due date)
- Add choice “open amount only / paid amount only / all entries” to replace the “Include reconcile entries”

6.Aged partner ledger
---------------------------
---------------------------

Mandatory/bugs => 5.0.11
-----------------------------------
Wizard:

- By default the value for “fiscal year” = actual fiscal year (year that contain the actual date).
- Add filter option like all other financial reports
- Add a new check box “with starting balance” => by default “true”
- Rename “Sart of period" with "balance date" to be consistent with other reports.

Calculation:

It should be based on “Maturity date” (not “effective date”). If the maturity date is empty => use the effective date.

The value are SUM of move_line that:

- account internal type = client and/or supplier (depending the choice made by the user)
- and journal/period <> “End of year entry journal” (see fiscal year)
- and move_line.date = into the selected fiscal year
- and move_line.date >= begin date/period and move_line.date <= end date/period
- if “with starting balance” = true => or move_line.date < begin date/period and (rec_max_date = false or rec_max_date > “balance date”)
- group by partners and by group of Maturity date

Presentation:

The last column of the report must show the sum from last period to infinite, do not limit it with another period min or max. Example:

- Today: 30-60, 60-90, 90-120, 120-150

- Correct is : 30-60, 60-90, 90-120, 120+