Importing XLS/csv in pre-defined format.

Question

Hi, i need to import sales and purchases from xls or csv files in Odoo16, where have data structure in each row like this:
Date; Client; Currency; Analytical text1; Analytical text2; Product1 Price; Product1 qty ;Product2 Price; Product2 qty;  .... ;ProductN+1 Price; ProductN+1 qty.
For each product I have pre-defined postings in accounting.
Do this is possible with native importing tools, existing app or need separate development?
Thanks in advance!

Thuy Ngoc · Answer

Hi Costa,
I think the following videos can help you:
1/ https://www.youtube.com/watch?v=etMYrOJyaiU&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=2 (starting at 55:00 in this video)
2/ https://www.youtube.com/watch?v=fXjL6fBJkuI&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=4

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
FAILURE TO IMPORT JOURNAL ENTRIES accounting import	1 helmik. 25	1800
Import plan comptable accounting import	0 maalisk. 24	1539
How to handle existing Odoo-data when setting up Odoo accounting? accounting import	1 huhtik. 24	1902
Accounting Reports amount in currency odoo 16 accounting odoo16features	0 helmik. 24	1916
AttributeError: 'dict' object has no attribute 'id' Ratkaistu accounting odoo16features	1 helmik. 24	4472

Tämä kysymys on merkitty

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