Symptom
You are receiving an error while migrating the Fixed Assets.
Posting date DD.MM.YYYY must be last day of 1. open fisc.year ZZZZ for hist. values
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Configuration work center.
- Go to the Overview view.
- Select Migration of Accounting Transaction Data activity.
- Click Migrate accounting transaction data using the migration tool.
- Select relevant Migration Unit.
- Click Execute Migration.
- Select Fixed Assets.
- Click Process File.
- Go to Step Validation.
Error detected in source record with key value ABC
Posting date DD.MM.YYYY must be last day of 1. open fisc.year ZZZZ for hist. values
Journal entry voucher cannot be posted
ABC represents the Fixed Asset ID on the file.
DD.MM.YYYY represents the Posting Date of the migration.
ZZZZ represents a year previous to the year YYYY.
Cause
This error occurs because the last Open Year must be the Fiscal Year from the Posting Date.
When migrating accumulated values (last period previous year), meaning values are maintained on column Cumulated Historical APC in the template, the Posting Date is required to be the last day of the first Open Fiscal Year.
However the Posting Date set on the Migration is from a different Year, for example you are using migration Posting Date 31.12.2020 while the Fiscal Year 2019 is still Open.
Resolution
To correct this issue, you need to perform the Balance Carryforward for the previous Year, meaning 2019 on the provided example.
After this is completed you can proceed with the migration.
Keywords
Migration, Fixed Asset, Posting date, must be last day of 1. open fisc.year, for hist. values , KBA , fixed asset , must be last day of 1. open fisc.year , migration , for hist. values , posting date , SRD-FIN-FA , Fixed Assets , How To