Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
fixedassetsreceivablefixed_assetpayableanalyticsAnalyticanalyticdistributionanalytic account
2 Odgovori
1828 Prikazi
Avatar
Zuhair

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'


Does anyone know:

  • Which field name should be used to map the analytic account in the import template?
  • Is it possible to assign analytic tags as well during asset import?

Thanks in advance!

Avatar
Opusti
Zuhair
Avtor

Hello Cybrosys,

It works fine thank you. we should use ID instead of External ID

Avatar
srikesh infotech
Best 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}

Avatar
Opusti
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best 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.


Hope it helps

Avatar
Opusti
Zuhair
Avtor

Hello,

I tried the same step it shows everything is valid but when I imported it the Analytic Distribution remains blank.

my external id is not whole number as your but its like this one for example: __export__.account_analytic_account_229_7c94c4b2. so i inserted this value for the Analytic Distribution: {"__export__.account_analytic_account_229_7c94c4b2":100.0}

and also I have several analytic plans.

Related Posts Odgovori Prikazi Aktivnost
Make Account Receivable and Payable filed optional when creating contact Solved
accounting receivable payable
Avatar
Avatar
1
feb. 23
3324
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
Avatar
Avatar
1
maj 25
2028
How to rent a fixed asset in odoo 16
rental rent fixedassets fixed_asset
Avatar
0
maj 23
3284
Receivable and payable balances on the same partner
accounting receivable payable quickstart
Avatar
0
jun. 25
6262
Issuing Stock Items/Products to a Fixed Asset
inventory fixedassets fixed_asset Capitalize
Avatar
0
maj 21
3433