3818161 - Delivery Dates not Recognized During Purchase Order Excel Upload

• 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.

 SAP Business ByDesign

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.

• 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.

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.
6. In the Excel template, enter Delivery Start Date Time Zone and Delivery End Date Time Zone using SAP-defined time zone values exactly as maintained in the system (avoid unsupported abbreviations like “JST”).

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

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