Pycon 2015

Veröffentlicht: 2015-03-26 10:00:00+00:00 pycon

This year, there will be 2 Foundation members (Sharoon Thomas and Cédric Krier) present during the PyCon 2015 at Montréal. PyCon is the largest annual conference for the Python community which Tryton is a part of.

If you want to meet Tryton's people, we will host an Open Space and sprint on Tryton will be organized.

Fundació UAB students to use Tryton in their business management classes

Veröffentlicht: 2015-03-23 12:00:00+00:00 university

An agreement signed between the Fundació Universitat Autònoma de Barcelona (FUAB) and NaN·tic will allow all International Trade students to use Tryton in their practical classes. The Catalan company NaN·tic will deploy and set up this software for 30 students a year ensuring them "a 100% real experience" during their practical classes. This means that they are going to learn how to manage business opportunities, sales, purchasing, production, logistics... to summarize: all Tryton’s functionalities. NaN·tic will also provide assistance and technical support to all the teachers staff to ensure a successful training.

Albert Cervera, NaN·tic co-founder and Tryton’s Foundation board member, explained that "this agreement will let students work in a technological environment like those that can be found in any business. Using this tool they’ll improve their knowledge of business management and, by extension, their chances to land on the job market". In addition, Cervera also noted that "with this deal Fundació UAB obtains an ERP with large benefits and with excellent growth prospects, while Tryton is introduced to the university thankfully to an institution as prestigious as the Fundació UAB." Albert Cervera remarked the importance of recognition to the open source technologies by highly reputed institutions as university foundations. Cervera is totally convinced that this type of agreement can be replicated by many other universities anywhere in the world.

NaN·tic has also announced collaboration with other universities such as Universitat de Barcelona, where they showcase Tryton to students of Businsess Administration. In this case, around 90 students a year will be in touch with an ERP for the first time in their life thanks to Tryton and NaN·tic.

Yet this is just the beggining. Other agreements with several Catalan educational institutions are being negotiated right now. NaN·tic expects to have 10 such agreements by the end of the year which will ensure a bright future for Tryton in Catalonia. Hopefully, other countries will follow as in Leipzig NaN·tic already offered their help to the Tryton community if other organizations want to lead the same initiative in other countries.

Tryton Unconference 2015 - Call for location proposals

Veröffentlicht: 2015-02-16 12:00:00+01:00 TUx foundation

It's time to plan the fifth TUx and put a capital letter in the x.

The Tryton Foundation is calling for community members (individuals or organizations) that want to establish a local team and host our 2015 global event in November.

Previous editions have taken place in Belgium, Spain and Germany.

Please send your application to foundation@tryton.org. You have time until 30th April.

If you have any questions please feel free to contact us on the tryton@ mailing list .

New Tryton release 3.4

Veröffentlicht: 2014-10-20 18:00:00+00:00 release

We are proud to announce the 3.4 release of Tryton.

In addition to the usual improvements of existing features for users and developers, this release has seen a lot of work done on the accounting part.

Of course, migration from previous series is fully supported with the obvious exception of the ldap_connection module which was removed.

Major changes in graphical user interface

  • The search of relation record has been re-worked to take advantage of the auto-completion. The search box of the pop-up window is filled with the text entered in the widget.

  • The search/open button of the Many2One widget is now inside the entry box and the create button is removed in favor of auto-completion actions or pop-up button. This change allow to harmonize the size of all widgets inside a form.

    many2one button inside
  • A new image widget is available on list/tree view.

    widget image tree
  • The client can now perform a pre-validation before executing a button action. The validation is based on a domain and so the offending fields can be highlighted and focused instead of having an error message pop-up.

  • The selection label are now available in addition of the internal value for the export data (CSV) functionality.

  • The export data window is now predefined with the fields of the current view. This gives a fast way to export what you see.

  • The predefined export can now be replaced directly with a new selection of fields. This eases the process of creating such predefined exportation.

  • It is now possible to re-order the list of the exported fields using drag and drop.

  • The range operator of the search box is now including on both endpoints. It appears to be less astonishing behavior for users even if the previous behavior including-excluding had some practical advantages.

  • The client loads now plug-ins defined in the user local directory (~/.config/tryton/x.y/plugins).

Major changes on the server side

  • A new Mixin MatchMixin is introduced. It allows to implement a common pattern in Tryton to find records that match certain values.
  • Another UnionMixin is also introduced. It allows to define a ModelSQL which is the UNION of some ModelSQL's.
  • Actually, Tryton doesn't update a record defined in a XML file if this one has been modified outside the XML. Now, it is possible to find those records and force the update to get the record synchronised with the XML.
  • A Python descriptor has been added to the Selection field. It allows to define an attribute on a Model which will contains the selection label of the record. It is planned to update all the reports to use such descriptor instead of hard-coded values.
  • A new configuration file format is introduced for the server. It is easily extendable to be used by modules. For example, the ldap_authentication module starts using it in replacement of the removed ldap_connection.
  • It is now possible to give a logging configuration files to setup the server logging. This file uses the Python logging configuration format.
  • The context defined on relation fields are now used to instantiate the target.
  • The SQL clause for a domain on a field can be now customized using a domain_<field> method. This method allows in some cases a more efficient SQL query. The method is designed to support joins.
  • The access rights has been reworked to be active only on RPC calls. With this design, Tryton follows the principle of checking input on the border of the application. So it is no more required to switch to the root user when calling methods requiring some specific access rights as far as it is not from an RPC call.

Modules

Account

  • A new wizard to help reconcile all accounts has been added. It loops over each account and party and makes a proposal of lines to reconcile if it could find one. This really speeds up the reconciliation task.

    reoncilie wizard
  • There is also another new wizard to ease the creation of cancellation moves. The wizard also reconciles automatically the line with the cancelled sibling.

  • A new option Party Required on account has been added. This option makes the party required for move lines of this account and forbids it for others.

Account Invoice

  • It is now possible to configure which tax rounding to use. There are two ways implemented: per document and per line. The default stays per document.

Account Payment

  • It is now possible to change a succeeded payment to failed.

Account Payment SEPA

  • The scheme Business to Business is supported for direct debit.
  • The mandate receives now a default unique identification using a configured sequence.
  • The module supports now the bank to customer debit/credit notification message (CAMT.054).
  • A report to print a standard form for mandate has been added.

Account Statement

  • It is now possible to order the statement lines and to give them a number. With those features, it is easier to reproduce the same layout of a bank statement.
  • A report for statement has been added. For example, it can be used when using the statement for check deposit.
  • A validation method can be defined on the statement journal. The available methods are: Balance, Amount and Number of Lines. This helps to uses the statement for different purposes like bank statement or check deposit.

Account Stock Continental/Anglo-Saxon

  • The method is now defined on the fiscal year instead of being globally activated on module installation.

Country

  • It is now possible to store zip code per country. A script is provided to load zip codes from GeoNames.

LDAP Authentication

  • The module ldap_connection has been replaced by an entry in the configuration file of trytond.

Party

  • The new zip code from the module country is used to auto-complete zip and city field on address.

Purchase

  • The Confirmed state has been split into Confirmed and Processing, just like the Sale workflow.

Sale Supply Drop Shipment

  • The management of exception on drop shipment is propagated from the sale to the purchase.

New modules

  • The Account Payment Clearing module allows to generate clearing account move when a payment has succeeded between the receivable/payable account to a clearing account. The clearing account will be reconciled later by the statement.

Proteus

Proteus is a library to access Tryton like a client.

  • It is now possible to run reports. It is useful for testing them.
  • A new duplicate method is added which is similar to the copy menu entry of the client.

Security Release for issue4155

Veröffentlicht: 2014-09-30 10:00:00+00:00 release security

Synopsis

A vulnerability in trytond has been found by duesenfranz, that might allow a malicious user to execute arbitrary commands on the server via the safe_eval function (see issue4155).

Impact

Any authenticated user can run arbitrary commands on the server with the permissions of the trytond user.

Workaround

There is no workaround.

Resolution

All users should upgrade trytond to the latest version of the used series.

Concern?

Any security concerns should be reported on the bug-tracker at https://bugs.tryton.org/ with the type security.

Tryton Unconference Leipzig 2014

Veröffentlicht: 2014-09-15 12:00:00+00:00 TUL

This year the annual Tryton Unconference will take place in Leipzig the 14th, 15th and 16th of November at the Leipzig University of Applied Sciences.

This will be the fourth global meeting where users, developers and interested people will have the opportunity to discover or talk about Tryton.

Until now, the following talks are proposed:

(More to be announced on our Lanyrd page)

The second Foundation Supporter Meeting will take place on Saturday 15h, 18.00.

On Sunday 16th, a Sprint is planned at the Hackerspace sublab.

Registration is available at TUL 2014.

If you like to give a talk, please announce it on Lanyrd. If you want to request a talk on a specific topic, you can send your request to the Tryton mailing list. If you have question about the organisation, please contact the foundation at foundation@tryton.org.

And don't forget to spread the word! #TUL2014

Videos of the Tryton Unconference 2013

Veröffentlicht: 2014-06-05 12:00:00+00:00 TUB video
Finally, the videos recored during the last Tryton Unconference 2013 are available. It took some time to synchronize the sound with the image but thanks to Pierre-Louis Bonicoli we have them now.

New Tryton release 3.2

Veröffentlicht: 2014-04-21 20:00:00+00:00 release

We are happy to announce the 3.2 release of Tryton.

This release mainly consolidates many new functionalities added in last two years. Also it prepares the future migration to Python 3 by dropping the support for Python 2.6. But also as usual there are many bug-fixes, improvements and new modules (see below).

Of course, migration from previous series is fully supported.

Major changes in graphical user interface

  • The client uses the local timezone to display date time.

  • The copy/paste on editable list has been improved to add new lines if needed beside of updating existing records.

  • The buttons of the view are also available in the action menu. This allows fast access using keyboard shortcuts but also trigger the button for a list of selected records.

    button action menu
  • Buttons and wizards can now trigger actions from the client side. This means it behaves like if the user clicked on one of the tool bar buttons.

  • The client uses now a pool of connections, this allows to speed up the client on requests that can be parallelized.

  • The attachment button can now receive drag & drop of file to quickly create attachments.

  • There is a new widget multi-selection, it uses the Many2Many field as backend. It is very useful and more visual when there is a small number of selection.

    multiselection
  • The client allows to browse the revisions of a record if it is historized. It also works on a full list of records, in this case the client shows the result of the search as if it was done at the revision date.

    revisions

Major changes on the server side

  • The server runs internally always in UTC timezone.
  • The ModelStorage.write method receives the similar improvements as the ModelStorage.create in version 2.8. This means it can write different values to many sets of records in one call and so this improves the performance by validating all the records at once and also it will validate only the modified and dependant fields. Also the action values of relation fields have been updated with the same interface.
  • A new decorator fields.depends is introduced to replace the deprecated on_change, on_change_with, selection_change_with and autocomplete fields attributes. This decorator applies on the called methods and the result will be the sum of all depends of all the modules, this brings much more flexibility to the modularity.
  • Tryton uses bcrypt to hash password if the library is available.
  • All types of field can now have a domain to constraint its value and most of the domains are supported for pre-validation and inversion on the client side.
  • The on_change returned value of One2Many uses now an index for the add keyword. This allows to define the position of the new record in the list instead of being always at the bottom.
  • A new method ModelSQL.restore_history allows to restore the values of a record as they were at a specific date time.

Modules

Account

  • A new journal type write-off has been added to ease the creation of write-offs.
  • Taxes has now an optional start and end, this allows to manage the changes over time.

French Chart of Account

  • The French chart of account has been updated for the new tax rates of 2014.

Account Statement

  • The module prevents now to use an already paid invoice in draft statements.
  • It uses the new index of on_change to add the new split line under the original.

Account Stock Continental

  • The creation of account move for stock move is speed-up.

Bank

  • The IBAN numbers are now validated and formatted.

Company

  • A new timezone field is added to the company to get the right date for today.
  • The employee is also taken from the context just like the company. This allows to use many clients with the same user but different employees.

Production

  • It is now possible to define the effective date of a production. This allows to enter past productions.

Purchase

  • There is now a warning when trying to receive a supplier stock move without an origin. Normally, the origin should be a purchase order.
  • The purchase tries to create links between stock moves and invoice lines.

Sale

  • The same warning exists for customer move without origin.
  • The sale tries as the purchase to create links between stock moves and invoice lines.

Stock

  • Supplier Shipment Return can now have partial assignation
  • The computation of stock quantities has been reworked to allow easy customization and better search.
  • It is now possible to define the effective date for all shipments. This allows to enter past shipments.

Stock Lot

  • A new relate has been added from lot to moves.

New modules

  • The Party Relationship module defines different types of relations between parties.
  • The Account Payment module allows to generate grouped payments for receivable and payable account move lines.
  • The Account Payment SEPA module allows to generate SEPA files for payments.
  • The Stock Package module allows to store packaging information about customer and supplier return shipments.
  • The Sale Shipment Grouping module adds an option to define how stock moves generated from sales will be grouped.
  • The Account Credit Limit module manages credit limit of parties.
  • The Sale Credit Limit module adds confirmed sale to the credit amount of the party.

Security Release for issue3446

Veröffentlicht: 2013-11-04 10:00:00+00:00 release security

Synopsis

A vulnerability in tryton has been found, that might allow a malicious server to send a crafted extention as answer to a report request leading the client to write the report on any file of the client host with the right of the user running the client (see issue3446).

Impact

Any file can be created on the client host with the access permissions of the user running the client.

Workaround

Users should connect only to trusted servers.

Resolution

All users should upgrade to the latest version of the used series.

Concern?

Any security concerns should be reported on the bug-tracker at http://bugs.tryton.org/ with the type security.

Neues Tryton Release 3.0

Veröffentlicht: 2013-10-21 18:00:00+00:00 release

Wir freuen uns, die Veröffentlichung von Tryton 3.0 bekannt zu geben!

Dieses Release bringt eine neue Kalenderansicht im Frontend, und ist weiterhin das Ergebnis eines weitreichenden Code-Refactorings, welches mit dem python-sql Projekt vor 2 Jahren gestartet ist. Des weiteren gibt es auch viele Fehlerkorrekturen, Verbesserungen und neue Module (siehe unten).

Wie immer ist die Migration aus älteren Versionen voll unterstützt.

Wesentliche Änderungen in der GUI

  • Eine Kalenderansicht ist nun verfügbar. Diese erlaubt die Anzeige von Vorgängen basierend auf Start- und/oder End-Datum bzw. -zeit. Drag&Drop von Events sowie editieren per Doppelklick wird unterstützt. Die Ansicht ist dahingehend optimiert, nur die anzuzeigenden Events abzurufen.

    Produktionskalender
  • Das URL-Schema, in Tryton 2.0 eingeführt, ist nun am Fuße aller Tabs sichtbar. Die URL erlaubt das Öffnen des gleichen Tab auf einem anderen Client.

    URL
  • Requests wurden wieder entfernt. Stattdessen sollen besser EMails mit URL genutzt werden.

  • Die ausgewählten Datensätze in einer Listanzeige sind persistent zwischen Sitzungen.

Wesentliche Änderungen am Server

  • Der Server nutzt nun python-sql um SQL Abfragen zu erzeugen. Dies verbessert die Kompatibilität zwischen unterschiedlichen Datenbanken - sowohl momentan unterstützten wie auch zukünftigen.
  • Die Sucher Methode kann nun die komplette Domäne zurückgeben (anstatt einer die durch eine AND Bedingung limitiert ist).
  • Das ältere order_field Attribut wurde ersetzt durch die Methode order_<field name> um eine höhere Modularität zu erreichen.
  • Das Datenbank-Backend kann dynamisch geladen werden, damit kann es in einem externen Package von trytond definiert werden.
  • Die Performance der MPTT Speicherung wurde verbessert indem die Standard-Sortierung entfernt und die Anzahl der Abfragen verringert wurde.
  • Ein neues Attribut grouped kann zum data -Tag hinzugefügt werden. Das erlaubt die gleichzeitige Erzeugung aller Datensätze eines Modells. Damit verkürzt sich die Installationszeit von Modulen mit großen Datensätzen.
  • Man kann nun eine Standard-Sortierung bei Action Windows definieren.

Module

  • Viele Module wurden einer neuen Entwicklung angepasst, bei dem erzeugte Dokumente mit ihrem Ursprung verlinkt werden. Anstatt den Code des Originals als Referenz zu kopieren wird ein Referenzfeld verwendet. Dies verbessert die Nachverfolgbarkeit der Verlinkungen zwischen Dokumenten ohne Informationsverlust, wenn diese später konsolidiert werden.

Account

  • Ein neuer Assistent vereinfacht die Saldenerzeugung bei nicht abgegrenzten Konten am Jahresende.
  • Alle Konten eines Kontenplans müssen in der gleichen Firma liegen. Durch diese Beschränkung wird die Performance bei der Soll/Haben Berechnung dramatisch erhöht.
  • Jede Buchung mit einer Nullzeile/Nullwert ist automatisch ausgeziffert wenn sie auf einem Abstimmungskonto ist. Damit werden Rechnungen mit Wert Null automatisch als gezahlt markiert.
  • Die centralised counterpart Option wurde vom Journal entfernt.

Account Invoice

  • Sobald eine Rechnung gebucht ist, werden die zugehörigen Buchungssätze genutzt, um die Buchungswerte anzuzeigen, anstatt sie aus den Rechnungszeilen zu berechnen. Das erhöht etwas die Performance, besonders bei Rechnungen mit vielen Zeilen.

Account Statement

  • Es ist jetzt möglich, direkt eine Rechnung auf eine Auftragzeile abzusetzen. Partnerdaten und Konto werden automatisch gezogen.

Stock

  • Es ist nun möglich den Bestand mit einem beliebigen Gruppierungsparameter abzufragen. So kann z.B. der Bestand pro Charge anstatt nur auf Artikelebene abgefragt werden.
  • Der Code des Bestandsmoduls wurde überarbeitet, um ein einfacheres Customizing der Bestandsbewegungen sowie der Constraints zu erreichen.
  • Der Periodencache kann nun verschieden gruppierte Mengen vorhalten.

Stock Lot

  • Felder für Menge und Forecastmenge sind jetzt auf Chargenebene.
  • Es können Bestände mit Charge angelegt werden.
  • Der Periodencache speichert Mengen pro Charge.

Stock Supply

  • Ein neuer Assistent erzeugt automatisch interne Warenbewegungen.
  • Wenn eine Bestellanforderung angelegt wird, und es bereits bekannt ist dass der Lieferant nicht zum Wunschlieferdatum liefern kann, erstellt der Assistent eine Warnung, damit der User diese erwarteten Wareneingänge in die Zukunft legen kann, da sie sonst für diese Bestellung ignoriert würden.

Neue Module

  • Das Bank Modul bringt die Referenz zu Banken und Bankkonten.
  • Das Account Dunning Modul stellt das Mahnwesen über mehrere Stufen bereit.
  • Das Account Dunning Letter Modul erzeugt die entsprechenden Mahnbriefe.
  • Das Sale Invoice Grouping Modul erlaubt die Gruppierung von Rechnungszeilen, die dem jeweiligen Verkauf zugrunde liegen.