SAP Knowledge Base Article - Public

2585738 - Outbound Deliveries Displayed Under the Previous day's Delivery Date

Symptom

Outbound Deliveries displayed under the Previous day's Delivery Date in datasource Outbound Delivery Item.

Environment

SAP Business ByDesign

Reproducing the Issue

1. Go to the Business Analytics Workcenter and Design Data Sources view.
2. Find Outbound Delivery Item Details and Preview.
3. In the report you will see that the Outbound Delivery with Delivery Date say DD/MM/YYYY at 00:00 hours CET will be displayed with Delivery Date of Previous Day in UTC.

Cause

The Delivery Date Time is stored in the backend in UTC.

You may have set the timezone to CET, which is UTC+1 on normal days, and UTC+2(daylight saving, usually starting from the last week of March to end of October) during summer. The Data Source works with UTC time.

Example: If you have performed a delivery on DD/MM/YYYY at 00:00:00 CET, this would be stored as a delivery for Previous day at 23:00:00 UTC in the backend. Thus, this delivery would not be selected when a query is performed for DD/MM/YYYY

Resolution

This is the expected behaviour.

As a workaround follow the below steps-
1. You can personalize and set the timezone to CET and log off.
2. Go to Outbound Logistics and Outbound Deliveries View and in Advance Search.
3. Enter Delivery Date DD/MM/YYYY

You will be able to see the outbound delivery created on DD/MM/YYYY at 00:00 hrs CET.

 

Keywords

Outbound Delivery, Delivery Date, time zone, data source , KBA , outbound delivery , delivery date , time zone , data source , AP-ODP-OD , Outbound Delivery , Problem

Product

SAP Business ByDesign 1711 ; SAP Business ByDesign 1802