Financial Mgmt: Balance does not sum up in General Ledger report

[Ruud Riem-Vis]

In OpenERP v5.0.2, the General Ledger report generated from "Financial Management->Legal Statements->Generic Reports->General Ledger" show the "Balance" column as being "Debit" - "Credit" for each line instead of a running sum: Balance[i] = Balance[i-1] + Debit[i] - Credit[i] (for i>0) and Balance[0] = Debit[0] - Credit[0].
This makes it impossible to intermediate balance with bank statement for example.

[Luc Maurer @ Camptocamp (lmaurer-c2c)]

I fully agree with this bug report => it is really important to improve this report.

[Luc Maurer @ Camptocamp (lmaurer-c2c)]

Hello,

Here are some other improvement to add to this report :

- change the balance calculation to have the running sum
- add on each page the title of column
- add on each page the code and the name of the account I have the detail
- add the total number of pages
- on ref column, if we have a big word (in only on bloc without space), the ref bloc overlaps the next column => I think it is the case for all column if we have only one big word
- on all number columns please put the thousand separator (comma_me)

It is really important to improve this financial reports to be really userful for an accountant.

[Ferdinand (office-chricar)]

for most reports as such ( as discussed already frequently)

Each page
* Company Name (!)
* Page Number
* Total Number of pages (if possible, usually time consuming)
* Printing Date/Time
* User who is starting the job
* Report Name
* Fiscal Year / Period - mostly very useful at least for period bound reports
* Column headers

Last Page
* "End of report" line at the end of reports - (often it is not clear that no more lines / pages follow)
* Context: very often it is not possible to identify the filter criteria, users start to write it manually on the reports :-(( to be able to identify what has been selected to be able to present document to their supervisors. - it's really a big issue.

* thousend separators
* hard word wrapper if soft wrapping at word boundaries is not sufficient to avoid overlapping

[Ferdinand (office-chricar)]

BTW if the context issue is solved once it would be also very helpfull to get this info on hoovering over the tab as (nicely formated) tooltip.

[Luc Maurer @ Camptocamp (lmaurer-c2c)]

Fabien, I don't agree with you !

You have put in place a report (base on the c2c report), but you don't have put it correctly and this report is really not userfull for accountant who should be concern by this report.

When you think General ledger, you would like to have a running sum and not only balance.......

When you print a report with more than 200 pages you would like to have title on each page.... => report have been really improved on the 5.0 version, but it is missing the last 5% which a really necessary for people who are using it (I see that it should not be your case.....).

It is really a bug and not a wishlist.... please reconsider this decision.... and make a general ledger fully usefulll.

Thanks

Luc

[Ruud Riem-Vis (ruud-riem-vis)]

I'm happy to see the support for the bug report but would propose to split the issue in two parts: one handling with the balance sum (which is a real bug) and one with the list of improvements for the report.
The bug in the balance sum makes the report more or less useless whereas the list of improvements can be considered as a wishlist. In particular if the running sum is corrected, the page numbering issue becomes less urgent as the sum and account numbers will help to keep the page numbers in sequence, even with a paper version.
Still I agree that importance of clean and self-containing reports, in particular in the finance area.

Thanks,

Ruud

[Alexis de Lattre (alexis-via)]

I am also affected by the bug reported by Ruud.

There is also another important bug in the General Ledger :

when you edit a General Ledger filtered by date :
- the lines of the General Ledger are filtered by date -> OK
- the total amounts (Total debit, total credit and total balance) don't take into account the date filter : the total amounts displayed are the total amounts of the accounts without the date limits !

It is important because it is very common to edit a General Ledger filtered by date.

[Vinay Rana (OpenERP) (vra-openerp)]

Hello Guys,

Can you apply the more improved attached patch of General Ledger report and notify me?

Thanks.

[Vinay Rana (OpenERP) (vra-openerp)]

Hello Guys,

 Apply the more improved patch of General Ledger report and notify me?

Thanks.

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hello,

We have a relevant fix on https://bugs.launchpad.net/openobject-addons/+bug/514808.

For the improvements, kindly file another bug, so we can plan to implement.

Thanks.