You are creating a report or data source based on the data source Sales Ledger Line Items. You would like to see the Associated Invoice Request and the Associated Invoice Request Item but you notice that the invoice request is always shown as unassigned (#).
Reproducing the Issue
- Go to the work center Business Analytics, view Design Data Sources.
- Search for the data source Sales Ledger Line Items.
- Click on Preview.
- Add the fields related to the invoice request, for example Associated Invoice Request ID
You will see that is shows unassigned (#).
Due to technical reasons, the data source Sales Ledger Line Items cannot show the invoice request information.
If you need to see details about the invoice request, please use another data source, for example Profitability : Invoice Profit or Profitability Management.
KBA , AP-RC-CEC-A2A , Process Integration A2A , Product Enhancement