While I was looking at the Charts of Accounts Report and playing with the available filtering fields to see the displayed debit/credit values from each account, I noticed that no matter what closed fiscal year I select and then press the search button (the button with the magnifier icon), the output is the same; i.e. the values in debit and credit remains the same. Is that normal or there is something wrong on my accounting setup, or it is a bug?
I cannot replicate this in the demo site since there is not enough data from many different fiscal years. For those who are running Tryton for many years on production, can you verify if you have the same problem as I described above?
I understand that this is not a major issue as chart of account report is not used for financial reporting, since it is more commonly used: the balance sheet and income statement, which both are generating the information correctly. Nonetheless, I am curious as to whether this is normal behavior or not.
I re-opened and re-closed all the fiscals year again and that seem to have fixed the problem, now each closed fiscal year show different values as expected. However now I have another problem, the parent account balance that supposed to show the sum of the child-accounts balances show a negative value that doesn’t make any sense. All the other reports such as general ledger, balance sheet and income statement show the parent account balances correctly.
Here is a screenshot of what it looks like:
I am aware of the deferral aspect of the accounts and I am not sure if the problem is related to it. I noticed that for each fiscal year closed, the deferral is cumulative (shown in the Deferral tab of the account form) and not just what was generated within that fiscal year. I wonder if this is correct, since for each passing fiscal year the deferral value grows without limit.