Projects:Financial Reports Review/Trial balance report
The following filters have been deleted:
- All: when selecting Subaccount as Account Level this checkbox is not anymore visible.
- Show selected level only checkbox.
As a result of removing Show selected level only, the primary filter section has been redesign to two column approach.
The following filters have been modified:
- From To and To Account: when selecting Subaccount as Account Level the application displays two extra filters to restrict an account range. Old filters (comboboxes) have been replaced for a more efficient and intuitive Account Selector.
|1||Multiple Business Partner filter. Remove include all option.||Must have||completed|
|2||Multiple Product filter.||Must have||completed|
|3||Multiple Project filter.||Must have||completed|
|4||Group by option. Add a drop-down to select the dimension it is desired to group by: Business partner, Product, Project or none. Only one can be chosen.||Must have||completed|
|5||Possibility to hide the dimensions filter in order to maximize the results area.||Nice to have||completed|
The following screenshot shows the new multiple selectors and the group by option. In the top-left corner there is an expand/collapse button to show/hide the dimensions filters.
|1|| Improve html output.
|2|| Improve pdf output.
|3|| Create a xls report
|4|| Group by drop-down
Logged issues to be considered
- 7251: FR. Add all accounting dimensions. On this review BPartner, Product and Project are added. Still missing Sales Campaign, Sales Region and 1st and 2nd Dimension.
- 2204: FR. Details drill down in Trial Balance Report.
- Instead of providing details by period, it provides details by month. That works only if the company uses monthly periods, but many companies use quarters instead.
- Even accepting the monthly breakdown, the name of the months are in Spanish and not in the user language.
- 11689: Error in Trial Balance Report. Initial Balance is not properly calculated.
- 9464: FR. Proper export to excel. Needs a new jasper template. Done in local workspace.
- 4379: FR. Show a user friendly message when no data is found.
- 7631: FR. Redesign of the report format. Needs a new output template for the report PDF output.
- 16046: Def. The field initial balance should not appear when printing the report trial balance.
- 14896: Def. Accounting Reports should show a page number.
- 10181: FR. Unify buttons to print reports.
- 9999: Def. It's a translation issue of all jasper reports and a platform problem with the name of the generated files. no change required in the report.
- 7535: FR. Review of style and formatting of the generated reports. Partially implemented in local workspace. Needs further review.
- 3383: FR. Add ability to set larger data range for html output. Currently is using the same range than grids, 20 by default, which might be to few for reporting. needs to be implemented in the platform first.