Symptom
You are executing the material valuation migration, however the simulation step returns an error message.
Environment
SAP Business ByDesign.
Reproducing the Issue
-
Go to Business Configuration work center.
- Go to Implementation Projects view.
- Open the activity Migration of Material Valuation Data.
- Click to migrate using the migration tool.
- Create a migration unit and execute a Migration Step-by-Step.
In the simulate step, an error is raised as follows: 'Fiscal year/period is missing for company <company ID and name> set of books <set of books ID> posting date <posting date>'
Cause
For this combination of company and set of books, you have a custom fiscal year variant from which the system derives the accounting periods and years for a given posting date.
In this case, you are uploading valuation data with validity from 01.03.2018 to 31.12.2018. Nevertheless, there is no accounting period and fiscal year defined, for example 31.12.2018 in your custom fiscal year variant. Hence, period and fiscal year cannot be derived for the date.
Resolution
In order to proceed with the migration of valuation data, please check the validity range of the uploaded data and make sure that the dates are mapped to an accounting period and fiscal year in the fiscal year variant.
To check which fiscal year variant is used:
- Go to General Ledger work center.
- Go to Sets of Books and Assigned Companies.
- Find the combination of company and set of books.
- In the details section of this screen, the associated variant is displayed.
In order to adjust the fiscal year variant, please follow below steps:
- Go to Business Configuration work center.
- Go to Implementation Projects view.
- Open the activity list.
- Find and open activity Other Fiscal Year.
- With the activity open, click Period Details tab for the concerned fiscal year variant.
- Maintain the mapping for the relevant dates and accounting period/year.
- Save and Close
After that, you may simulate the inport of valuation data again.
Note that depending on the setup of the fiscal year variant, the required date would be mapped to an accounting period of the following year. In the example above mentioned, date 31.12.2018 could be mapped to 001/2019. In this case, you may also include the relevant fiscal year in the set of books, as follows:
- Go to General Ledger work center.
- Go to Sets of Books and Assigned Companies.
- Find the combination of company and set of books.
- Click Edit Fiscal Year.
- Add the required fiscal year if not added yet.
Keywords
Migration Tool. Material Valuation. Fiscal Year. Set of Books. , KBA , SRD-FIN-GL , General Ledger , How To