How to Import Fixed Assets with Analytic Accounts in Odoo?

Question

Hello everyone,

I'm trying to import fixed assets into Odoo 18 and would like to assign each asset to a specific *analytic account* during the import. However, I'm unsure which field should be used in the import file. To correctly map the *analytic account* to each asset. I tried to map it with
*Analytic Distribution *but I am getting this error:
*does not seem to be a valid JSON for field 'Analytic Distribution'*
* Image [1] *

Does anyone know:

Which field name should be used to map the *ana

srikesh infotech · Accepted Answer

I created an asset called Exchange-Traded Funds. It has two analytic accounts:

1. Dividend Income (External ID = 3)
2. Expense Ratio Impact (External ID = 4)

You can import the Analytic Distribution in the following format for this asset: {"3": 90.0, "4": 0}
image [1]
image [2]

[1] /web/image/68816138-0a62f08d/image.png?access_token=b343a5c1-17ad-45f9-b0c7-f60234c8c784
[2] /web/image/68816139-4d34b215/image.png?access_token=b42cc466-a0d2-4726-9cb5-45819d1b18ea

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
While importing the
assets, instead of 'Analytic Account' choose 'Analytic Distribution' as
shown in the photo attached below. And {"16,17":20.0} refers to the
external id and the percentage respectively of the analytic account
which you are adding to the analytic distribution.
Here I am adding two analytic accounts(external id 16 & 17 ) each of 20 % distribution into the field Analytic Distribution.
Image [1]
Image [2]

Hope it helps

[1] data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABw0AA

関連投稿	返信	ビュー
Make Account Receivable and Payable filed optional when creating contact 解決済 accounting receivable payable	1 2月 23	3281
Buying a Fixed Asset in Odoo 18. How to Assign a Location During Vendor Bill Creation? accounting warehouses locations fixedassets fixed_asset payable vendorbill Fixedasset Odoov18	1 5月 25	1958
How to rent a fixed asset in odoo 16 rental rent fixedassets fixed_asset	0 5月 23	3251
Receivable and payable balances on the same partner accounting receivable payable quickstart	0 6月 25	6210
Issuing Stock Items/Products to a Fixed Asset inventory fixedassets fixed_asset Capitalize	0 5月 21	3419

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！