I'm looking for custom report which we will be than exporting into excel sheet. I'm working if someone can let me know the best method to achieve this and can provide some guidance.
Parameters for the report:
- Fiscal Year for which report is required
- Currency in which this report is required
- Entity for which this report is required
Fields/Columns required in the report:
- GL Code
- GL Description
- Cost Centre
- Opening Balance
- Total for each fiscal period (currently there are 16 fiscal periods in SAP, there will be 16 columns)
- Closing Balance for YTD (optional, if not available then this can be calculated in Excel)
- Exclude GL Code/Cost Centre where there is no opening balance and no transaction under any fiscal period.
Thanks in advance,