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:
- Go to General Ledger Work Center.
- Go to Master Data > Companies View.
- Select the respective company.
- Click on Actions > Set Posting Date for Migration.
- Choose a valid Posting Date and click on OK.
#Create a new Migration Unit:
- Go to the Business Configuration Work center.
- Select the Implementation Projects View.
- Select your Implementation Project and click Open Activity List button.
- Search and open the activity Migration of Accounting Transaction Data.
- Click Migrate accounting transaction data using the migration tool.
- 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