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
- Go to the Business Analytics work center.
- Select the Data Sources view.
- Search for Sales Order Item with Invoice Schedule Items.
- Click Preview.
- Enter Sales Order ABC (ABC represent the ID of the Sales Order).
- Navigate to the View tab.
- Enter the following fields under Row:
Sales Order Item
Invoice Schedule Item ID
Invoice Schedule To Be Scheduled Item Life Cycle Status - 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