Odoo Help

Welcome!

This community 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.

2

How to upload EU commodity codes (report_intrastat) ?

By
Patrick
on 7/30/13, 4:30 AM 1,491 views

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.

0
Patrick
On 5/17/14, 2:36 AM

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.

 

Your Answer

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 7/30/13, 4:30 AM
Seen: 1491 times
Last updated: 3/16/15, 8:10 AM