Projects:Financial Reports Review/General Ledger Report
Contents |
Primary Filters
Actual filters are kept. No new filters are needed.
Dimensions
Num | 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 |
Output
Num | Requirement | Importance | Status |
1 | Improve html output.
| Must have | completed |
2 | Improve pdf output.
| Must have | completed |
3 | Improve xls output
| Must have | completed |
4 | Group by drop-down
| Must have | completed |
Logged issues to consider
Solved issues:
- 10727: FR. Add description for Opening and Closing entries. Changed the process to generate these entries to add the descriptions.
- 7636: Def. Too large Opening and Closing entries. The entries are going to be grouped so the Opening and Closing entries should be smaller.
- 15932: Def. The general ledger journal should show an "Add and keep going..." a "Total" and a "Previous Sums" sections
- 15933: Def. Information about the ledger entry should be shown in the general ledger journal.
- 15934: Def. The legal entity tax id does not appear in the general ledger journal report.
Other issues:
- 10730: FR. Put Customer, Vendor or Creditor depending on the account number. Needs to be discussed.
- 9566: FR. To show all accounts and not only accounts with transactions. To be discussed. Might need a huge redefinition of the needed SQLs.
- 3956: FR. Enable the possibility of showing the results also by other accounting levels different than subaccount
Solved:
- 9464: FR. Proper export to excel. Needs a new jasper template. Done in local workspace.
- 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.
- 4379: FR. Show a user friendly message when no data is found.
- 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.
- 7631: FR. Redesign of the report format. Needs a new output template for the report PDF output.
- 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.