SAP Knowledge Base Article - Public

3818161 - Delivery Dates not Recognized During Purchase Order Excel Upload

Symptom

  • While creating the Purchase Order through Excel Add-in, the delivery dates are not updated to the system as written in the Excel file.
  • The system set a default delivery date (for example, current date + 7 days) instead of the date provided in the Excel file.

Environment

 SAP Business ByDesign

Reproducing the Issue

  1. Go to Purchase Requests and Orders work center.
  2. Go to Purchase Orders view.
  3. Select New -> Microsoft Excel.
  4. Open the downloaded file.
  5. Log in to the Excel Add-in.
  6. Enter the mandatory Purchase Order data, including delivery dates.
  7. Select Save data to upload.
  8. Open the created Purchase Order.

The delivery date in Purchase Order differs from the Excel value.

Cause

  • An unsupported or incorrect time zone value was entered in the Excel template’s Delivery Start/End Date Time Zone fields. The system requires supported time zone values maintained in Business Configuration. Regional abbreviations (for example, “JST”) may not be processed.
  • When an invalid time zone is entered, the system determines the delivery date based on the configured settings or applies the default behavior.
  • By default, the system proposes the delivery date based on the “Define Purchase Order Delivery Date” configuration. If this configuration is not maintained, the system defaults to the current date + 7 days.

Resolution

Use the system defined time zone codes.

To verify supported time zone values in the system:

  1. Go to Business Configuration work center.
  2. Go to Overview view.
  3. Search for Countries/Regions.
  4. Choose Open.
  5. Select Specify Time Zones (Time Zones by Country/Region) to review valid entries for a countries.

In the Excel template, enter the Delivery Start Date Time Zone and Delivery End Date Time Zone using the SAP-defined time zone codes exactly as maintained in the system.

Example: For Japan, use the SAP-defined time zone code "JAPAN" instead of unsupported abbreviations such as "JST"

 

See Also

KBA:  3650087 - How to define Delivery Date for Purchase Orders? - SAP for Me 

Keywords

Excel Add-in; Purchase Order Upload, Delivery Date Not Applied; Delivery Start Date; Delivery End Date; Default Delivery Date , KBA , SRD-SRM-PRO , Purchase Requests and Orders , Problem

Product

SAP Business ByDesign all versions