Projects:Financial Reports Review/Trial balance report

Contents 1 Primary Filters 2 Dimensions 3 Output 4 Logged issues to be considered 5 Common issues related to all reports

Primary Filters

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.

Dimensions

Sl.No	Requirement	Importance	Status
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.

Output

Num	Requirement	Importance	Status
1	Improve html output. Add needed modifications to group data based on the user selection. Enhance the output when selecting Subaccount as account level. Merge results: don't create a table for each account. Use the same approach as in other account levels. Expan/Collapse button for displaying group by details. Show a user friendly message when no data is found.	Must have	completed
2	Improve pdf output. Add needed modifications to group data based on the user selection. Different template when selecting Subaccount: For each SubAccount show business partner, product and project dimensions. Move the group header when there is not enough space to print at least 2 entries. Show a user friendly message when no data is found. Optimize space used and ink wasted.	Must have	completed
3	Create a xls report Add the proper xls button to the toolbar. Create a new template. Different template when selecting Subaccount: Show business partner, product and project dimensions. Don't group data by dimensions. Show a user friendly message when no data is found.	Must have	completed
4	Group by drop-down Only applies to html and pdf outputs. Results are grouped by the account number and selected dimension. If no dimension is selected group only by account number.	Must have	completed

Logged issues to be considered

Solved:

• 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.

Common issues related to all reports

Solved:

• 14896: Def. Accounting Reports should show a page number.

Other:

• 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.