Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
Unlike other forms for data input, the report_intrastat_code_form does not seem to allow upload of reference data (available from the EU website) to the underlying table. What is the best way to proceed to mass update of this data ? How to import this data directly to the database tables ? Thanks Patrick.
I finally found out how to upload and use this data.
First you select the data you want to upload (or all of it) either from your national customs authority list (case for France) or from the EU website on the subject. Note that there are approximately 23000 entries. I believe there is a version in each EU language.
Then to complete the configuration steps navigate to Sales / Configuration / Address Book / Intrastat Code and proceed to upload your data by clicking on the import tag and following instructions. Only 2 fields are needed, the intrastat code and the description. The final configuration step willbe to update the inventory part of your products to reflect the appropriate intrastat codes. Note also that the report is driven by a flag (intrastat member) set at country level (preset for all EU countries) also present for update in Sales / Configuration / Addess Book / Localization / Countries.
Subsequent purchases and sales will then record this data and provide the appropriate output from the report provided.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 7/30/13, 4:30 AM|
|Seen: 1613 times|
|Last updated: 3/16/15, 8:10 AM|