2131378 - Undefined Date Format When Migrating Open Receivables

SAP Knowledge Base Article - Public

2131378 - Undefined Date Format When Migrating Open Receivables

Symptom

You are trying to migrate open items receivable via Migration Tool, however you get a date format error.

Reproducing the Issue

  1. Go to Business Configuration work center.
  2. Go to Implementation Projects view.
  3. Open the activity list of the relevant project.
  4. Open activity Migration of Accounting Transaction Data.
  5. Click Migrate accounting transaction data using the migration tool.
  6. Select the migration unit that you are using to migrate the open items or create a new migration unit.
  7. Click Execute Migration.
  8. In the Process Files step, Click Upload File for the Open Items Receivable object.
  9. Browse your xml migration file and start the upload.

A dialog window is shown stating an Undefined Date Format. File contains some date values for which the format could not be determined. Correct these entries before executing migration.

Cause

The attributes that carries a Date parameter, such as Document Date and/or Base Line Date, have one or more records in the file with, for example, time details alongside the Date. The cells itself are formatted to display only date information, hence you have to select the concerned cell and refer to its content in the Formula Bar. 

Resolution

In order to be able to upload your excel file and process it in the migration tool, you have to remove the time details so that the fields are populated only with Date.

In case you have many records, you may copy all the column content to a Notepad, you'll see that only the Date is copied due to cell formatting, and copy the Notepad content back to the excel file only with Date information.

You must review your file and make sure that all the records have the correct date assigned back, before you upload the same into the system.

Keywords

KBA , AP-RC-BCT , Business Config. Tools (SAP Business ByDesign , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711