IRC logs of #tryton for Monday, 2011-07-25 #tryton log beginning Mon Jul 25 00:00:02 CEST 2011
-!- plantian( has joined #tryton00:10
-!- redarmy(~Miranda@ has joined #tryton02:14
-!- ikks_(~ikks@ has joined #tryton02:57
-!- yangoon1( has joined #tryton05:01
-!- elbenfreund( has joined #tryton05:37
-!- zodman(~zodman@foresight/developer/zodman) has joined #tryton05:53
-!- helmor(~helmo@ has joined #tryton06:23
-!- alimon(~alimon@ has joined #tryton06:40
-!- deavid( has joined #tryton08:51
-!- enlightx( has joined #tryton09:20
-!- nicoe( has joined #tryton09:21
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:40
-!- mhi1( has joined #tryton09:45
-!- bechamel( has joined #tryton09:47
-!- helmor(~helmo@ has joined #tryton09:53
-!- reichlich( has joined #tryton11:15
-!- reichlich( has joined #tryton11:17
-!- version2beta(~rob@ has joined #tryton11:30
version2betaHello all - we migrated in a hurry over the weekend from OpenERP v6 to Tryton v2 (with Sharoon's excellent help and on his recommendation) but there's a few things I'm missing before our customer goes into production this morning, and Sharoon could not stay longer. Is there anyone who'd be willing to tolerate some questions for a bit?11:31
bechamelversion2beta: Don’t ask to ask, just ask :)11:34
yangoon1version2beta: just ask, if its not too complicated and time is sufficient11:35
cedkversion2beta: if it is long questions better to use mailing list11:35
version2betaAppreciated :-) How does one enter a product_price_list_line formula to return a given precision? For example, unit_price*1.33 rounded to two decimals?11:37
yangoon1version2beta: sorry, never worked with this upstream module, but it should take pretty any python expression to be evalutated11:40
cedkversion2beta: I see normally the price should have the precision of unit_price of sale line11:41
version2betayangoon1: If I change the formula to round(unit_price*1.33,2), I cannot save - "Invalid formula".11:43
version2betacedk: Where is the precision of unit_price set?11:43
yangoon1version2beta: ok, the module was changed tonor more allow fot that11:43
cedkversion2beta: otherwise you can type: (unit_price*Decimal('1.33')).quantize(Decimal('0.01')11:44
cedkversion2beta: on the Model SaleLine11:45
cedkversion2beta: anyway, I think we miss a rounding when calling get_sale_price in SaleLine11:47
version2betacedk: I'm still learning. Is that adjusted in the client somewhere?11:48
cedkversion2beta: could you fill an issue in roundup?11:48
cedkversion2beta: no it is not `adjustable` in the client11:48
version2betacedk: Thank you. I'm registering now at
cedkversion2beta: by default it is 4 digits11:51
deavidhello :-) i'm trying Tryton for the first time (using Debian packages), i'm looking for documentation for the "Dashboard", and some general documentation about using the app. All the documentation i've found is about installing and creating my own apps.11:52
version2betacedk: That is what I'm seeing too. I will want to present a customer with two digit pricing in USD. It sounds like this is not a configuration issue, but that the return from get_unit_price is not rounding. (I do not have my head wrapped around the code at all yet, and I'm new to python. I apologize if this is wrong.) If this is correct, I will enter a bug report as suggested.11:55
cedkversion2beta: yes the 4 digits is for internal computation11:56
cedkversion2beta: so we should ensure that the value returned from the price list computation is rounded accroding to the field definition11:57
cedkdeavid: you must see Tryton has a framework and not a ready to use application11:57
cedkdeavid: you can find documenation about the usage of the client
cedkdeavid: deavid and for each modules
deavidcedk: you mean that i need other client app or maybe that the "default modules" aren't suitable for production?11:59
version2betacedk: So it should pay attention to currency_digits in sale_line, is that correct?11:59
cedkdeavid: no, I mean the default modules will perhaps not cover your needs12:00
deavidi don't have needs, i'm just testing these modules :P12:00
cedkdeavid: in most of the case, you must customize the default modules to have something workable for you12:00
deavidok :)12:00
cedkdeavid: so there is no documentation describing how to use the software for end user because it always depend of the company rules etc.12:01
cedkversion2beta: yes12:01
deavidbut i'm having problems with the dashboard. The other modules are very simple to understand how they work, but the dashboard seems always empty. I missed something.12:01
version2betacedk: report submitted. Thank you.12:01
cedkdeavid: you must fill it in the user preferences12:05
deavidcedk: thanks :) i found it12:06
cedkversion2beta: is my example with Decimal works?12:54
-!- nicoe( has joined #tryton13:38
version2betacedk: Sorry for the delay. Yes - returned 11.8500 instead of 11.8490, for instance.13:40
cedkversion2beta: I think this should also work: (unit_price * 1.33).quantize(0.01)13:41
version2betacedk: I will try that too. Unfortunately, my customer has the idea that all 20,000 products should have fixed pricing on multiple price lists. I'll need to develop a module to add columnar pricing to product.product, as a pricelist with 20,000 lines is amazingly slow to save or reference.13:44
cedkversion2beta: strange, is there a fixed number of price list?13:45
version2betacedk: And since I put him on a Rackspace cloud server with only 1GB RAM, I see the save pushed me into swap :-(13:45
version2betacedk: Not really a fixed number of price lists. Right now they have 6, but that may vary slightly over the life of their implementation.13:46
cedkversion2beta: I think you could just add the fields like list_price1, list_price2 etc. on product13:46
cedkversion2beta: and reuse it in the computation of the list price13:47
cedkversion2beta: you just have to add the fields in _get_context_price_list_line of product.price_list13:48
version2betacedk: Yes, already added cost_price to context for price list calculations. (I think that should be standard.) But I think it's more than that, or at least Sharoon convinced me so. If UOM or currency changes, it needs to return a calculated value.13:49
cedkversion2beta: don't understand the UOM stuff13:51
cedkversion2beta: for cost_price, I don't think it is good practice to use it13:51
version2betacedk: I know cost_price will vary by vendor, but there is no other way to protect margin.13:52
cedkversion2beta: I think it is not cost_price that you really need but more something like the last purchased price13:52
version2betacedk: Yes, last purchased price could be a good idea.13:53
cedkversion2beta: cost_price is there for valuation of your stock13:54
cedkversion2beta: any way, it is easy to add it13:54
version2betacedk: Openlabs made us a module yesterday for adding cost_price. It's working fine for now, and meets the pricing requirements we had with OpenERP. Now I need to go get them using Tryton. It's a "Surprise, new software!" moment for all of their employees.13:56
version2betacedk: Actually, it'll be more like "Surprise, we upgraded OpenERP while you were out. The new version is called 'Tryton' and they fixed a lot of the things you complained about."13:57
cedkversion2beta: :-)13:57
version2betacedk: Thank you for your help.13:57
-!- ccomb(~ccomb@ has joined #tryton14:02
-!- enlightx( has joined #tryton14:40
-!- predatell(~predatell@ has joined #tryton14:57
-!- pepeu(~manuel@ has joined #tryton15:21
-!- verwsion2beta( has joined #tryton15:47
verwsion2betaTrying to set up sales tax, and I'm having trouble with the basic concept of sales tax in Tryton. Can someone explain how tax rules are supposed to work?15:51
cedkversion2beta: tax rules are just doing substitution of taxes15:57
version2betaTrying to wrap my head around it. Standard config would be to put appropriate taxes on each category, then put appropriate rules on parties, right?15:58
version2betacedk: In our situation, we have three sales taxes that apply: state, county, and special. Customers may get 0 to 3 of them.15:58
-!- predatell(~predatell@ has joined #tryton15:59
version2betacedk: Vast majority of customers are exempt from any of the taxes, though, since they are in other states.15:59
version2betacedk: So if I apply taxes to categories, I need a tax rule for exempt replacing each original tax with a blank substitution tax, correct?16:00
cedkversion2beta: yes16:00
version2betaOkay, I'll see if I break everything ;-) Thank you!16:00
cedkversion2beta: I think you must create 3 tax groups for each level16:00
version2betaEach level?16:01
cedkversion2beta: for state, county and special16:01
version2betaThree taxes - got it.16:01
cedkversion2beta: it is tax group, you can see it as the *real* tax in the mind of people16:02
cedkversion2beta: so you get the tax group county which will contain the tax to apply when you are in the county, the tax when you are from the state etc.16:03
cedkversion2beta: the tax rule can substitude only taxes from the same tax group16:03
version2betacedk: must tax groups be configured?16:03
cedkversion2beta: like that you can not make a mistake by creating a tax rule that will replace a county tax by a state tax16:04
cedkversion2beta: it is just a record to create16:04
cedkversion2beta: it is better to use it but you can put all taxes in the same group16:04
cedkversion2beta: but I think latter it will help you to have proper tax group16:04
-!- saxa(~sasa@ has joined #tryton16:05
version2betacedk: I don't think I have any taxes that fit into more than one group - i.e. the group is the tax, but maybe I don't see it right?16:05
cedkversion2beta: yes the group is the tax, but sometimes a tax can have different rate or account etc.16:09
cedkversion2beta: so you must substitute one tax with an other one from the same group16:10
cedkversion2beta: here in europe we got VAT which can have different rate depending of the customer16:10
cedkversion2beta: so we have many tax (in Tryton) for VAT but all are under the group VAT16:11
version2betacedk: I currently have three taxes configured, for state, county, and special. I also have a tax rule called "Exempt" that replaces them with an empty substitution tax, and a tax rule called "Milwaukee" that has no lines. My product is in a category that has the three taxes listed under "Customer Taxes", and my customer has tax rule "Milwaukee". Shouldn't the three taxes be applied when I add the product?16:12
version2betacedk: Thank you for the tax group explanation - makes more sense now.16:13
cedkversion2beta: yes an empty rule should do nothing16:16
version2betacedk: I've confirmed the product has the flag set for "use category taxes". The category has the taxes. The customer is in the group with no lines under tax rule "Milwaukee". The taxes do not appear on the sale order line. When I remove the tax rule "Milwaukee"  from the customer, the taxes appear.16:19
-!- sharkcz(~sharkcz@2001:15c0:6747:160::7) has joined #tryton16:21
version2betacedk: When I added a line to the "Milwaukee" tax rule, substituting an "exempt" tax (0%) with an empty16:21
version2betacedk: When I added a line to the "Milwaukee" tax rule, substituting an "exempt" tax (0%) with an empty tax, the other taxes come through.16:22
cedkversion2beta: strange without line tax rule should return the same tax see
version2betacedk: What is there is one line with both original tax and substitute tax empty?16:24
cedkversion2beta: don't understand16:28
-!- helmor(~helmo@ has joined #tryton16:29
version2betacedk: Sorry, meant to say "What if there is one line under the tax rule, but it has both the original and substitute taxes empty?" I have been seeing a situation in which the tax rule has a blank line above other lines that will not be deleted. I wondered if I had one of those I couldn't see, because there weren't any lines under to demonstrate the invisible (blank) line at the top.16:30
version2betacedk: Sorry, having trouble with my irc client.16:30
cedkversion2beta: if you have an empty rule line then it will substitue all taxes by None16:33
version2betacedk: Indeed - that is what it did. That explains the behavior, thank you.16:35
-!- alimon(~alimon@ has joined #tryton16:57
cedkversion2beta: by the way, did you create a account chart for US?17:19
version2betacedk: Yes, Barbara (@lageekitude) did that, based on minimal and somewhat customized for our customer's business. Does Tryton need one?17:24
cedkversion2beta: yes it will be good to have a minimal standard one for US17:26
version2betacedk: Sometime when I'm not rolling out a system with employees standing around waiting, I'd like to learn how to package a chart of accounts. We'd be happy to create one. Is there documentation on how to do it?17:27
cedkversion2beta: there is
cedkversion2beta: but not sure if it is uptodate17:31
version2betacedk: Thank you. I've sent it to Barbara and we should be able to put something together.17:34
-!- zodman(~zodman@foresight/developer/zodman) has joined #tryton17:58
-!- vladimirek( has joined #tryton18:09
-!- sharoon( has joined #tryton18:11
sharooncedk: ping18:12
cedksharoon: pong18:17
sharooncedk: just wanted to clarify something before doing regarding the order points and schedulers18:17
sharooncedk: for a client of mine, a waiting supplier shipment, is guaranteed to arrive even if it is delayed beyond the planned date18:18
sharooncedk: this is against the forecasted stock computation which assumes that if you haven't received before `today()` it will not be received.18:18
sharooncedk: what do you think of a cron task which updates the planned date for all supplier > input moves in draft with date less than today ?18:19
cedksharoon: if you know you will receive, update the planned date18:19
sharooncedk: cool, just wanted to confirm.18:19
sharooncedk: BTW, over the weekend I migrated a customer from OpenERP to triton ;)18:19
cedksharoon: I see18:20
sharooncedk: it was fun, several orders from openerp driving tryton  crazy!!!18:20
sharooncedk: like there were several order lines with UOM PCE (eq of Unit in tryton) which had decimal values and triton wouldn't accept it.18:21
-!- reichlich( has joined #tryton18:22
sharooncedk: so i realize that one of the major advantages of tryton which we rarely speak about is data quality and integrity, compared to OpenERP18:22
cedksharoon: yes that's funny :-)18:23
cedksharoon: free, functional and secure :-)18:26
sharooncedk: yeh! i like that!18:26
-!- alimon(~alimon@ has joined #tryton19:23
version2betasharoon: can you look at notes on teambox re serialization problems? we can't enter anything.19:42
sharoonversion2beta: on private chat pls19:43
cedksharoon: by the way, I think if you write a module to update planned date, it could become part of Tryton20:38
sharooncedk: cool, i will keep that in mind when i write. so can we quickly discuss the design ?20:38
cedksharoon: I think it is a common expected behavior but it should be optional20:40
sharooncedk: ok, should the module just move the `stock.move`s on a cron20:41
cedksharoon: yes but perhaps based on supplier configuration20:43
sharooncedk: ok, in supplier configuration as in purchase configuration or a setting on party ?20:45
cedksharoon: hard to say20:54
sharooncedk: we don't differentiate party into supplier and customer, but doing it there would mean we would move the `stock.move`s to customers also ?20:54
-!- gremly(~gremly@ has joined #tryton20:58
cedksharoon: I think you must only take care of move with from location being supplier21:14
sharooncedk: what do you think of setting this in the location ?21:14
sharooncedk: location == `stock.location`21:14
-!- bechamel( has joined #tryton21:37
-!- vladimirek( has joined #tryton21:50
cedksharoon: don't understand22:17
sharooncedk: perhaps take a new option in stock.location id the type is supplier, a boolean flag which decides if the stock moves with the location as origin need to be automatically moved ?22:19
sharoons/id the/if the22:19
sharoonby `automatically moved` i mean, the planned date will be updated with today()22:19
cedksharoon: no, it is only about supplier22:20
sharooncedk: ok, so fall back to party ?22:20
cedksharoon: no I mean you can find the move to update just with the from location of type supplier22:55
sharooncedk: ok, so if the module is installed the rule applies to all supplier locations. And what and how would be the option to disable the feature ?22:56
cedksharoon: I don't know yet if it must be on ProductSupplier or Party22:57
sharooncedk: not all suppliers may be on ProductSupplier ?22:57
cedksharoon: but if on ProductSupplier it can be annoying to update all the products of a supplier because you know he will deliver late23:01
cedksharoon: I think it should be on both23:02
sharooncedk: on both in the sense ?23:02
cedksharoon: on ProductSupplier and Party23:04
cedksharoon: with perhaps default value coming from the Party23:04
sharooncedk: set that in-spite of the fact that a party may not be supplier ?23:04
sharooncedk: and what do you think should be the field name ?23:05
cedksharoon: Boolean23:08
cedksharoon: don't care if it is not a supplier, it is like the accounts, locations etc.23:08
sharooncedk: got it, and a field name 'auto_reassign_planned_date'23:09
sharooncedk: ?23:09
cedksharoon: long name :-(23:16
cedksharoon: update_planned_date23:16
sharooncedk: cool :)23:16
-!- sharoon_(~sharoon@2001:470:5:630:91c:2315:4421:98b3) has joined #tryton23:47
-!- sharoon__( has joined #tryton23:48

Generated by 2.11.0 by Marius Gedminas - find it at!