From the view of products, I want to export quantities on hand to a csv file, using the export menu. The list of fields available for export does not contain any field related to quantities.
Is there an other way to export such data?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- ลูกค้าสัมพันธ์
- e-Commerce
- ระบบบัญชี
- สินค้าคงคลัง
- PoS
- โปรเจกต์
- MRP
คำถามนี้ถูกตั้งค่าสถานะ
7
ตอบกลับ
35432
มุมมอง
In Version 7.0, Open Sales/Products/Products Menu Select any product or all products, In More: click on export and wizard is open. On that wizard, Selection field is there 'Export Type' in that select 'Export all data' and select field 'Quantities on Hand' on left grid view. After that click on 'Add' button to take that field and then click on 'Export to File' to export all data related to quantities on hand are stored in 'CSV' file. And if you want to store data in excel sheet, then select 'Export Format' to 'Excel'.
then how to import quantity? i can't found a field call 'Quantities on Hand'.
did u find how to import quantity?
I believe you can import quantities by using the inventory menu
it looks like you can't import it, since it only appears in the "export all data" view and not the "export-import compatible only"
HI Michel,
You can check below apps which will export fields of data for any application into excel format
https://apps.odoo.com/apps/modules/10.0/dev_export_excel/
Hope it Helps !
Thanks ,
Devintelle : Odoo Support Service Provider '
Mail: Devintelle@gmail.com
Check out this free app : it may useful to you. https://www.odoo.com/apps/modules/8.0/ir_export_extended_ept/
สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!
สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!
ลงชื่อ| Related Posts | ตอบกลับ | มุมมอง | กิจกรรม | |
|---|---|---|---|---|
|
1
มี.ค. 15
|
4816 | ||
|
0
มี.ค. 15
|
6624 | ||
|
2
ม.ค. 22
|
10407 | ||
|
1
มี.ค. 15
|
11487 | ||
|
1
มี.ค. 15
|
13140 |
My apologizes; export of quantities is available when selecting the choice "all types of data". The export works; however the numerical values are considered as characters when reading the csv file with openoffice/calc.A transformation to numerical value needs to be done with openoffice.