To replicate: (using version7.0-20130604)
- Create a new DB
- Install Accounting & Finance app & click through the wizard for a default chart of accounts/currency setup, keeping default values.
- Under Accounting > Configuration > Periods > Fiscal Years, create a new fiscal year for 2012 (starting 01/01/2012, ending 12/31/2012)
- Click 'Create Monthly periods' on the new fiscal year
- Create an arbitrary invoice, making sure it has some taxes attached to it AND that the date is somewhere in 2012. Validate the invoice.
- Under Reporting > Generic Reporting > Taxes > Tax Report, run the Tax Report wizard, choosing the fiscal year as '2012' and leaving periods blank.
- The system will produce a report with NO taxes visible, as it has actually selected 2013 as the fiscal year (if no period list is made, the account_tax_report.py will run a direct database statement "select id from account_fiscalyear", choosing an essentially random fiscal year, despite one being given). The expected result should be that if a fiscal year is chosen it should display tax entries from the chosen fiscal year.
Note that this also occurs if only one period is chosen, yet works if periods are chosen on either side of the invoice date.
The simple solution is that the periods should be required fields unless fiscal_year is blank. I have linked a branch with this very small fix which will greatly improve the usability of this report. It will also allow a report to be generated showing all tax owing on active periods, even if these span over multiple fiscal years, a task which is currently impossible.
Hello,
I didn't see the fiscal year field on "Chart of Taxes" wizard, but I can see the "Period" field with help "If you do not select period it will take all open periods".
But when I don't select the period then it doesn't show the last year's open period's entry.
Thank you!