Module to build InterVAT documents

openthink-laurent · July 28, 2009, 2:13am

Il y a peu, j’avais répondu à un ancien message du forum concernant un développement de module spécifique à la Belgique et qui permettrait, entre autre, de générer des documents Intervat.

Je viens de publier la version 0.1 beta du module “belgium” qui prend en charge pour l’instant la liste des clients TVA et l’export en format XML Intervat. le module peut être téléchargé à l’adresse suivante : http://people.open-minds.org/laurent/dolibarr-belgium/module_belgium-0.1beta.tgz

Tout commentaire est évidemment le bienvenu.

eldy · July 28, 2009, 3:27pm

I suggest you to post this announce on the french Dolibarr web site (http://www.dolibarr.fr)

openthink-laurent · July 28, 2009, 8:08pm

I just tried but the TinyMCE version used seems to be very buggy. I was unable to add an URL link and to post the article, I always got the following error message : “L’article doit contenir du texte”.

openthink-laurent · July 31, 2009, 1:21am

Could you publish the annonce for me ? Thank you.

eldy · July 31, 2009, 9:40am

I uploaded file on download - modules - more feature.
I added a news also.

openthink-laurent · July 31, 2009, 12:36pm

Thank you ! Could you also add a similar announce on dolibarr.fr since the half of Belgium is speaking french ?

regis · July 31, 2009, 3:37pm

added in dolibarr.fr

openthink-laurent · July 31, 2009, 10:36pm

Great ! Thank you.

jonatan · January 2, 2010, 5:31pm

Finally we don’t know whether we have to speak English, French, Dutch, German or whatever on the Belgian forum
But since there are only French speaking people on this forum, I will write in French. If there is any problem for someone, please tell me and I will translate into English…

Tout d’abord, merci pour ce module très pratique.
Il serait intéressant de développer des modules liés aux spécificités belges, en particulier dans le cas des personnes physiques (le système de compta Dolibarr est plus adapté aux personnes physiques qu’aux sociétés, à l’heure actuelle). Je compte m’y mettre prochainement.

Au niveau des factures de sortie, rien de bien extraordinaire, sauf bien entendu qu’il faut, pour les déclarations, faire la différence entre les taux de TVA.

Pour les factures d’entrée, c’est un peu plus compliqué puisqu’il y a différents cas à gérer, par exemple :
- un simple achat purement professionnel en Belgique : le montant HTVA en marchandises, SBD ou investissements, le montant de la TVA en TVA déductible
- un achat en intra-communautaire : avec la prise en compte des cases AIC et TVA sur AIC, et le calcul d’une TVA “simulée” en TVA déductible
- des dépenses partiellement professionnelles et donc partiellement déductibles (les plus classiques sont les frais liés à un immeuble mixte, pour ce qui n’est pas physiquement séparé, ou les frais de matériel roulant n’étant pas 100% utilitaire) : les montants HTVA et de TVA déductible sont une fraction du montant total
- les importatations hors UE et exportations, mais ces cas là étant plus rares, je pense qu’ils sont moins importants

Si d’autres personnes veulent travailler à ce module, qu’ils se manifestent
Cela permettrait de faciliter grandement la tâche à bon nombre d’indépendants en personne physique qui, comme moi, se chargent eux-mêmes de leur comptabilité.

Jonatan

eldy · January 4, 2010, 11:39pm

Language rules are:
English for forum on dolibarr.org
French for forum on dolibarr.fr

le_top · January 16, 2010, 12:08am

eldy made the rules clear. I just want to hightlight that there are not only french speaking people on this forum.
For instance, I am a Belgian guy living in France, natively speaking Dutch, but in daily life French and generally English on the web or in mails.

Dus dat kan soms wel ingewikkeld worden ;-).

[translation: That can become difficult from time to time ;-)]

IC-it · November 30, 2010, 5:41pm

Hello,

We’ve just started using Dolibarr as account system. As I’m living in Belgium (Dutch part… we’re very interested in knowing if the VAT module 0.1 Beta is working correct.

If this is the case, we can install and use it. Thanks to the designer!!

Should this message be unreadable for Frennch speaking Belgian readers they can send me and Email or reply. I’ll translate it (as far as I can) into French then.

As said before her, being Belgium is a ‘bit complicated’

IC-it · November 30, 2010, 9:07pm

We’ve installed the module and I see an additionale tab “Belgium” on the board. Problem is that the tab is not active and seemingly I can’t reach that button.

Can anyone tell me what’s wrong?

openthink-laurent · November 30, 2010, 9:45pm

There are rights to:
- read VAT clients list
- export VAT clients list as XML (InterVAT format)

You have to give appropriate permissions to the user/group to use the Belgium module.

IC-it · December 1, 2010, 8:36am

Thanks for the reply.

The module is active and has an “green light” on the control board. You mentione a VAT read list and VAT export list. How is that done then?

Seemingly we missed out something on the permissions. Could you give some more info/assistance?

Thanks!

openthink-laurent · December 1, 2010, 9:28am

First you have to enable the module (green light) in “Home > Setup > Modules”.

Then you have to add the permissions to use the module to each user/group you want in “Home > Users & Groups > USER_OR_GROUP > Permissions tab”.

If you need it, you can contact me for more assistance.

IC-it · December 1, 2010, 1:35pm

Laurent

OK we can access the module now (haven’t changed anything, just logged out completely and logged in again.)

In the client list I see 2 clients/suppliers with VAT turnover and VAT amount, although there should be more clients/suppliers in this list.

All clients/Suppliers have a code BE… added in the box “professional number” but only these 2 show op in the list.

Could you give some more info how we can add the other clients so they appear in the list?

openthink-laurent · December 1, 2010, 2:01pm

Only clients with a belgian VAT number and turn over >= 250 euros should appear in the VAT clients list.

IC-it · December 26, 2010, 4:20pm

Hello

We managed to get a TVA listing of the clients. The listing gave tough some errors due to the format of TVA numer I guess. Could you tell in wich format we put in the TVA number and where we put in teh numer in teh Dolibaar system (as profesional numer or as TVA. I’ve tried both but it keeps giving failure notes whem I open the xml in INTERVAT.

Another question; is there also a possibility to export alle the data for a full TVA document that we have to fill in every 3 mon,ths (don’tknow how to translate that; in Dutch it’s the " kwartaalaangifte".

When i go to the tab “Belgium” in Dolibaar I see also an tab INTERVAT beside “BTW klantenlisting” but nothing happens as I click the tab.MAybe we have to make a hyperlink somewhere?

openthink-laurent · December 27, 2010, 2:14am

You have to fill in your VAT number in “Home > Setup > Company/Foundation > VAT number” in the following format : BE0XXXXXXXXX.

At this time, there is no support for monthly/quarterly VAT declaration.

I’m currently working on the next version of Belgium module that will fix some bugs, add data checks and update VATList schema. This release will be Dolibarr 2.9.x compliant, but I will release a Dolibarr 2.8.x compliant version too.

I know I already wrote ont this thread about the next release, but I work on Dolibarr module during my leisure. I’m a self-employee software developper and system administrator so feel free to support this development with financial donation or various help (development, documentation, translation…) to speed up development.