openerp-expert-accounting team mailing list archive

[Joël Grand-Guillaume @ CampToCamp <joel.grandguillaume@xxxxxxxxxxxxxx>]

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+



** Summary changed:

- Financial reports to review
+ Financial reports to review for 6.0

-- 
Financial reports to review for 6.0
https://bugs.launchpad.net/bugs/551630
You received this bug notification because you are a member of OpenERP
Accounting Experts, which is a direct subscriber.

Status in OpenObject Addons Modules: Confirmed

Bug description:
Hello,

As discuss during the community days, all financial reports have to be reviewed.

The list of modification has been created by Quentin, please ask him for more information => here are the most important things to change :

== Account balance  ==

 * Wizard
     * add currency balance amount => check box
     * add comparison with other fiscal year
     * filter => only by date / by periode / none => from ... to for both date and period (period really based on period and not on dates) 
     * filter => dependant to the fiscal year (only see period related to the fiscal year selected)

* Calculation
     * sum of all entries related to the account into the date filter selection

== General ledger ==
 * Wizard
     * add “with opening balance" => to have a new line with the sum of all entries that are before the begin date/periode
     * Use the “Display history” check box => add a new select field (see quentin notes)
     * add cumulative balance column

Calculation
     * list of all entries related to the account into the date filter selection

== Partner balance ==
* Wizard
     * add "balance date"
     * add new selection “partner with movement / balance <> 0 / all
     * Also available on the partner (automatic selection of the partner) => important if multi selection

* Calculation
     * selection of client vs supplier based on the internal account type
     * sum of all entries related to the account into the date filter selection group by partners

== Partner ledger ==
 * Wizard
     * add "balance date"
     * add new selection “partner with movement / balance <> 0 / all
     * Add choice “open amount only / paid amount only / all entries”
     * Add sort option (date, entry number, amount, due date)
     * Also available on the partner (automatic selection of the partner)

* Calculation
     * add store field “last pmt date” => define if paid or date at a specific date
     * selection of client vs supplier based on the internal account type
     * list of entries group by client