Symptom
When you run the report the month is, e.g., September but the report show orders created on October.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Sales Orders work center.
- Select the Reports view.
- Search for the Report: Sales Orders Volume.
- Open this Report.
- Filter the Report by Month/Calendar Year e.g. September and year 2020.
Cause
It occurs due to difference in timestamp, as the data is stored in UTC, which would be 30th September 2020 16:00:00, for example, when converted from UTC + 8 for the referred Report.
The value for Month/Calendar Year field, from underlying data source, is stored based on the UTC timestamp, if no customer specific Business Configuration is maintained, as all the period information in CRM Application area are, in general, stored in UTC.
Resolution
This is an expected behavior.
Maintain a specific time zone. If you work in one time zone different from the one maintained in the configuration, it could lead to issues, specially if the users work in multiple time zones.
Keywords
Sales Order Volume, Report, CRM, Month , KBA , SRD-CRM-ORD , Orders & Contracts , How To