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
accountinganalyticaccountingAnalytic Distribution
2 Odgovori
995 Prikazi
Avatar
Mourad Hadj Amor

hello community,

we are loading our historical transaction (GL transaction), we were able to load our all our entries without issue. However when we try to load it adding some analytical account for our P&L accounts, we cannot pass the "test" before import. 

here is our format : 

DateJournalReferenceJournal Items / Accountjournal item nameEcritures comptables - libelléJournal Items / DebitJournal Items / Creditanalytic_account_id
01.01.24HISTBatch-JAN243400Ventes de prestationsconfidential - deleted4353307
2200TVA dueconfidential - deleted35261,73
2301Produits encaissés d’avanceconfidential - deleted470591,73

the entry is balance and pass the load without the analytical code, however when we try to load with analytical code and trying to link it to different connector in Odoo, we have error message. The "7" correspond to analytical code ID in Odoo. 

please let me know which field should we use and if we need to specify the distribution (in example 100%) and the format for load.


thanks a lot in advance for your precious help

Avatar
Opusti
Ray Carnes (ray)

Export an entry with the "import-compatible export" option to understand the format that Odoo expects.

The "analytic_account_id" does not exist, you need to import via "analytic_distribution" which you will see in your export.

Avatar
Mourad Hadj Amor
Avtor Best Answer

hello, 

thanks for your return very useful,

we solve the issue by effectively providing the analytical code ID + distribution and map it to "analytical distribution".

post can be closed

Avatar
Opusti
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

Please refer to the Solved Forums:


1. https://www.odoo.com/sl_SI/forum/pomoc-1/analytic-distribution-analytic-account-import-journal-entry-via-excel-236457

2. https://www.odoo.com/sl_SI/forum/pomoc-1/v16-how-do-i-import-journal-entries-with-an-analytic-account-distribution-226866

3. https://www.odoo.com/sl_SI/forum/pomoc-1/how-to-import-fixed-assets-with-analytic-accounts-in-odoo-276408


Hope it helps.

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
Is there any reason to use Analytic Accounts for transactions with balance sheet accounts? Solved
accounting analyticaccounting
Avatar
Avatar
1
mar. 24
3316
Odoo 18 Studio — Which trigger should update a “Remaining Budget” field when Committed/Achieved changes from PO/Bill?
accounting budget Odoo 18 Analytic Distribution
Avatar
0
avg. 25
878
Select an Analytic Plan to apply all its Analytic Accounts
accounting 17 analytic account Analytic Distribution
Avatar
Avatar
Avatar
2
jul. 25
1788
Berapa nomor telepon layanan Tokopedia?
accounting
Avatar
0
nov. 25
2
what is the best girl mexico
accounting
Avatar
0
nov. 25
2