The backport of v6 financial reports on the v5 is now available here
http://bazaar.launchpad.net/~openerp-commiter/openobject-addons/trunk-extra-addons/files/head%3A/account_v6_reports_backport.
Installing this module will replace the existing version of the main accounting
reports with more accurate and more user friendly ones.
So i'm closing this bug which is related to v5 only. If you found new
bugs in the report of v6, please create a new bug report.
Thank you,
Quentin
** Changed in: openobject-addons
Status: Confirmed => Fix Released
--
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/583666
Title:
Financial Report Minimal Requierement for 5.0
Status in OpenObject Addons Modules:
Fix Released
Bug description:
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
:https://bugs.launchpad.net/openobject-addons/+bug/551630 will be for 6.0.
1. All financial reports
---------------------------
Wizard changes for balance sheet & general ledger & journal printing & partner
ledger (qdp)
----------------------------------------------------------------------------------------------------------------------------------------
Filter :
Filters have to be refactorized and period filters isn't working.
We need those filter :
- 'start date end date' and 'start period and end period'.
- 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 (al)
-----------------------
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
--> AL is working on this.
For 6.0 version (qdp's team)
-------------------------
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+
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
