SAP Knowledge Base Article - Public

2447153 - No Data Available in Maintain Project Expense and Revenue Excel File

Symptom

You are trying to maintain the Project Expense and revenue planning data via the Project Expense and Revenue Planning using Microsoft Excel® functionality.

However when opening the Excel document downloaded, no data is displayed.

Reproducing the Issue

  1. Go to Cost and Revenue work center, choose Projects view.
  2. Show All Projects.
  3. Find 123 (123 represents the Project ID).
  4. Select the project.
  5. Click Export - Maintain Project Expense and Revenue in Microsoft Excel®.

The document is downloaded successfully but no data is shown in the Excel file.

Cause

You need to connect the Add-in to the ByDesign system and query the project from the add-in in order to display the data.

Resolution

You can follow these steps to display the data:

  • Export document from the system.
  • Log in to your system via the Excel add-in.
  • Enable editing and enable content if required.
  • Go to Query sheet.
  • Enter 123 (123 represents the Project ID).
  • Go to the Home tab in Excel.
  • On the far right of the screen, click Query.

log on.png

  • Log in with your ByDesign details. You might need to add your system details if this is the first time you are using this functionality. For this, click on the "…" box and enter your system URL and name. Once it's added, you will be able to select it in the dropdown menu.

system data.png

  • This opens the Project Expense and Revenue sheet.
  • Click the "+" sign on the left of the Project name, left of the row number (6).

+.png

All the data appears here.

 

 

 

Keywords

KBA , project budgets , maintain project budgets , excel , maintain project expense and revenue , LOD-CRM-EMP , Employee , How To

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711