Skip to Content
This question has been flagged
accountinganalyticaccountingAnalytic Distribution
2 Respostes
165 Vistes
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
Descartar
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
Autor 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
Descartar
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
Descartar
Related Posts Respostes Vistes Activitat
Is there any reason to use Analytic Accounts for transactions with balance sheet accounts? Solved
accounting analyticaccounting
Avatar
Avatar
1
de març 24
2471
Select an Analytic Plan to apply all its Analytic Accounts
accounting 17 analytic account Analytic Distribution
Avatar
Avatar
Avatar
2
de jul. 25
393
Analytical distributions by amount in accounting app Solved
accounting
Avatar
Avatar
Avatar
2
d’ag. 25
628
Can Odoo replace Winauditor ? How is the Peppol functionality? Is it free? Solved
accounting
Avatar
Avatar
2
d’ag. 25
293
Upload Miscellaneous Operations in Accounting App Odoo 18
accounting
Avatar
Avatar
Avatar
Avatar
4
d’ag. 25
345