Re: [tryton] avoid rounding problem in sales/invoices

[jomeyy]

Am Freitag, 17. Januar 2014 15:22:41 UTC+1 schrieb Cédric Krier:
>
> On 17 Jan 05:19, jomeyy wrote: 
> > Hello 
> > 
> > I am working with Tryton 2.4 and have problems with the total price in 
> > Tryton. 
> > 
> > I sell 2 Products, 1x 25 EUR 1x 4,60 EUR = 29,60 
> > 
> > sale.lines[0].unit_price == 21.0084 
> > sale.lines[1].unit_price == 3.8655 
> > sale.lines[0].unit_price + sale.lines[1].unit_price == 24.87   (x1,19 = 
> > 29,60) 
> > 
> > But: 
> > sale.untaxed_amount == 24.88 ! (x1,19 = 29,61) 
> > sale.total_amount == 29.61 
> > 
> > It seems to me that Tryton is rounding the singe positions before adding 
> > them together!?. 
>
> Yes, it is done on purpose because the amount of each line will 
> debit/credit an account. So it must be rounded with the currency 
> precision to get the same result from the invoice as from the 
> accounting. 
>
> > How can I avoid this? This is a serious problem for me because it 
> affects 
> > to 50% of all of my sales/invoices. 
>
> You can not otherwise you will have the problem with accounting. 
>

 
Thanks, now I understand the process better and can work with it.

[tryton] avoid rounding problem in sales/invoices

[jomeyy]

Hello

I am working with Tryton 2.4 and have problems with the total price in 
Tryton.

I sell 2 Products, 1x 25 EUR 1x 4,60 EUR = 29,60

sale.lines[0].unit_price == 21.0084
sale.lines[1].unit_price == 3.8655
sale.lines[0].unit_price + sale.lines[1].unit_price == 24.87   (x1,19 = 
29,60)

But:
sale.untaxed_amount == 24.88 ! (x1,19 = 29,61)
sale.total_amount == 29.61

It seems to me that Tryton is rounding the singe positions before adding 
them together!?.

How can I avoid this? This is a serious problem for me because it affects 
to 50% of all of my sales/invoices.

Thanks

Jomeyy

Re: [tryton] Proteus search option

[jomeyy]

Am Dienstag, 10. Dezember 2013 08:20:13 UTC+1 schrieb Albert Cervera Areny:
>
> 2013/12/9 jomeyy >: 
> > hello Tryton user group, 
> > 
> > I try to search multiple products with Proteus. I want to find all 
> products 
> > where the product code containing the word "bunny". Products are 
> [bunny01], 
> > [bunnyx], [xbunny01]] etc. Can I do this with Proteus? 
>
>
> Yes, something like this should do the work: 
>
> Product = Model.get('product.product') 
> products = Product.find(['code', 'ilike', '%bunny$']) 
>
> -- 
> Albert Cervera i Areny 
> Tel. 93 553 18 03 
> @albertnan 
> www.NaN-tic.com 
>


Hello Albert,

thank you very much for your help. I assume that you mean

products = Product.find(['code', 'ilike', '%bunny%'])

because this is working fine for this constellation.

Kindly regards

Jome

[tryton] Proteus search option

[jomeyy]

hello Tryton user group,

I try to search multiple products with Proteus. I want to find all products 
where the product code containing the word "bunny". Products are [bunny01], 
[bunnyx], [xbunny01]] etc. Can I do this with Proteus?

kindly regards

jome

[tryton] ImportError: No module named psycopg2.pool after Installation

[jomeyy]

Hello,

I installed Tryton and Trytond with Python EasyInstall. After that I
extracted the pythond.conf and copied it to /etc/ and configured it.

But when I try to start I got the following message:


$ /usr/local/bin/trytond
[Tue Jul 26 19:09:27 2011] INFO:server:using /etc/trytond.conf as
configuration file
[Tue Jul 26 19:09:27 2011] INFO:server:initialising distributed
objects services
Traceback (most recent call last):
  File "/usr/local/bin/trytond", line 5, in 
pkg_resources.run_script('trytond==2.0.0', 'trytond')
  File "/usr/lib/python2.6/dist-packages/pkg_resources.py", line 461,
in run_script
self.require(requires)[0].run_script(script_name, ns)
  File "/usr/lib/python2.6/dist-packages/pkg_resources.py", line 1194,
in run_script
execfile(script_filename, namespace, namespace)
  File "/usr/local/lib/python2.6/dist-packages/trytond-2.0.0-py2.6.egg/
EGG-INFO/scripts/trytond", line 30, in 
trytond.server.TrytonServer().run()
  File "/usr/local/lib/python2.6/dist-packages/trytond-2.0.0-py2.6.egg/
trytond/server.py", line 74, in run
from trytond.backend import Database
  File "/usr/local/lib/python2.6/dist-packages/trytond-2.0.0-py2.6.egg/
trytond/backend/__init__.py", line 10, in 
from postgresql import *
  File "/usr/local/lib/python2.6/dist-packages/trytond-2.0.0-py2.6.egg/
trytond/backend/postgresql/__init__.py", line 4, in 
from database import *
  File "/usr/local/lib/python2.6/dist-packages/trytond-2.0.0-py2.6.egg/
trytond/backend/postgresql/database.py", line 7, in 
from psycopg2.pool import ThreadedConnectionPool
ImportError: No module named psycopg2.pool

-- 
tryton@googlegroups.com mailing list