Comment 5 for bug 1217707

Revision history for this message
Ajit (alessandro-domanico) wrote :

Hello Chris! I found where was the problem! I comment here in case it may helps somebody else.

I found that parent_left and parent_right column in account_account table were populated with wrong values which were not reflecting correctly my accounts structure, so also some reports (like Balance Sheet) were wrongly formatted (with some accounts belonging to wrong parents).

I fixed it with:
alter table account_account drop parent_left;
alter table account_account drop parent_right;
and restart the server with –update=account on the same db

Now everything is working fine.

Tip: I don't know why parent_left and parent_right were containing wrong values, could be a OpenERP error when adding new accounts?