Symptom
Cannot find 'Project Task ID' field in the financial planning excel downloaded from Cost and Revenue work center - Planning view.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Cost and Revenue work center.
- Go to Planning view.
- Click on New and select 'Plan Version from Microsoft Excel'.
- Select 'New Expense And Income Statement Plan' and click 'Download'.
- Open the downloaded excel file.
- Cannot see field "Project task ID" in the excel.
Cause
There are many fields not mapped by default. However, it is possible to customize the template according to the business need.
Resolution
Download the excel template and under the Developer tab in Excel, view the source - this is an XML source structure and fields can be mapped to new columns via drag and drop. For example, field 'Project Task ID' can be selected here.
See Also
Keywords
Documentation, Project Task ID, Template, Microsoft Excel , KBA , SRD-FIN-COR , Cost & Revenue , Problem