SAP Knowledge Base Article - Public

2151963 - Error Message: "Bank statement date MM-DD-YYYY must not be in the future" While Doing Bank Account Balances Migration

Symptom

You are creating a Bank Account Balances Migration and system shows the error message Bank statement date MM-DD-YYYY must not be in the future.

Reproducing the Issue

1. Go to the Business Configuration Work center.
2. Select the Implementation Projects View.
3. Select your Implementation Project and click Open Activity List button.
4. Search and open the activity Migration of Accounting Transaction Data.
5. Click Migrate accounting transaction data using the migration tool.
6. Select your Migration Unit and click on Execute Migration button.
7. Select your Migration File and click Process File.
8. System shows the error message Bank statement date MM-DD-YYYY must not be in the future.

Cause

For Migration of Bank Statements, the Migration Unit for Accounting Transaction Data cannot have a Posting date in the future.

Resolution

You need to create the Migration Unit for Accounting Transaction Data with the current day as Posting Date, as per steps below:

#Set the Migration Posting Date:

  1. Go to General Ledger Work Center.
  2. Go to Master Data > Companies View.
  3. Select the respective company.
  4. Click on ActionsSet Posting Date for Migration.
  5. Choose a valid Posting Date and click on OK.

#Create a new Migration Unit:

  1. Go to the Business Configuration Work center. 
  2. Select the Implementation Projects View. 
  3. Select your Implementation Project and click Open Activity List button. 
  4. Search and open the activity Migration of Accounting Transaction Data
  5. Click Migrate accounting transaction data using the migration tool.
  6. Under Migration Units for Accounting Transaction Data click on Create Unit button.

The new Migration Unit will be created with the Posting Date defined in the General Ledger Work Center. Also, it is your responsibility to define the Posting Date as per the needs.

Keywords

KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions