IRC logs of #tryton for Monday, 2011-07-25 #tryton log beginning Mon Jul 25 00:00:02 CEST 2011
2011-07-25 00:10 -!- plantian( has joined #tryton
2011-07-25 02:14 -!- redarmy(~Miranda@ has joined #tryton
2011-07-25 02:57 -!- ikks_(~ikks@ has joined #tryton
2011-07-25 05:01 -!- yangoon1( has joined #tryton
2011-07-25 05:37 -!- elbenfreund( has joined #tryton
2011-07-25 05:53 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton
2011-07-25 06:23 -!- helmor(~helmo@ has joined #tryton
2011-07-25 06:40 -!- alimon(~alimon@ has joined #tryton
2011-07-25 08:51 -!- deavid( has joined #tryton
2011-07-25 09:20 -!- enlightx( has joined #tryton
2011-07-25 09:21 -!- nicoe( has joined #tryton
2011-07-25 09:40 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2011-07-25 09:45 -!- mhi1( has joined #tryton
2011-07-25 09:47 -!- bechamel( has joined #tryton
2011-07-25 09:53 -!- helmor(~helmo@ has joined #tryton
2011-07-25 11:15 -!- reichlich( has joined #tryton
2011-07-25 11:17 -!- reichlich( has joined #tryton
2011-07-25 11:30 -!- version2beta(~rob@ has joined #tryton
2011-07-25 11:31 <version2beta> Hello 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?
2011-07-25 11:34 <bechamel> version2beta: Don’t ask to ask, just ask :)
2011-07-25 11:35 <yangoon1> version2beta: just ask, if its not too complicated and time is sufficient
2011-07-25 11:35 <cedk> version2beta: if it is long questions better to use mailing list
2011-07-25 11:37 <version2beta> Appreciated :-) 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?
2011-07-25 11:40 <yangoon1> version2beta: sorry, never worked with this upstream module, but it should take pretty any python expression to be evalutated
2011-07-25 11:41 <cedk> version2beta: I see normally the price should have the precision of unit_price of sale line
2011-07-25 11:43 <version2beta> yangoon1: If I change the formula to round(unit_price*1.33,2), I cannot save - "Invalid formula".
2011-07-25 11:43 <version2beta> cedk: Where is the precision of unit_price set?
2011-07-25 11:43 <yangoon1> version2beta: ok, the module was changed tonor more allow fot that
2011-07-25 11:44 <cedk> version2beta: otherwise you can type: (unit_price*Decimal('1.33')).quantize(Decimal('0.01')
2011-07-25 11:45 <cedk> version2beta: on the Model SaleLine
2011-07-25 11:47 <cedk> version2beta: anyway, I think we miss a rounding when calling get_sale_price in SaleLine
2011-07-25 11:48 <version2beta> cedk: I'm still learning. Is that adjusted in the client somewhere?
2011-07-25 11:48 <cedk> version2beta: could you fill an issue in roundup?
2011-07-25 11:48 <cedk> version2beta: no it is not `adjustable` in the client
2011-07-25 11:51 <version2beta> cedk: Thank you. I'm registering now at
2011-07-25 11:51 <cedk> version2beta: by default it is 4 digits
2011-07-25 11:52 <deavid> hello :-) 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.
2011-07-25 11:55 <version2beta> cedk: 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.
2011-07-25 11:56 <cedk> version2beta: yes the 4 digits is for internal computation
2011-07-25 11:57 <cedk> version2beta: so we should ensure that the value returned from the price list computation is rounded accroding to the field definition
2011-07-25 11:57 <cedk> deavid: you must see Tryton has a framework and not a ready to use application
2011-07-25 11:58 <cedk> deavid: you can find documenation about the usage of the client
2011-07-25 11:59 <cedk> deavid: deavid and for each modules
2011-07-25 11:59 <deavid> cedk: you mean that i need other client app or maybe that the "default modules" aren't suitable for production?
2011-07-25 11:59 <version2beta> cedk: So it should pay attention to currency_digits in sale_line, is that correct?
2011-07-25 12:00 <cedk> deavid: no, I mean the default modules will perhaps not cover your needs
2011-07-25 12:00 <deavid> i don't have needs, i'm just testing these modules :P
2011-07-25 12:00 <cedk> deavid: in most of the case, you must customize the default modules to have something workable for you
2011-07-25 12:00 <deavid> ok :)
2011-07-25 12:01 <cedk> deavid: so there is no documentation describing how to use the software for end user because it always depend of the company rules etc.
2011-07-25 12:01 <cedk> version2beta: yes
2011-07-25 12:01 <deavid> but 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.
2011-07-25 12:01 <version2beta> cedk: report submitted. Thank you.
2011-07-25 12:05 <cedk> deavid: you must fill it in the user preferences
2011-07-25 12:06 <deavid> cedk: thanks :) i found it
2011-07-25 12:54 <cedk> version2beta: is my example with Decimal works?
2011-07-25 13:38 -!- nicoe( has joined #tryton
2011-07-25 13:40 <version2beta> cedk: Sorry for the delay. Yes - returned 11.8500 instead of 11.8490, for instance.
2011-07-25 13:41 <cedk> version2beta: I think this should also work: (unit_price * 1.33).quantize(0.01)
2011-07-25 13:44 <version2beta> cedk: 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.
2011-07-25 13:45 <cedk> version2beta: strange, is there a fixed number of price list?
2011-07-25 13:45 <version2beta> cedk: And since I put him on a Rackspace cloud server with only 1GB RAM, I see the save pushed me into swap :-(
2011-07-25 13:46 <version2beta> cedk: Not really a fixed number of price lists. Right now they have 6, but that may vary slightly over the life of their implementation.
2011-07-25 13:46 <cedk> version2beta: I think you could just add the fields like list_price1, list_price2 etc. on product
2011-07-25 13:47 <cedk> version2beta: and reuse it in the computation of the list price
2011-07-25 13:48 <cedk> version2beta: you just have to add the fields in _get_context_price_list_line of product.price_list
2011-07-25 13:49 <version2beta> cedk: 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.
2011-07-25 13:51 <cedk> version2beta: don't understand the UOM stuff
2011-07-25 13:51 <cedk> version2beta: for cost_price, I don't think it is good practice to use it
2011-07-25 13:52 <version2beta> cedk: I know cost_price will vary by vendor, but there is no other way to protect margin.
2011-07-25 13:52 <cedk> version2beta: I think it is not cost_price that you really need but more something like the last purchased price
2011-07-25 13:53 <version2beta> cedk: Yes, last purchased price could be a good idea.
2011-07-25 13:54 <cedk> version2beta: cost_price is there for valuation of your stock
2011-07-25 13:54 <cedk> version2beta: any way, it is easy to add it
2011-07-25 13:56 <version2beta> cedk: 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.
2011-07-25 13:57 <version2beta> cedk: 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."
2011-07-25 13:57 <cedk> version2beta: :-)
2011-07-25 13:57 <version2beta> cedk: Thank you for your help.
2011-07-25 14:02 -!- ccomb(~ccomb@ has joined #tryton
2011-07-25 14:40 -!- enlightx( has joined #tryton
2011-07-25 14:57 -!- predatell(~predatell@ has joined #tryton
2011-07-25 15:21 -!- pepeu(~manuel@ has joined #tryton
2011-07-25 15:47 -!- verwsion2beta( has joined #tryton
2011-07-25 15:51 <verwsion2beta> Trying 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?
2011-07-25 15:57 <cedk> version2beta: tax rules are just doing substitution of taxes
2011-07-25 15:58 <version2beta> Trying to wrap my head around it. Standard config would be to put appropriate taxes on each category, then put appropriate rules on parties, right?
2011-07-25 15:58 <version2beta> cedk: In our situation, we have three sales taxes that apply: state, county, and special. Customers may get 0 to 3 of them.
2011-07-25 15:59 -!- predatell(~predatell@ has joined #tryton
2011-07-25 15:59 <version2beta> cedk: Vast majority of customers are exempt from any of the taxes, though, since they are in other states.
2011-07-25 16:00 <version2beta> cedk: So if I apply taxes to categories, I need a tax rule for exempt replacing each original tax with a blank substitution tax, correct?
2011-07-25 16:00 <cedk> version2beta: yes
2011-07-25 16:00 <version2beta> Okay, I'll see if I break everything ;-) Thank you!
2011-07-25 16:00 <cedk> version2beta: I think you must create 3 tax groups for each level
2011-07-25 16:01 <version2beta> Each level?
2011-07-25 16:01 <cedk> version2beta: for state, county and special
2011-07-25 16:01 <version2beta> Three taxes - got it.
2011-07-25 16:02 <cedk> version2beta: it is tax group, you can see it as the *real* tax in the mind of people
2011-07-25 16:03 <cedk> version2beta: 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.
2011-07-25 16:03 <cedk> version2beta: the tax rule can substitude only taxes from the same tax group
2011-07-25 16:03 <version2beta> cedk: must tax groups be configured?
2011-07-25 16:04 <cedk> version2beta: like that you can not make a mistake by creating a tax rule that will replace a county tax by a state tax
2011-07-25 16:04 <cedk> version2beta: it is just a record to create
2011-07-25 16:04 <cedk> version2beta: it is better to use it but you can put all taxes in the same group
2011-07-25 16:04 <cedk> version2beta: but I think latter it will help you to have proper tax group
2011-07-25 16:05 -!- saxa(~sasa@ has joined #tryton
2011-07-25 16:05 <version2beta> cedk: 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?
2011-07-25 16:09 <cedk> version2beta: yes the group is the tax, but sometimes a tax can have different rate or account etc.
2011-07-25 16:10 <cedk> version2beta: so you must substitute one tax with an other one from the same group
2011-07-25 16:10 <cedk> version2beta: here in europe we got VAT which can have different rate depending of the customer
2011-07-25 16:11 <cedk> version2beta: so we have many tax (in Tryton) for VAT but all are under the group VAT
2011-07-25 16:12 <version2beta> cedk: 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?
2011-07-25 16:13 <version2beta> cedk: Thank you for the tax group explanation - makes more sense now.
2011-07-25 16:16 <cedk> version2beta: yes an empty rule should do nothing
2011-07-25 16:19 <version2beta> cedk: 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.
2011-07-25 16:21 -!- sharkcz(~sharkcz@2001:15c0:6747:160::7) has joined #tryton
2011-07-25 16:21 <version2beta> cedk: When I added a line to the "Milwaukee" tax rule, substituting an "exempt" tax (0%) with an empty
2011-07-25 16:22 <version2beta> cedk: When I added a line to the "Milwaukee" tax rule, substituting an "exempt" tax (0%) with an empty tax, the other taxes come through.
2011-07-25 16:23 <cedk> version2beta: strange without line tax rule should return the same tax see
2011-07-25 16:24 <version2beta> cedk: What is there is one line with both original tax and substitute tax empty?
2011-07-25 16:28 <cedk> version2beta: don't understand
2011-07-25 16:29 -!- helmor(~helmo@ has joined #tryton
2011-07-25 16:30 <version2beta> cedk: 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.
2011-07-25 16:30 <version2beta> cedk: Sorry, having trouble with my irc client.
2011-07-25 16:33 <cedk> version2beta: if you have an empty rule line then it will substitue all taxes by None
2011-07-25 16:35 <version2beta> cedk: Indeed - that is what it did. That explains the behavior, thank you.
2011-07-25 16:57 -!- alimon(~alimon@ has joined #tryton
2011-07-25 17:19 <cedk> version2beta: by the way, did you create a account chart for US?
2011-07-25 17:24 <version2beta> cedk: Yes, Barbara (@lageekitude) did that, based on minimal and somewhat customized for our customer's business. Does Tryton need one?
2011-07-25 17:26 <cedk> version2beta: yes it will be good to have a minimal standard one for US
2011-07-25 17:27 <version2beta> cedk: 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?
2011-07-25 17:30 <cedk> version2beta: there is
2011-07-25 17:31 <cedk> version2beta: but not sure if it is uptodate
2011-07-25 17:34 <version2beta> cedk: Thank you. I've sent it to Barbara and we should be able to put something together.
2011-07-25 17:58 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton
2011-07-25 18:09 -!- vladimirek( has joined #tryton
2011-07-25 18:11 -!- sharoon( has joined #tryton
2011-07-25 18:12 <sharoon> cedk: ping
2011-07-25 18:17 <cedk> sharoon: pong
2011-07-25 18:17 <sharoon> cedk: just wanted to clarify something before doing regarding the order points and schedulers
2011-07-25 18:18 <sharoon> cedk: for a client of mine, a waiting supplier shipment, is guaranteed to arrive even if it is delayed beyond the planned date
2011-07-25 18:18 <sharoon> cedk: this is against the forecasted stock computation which assumes that if you haven't received before `today()` it will not be received.
2011-07-25 18:19 <sharoon> cedk: 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 ?
2011-07-25 18:19 <cedk> sharoon: if you know you will receive, update the planned date
2011-07-25 18:19 <sharoon> cedk: cool, just wanted to confirm.
2011-07-25 18:19 <sharoon> cedk: BTW, over the weekend I migrated a customer from OpenERP to triton ;)
2011-07-25 18:19 <sharoon> s/triton/tryton
2011-07-25 18:20 <cedk> sharoon: I see
2011-07-25 18:20 <sharoon> cedk: it was fun, several orders from openerp driving tryton crazy!!!
2011-07-25 18:21 <sharoon> cedk: like there were several order lines with UOM PCE (eq of Unit in tryton) which had decimal values and triton wouldn't accept it.
2011-07-25 18:22 -!- reichlich( has joined #tryton
2011-07-25 18:22 <sharoon> cedk: so i realize that one of the major advantages of tryton which we rarely speak about is data quality and integrity, compared to OpenERP
2011-07-25 18:23 <cedk> sharoon: yes that's funny :-)
2011-07-25 18:26 <cedk> sharoon: free, functional and secure :-)
2011-07-25 18:26 <sharoon> cedk: yeh! i like that!
2011-07-25 19:23 -!- alimon(~alimon@ has joined #tryton
2011-07-25 19:42 <version2beta> sharoon: can you look at notes on teambox re serialization problems? we can't enter anything.
2011-07-25 19:43 <sharoon> version2beta: on private chat pls
2011-07-25 20:38 <cedk> sharoon: by the way, I think if you write a module to update planned date, it could become part of Tryton
2011-07-25 20:38 <sharoon> cedk: cool, i will keep that in mind when i write. so can we quickly discuss the design ?
2011-07-25 20:40 <cedk> sharoon: I think it is a common expected behavior but it should be optional
2011-07-25 20:41 <sharoon> cedk: ok, should the module just move the `stock.move`s on a cron
2011-07-25 20:43 <cedk> sharoon: yes but perhaps based on supplier configuration
2011-07-25 20:45 <sharoon> cedk: ok, in supplier configuration as in purchase configuration or a setting on party ?
2011-07-25 20:54 <cedk> sharoon: hard to say
2011-07-25 20:54 <sharoon> cedk: 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 ?
2011-07-25 20:58 -!- gremly(~gremly@ has joined #tryton
2011-07-25 21:14 <cedk> sharoon: I think you must only take care of move with from location being supplier
2011-07-25 21:14 <sharoon> cedk: what do you think of setting this in the location ?
2011-07-25 21:14 <sharoon> cedk: location == `stock.location`
2011-07-25 21:37 -!- bechamel( has joined #tryton
2011-07-25 21:50 -!- vladimirek( has joined #tryton
2011-07-25 22:17 <cedk> sharoon: don't understand
2011-07-25 22:19 <sharoon> cedk: 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 ?
2011-07-25 22:19 <sharoon> s/id the/if the
2011-07-25 22:19 <sharoon> by `automatically moved` i mean, the planned date will be updated with today()
2011-07-25 22:20 <cedk> sharoon: no, it is only about supplier
2011-07-25 22:20 <sharoon> cedk: ok, so fall back to party ?
2011-07-25 22:55 <cedk> sharoon: no I mean you can find the move to update just with the from location of type supplier
2011-07-25 22:56 <sharoon> cedk: 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 ?
2011-07-25 22:57 <cedk> sharoon: I don't know yet if it must be on ProductSupplier or Party
2011-07-25 22:57 <sharoon> cedk: not all suppliers may be on ProductSupplier ?
2011-07-25 23:01 <cedk> sharoon: but if on ProductSupplier it can be annoying to update all the products of a supplier because you know he will deliver late
2011-07-25 23:02 <cedk> sharoon: I think it should be on both
2011-07-25 23:02 <sharoon> cedk: on both in the sense ?
2011-07-25 23:04 <cedk> sharoon: on ProductSupplier and Party
2011-07-25 23:04 <cedk> sharoon: with perhaps default value coming from the Party
2011-07-25 23:04 <sharoon> cedk: set that in-spite of the fact that a party may not be supplier ?
2011-07-25 23:05 <sharoon> cedk: and what do you think should be the field name ?
2011-07-25 23:08 <cedk> sharoon: Boolean
2011-07-25 23:08 <cedk> sharoon: don't care if it is not a supplier, it is like the accounts, locations etc.
2011-07-25 23:09 <sharoon> cedk: got it, and a field name 'auto_reassign_planned_date'
2011-07-25 23:09 <sharoon> cedk: ?
2011-07-25 23:16 <cedk> sharoon: long name :-(
2011-07-25 23:16 <cedk> sharoon: update_planned_date
2011-07-25 23:16 <sharoon> cedk: cool :)
2011-07-25 23:47 -!- sharoon_(~sharoon@2001:470:5:630:91c:2315:4421:98b3) has joined #tryton
2011-07-25 23:48 -!- sharoon__( has joined #tryton

Generated by 2.17.3 by Marius Gedminas - find it at!