SAP Knowledge Base Article - Public

3053351 - Date Formatting for "Valid From/To" Fields Are Not Correct in Sales Quote Created via Webservice

Symptom

 Date Formatting for "Valid From/To" Fields are coming broken in Sales Quote created via webservice.

Environment

SAP Business ByDesign

Reproducing the Issue

Payload is being passed with the following value: (The Dates below are being used as example)
<ValidityPeriodPeriodTerms actionCode="01">
<StartDateTime timeZoneCode="UTC">2021-03-04T12:00:00Z</StartDateTime>
<EndDateTime timeZoneCode="UTC">2021-03-21T12:00:00Z</EndDateTime>
</ValidityPeriodPeriodTerms>

  1. Go to the New Business work center.
  2. Go to the Sales Quotes view.
  3. Search for: ABC (ABC is the Sales Quote ID created via webservice).
  4. Open the document, in the View All, fields "Valid From/To" are with the following format: 2021--0-3-

Cause

The character '-' being used bettwen dates, like: 2021-03-04 is not expected.

Resolution

This is the expected tag to be used and passed (The Dates below are being used as example):

<ValidityPeriodPeriodTerms actionCode="01">
<StartDateTime timeZoneCode="UTC">20210505T12:00:00Z</StartDateTime>
<EndDateTime timeZoneCode="UTC">20251230T12:00:00Z</EndDateTime>
</ValidityPeriodPeriodTerms>

Keywords

Valid From/To, Field, Broken date, Sales Quote, webservice , KBA , AP-CQP-CQ , Customer Quote , How To

Product

SAP Business ByDesign all versions