Symptom
The Invoice Volume report displays a different Ship-To value instead of the actual value maintained in the respective Invoice Document
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Customer Invoicing work center.
- Navigate to the Reports view.
- Open the Invoice Volume report.
- Search for ABC (where ABC represents the Invoice Document ID).
- Observe that the displayed State (Ship-To) field value does not match the Ship-To state maintained in the Invoice Document.
Cause
The issue occurs because the Sales Order/Invoice Document uses a Ship-To address that is different from the Ship-To address maintained in the account master data.
The State (Ship-To) field in the Invoice Volume report is determined from the Account Master Data and not from the Ship-To address maintained in the Invoice Document. This is the standard system behavior.
Resolution
To display the Ship-To information from the transaction document instead of the Account Master Data, add the required Ship-To field in the Invoice Volume report.
In the Invoice Volume report, add the column Address of Ship-To to display the Ship-To address information.
Depending on the required Ship-To information, use the available fields ending with "of Ship-To" (for example, State of Ship-To, Postal Code of Ship-To, and similar fields). These fields retrieve the data from the Sales Order/Invoice Document.
If the required field is not available for selection in the Invoice Volume report (for example, Address of Ship-To):
- In the Invoice Volume report, click the Configure icon in the top-right corner.
- Expand the Business Partner dimension.
- Find the characteristic Address of Ship-To.
- Select the checkbox Display in Report and click OK.
- The Address of Ship-To characteristic is added to the Row Fields, allowing you to view the Ship-To address used in the Sales Order/Invoice Document.
See Also
Keywords
Customer Invoicing; Reports View; Invoice Volume report; Invoice Document; Sales Order; Account Master Data; Ship-To address; State (Ship-To); Address of Ship-To; State of Ship-To; Business Partner; Row Fields; Address mismatch; Wrong Ship-To state; Report discrepancy; Different ship-to value; Configure report; Display in Report; Add column; Characteristic selection , KBA , SRD-CRM-ORD , Orders & Contracts , Problem
SAP Knowledge Base Article - Public