Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Import journal items entry in odoo accounting journal as opening balance from csv file

accounting importing journal_entry

2 Vastaukset

12373 Näkymät

rais

Is it possible to import (using odoo csv import) into one journal entry (let's say journal number GJ01) and add all items as child entry, such that it will balance the journal automatically?

Suppose below is my General Journal (GJ) entries csv items.

Number,Period,Journal,Date,Ref,Name,Account,YTD Debit,YTD Credit

GJ01,May 2015,General Journal,2015-05-01,Opening Balance ,May 2015,Electronic Clearing Ac," $25,000.00 ",

GJ01,May 2015,General Journal,2015-05-01,Opening Balance ,May 2015,Pension Acc.," $25,000.00 ",

GJ01,May 2015,General Journal,2015-05-01,Opening Balance ,May 2015,Trade Debtors," $200,000.00 ",

GJ01,May 2015,General Journal,2015-05-01,Opening Balance ,May 2015,Prepayment Insurance," $100,000.00 ",

GJ01,May 2015,General Journal,2015-05-01,Opening Balance ,May 2015,Prepayment Workers Comp.,," $100,000.00 "

GJ01,May 2015,General Journal,2015-05-01,Opening Balance ,May 2015,Less Prov'n for Doubtful Debts,," $250,000.00 "

I did import using the above csv and it recorded six records into the object account.move and six records into the account.move.lines. Actually, I wanted one record in account.move and six records in account.move.lines.

Is there any tool or way/s to achieve my goal?

Thanks.

KEVIN NIHBE

Hello all

Is it possible to import journal entries with a partner ID at line item ?

In fact the partner ID correspond to employee in the salary balance sheet account in order to make account auxiliarization.

Thank you for your help

Jérôme TANCHÉ

Hi Rais,

in order to do that, I think that you just have to modify your CSV file like this :

Number,Period,Journal,Date,Ref,Name,Account,YTD Debit,YTD Credit
GJ01,May 2015,General Journal,2015-05-01,Opening Balance ,May 2015,Electronic Clearing Ac," $25,000.00 ",
,,,,Opening Balance ,May 2015,Pension Acc.," $25,000.00 ",
,,,,Opening Balance ,May 2015,Trade Debtors," $200,000.00 ",
,,,,Opening Balance ,May 2015,Prepayment Insurance," $100,000.00 ",
,,,,Opening Balance ,May 2015,Prepayment Workers Comp.,," $100,000.00 "
,,,,Opening Balance ,May 2015,Less Prov'n for Doubtful Debts,," $250,000.00 "

The first four fields relate to each move, and should be filled only on the first line of a move.

While the five following fields relate to each move line, and must be completed on each line.

Regards,

Jérome

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Errors importing chart accounts in .xls accounting importing	1 kesäk. 24	1588
What is the purpose of Journal Entries and Journals in Odoo? Ratkaistu accounting journal_entry	3 toukok. 24	9979
How to write items in journal entry programmatically? accounting journal_entry	0 huhtik. 22	4706
Account Journal Entries Creation In Odoo14? accounting journal_entry	0 huhtik. 24	5819
How do I see the Journal Entries? Ratkaistu accounting journal_entry	2 elok. 18	12863

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!