Symptom
You are migrating Accounting Transaction Data related to Fixed Assets and when you choose Simulate Import, the error message below is shown for one or more Fixed Assets:
"Posting date DD/MM/YYYY is not in fiscal year XXXX"
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Configuration Work center.
- Go to Implementation Projects view.
- Go to Project and Choose Open Activity List.
- Go to Integrate and Extend tab.
- Show All Activities and Find Activity Migration of Accounting Transaction Data.
- Click on: Migrate accounting transaction data using the migration tool
- Select the Migration file for Fixed Assets and Choose Execute Migration.
- In C - Simulate Import step, error message is shown.
Cause
The Posting Date for the Migration is in Fiscal Year XXXX. (XXXX stands for the Fiscal Year in which the Migration was executed)
When the Migration is executed, Journal Entries for those Fixed Assets are created as indicated on the Migration file. If the Posting Date maintained on the file happens to occur on an Accounting Period that does not exists for the Company in the system, this error will be raised.
First, check the Accounting Periods maintained for Company ABC (ABC stands for the Company relevant to Migration ID):
- Go to General Ledger Work Center.
- Open Sets of Books and Assigned Companies view.
- Select the line for Company ABC and the respective Set of Books.
- Click on Open and Close Periods.
- You will notice that for Fiscal Year XXXX, not all the Periods exist.
Then, back on the Migration in the step C - Simulate Import, you will notice that all the error messages "Posting date DD/MM/YYYY is not in fiscal year XXXX" for Fixed Assets happens to occur on an Accounting Period that does not exists in the system for Company ABC.
Resolution
You need to change the Posting Dates for the entries that are with error to a date within Accounting Periods that exist in Fiscal Year XXXX.
1. On the Migration, in the step C - Simulate Import where the errors are raised to click on Go To Correction.
2. Go to the tab Asset Posting Lines.
3. Change the Posting Dates on the entries that lies on Fiscal Year XXXX, but outside Accounting Periods of Fiscal Year XXXX that exists in the system.
4. Click on Save and Close.
5. Execute the process again.
The error message for that specific Fixed Asset will disappear.
Then repeat the process to all other affected entries.
Keywords
Fixed Assets, Migration, is not in fiscal year , KBA , SRD-FIN-FA , Fixed Assets , Problem