IRC logs of #tryton for Friday, 2018-01-19

chat.freenode.net #tryton log beginning Fri Jan 19 00:00:02 CET 2018
2018-01-19 00:16 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 01:04 -!- csotelo(~csotelo@190.232.106.37) has joined #tryton
2018-01-19 02:52 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 02:53 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 02:54 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 02:54 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 02:55 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 03:08 -!- csotelo(~csotelo@190.232.106.37) has joined #tryton
2018-01-19 04:00 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 04:15 -!- thaneor1(~ldlc6@179.26.31.130) has joined #tryton
2018-01-19 04:31 -!- zmijunkie1(~Adium@200116b80a396700b4439904e82aeeb7.dip.versatel-1u1.de) has joined #tryton
2018-01-19 06:22 -!- zmijunkie(~Adium@i577ADD40.versanet.de) has joined #tryton
2018-01-19 06:46 -!- zmijunkie(~Adium@i577ADD40.versanet.de) has joined #tryton
2018-01-19 07:00 -!- _2cadz(~2cadz@82.64.14.213) has joined #tryton
2018-01-19 07:35 -!- apostatize(~visavis@unaffiliated/apostatize) has joined #tryton
2018-01-19 07:40 -!- plaes(~plaes@unaffiliated/amd) has joined #tryton
2018-01-19 08:02 -!- catonano(~user@151.50.159.78) has joined #tryton
2018-01-19 08:17 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2018-01-19 08:26 -!- JanGB(~jan@x59cc8980.dyn.telefonica.de) has joined #tryton
2018-01-19 08:53 -!- JanGB1(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 08:56 -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton
2018-01-19 08:58 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 09:24 -!- udono(~udono@185.22.140.150) has joined #tryton
2018-01-19 09:34 -!- rpit(~rpit@ip-109-40-1-123.web.vodafone.de) has joined #tryton
2018-01-19 09:39 -!- meigallodixital(~meigallod@249.135.116.91.static.reverse-mundo-r.com) has joined #tryton
2018-01-19 09:42 -!- zmijunkie(~Adium@b2b-78-94-52-226.unitymedia.biz) has joined #tryton
2018-01-19 09:54 <_2cadz> Hi, in SAO how to deselect an invoice (my list contains only one) in the open dialog to handle the invoice exception.
2018-01-19 09:57 <cedk> _2cadz: click on it
2018-01-19 09:57 <cedk> _2cadz: indeed I think it is CTRL+click
2018-01-19 09:59 <cedk> but it may depend of the browser
2018-01-19 10:00 <_2cadz> cedk: Yes ctrl+click works on chrome
2018-01-19 10:05 <_2cadz> cedk: works on Firefox too.
2018-01-19 10:21 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 10:23 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 10:24 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 10:25 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 10:26 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 10:28 -!- dmollerm(~dmollerm@170.red-80-28-119.staticip.rima-tde.net) has joined #tryton
2018-01-19 10:29 -!- lukio(~lukio@181.95.104.89) has joined #tryton
2018-01-19 10:43 -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton
2018-01-19 10:57 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 11:30 -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton
2018-01-19 11:36 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 11:53 <_2cadz> is there a place where I can find an example of how to set the user password used in the scenario file? TRYTONPASSFILE seems no work.
2018-01-19 11:54 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 11:56 <pokoli> _2cadz: you can change the admin password with trytond-admin -d <database> -p
2018-01-19 11:57 <pokoli> _2cadz: how do you setup TRYTONPASSFILE? I have it working on my laptop
2018-01-19 11:58 <_2cadz> pokoli: yes i now, but i would use scenario to set some value in my base with this command : TRYTONPASSFILE=./password.txt TRYTOND_CONFIG=./trytond.conf DB_NAME=tdev_adz2 python -m doctest -f brz_adding_product_attribut.rst
2018-01-19 11:59 -!- zmijunkie(~Adium@i577ADD40.versanet.de) has joined #tryton
2018-01-19 12:00 <_2cadz> pokoli: in rst file a i get the config by this line : config = set_trytond()
2018-01-19 12:02 <_2cadz> pokoli: but i have an error message : unable to access to relation ir_cache (translate from French)
2018-01-19 12:05 <pokoli> pokoli: does the database tdev_adz2 exist?
2018-01-19 12:05 <pokoli> ups, that should be _2cadz not myself
2018-01-19 12:07 <_2cadz> pokoli: yes, I have a tryton client connected to it
2018-01-19 12:07 <buxy> I wonder how the income statement works... I would like a simple difference between expenses and incomes. But actually I get this and it also includes the movements from the account where the income of the previous year is stored.
2018-01-19 12:07 <buxy> Which gives a bad result because that amount should not be counted in the income statement of this year...
2018-01-19 12:08 <pokoli> _2cadz: which client version? maybe a version missmatch?
2018-01-19 12:11 <buxy> Strangely in the balanche sheet, there's no such problem.
2018-01-19 12:12 <buxy> It's as if the value reported from previous year was not used in the "income statement" view while it would be used in the other.
2018-01-19 12:19 <_2cadz> pokoli: Newbie error, you're right I was working on the wrong base. sorry, thanks for your help :)
2018-01-19 12:26 <pokoli> buxy: which chart of accounts are you using?
2018-01-19 12:26 <buxy> pokoli: french
2018-01-19 12:27 <buxy> pokoli: the type of account that has income_statement=True is also linked to a real account where we store the benefits (and then we have a move to say how we use that benefit)
2018-01-19 12:28 <buxy> I think I need to move the income_statement=True to another account type that has no real account associated
2018-01-19 12:29 <buxy> we have one that is a children of the account where we store the benefits
2018-01-19 12:31 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 12:31 <pokoli> buxy: yes, that configuration is correct
2018-01-19 12:32 <buxy> pokoli: what do you mean? my suggestion is correct or the current setup is correct?
2018-01-19 12:32 <pokoli> buxy: your setup is correct, and previous fiscalyear values should not be cumulated
2018-01-19 12:33 <pokoli> buxy: but probably the problem is that the previous fiscalyear account should not be listed on the income statement
2018-01-19 12:34 <buxy> indeed
2018-01-19 12:34 <buxy> currently it appears at the top-level account in the income statement tree
2018-01-19 12:34 <buxy> with a single child where I have the correct income statement, which has itself two childs (Expenses, Incomes)
2018-01-19 12:35 <buxy> if I move the income_statement=True to the current child (named "Compte de résultats"), then I get something that seems clean
2018-01-19 12:36 <pokoli> buxy: just checked the account_es, and the previous fiscalyear results account is include on the balance_sheet but not on the income_statement
2018-01-19 13:27 -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton
2018-01-19 13:28 -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton
2018-01-19 13:28 -!- thaneor(~ldlc6@179.26.31.130) has joined #tryton
2018-01-19 13:28 -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton
2018-01-19 13:52 -!- dmollerm(~dmollerm@170.red-80-28-119.staticip.rima-tde.net) has joined #tryton
2018-01-19 13:53 -!- csotelo_at_work(~csotelo@179.43.97.56) has joined #tryton
2018-01-19 14:11 -!- lukio(~lukio@iplan.gcoop.com.ar) has joined #tryton
2018-01-19 14:16 -!- lukio(~lukio@iplan.gcoop.com.ar) has joined #tryton
2018-01-19 14:20 -!- JanGB(~jan@ipservice-092-216-127-053.092.216.pools.vodafone-ip.de) has joined #tryton
2018-01-19 14:21 -!- Timitos(~kpreisler@tmo-080-89.customers.d1-online.com) has joined #tryton
2018-01-19 14:36 -!- JanGB(~jan@x2f7fe34.dyn.telefonica.de) has joined #tryton
2018-01-19 14:40 -!- Timitos(~kpreisler@tmo-080-89.customers.d1-online.com) has joined #tryton
2018-01-19 15:05 -!- JanGB(~jan@x2f7f919.dyn.telefonica.de) has joined #tryton
2018-01-19 15:09 -!- jmousset(~jeremy@176.158.167.193) has joined #tryton
2018-01-19 15:28 -!- hedererjs(~hedererjs@dig50-1-78-222-206-45.fbx.proxad.net) has joined #tryton
2018-01-19 15:43 <mrichez> hi, my search_function on boolean function field needs to compare to fields, how returning a domain for this condition ? ['field_name1', '=', Eval(field_name2)] is not working
2018-01-19 15:46 <pokoli> mrichez you should compose and sql query that does the match between the fields on the table
2018-01-19 15:46 <pokoli> mrichez: something like: select id from table where field_name1 == field_name2
2018-01-19 15:46 <pokoli> mrichez: save this in a query variable and return a domain like [('id', 'in', query)])
2018-01-19 15:47 <mrichez> pokoli: but one of my field to compare is a function field
2018-01-19 15:47 <pokoli> mrichez: and do you use a sql query to compute the function field?
2018-01-19 15:48 -!- JanGB(~jan@x2f7fc16.dyn.telefonica.de) has joined #tryton
2018-01-19 15:48 <mrichez> pokoli: no, my first function field is product.quantity
2018-01-19 15:49 <pokoli> mrichez: product quantity has a searcher method that uses and sql query
2018-01-19 15:50 <pokoli> mrichez: It should be possible to get the query, and combine in your query (thanks to python-sql)
2018-01-19 15:51 <mrichez> pokoli: so in a search function, i'can use current record field value ?
2018-01-19 15:52 <pokoli> mrichez: there is no current record
2018-01-19 15:54 <pokoli> mrichez: may I ask what are you trying to filter?
2018-01-19 15:56 <mrichez> pokoli: a module we discuss previously, adding a minimum qty on a product to get an alert when product quantity is lower than minimum quantity. So i add a function field "alert_stock_min" (boolean) to get all the products having a quantity lower then their minimum quantity (so in my search, i thought to have a domain like this ['quantity', '<', Eval('qty_stock_min')]
2018-01-19 16:08 <pokoli> mrichez: are you using trigger to launch the alert?
2018-01-19 16:08 <pokoli> mrichez: indeed that's implemented on the stock_supply module
2018-01-19 16:08 <mrichez> pokoli: no just a view with a filter the boolean field
2018-01-19 16:09 <pokoli> mrichez: it creates all the missing product an quantities as purchase.request
2018-01-19 16:10 <mrichez> pokoli: yes i know, we talk already about this, but in our case, we don't purchase with tryton, so all we need is the list of the products under the minimum quantity
2018-01-19 16:11 <mrichez> mrichez: minimum quantity is new field in product class
2018-01-19 16:11 <pokoli> mrichez: with this requirements, the best solution is to do the sql query that comprares the computeed qty with the minimun qty
2018-01-19 16:12 <pokoli> mrichez: If you want to do it on python you can search for all products, and add the ids of matching ones to a list
2018-01-19 16:12 <pokoli> mrichez: and then return [('id', 'in', your_list)]
2018-01-19 16:13 <pokoli> mrichez: if the number of products is to high it may take a while to load
2018-01-19 16:14 <mrichez> pokoli: ok, thanks ... will try to do this... (number of products is not too high, it's for managing our printers and printer supplies stock)
2018-01-19 16:19 -!- thaneor(~ldlc6@179.26.235.155) has joined #tryton
2018-01-19 16:44 -!- lukio(~lukio@iplan.gcoop.com.ar) has joined #tryton
2018-01-19 16:53 -!- jmousset(~jeremy@80.215.234.201) has joined #tryton
2018-01-19 17:18 -!- catonano(~user@151.50.159.78) has joined #tryton
2018-01-19 17:26 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2018-01-19 17:58 -!- catonano(~user@151.50.159.78) has joined #tryton
2018-01-19 18:18 -!- JanGB(~jan@185.101.128.37) has joined #tryton
2018-01-19 18:29 -!- lukio(~lukio@200.68.72.41) has joined #tryton
2018-01-19 19:04 -!- swayf(~swayf@ipbcc14f49.dynamic.kabel-deutschland.de) has joined #tryton
2018-01-19 19:52 -!- catonano(~user@151.50.159.78) has joined #tryton
2018-01-19 19:52 -!- jmousset(~jeremy@cnf78-h03-89-87-66-192.dsl.sta.abo.bbox.fr) has joined #tryton
2018-01-19 19:53 -!- jmousset(~jeremy@cnf78-h03-89-87-66-192.dsl.sta.abo.bbox.fr) has left #tryton
2018-01-19 19:56 -!- rpit(~rpit@p200300C88BEA410056EE75FFFE0DD3C7.dip0.t-ipconnect.de) has joined #tryton
2018-01-19 20:13 -!- JanGB(~jan@185.101.128.37) has joined #tryton
2018-01-19 21:05 -!- lukio(~lukio@186.143.137.237) has joined #tryton
2018-01-19 21:20 -!- lukio(~lukio@186.143.134.249) has joined #tryton
2018-01-19 21:57 -!- apostatize(~visavis@unaffiliated/apostatize) has joined #tryton
2018-01-19 21:58 -!- catonano(~user@151.50.159.78) has joined #tryton
2018-01-19 22:00 -!- cryptic(~cryptic@142.196.170.87) has joined #tryton
2018-01-19 22:00 -!- semarie_(~semarie@unaffiliated/semarie) has joined #tryton
2018-01-19 22:20 -!- lukio(~lukio@186.143.134.249) has joined #tryton
2018-01-19 23:22 -!- cryptic(~cryptic@142.196.170.87) has joined #tryton

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!