open source basecamp

 

Posts Tagged ‘openobject’

OERPScenario, the test suite for OpenERP

Wednesday, March 10th, 2010 by Joël Grand-Guillaume

Hi!

On February 12, 2010, at the last IRC meeting between OpenERP SA and the Official Partners, OERPScenario has been accepted as the Official test suite for the version 5.0 of OpenERP. Camptocamp is very proud of this milestone since our team has spent a lot of energy in the development of this project, allowing OpenERP to become more stable and more reliable.

In order to scale up this project, we recently improved the usage and ease of the test launching by reviewing the tags.

We are also currently working to implement OERPScenario into the continuous integration server of OpenERP: http://test.openobject.com .  This will guarantee the use of the test suite in the development process, the resulting tests being run before every release.

Your contributions are essential to help us write scenarios ; for this purpose,  we created a documentation. This documentation concerns both technical and business individuals and will be soon included in the http://doc.openerp.com website. For now, you can have access to it by downloading the following pdf : http://dev.camptocamp.com/files/OERPScenario/documentation.pdf

Business individulas can easily write scenarios description using the Gherkin Syntax as explained into the documentation. Feel free to add your own as a blueprint on Launchpad :

https://blueprints.launchpad.net/oerpscenario

Camptocamp will write them all as soon as possible, but developers are welcome to help us :)

Feel free to ask your questions in OERPScenario’s FAQ (https://answers.launchpad.net/oerpscenario ), we’ll be happy to help you understand, use and contribute to OERPScenario.

Best regards,

Joël Grand-Guillaume

Customizing OpenERP to support international companies

Tuesday, March 2nd, 2010 by Joël Grand-Guillaume

Hi,

I am proud to announce the integration of Camptocamp’s work in the future stable version of OpenERP. It took place a few days ago in the trunk branch! This work consisted of improving the management of the multi-company component in OpenERP. It is now possible to define, for each product and each company, the currency and the price field to assign to a specific product.

Our contribution resulted in the following improvements:

  • Use the new company defined price type (currency and field) for a product
  • Adapt stock accounting
  • Adapt analytic accounting and Timesheet
  • Factorize part of the code to ease the maintenance (mostly in analytic accounting)
  • Add the multi-currency fesature on analytic lines (therefore, making it similar to the financial accounting)
  • Correct the analytic indicators to take care of multi-currency entries
  • Keep the same default setting to ease the transition to the new feature

As a result, it is now possible for companies to  share the same product between them, eventhough they don’t use the same currency and/or same cost price. This applies to  manufacturing companies and services companies, as this improvement concerns both stock and analytic accounting.

We can manage one field per company on the product form to store the cost of a given price type (and so for a given company). This simplifies the price updating quite a lot.

Browsing the analytic account on the tree view now displays the right values according to each account currency!

We also back-port those modules on the current stable version, in the extra-addons branch with the following names:

  • c2c_multicost_base
  • c2c_multicost_expense
  • c2c_multicost_project_timesheet
  • c2c_multicost_stock
  • c2c_multicost_timesheet
  • c2c_multicost_timesheet_invoice
  • c2c_multicost_user_function

More news soon about our next contribution!

Best regards,

Joël Grand-Guillaume

One Time Password on OpenERP by Camptocamp

Monday, February 22nd, 2010 by Joël Grand-Guillaume

Hi,

Camptocamp is proud to announce the release of 2 new modules and a specific branch of the GTK client, providing OpenERP with OTP (One Time Password). The GTK client has been modified and now presents a third field on the login form, preventing overload on the OpenERP server.

The server part is composed of two modules:

  • The first one, supporting OTP in a generic way (handling session, …)
  • The second one, providing support for the Yubikey system (http://www.yubico.com/products/yubikey/).

You can download the GTK client here:

bzr clone bzr+ssh://bazaar.launchpad.net/~c2c/openobject-client/5.0-c2c-otp/

…and find the following server modules in the official extra-addons branch:

  • c2c_one_time_password_login
  • c2c_one_time_password_login_yubikey_provider

If you want to try it, buy a yubikey, download the client and install both modules. You just need to provide the Yubikey identifier on the required user. That’s it !

Feel free to make your comments or contributions to support another OTP system.

Enjoy !

Joël Grand-Guillaume

Releasing Easy-OpenERP for 1coach

Thursday, February 11th, 2010 by Joël Grand-Guillaume

** English below **

Bonjour,

L’équipe “Business Solutions” de Camptocamp est fière d’annoncer la sortie d’Easy-OpenERP, une offre SaaS low-cost pour OpenERP réalisée pour l’un de nos clients, 1coach.

Cette nouvelle offre est spécialement adaptée aux petites compagnies et aux associations. L’ensemble a été configuré pour les particularités Suisse : comptabilité, paiements électroniques, taxes, etc…

Vous pouvez la tester ici (utilisateur :demo, password: demo) :

http://demo.easy-openerp.ch/

Plus d’informations ici :

http://easy-openerp.ch

Cordialement,

Joël Grand-Guillaume

* English *

Hi,

Camptocamp’s “Business Solutions” team is proud to announce the release of Easy-OpenERP, a low-cost OpenERP SaaS offer that has been developed for one of our customers, 1coach.

This new offer is particularly designed for small companies and associations. The configuration is specifically adapted to Switzerland: accounting, electronic payments, taxes, etc..

You can test it there (user :demo, pass: demo) :

http://demo.easy-openerp.ch/

More infos here (in french only…) :

http://easy-openerp.ch

Regards,

Joël Grand-Guillaume

OpenERP & PostFinance : paiement OPAE

Monday, January 11th, 2010 by Luc Maurer

** English below **

Grâce à Camptocamp, il sera bientôt possible de générer un fichier OPAE (Ordre de Paiement Electronique) pour PostFinance.

Camptocamp, en tant qu’éditeur de la localisation Suisse et principal intégrateur de la solution, assure régulièrement l’amélioration des possibilités offertes par OpenERP pour le marché Suisse. Notre équipe a donc débuté le développement des paiements via fichier OPAE, répondant ainsi aux nombreuses demandes des petites et moyennes entreprises. Ce développement devrait normalement être terminé d’ici fin février 2010 et sera inclus dans le module l10n_ch.

Le financement de ce module est entièrement pris en charge par Camptocamp ; dans le cas où vous souhaiteriez nous aider à développer les fonctionnalités d’OpenERP, toute contribution de votre part est toujours grandement appréciée!

Salutations à toutes et à tous.

Luc Maurer

*English*

OpenERP & PostFinance :  OPAE payment

Thanks to Camptocamp, it will be soon possible to generate an EPO (Electronic Payment Order) file transfer for PostFinance.

Editor of the Swiss localization and main integrator of the solution, Camptocamp regularly makes sure OpenERP improvements and updates are adapted to the Swiss market. Our team committed to the development of payments via EPO file transfers in order to meet the needs of SMEs. This development will be completed by the end of February 2010 and will be included in the l10n_ch module.

The elaboration of this module is entirely financed by Camptocamp ; should you wish to participate to the development of the functionalities of OpenERP, any contribution from you is always greatly appreciated!

Best regards,

Luc Maurer

OERPScenario : The simple way to write test scenario for OpenERP

Friday, October 30th, 2009 by Joël Grand-Guillaume

Hi !

After making hundreds of checklists and manual testings, our team decided to create a tool which allows users to write test scenario for OpenERP. It’s just a Beta version for now, but we’re convinced that it will improve the global performance of OpenERP. This tool allows users to launch a set of functional tests on a specific OpenERP server and to get a result for each test in pdf, html, junit or text format.

See the html example here : http://dev.camptocamp.com/files/OERPScenario/result.html

This project is developed with the Ruby language and the cucumber library.

A few words on our choice:
• It’s separated from OpenObject, so bugs won’t affect it
• Business specialists can write tests without any technical knowledge
• Fully integrated with Ruby (it will allow us at one point to release a Web-interface)
• Modular and very easy to learn and to contribute to
• Rails compatible
• Ruby rocks !
With additional new tests, we hope that we’ll be able to avoid most critical regressions in the near future.

Feel free to make comments and contributions to this project : https://launchpad.net/oerpscenario


Regards,
Joël Grand-Guillaume

Camptocamp improve the Swiss localization (l10n_ch) / Camptocamp améliore la localisation Suisse (l10n_ch)

Monday, October 26th, 2009 by Joël Grand-Guillaume

** (French part below) **

Hi all !

I have the pleasure to announce that Camptocamp released improvements to the OpenERP official Swiss localization module (l10n_ch). Remember that Camptocamp is the official developer and maintainer of this localization!

This module includes:

  • Full BVR support to generate electronic invoices in Switzerland
  • Import of standardized bank V11 files  from Swiss bank into OpenERP
  • Electronic payments via DTA (specific electronic payments used by Swiss banks)

This new release includes the following improvements:

  • DTA generation file : avoids encoding errors (thanks for contributions)
  • Support of old BVR references
  • Temporary solution for the non functional expr tag in the RML
  • Temporary solution for the missing ocrb file
  • Easy insertion of fields on the res.partner.bank view : allows to choose what to print on BVRs
  • Support on error messages translation
  • Addition of last translations from Launchpad

Note:  OpenERP still has trouble with payment orders in foreign currency; this affects also the DTA payments into our Swiss localization.

Best regards,

Joël Grand-Guillaume

—-

Bonjour à tous !

J’ai le plaisir de vous annoncer la sortie d’une nouvelle version du module de la localisation Suisse pour OpenERP (l10n_ch), incluant de nouvelles amélioration.

Camptocamp est le développeur et le mainteneur officiel de cette localisation. Ce module inclut les fonctionnalités suivantes:

  • Support des BVR pour la génération de factures
  • Importation des fichiers bancaires standardisés V11 dans les états bancaires d’OpenERP
  • Paiements électroniques via les fichiers DTA dans toutes les banques suisses

Cette nouvelle version inclut les améliorations/corrections suivantes:

  • Génération des DTA : Suppressions des erreurs d’encodage (merci pour la contribution)
  • Support des anciennes références BVR
  • Solution temporaire pour le tag “expr” qui n’est plus supporté dans l’API OpenERP
  • Solution temporaire pour le fichier manquant “ocbr”
  • Ajout de champs dans la vue res.partner.bank qui permet maintenant de choisir ce que l’on imprime sur son BVR
  • Support de la traduction sur les messages d’erreurs
  • Ajout des dernières traductions en provenance de Launchpad

Note: OpenERP a toujours des problèmes avec les paiements en devise étrangères, cela affect aussi les paiements  DTA de notre localisation Suisse.

A bientôt,

Joël Grand-Guillaume

Integration OpenERP - Magento - POS - iPhone

Thursday, October 22nd, 2009 by Joël Grand-Guillaume

Hi all,

With the collaboration of Scalena Agency SA and the RFID Center (Icare institute), Camptocamp was awarded an international project to implement OpenERP with Magento and an iPhones Apps !

Some of the requirements/features to develop in this very interesting project are:

  • Sync OpenERP with Magento - OpenERP using the brand new Magento-OpenERP connector
  • Point Of Sale : OpenERP integration with “Cash register”
  • Use of iPhones as a bar code reader
  • Management of a datawarehouse  for statistic purpose
  • Various locations to handle worldwide

In order to provide you with a better integrated solution between Magento and OpenERP, Camptocamp will participate to the development of the connector, in collaboration with its  authors i.e.  R. Valyi and S. Thomas.

Thanks to you guys!  You made an excellent job at making this kind of project possible !

Regards,

Joël Grand-Guillaume

Update your OpenERP data by yourself with the new import/export financed by Camptocamp

Wednesday, August 12th, 2009 by Joël Grand-Guillaume

Hi all!

We’re proud to announce the release of a brand new feature in the stable version of OpenERP 5.0.1: the management of OpenObject and PostgreSQL IDs in the import/export system. Camptocamp financed this new feature in order to allow people to update their stored data through the standard GTK Client.

With this new feature you can:

  • Affect a new, or change, the OpenObject ID of any object in the database,
  • Update stored data by exporting/importing them (based on the PostgreSQL ID or the OpenObject ID),
  • Let your customers update their data themselves via CSV files.

Concrete example:

You need to keep the product cost prices in sync with your supplier price lists (let’s say you have only one supplier per product for this example). Your suppliers give you an Excel file of all prices and references.

  1. First, you’ll need to export your product with the PostgreSQL and the OpenObject IDs into a CSV file. Take at least all required fields.
  2. Update the exported file with the supplier information. Put the new cost price and affect the supplier product reference as OpenObject ID.
  3. Import the updated file. That’s all! The new product will be created and the existing one will be updated, nothing will be deleted.

Note: next time you’ll only need to export the OpenObject ID in order to update the data. You won’t need the PostgreSQL ID anymore unless you need to update the supplier product reference!

Joël Grand-Guillaume

OpenERP tax 100% on import

Wednesday, July 8th, 2009 by Luc Maurer

Companies that are making importations often receive invoices from the carrier which does only have taxes.

Here is a small tutorial on which you will learn how to input it into OpenERP to be sure that the tax declaration is correct. This screencast should also help you.

Tax code creation

The first step is to create a new tax code : "100% import" for example.

  1. Create a new tax code : financial managerment > configuration > financial accounting > taxes > taxe
  2. Type = Percent
  3. Amount = 0
  4. Tax account and child tax account = nothing
  5. Tax application = purchase (never put all)
  6. Base code and Refund base code (2nd tab) = the tax code you are normally using for purchase tax code
  7. Base code sign = -1
  8. Tax code sign = 1

New supplier invoice

When you receive a new carrier invoice with tax on it (for example 2000 CHF):

  1. Add a new line for the tax => put the amount : 2000
  2. The account is the "tax refund account" => that mean the account you are normally using to put the VAT amount you will received from the tax administration => in switzerland : "1170 TVA déductible sur achat de biens et services"
  3. Specify the tax of the invoice line : "100% Import" and press tax computation

That’s it ! I hope it will help you.