Symptom
During the Fixed Asset migration process, the error message 'Valuation view XXX not assigned to set of books YYY in company ABC' appears.
XXX - Relevant Valuation View ID
YYY - Relevant Set of Books ID.
ABC - Relevant Company ID.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Business Configuration work center.
- Go to the Overview view.
- Find Migration of Accounting Transaction Data activity.
- Click Open.
- Click Migrate accounting transaction data using the migration tool.
- Select the relevant migration unit.
- Click Execute Migration.
- Select Migration Object Fixed Assets.
- Click Process File.
- Go to Step c.
The following error is raised: 'Valuation View XXX Not Assigned To Set of Books YYY In Company ABC'
Cause
This error message appears when you add a Valuation View to a Set of Books after there have been already Fixed Assets created in the system. In this case the new Valuation View's Status is set as Partially Active.
Use below steps to check the Status of the Valuation View:
- Go to the Business Configuration work center.
- Go to the Overview view.
- Find activity Set Of Books.
- Click Open.
- Select relevant Set of Books.
- Click Edit.
- Go to the Fixed Assets Settings tab.
- Select the Valuation View ID XXX.
Here, you can find the Valuation View status is set to Partially Active.
Resolution
In case there are Fixed Assets already Capitalized in the system then it is not possible to activate the new Valuation View for the respective Set of Books-Company combination.
On cases where the Fixed Assets created are all in Status In Process you can adjust this with below steps.
First, delete all previously created Fixed Assets for the respective company.
After, follow the below steps:
- Go to the Business Configuration work center.
- Go to the Overview view.
- Find Fixed Assets Valuation View activity.
- Click Open.
- Select relevant Valuation View.
- Go to the Assignment to Accounting Principles tab.
- Select the Accounting Principle applicable.
- Click Delete.
- Click Save and Close.
Close all Set of Books relevant screens such as Business Configuration views, Open and Close Periods activity, New Fiscal Year activity.
Make sure no other User locks the Set of Books in any of these mentioned screens. This is required as the additional Accounting Principle for a Valuation View triggers backend changes on all the Set of Books assigned to the respective Accounting Principle.
Wait for 10 minutes, this is to avoid any inconsistency in the Set of Books Valuation View assignments while the Set of Books is being updated in the backend.
- Open the Fixed Asset Valuation View activity again.
- Go to the Assignment to Accounting Principles tab.
- Select relevant Valuation View.
- Click Add Row.
- Add the Accounting Principle you removed before.
- Click Save and close.
After proceed with below steps.
- Open Set of Books activity.
- Select the relevant Set of Books.
- Click Edit.
- Go to the Fixed Asset Settings tab.
Now the Valuation View is added to the assigned Company and Set of books with the Asset Valuation View Status 1 - Active.
Now the migration file will be processed with no errors.
Keywords
Fixed Asset, Migration, Fixed Asset Migration Error, Valuation view, not assigned to set of books , KBA , AP-ACC , Business ByDesign: Financial Accounting , How To