openerp-expert-accounting team mailing list archive

[Alexis de Lattre <alexis.delattre@xxxxxxxxxxxx>]

Dear Sven,

Sorry for this late answer : I moved to another city with my familly this
month, so I was too busy to answer all my emails. I put in Cc the accounting
expert mailing-list, because other OpenERP community members may be
interested in my message.

I have worked a lot on intrastat reporting for France recently. In fact,
Akretion worked on this since the end of 2009.
1) at the beginning, we extended the "report_intrastat" module available in
the addons, in order to add some basic functionnalities that were not
present, such as :
  . handle multi-currency
  . handle service declaration
  . implement many things required by French regulations
  . implement XML file export, which avoids manually entering the intrastat
data on the website of the French administration (a great "time saving"
feature !)
This work is available here for OpenERP v5 :
lp:~akretion-team/openobject-addons/openobject-addons_5.0_report_intrastat

2) Then, early 2011, we needed to work again on intrastat reporting in
OpenERP because of a change in French regulations. With my previous
experience coding on the module report_intrastat, I decided that it was time
to rewrite it in order to :
* remove some technical limitations that were linked to the fact that the
main object (report.intrastat) was an osv_memory object and not a regular
osv object
* allow a service-only company to install what is needed for service
intrastat reporting and avoid to install all the objects that are only
needed for product intrastat reporting.

Before starting my rewrite work, I posted in the accounting expert mailing
list :
https://lists.launchpad.net/openerp-expert-accounting/msg01086.html
My goal was to get some info about intrastat reporting in other EU
countries, in order to be able to decide which parts of the code must go in
generic modules and which part of the code must go in France-specific
modules.
Unfortunately, I didn't get much precise information about intrastat
reporting in other EU countries, so I was not able to make a good split
between generic modules and country-specific ones.

The code for OpenERP v5 is available here (pure AGPLv3) :
https://code.launchpad.net/~akretion-team/+junk/new_report_intrastat
The port to OpenERP v6 has already been done, but I need to create a
dedicated Launchpad project in order to have multiple branches (I plan to do
that shortly).

As you can see, there are 3 modules :
- one generic module : intrastat_base, which contains the code which is
common to service and product intrastat reporting
- two France-specific modules : l10n_fr_intrastat_product and
l10n_fr_intrastat_service, which contain the "real" code that generate
service & product intrastat reports for France with their XML exports.

If I find an OpenERP partner based in another EU country which has some good
knowledge of intrastat reporting in his country and is ready to work with
me, then I would be ready to re-organize the code and have 5 modules :
- keep the generic module intrastat_base
- add 2 generic modules intrastat_product and intrastat_service, which would
contain everything that is common among our 2 countries
- 2 France-specific modules : l10n_fr_intrastat_product and
l10n_fr_intrastat_service, which would only contain France-specific stuff.
You would develop you own country-specific modules l10n_at_intrastat_product
and l10n_at_intrastat_service.

Regards,

-- 
Alexis de Lattre
Mail : alexis.delattre@xxxxxxxxxxxx
Jabber/Gtalk : alexis.delattre@xxxxxxxxxxxxxxx

2011/7/7 Sven Petersen <s.petersen@xxxxxxxxxx>

> ** **
>
> ** **
>
> ** **
>
> conexus
> your it solution partner****
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> 7. Juli 2011 ****
>
> *Subject *   OpenERP: EU Intrastat v6**
>
> ** **
>
> ** **
>
> ** **
>
>
> Hello,
>
> according to some of the replies from the OpenERP Partner Mailing List, you
> have Customers who do their Intrastat Reporting with OpenERP.
>
> May I ask you if they are using the report_intrastat Module from v6 and if
> you have made any Adaptions or additional Modules? If so, would you please
> tell me if you would provide those additions for a fee?
>
> Thanks in Advance!****
>
>
> with kind regards,
> Sven Petersen****
>
> [image: Beschreibung: cid:image001.jpg@01C8D5EE.01DB6F70]****
>
> Conexus
> A  6830 Rankweil
> In der Schaufel 54
> T  0043 5522 48331****
>
> F  0043 5522 48381****
>
> E  office@xxxxxxxxxx
> W www.conexus.at****
>
> Vorarlberger Volksbank****
>
> BLZ:  45710****
>
> Konto:  101 017 197****
>
> BIC:  VOVBAT2B****
>
> IBAN: AT31 4571 0001 0101 7197****
>
> UST-NR. ATU36612607 Steuernummer : 363 / 6200****
>
> Handelsgericht Feldkirch 6800****
>
> ** **
>
> ** **
>
> ** **
>