Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Tryton's rounding does not fit to German requirements
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  5 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Udo Spallek  
View profile  
 More options Nov 8 2010, 1:07 pm
From: Udo Spallek <udo.spal...@googlemail.com>
Date: Mon, 08 Nov 2010 19:07:01 +0100
Local: Mon, Nov 8 2010 1:07 pm
Subject: Tryton's rounding does not fit to German requirements
Hi,

Tryton uses the round half to even method for currencies[1], aka bankers
rounding[2]. In Germany we use another rounding, called round half
up[3].

Example
-------

A net amount of an invoice has 1257,50 EUR. The tax is 19%.

Exact Total Amount = 1257,50 * 1,19 = 1496,425 EUR

Total Amount Tryton = 1496,42

Total Amount Germany = 1496,43

Questions
---------

* Are there other nations using round half up, like used in Germany?

* At least for Germany we need an upstream module which fix this issue.
  Is such a module welcome? (I will write it and put on codereview.)

* The name of the module could be currency_round_half_up and just
  overwrite the default value of the round method signature. Is this
  the way to go?

[1]
http://hg.tryton.org/1.8/modules/currency/file/9087d8922511/currency....

[2] http://en.wikipedia.org/wiki/Rounding#Round_half_to_even

[3] http://en.wikipedia.org/wiki/Rounding#Round_half_up

Regards
--
Udo Spallek

------------------------------------
virtual things
Preisler & Spallek GbR
Munich - Aix-la-Chapelle

Windeckstr. 77
81375 Munich - Germany
Tel: +49 (89) 710 481 55
Fax: +49 (89) 710 481 56

i...@virtual-things.biz
http://www.virtual-things.biz


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Cédric Krier  
View profile  
 More options Nov 8 2010, 1:46 pm
From: Cédric Krier <cedric.kr...@b2ck.com>
Date: Mon, 8 Nov 2010 19:46:29 +0100
Local: Mon, Nov 8 2010 1:46 pm
Subject: Re: [tryton] Tryton's rounding does not fit to German requirements

On 08/11/10 19:07 +0100, Udo Spallek wrote:

I don't know.

> * At least for Germany we need an upstream module which fix this issue.
>   Is such a module welcome? (I will write it and put on codereview.)

Yes of course.

> * The name of the module could be currency_round_half_up and just
>   overwrite the default value of the round method signature. Is this
>   the way to go?

Looks good.

--
Cédric Krier

B2CK SPRL
Rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
Email/Jabber: cedric.kr...@b2ck.com
Website: http://www.b2ck.com/

  application_pgp-signature_part
< 1K Download

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Phillip Heller  
View profile  
 More options Nov 11 2010, 2:35 pm
From: Phillip Heller <phel...@me.com>
Date: Thu, 11 Nov 2010 13:35:27 -0600
Local: Thurs, Nov 11 2010 2:35 pm
Subject: Re: [tryton] Tryton's rounding does not fit to German requirements

On Nov 8, 2010, at 12:46 PM, Cédric Krier wrote:

> On 08/11/10 19:07 +0100, Udo Spallek wrote:
<snip>

>> * The name of the module could be currency_round_half_up and just
>>  overwrite the default value of the round method signature. Is this
>>  the way to go?

> Looks good.

What about multi-national multi-company installations?  Would it not be better to add as an attribute set within the company model, then retrieved from context whenever rounding is done?

Regards,

  Phil

  smime.p7s
5K Download

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Udo Spallek  
View profile  
 More options Nov 12 2010, 10:31 am
From: Udo Spallek <udo.spal...@googlemail.com>
Date: Fri, 12 Nov 2010 16:31:09 +0100
Local: Fri, Nov 12 2010 10:31 am
Subject: Re: [tryton] Tryton's rounding does not fit to German requirements
Am Donnerstag, den 11.11.2010, 13:35 -0600 schrieb Phillip Heller:
> On Nov 8, 2010, at 12:46 PM, Cédric Krier wrote:

> > On 08/11/10 19:07 +0100, Udo Spallek wrote:
> <snip>
> >> * The name of the module could be currency_round_half_up and just
> >>  overwrite the default value of the round method signature. Is this
> >>  the way to go?
> > Looks good.
> What about multi-national multi-company installations?  Would it not
> be better to add as an attribute set within the company model, then
> retrieved from context whenever rounding is done?

Sounds promising. But I am unsure if it is not better done in a separate
module. When you want to consolidate data of depending companies like a
headquarter with its daughter company you will have rounding differences
on using different rounding methods. I guess these differences needed to
take care in accounting. Because the small rounding differences could
create unbalanced balances in the headquarter company.

It is the same situation with the party module. One of our multi-company
interests (multi national education sector) request separate parties for
different companies. But some parties should be shown in all companies.
Nested companies should see their own parties and the parties of their
children companies. Some headquarter parties should be shown in all
companies.

Multi company setup can be very complicated and special. Most I'm
missing is a general idea of a flexible multi-company setup.
IIRC, I have started some general thoughts about this in the past, if
you or someone else is interested to discuss, I will share them.

But another idea could be to put the needed modification on rounding
inside the account_de_skr03 chart of accounts module. This has the big
benefit, to easily remove the code on migration, when we have a
multi-company solution. This is much more easy then removing an already
installed module in Tryton.

Cheers

--
Udo Spallek

------------------------------------
virtual things
Preisler & Spallek GbR
Munich - Aix-la-Chapelle

Windeckstr. 77
81375 Munich - Germany
Tel: +49 (89) 710 481 55
Fax: +49 (89) 710 481 56

i...@virtual-things.biz
http://www.virtual-things.biz


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Cédric Krier  
View profile  
 More options Nov 12 2010, 10:50 am
From: Cédric Krier <cedric.kr...@b2ck.com>
Date: Fri, 12 Nov 2010 16:50:17 +0100
Local: Fri, Nov 12 2010 10:50 am
Subject: Re: [tryton] Tryton's rounding does not fit to German requirements

On 12/11/10 16:31 +0100, Udo Spallek wrote:

First, it is not an issue to have difference rounding method when
consolidating accounting because it is just reports (nothing legal).
Second, it should not have issue there because you only make sum. Except if
you have currency convertion but then you will have issue any way.

I find the idea good but it will require modification in all modules.

> But another idea could be to put the needed modification on rounding
> inside the account_de_skr03 chart of accounts module. This has the big
> benefit, to easily remove the code on migration, when we have a
> multi-company solution. This is much more easy then removing an already
> installed module in Tryton.

I perfer to not have code in account_xx modules. And more over, it is not
because you install account_de_skr03 that you are a German company.

For now, I would say that if someone need different rounding mechanism he just
have to write a small module and change the default value ofthe method. But
this module will not be part of the standard Tryton module set.

We need to work to define rounding method on company and use it when rounding.

--
Cédric Krier

B2CK SPRL
Rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
Email/Jabber: cedric.kr...@b2ck.com
Website: http://www.b2ck.com/

  application_pgp-signature_part
< 1K Download

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »