SAP Knowledge Base Article - Public

3442978 - Sales Order Item with Invoice Schedule Items Data Source Shows Wrong Item Status

Symptom

You are using the data source Sales Order Item with Invoice Schedule Items and noticed that the report shows an Invoiced scheduled item with the Open status .

Environment

SAP Business ByDesign 

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Select the Data Sources view.
  3. Search for Sales Order Item with Invoice Schedule Items.
  4. Click Preview.
  5. Enter Sales Order ABC (ABC represent the ID of the Sales Order).
  6. Navigate to the View tab.
  7. Enter the following fields under Row:
    Sales Order Item
    Invoice Schedule Item ID
    Invoice Schedule To Be Scheduled Item Life Cycle Status
  8. Line item  shows as Open

Resolution

In order to have the expected value, please add the field/column "Invoice Schedule Item Life Cycle Status" which will provide the correct/expected Invoice Schedule Status for the line item. 

Keywords

Invoice Schedule, Item, Life Cycle, Status, To Be Scheduled, Data Source, Sales Order Item with Invoice Schedule Items, Report , KBA , AP-SLO-SO , Sales Order , How To

Product

SAP Business ByDesign all versions