Symptom
In the report Profit Overview by Key Figure you notice that the Net Sales field is blank for few Sales Document IDs.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Cost and Revenue work center.
- Go to the Reports view.
- Select List subview.
- Run the report Profit Overview by Key Figure with the required selection.
You notice that for some sales document ids the Net Sales field is updated with some value and for some other sales documents the Net Sales field is blank.
Cause
If the customer invoices that belong to the sales documents are not posted, then the Net Sales field will not be updated.
Resolution
If you need to see the correct profitability view of the sales documents, then as a prerequisite post the relevant Customer Invoices and Goods and Activity Confirmations related to the sales documents for which you need to know the profitability. Once the follow up documents of the sales documents are posted then you will be able to view the Net Sales and Total Cost of Goods Sold resulting which the system shows the Gross Profit / Operating Income of this report.
Report Sales Document - Line Items, will help to Cross check if the Customer Invoices and Goods and Activity Confirmation documents are posted. If the Customer Invoices and Goods and Activity Confirmations are posted and is not reflecting in the Profit Overview by Key Figure report, then report a case to SAP to investigate the root cause.
Keywords
Net Sales, Profit Overview by Key Figure, Cost of Goods Sold. , KBA , net sales not updated , net sales blank in profitability report , net sales field blank in profit overview , profit overview by key figure , SRD-FIN-COR , Cost & Revenue , Problem