Hi,
Now, Odoo doesn't generate opening entries for the next fiscal exercise (indicated in the documentation). But my general balance (and the general ledger too) is incorrect because the balance of my new exercise is at 0 on the report.
Example a new base with exercise for January 1st to December 31 :
1) I do an entry :
411100 Clients - 20/12/2016 - Crédit : 1000€
512000 Banque - 20/12/2016 - Débit : 1000€
--
2) I lock my exercise at 31/12/2016.
--
3) My bank balance in the dashboard is correct : +1000€.
--
4) If I launch a general balance edition for the period 2016 (01/01/16 > 31/12/16), the balance is correct for the two accounts (+1000 and -1000).
--
5) If I launch a general balance edition for the period 2017 (01/01/17 > 31/12/17), the balance is NOT correct because Odoo didn't generate the opening entries for the new exercise and my balance are at 0.
What is the mistake ? I search a lot but can't find what's wrong.
Yes, if I do that, the balance is correct, but the columns debit and credit are the accumulation of all years, and that isn't correct. My accountant wants to have only the fiscal year wished. In the general ledger, we can check if we want the initial balances but not in the general balance report.
So, if I put a period with start and end dates, I have correct debit and credit values, but wrong balance.
If I just put an end date, I have correct balance but not wanted debit and credit values.
There's a problem...
I did never use debit/credit columns in balance sheets. And there is no standard report available showing the initial balance at date t-1 and total credit and debit values for a period starting at date t and ending at date t+x. But you could easily create such a report yourself or google for the availability of such kind of reports.
You might want to check this OCA repository for example: https://github.com/OCA/account-financial-reporting/tree/10.0