Print/account balance - Wrong layout

[Zeina]

openerp 5.0.7

Financial Management / Chart of accounts/ Print / account balance

This report does not follow the structure defined in the "Chart of accounts" tree.

account_balances are printed in the ascending order of "account_codes" beginning with the numeric codes and ending with the alpha-numeric codes.

For the following structure of accounts_codes, for example:
                                                                   AC100 (Parent of accounts): 111, 112 & 113
                                                                   BE200 (parent of accounts): 211 & 212

"Print/ account balance" will display records in the following account_codes sequence:
                                                                   111, 112, 113, 211, 212, AC100, BE200

instead of the following sequence: AC100, 111, 112, 113, BE200, 211, 212

Chart of accounts (especially virtual ones) become meaningful and incomprehensible, as the sequence (order) explaining the cumulative amounts of account balances is sometimes lost, as well as the hierarchy between some parents & child accounts.

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

We Let the Addons3 team decide.

Thanks.

[Ashvin Rathod (OpenERP) (ara-tinyerp)]

Hello Zeina,

I have checked the scenario as given by you. But it seems there is no problem appear in trial balance report in Addons3 (may be also with Trunk addons).
It display account with proper sequence => AC100, 111, 112, 113, BE200, 211, 212

I am closing the bug. If you still get any problem, you can reopen it.

Thanks.

[Zeina (sales-fiberyarn)]

I still have the problem!!

I tried also with version 5.0.15, same problem: Print / account balance gives wrong layout

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

Zeina,

We will be checking it soon for 5.0.15.

This bug has been set invalid for release of 6.0.

Thanks.

[Frederic Clementi - Camptocamp (frederic-clementi)]

This bug should have been solved with https://bugs.launchpad.net/openobject-addons/+bug/583666/comments/25
have a look

[Zeina (sales-fiberyarn)]

The "account_v6_reports_backport" module didn't resolve the problem

After installing this module:
  "Print / account balance" still gives the same wrong layout
and
  "Print / General ledger" gives the following error:

File "/usr/lib/python2.5/site-packages/openerp-server/addons/account_v6_reports_backport/report/account_general_ledger.py", line 47, in set_context
    self.sortby = data['form'].get('sortby', 'sort_date')
KeyError: 'form'

[Zeina (sales-fiberyarn)]

After installing the "account_v6_reports_backport" module, we get a correct "account balance" report layout, by printing the "Trial Balance" : Legal Statements/Generic Reports/Trial Balance

:)

N.B. Error message related to " KeyError: 'form' " is resolved by using the same client version as the server version.