IRC logs of #tryton for Friday, 2009-04-03 #tryton log beginning Fri Apr 3 00:00:01 CEST 2009
CIA-48ced roundup * #906/Access permissions to databases: [resolved] It is almost impossible to know if a database is suitable for a server except by running a complete update. The best way to separate da ...00:43
-!- juanfer(n=juanfer@ has joined #tryton01:12
CIA-48matb roundup * #906/Access permissions to databases: [chatting] *At least* the tables created by the system (server) should be in the version of the server. I think it is very well possible to tag a ...01:41
-!- johbo( has joined #tryton01:42
-!- yangoon( has joined #tryton05:19
-!- johbo( has joined #tryton05:57
-!- johbo( has joined #tryton06:38
-!- nicoe( has joined #tryton07:34
-!- sharkcz( has joined #tryton07:38
CIA-48udono roundup * #921/Invoice Report not translated: [new] The Invoice report is not translated into german language. This is for all phrases in the report like "Invoice", "Description" but also for ...08:01
-!- racke(n=racke@ has joined #tryton08:41
CIA-48Timitos roundup * #919/problems with digits when entering account move lines: [resolved] i could not reproduce the error. so it seems to be fixed08:43
-!- Timitos(n=Timitos@ has joined #tryton08:55
CIA-48udono roundup * #922/Invoice Report: Tax as sequence: [new] We have the new possibility to show taxes in invoice lines like footnotes. E.G.: Description Unit Price Qty Tax Amount Stuff ...09:11
-!- racke(n=racke@ has left #tryton09:12 * r492 /wiki/ Two issues already fixed.09:18
-!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton09:38
-!- enlightx( has joined #tryton09:50
-!- bechamel(n=user@ has joined #tryton09:50
-!- paola( has joined #tryton10:02
cedkTimitos: I add the accounting date on invoice10:30
cedkTimitos: I think this functionnality is right and necessary10:31
CIA-48ced roundup * #918/Translation: items reappearing untranslated: [need-eg] Could you give the create_uid, write_uid of those records?11:25
CIA-48udono roundup * #921/Invoice Report not translated: [resolved] sorry, it is a customized invoice in an addon module...11:29
cedkTimitos: for the number of invoice which date do you think I need to take?11:32
cedkTimitos: for me, it is the invoice date11:33
cedkTimitos: ok, I call our accountance and the tax date must be the same than the account date11:42
-!- carlos(n=carlos@ has joined #tryton11:42
Timitoscedk: i was out of office. i am back right now11:43
cedkTimitos: I think that accounting date is only required for supplier invoice11:50
cedkTimitos: s/required/allowed/11:51
Timitoscedk: no. there are cases where accounting date is also needed for customer invoice. when the product is delivered in march and the invoice is written in april the accounting date should be in march.11:51
cedkTimitos: why do you create the invoice in april?11:52
cedkTimitos: and what do you do if march is closed?11:52
CIA-48matb roundup * #918/Translation: items reappearing untranslated: After database update all is correct: 497;"en_US";"You try to bypass an access rule! (Document type: %s)";"access_error";0;"You try to bypass an ...11:52
Timitoscedk: let me give you an example. think of a company doing transportation services. it is common that the invoice is written very late because of missing documents that need to be searched for all over the world. so the transport happens in january and the invoice can be written in april as all documents are available. this is common in this business. in this case the invoice date is in april and the accounting date must be in january. it is common that t11:56
Timitoscedk: if march is already closed i would do the move in the nearest open period.11:57
cedkTimitos: at which date?11:57
cedkTimitos: so ok, we keep accounting_date on both invoices11:58
Timitoscedk: as for tax authorities only the period is important you can choose to use the 1st day or the last day of the period. i think i would use the last day of period11:59
cedkTimitos: if we put a accounting_date, we let the user decide11:59
Timitoscedk: yes. this is the best way12:00
cedkTimitos: ok, I see what to do for account move12:00
carloscedk: I think we don't use that in Spain, but I will need to check it to be sure. If we don't use it, I guess the system will work as it does now, right?12:00
cedkTimitos: but next issue is the numbering of invoice, we need a date12:00
cedkcarlos: yes, the accounting_date will be optionnal, so if you leave it empty, it will use the invoice_date12:01
Timitoscedk: where do you need this. i do not understand exactly12:01
cedkTimitos: sequence for numbering invoice are stored on periods12:01
cedkTimitos: so I need to find the right period, but I don't know which one?12:02
Timitoscedk: i will take a look on it. i need to think about12:02
cedkI think we should take the invoice_date12:03
cedkand allow to use sequence on closed period12:04
Timitoscedk: i think so too. but i am not quite sure12:04
cedkTimitos: here, we must keep the number serie depending of the invoice date12:04
Timitoscedk: i do not understand this completely because i haven´t used this before12:05
cedkTimitos: what don't you understand?12:05
Timitoscedk: i need to check the behavior first in a test db. i think this is better than let you explain it12:06
cedkTimitos: ok, I make the change now12:06
Timitoscedk: what about the date on tax lines? do i understand your comment from above (your call to your accountant) correct that you leave it out?12:07
cedkTimitos: yes, she say that it is the same date than the account move12:07
Timitoscedk: because we have here some cases where the tax date is the invoice date and is different from the account date. this is for supplier invoices only12:08
cedkTimitos: how is it possible?12:09
cedkTimitos: and what do it happen when you already send you tax report before you receive an invoice with a date before12:10
Timitos:-D i do not know any accounting software in germany that can handle this case correct.12:10
Timitoscedk: then you need to submit a changed tax report for the period12:11
Timitosi will try to explain the case12:11
Timitosin germany you will only get back vat of supplier invoices if you have a correct invoice. so the vat refund is connected to the invoice. and this is why taxes of supplier invoices can be only declared in period of the invoice date. but there is another rule that the costs of the supplier invoice must be recorded in the period of the product delivery (this is the delivery date or in our case the account date). so there is a difference for this case between12:14
Timitosthe problem is: if we use the account date for the tax the tax will be declared too early and tax authorities do not like this :-)12:15
cedkTimitos: so if I understand well for you supplier taxes must use the invoice date for report12:18
Timitoscedk: yes12:19
cedkTimitos: so why not handling this on the tax report?12:20
Timitoscedk: this could be a solution. but will i be able to use the chart of Tax Codes? i think there would be different values. this could be confusing12:23
-!- tekknokrat( has joined #tryton12:29
cedkTimitos: there is one thing that I still don't understand, how can you encode a supplier invoice before the delivery?12:30
Timitoscedk: for number the invoice date is the correct date.12:30
Timitoscedk: this is not the case. it is always encoded after delivery? where did i write this?12:31
cedkTimitos: so the invoice date is after the delivery date (= accounting date)12:31
Timitoscedk: yes12:32
cedkTimitos: what is the frequency of tax report?12:35
Timitoscedk: by 3 month or monthly or by year. we have all cases here12:36
cedkTimitos: and much in the past can you make change in tax report?12:37
Timitoscedk: i can do this changes for any period if the fiscal year has not been closed.12:38
cedkTimitos: and what do it happen if the delivery date is in a closed period?12:39
-!- udono( has joined #tryton12:39
cedkTimitos: and if we add a date on tax lines how do the user will know that there is a change in his tax report?12:41
Timitoscedk: in this case i cannot do i right. i would decide together with the accountant in which period it should be posted. one solution is to put it in the period nearest to the correct period. the other solution is to put it in the actual period12:41
Timitoscedk: first of all: we are discussing not to put the tax to early into the report but later. so normally for this cases the tax would be declared later than it would be with your solution when you use the account date.12:44
cedkTimitos: one thing I don't understand is that period are globally only for taxes (not for move) and here you want to by-pass it12:44
Timitoscedk: hm. so if period is only for taxes we need to think about if we can handle this in a different way.12:46
cedkTimitos: can it be fixed with moves on an adjustment period?12:46
Timitoscedk: the normal way to handle such things for closed periods is to open an adjustment period for this month and to do the changes there.12:48
cedkTimitos: so you could do it for the tax backward change12:48
cedkTimitos: and the tax.code report will work normally12:49
Timitoscedk: i need to read our discussion again.12:51
cedkTimitos: so globally you make a move with debit/credit but only tax lines at the date you want on a adjustment period12:52
Timitoscedk: would accounting date and period depend on each other or not?12:52
cedkTimitos: yes they depend except for adjustment period12:53
Timitoscedk: so for now i can add a account date to the invoice which is optional. this date will define the period where the move for the invoice will be created. right?12:55
Timitosso for our case this will work good for customer invoices12:55
cedkTimitos: yes12:57
cedkTimitos: and for the special case where you have to put backward a tax, you write two moves without credit/debit with the right dates and tax lines amount13:01
cedkTimitos: I guess this case doesn't happen often?13:01
Timitoscedk: when periods are only for taxes why is then period related to account.move? i know this is common but i think it is a allowed question13:01
Timitoscedk: this case happens in transport business very often for example13:02
cedkTimitos: it is "globally" :-)13:02
cedkTimitos: so if the case happens often for one business, I guess it is better to write a module that make the two moves automaticly13:02
cedkTimitos: as it seems to be only for Germany13:03
Timitoscedk: yes. i think it must be a custom module13:03
cedkTimitos: and the rules are so specific13:03
Timitoscedk: i would need to adjust move creation for supplier invoices13:03
cedkTimitos: as soon as we can fix it with moves13:03
cedkTimitos: you must create two new moves with each one one line13:04
cedkTimitos: it can not be handle on one move because the date is on the move13:04
Timitoscedk: yes. because of different periods13:04
cedkTimitos: yes also, the backward moves must be done on adjustment periods13:05
cedkTimitos: so we are aggreed?13:05
Timitoscedk: yes13:06
Timitoscedk: but i have another point :-D13:07
cedkTimitos: argg...13:07
Timitoscedk: why is relation between account.move.line and a One2Many?13:07
cedkTimitos: what do you want?13:08
Timitoscedk: i noticed this when i was testing the entering of account moves from the view 'open journal'13:09
cedkTimitos: one tax move line can be dispatched into more than one tax code13:09
Timitosi think that there is no use of more than one tax line on a account.move.line and i would like to have a better solution for entering the tax on journal13:09
cedkTimitos: in Belgium, we have some case where we must put the base amount in two codes13:10
Timitosshat a pity :-)13:11
cedkTimitos: you don't have this? It is when you refund invoice13:11
Timitoscedk: my problem is that entering account moves from journal is not really easy with this tax line relation13:12
Timitoscedk: no. we do not have this.13:12
cedkTimitos: you can put default tax on account13:12
Timitoscedk: how?13:12
cedkTimitos: on account form13:13
Timitoscedk: with a custom module?13:13
cedkTimitos: no13:13
cedkTimitos: open account form13:13
cedkTimitos: I just though that it will be possible to create a wizard that take the current line and apply selected tax on it13:14
Timitosah. i will test.13:14
Timitoscedk: so is it already working? or not?13:15
Timitoscedk: why a wizard? isn´t it more a on_change action?13:15
cedkTimitos: default tax on account is working13:17
cedkTimitos: it must be a wizard because there is no field to store taxes on move line13:18
Timitoscedk: i try to use the default tax. but there is not tax line created automaticly but only a account move line with this tax13:20
Timitoscedk: stop. i think i forgot something13:20
cedkTimitos: you must have tax code on tax13:21
cedkTimitos: but I think there is an issue as it don't fill the code on tax lines13:21
Timitoscedk: yes it is not working13:22
CIA-48C?dric Krier <> default * 421:2086f0ce6678 account/ Fix typo in _compute_tax_lines13:38
cedkTimitos: fixed with this changeset13:38
cedkTimitos: last question, could we create a customer invoice with an invoice date in closed period?13:40
Timitoscedk: if the account date is in a open period perhaps. but for me account date should be always before invoice date and so i think that this case should not happen because if account date is before invoice date the period for account date will be before the period of invoice date an therefor it should be closed too.13:47
cedkTimitos: in my talk with our accountance, it was clear that account date can be after the invoice date for supplier invoice13:49
cedkTimitos: it is when you recieve an invoice with a date that is in the previous period that as closed, so you can only make your account move in the current period13:50
cedkTimitos: and you make a account move on adjustment period to correct13:51
Timitoscedk: ok. this is good13:51
cedkTimitos: so I propose to check that the period is still open at the invoice date only for customer invoice and supplier invoice we don't care13:52
Timitoscedk: sound reasonable13:53
cedkTimitos: ok, I think we have done all the issues13:54
Timitoscedk: i hope so.13:54
Timitoscedk: the tax lines are still not working for me13:55
cedkTimitos: yes, for our knowledge :-)13:55
-!- ctp( has joined #tryton14:03
CIA-48C?dric Krier <> default * 422:585a31836be8 account/ Add docstring and param test_state to find on account.period14:03
CIA-48C?dric Krier <> default * 316:016aae507e32 account_invoice/ Fix typo in default value of copy to reset the invoice_date to today14:06
CIA-48C?dric Krier <> default * 317:9458bda9d384 account_invoice/ ( invoice.xml): Add accounting_date on invoice14:06
cedkTimitos: ok, you can test it14:06
cedkudono: for issue922, did you change the language of the party?14:18
-!- enlightx(n=enlightx@ has joined #tryton14:19
-!- tekknokrat( has joined #tryton14:19
CIA-48Timitos roundup * #923/default taxes of account for entering account move lines not working: [new] there are still no tax lines added when i enter new account move lines from view 'open journal'.14:23
CIA-48ced roundup * #923/default taxes of account for entering account move lines not working: [need-eg] On which type of journal do you use?14:24
CIA-48Timitos roundup * #923/default taxes of account for entering account move lines not working: it is the standard expense journal14:26
CIA-48Timitos roundup * #923/default taxes of account for entering account move lines not working: [resolved] sorry. its working now. i was on a different db.14:31
-!- enlightx_( has joined #tryton14:55
-!- gremly(n=gremly@ has joined #tryton15:19
-!- gremly(n=gremly@ has joined #tryton15:45
-!- juanfer(n=juanfer@ has joined #tryton15:47
CIA-48C?dric Krier <> default * 1257:cd7ff2c152c3 tryton/tryton/gui/window/view_form/model/ Prevent signal when calling remove in set_on_change of O2M17:46
CIA-48C?dric Krier <> default * 318:69e5ff75f42a account_invoice/ Update taxes only for draft invoices17:51
CIA-48C?dric Krier <> default * 319:bf5a49c3e83b account_invoice/ ( invoice.xml): Add tax on invoice tax and use it for key instead of description for issue92217:51
CIA-48ced roundup * #922/Invoice Report: Tax as sequence: [resolved] Fix with changeset bf5a49c3e83b17:51
-!- vengfulsquirrel( has joined #tryton17:55
-!- enlightx( has joined #tryton17:56
-!- MechtiIde( has joined #tryton18:01
-!- MechtiIde( has left #tryton18:03
-!- enlightx( has joined #tryton18:26
-!- cristi_an(i=5978d3ce@gateway/web/ajax/ has joined #tryton19:02
-!- enlightx( has joined #tryton20:13
cristi_ancedk: from where do you have svg files ?20:44
cristi_anand client works with those ? not png ?20:45
cedkcristi_an: I don't understand20:47
cedkcristi_an: svg files are under pixmaps folder20:47
cristi_ancedk: thx...20:48
cristi_ancedk: i asked who did them for tryton20:48
cedkcristi_an: some comes from tango project and other it is bechamel20:49
-!- gremly(n=gremly@ has joined #tryton20:51
-!- saxa( has joined #tryton20:57
-!- paola( has joined #tryton21:08
juanferHello, I have problem seen one module in the list of modules, the module is account_invoice_history, I just download it and left in the direcotry .../trytond/modules/account_invoice_history, and doesn't appear.21:45
yangoonjuanfer: did you restart the server?21:46
juanferand of course the client21:46
juanferit is a bug?21:47
yangoonjuanfer: do you have correct permissions on the module dir, so that the server can read it?21:47
juanferhold on21:47
juanferThe same as other modules.21:48
yangoonjuanfer: could you start the server on the console with -v and paste the output to a pastebin?21:49
juanferand my modules directory
juanferCould I report the bug?21:55
yangoonjuanfer: which distro?21:55
yangoonjuanfer: you have a conflict between two installations21:56
yangoonjuanfer: one is in /home/juanfe/tryton/trytond/trytond21:56
yangoonthe other is in /usr/lib/python2.5/site-packages/21:56
yangoonjuanfer: I had this already:
juanferBut I never had one there21:57
yangoonjuanfer: I think you iinstalled the debian packages21:57
carlosjuanfer: did you executed setup install inside any Tryton module?21:58
yangoonjuanfer: then you probably did one install with setup.py21:59
juanferah, this is the problem21:59
juanfercarlos is right, it was I never do with acount_invoice_history.21:59
juanfernever did21:59
juanferI will try22:00
carlosjuanfer: you don't really need an install22:00
yangoonjuanfer: you should remove one of both installations, otherwise you will get a mix22:00
carlosif you execute it from within you home, you only need the modules inside trytond/modules directory22:00
yangooncarlos: my experience is other
juanfercarlos is right it work22:02
yangoonjuanfer: good luck. you have been warned;)22:03
juanfer cd trytond/modules/account_invoice_history; python install22:04
juanferyangoon, but I never use the debian package for tryton, so is different, but I will take in account, if some day I do22:05
juanferthx both22:05
carlosyangoon: I mean that is easier to use only the ones in his home directory22:05
yangooncarlos: sure22:06
carlosyangoon: having a mix is a good way to have problems22:06
yangooncarlos: sure22:06
carlosas you already stated ;-)22:06
yangooncarlos: I have not yet recovered all my databases from this mix... and probably will never do22:06
carlosoh, so it affected a production system? bad thing...22:07
yangooncarlos: no, not production, gladly22:08
yangooncarlos: I have to investigate further, but it seems really dangerous to have a mix of setup methods22:10
carlosyeah, I agree22:10
yangooncarlos: running stable parallel to dev version: no problem when running just from source directory22:11
carlosIt may be a problem for people trying to migrate to a new version and have two versions installed at the same time22:11
yangoonbut running dev version from sources and having installed stable with is dangerous22:11
carlosyangoon: in that case, is not a problem only if neither are in the PYTHONPATH22:12
carlosthe problem is that modules are found in PYTHONPATH22:12
yangoonyes, I didn't try so far to (re)set PYTHONPATH for such instances, but I will give it a try some time22:14
-!- ctp( has joined #tryton22:55
-!- ctp( has joined #tryton22:56
-!- vengfulsquirrel( has joined #tryton23:20
-!- tekknokrat( has left #tryton23:28 * r493 /wiki/ Added the initial set of data structures for chart of accounts.23:29
-!- essich( has joined #tryton23:29 * r494 /wiki/ Edited wiki page through web user interface.23:29 * r495 /wiki/ Added description to some fields23:29
CIA-48C?dric Krier <> default * 1708:0bd0feea1d79 trytond/trytond/modules/ Fix get_module_list if there is no pkg_resources23:30
cedkyangoon: did you test the patches for issue915?23:45
CIA-48C?dric Krier <> default * 1709:190a74359aef trytond/trytond/ir/ Prevent to delete not xml error message for issue91823:47
CIA-48ced roundup * #918/Translation: items reappearing untranslated: [resolved] Fix with changeset 190a74359aef23:48
yangooncedk: I don't have python 2.6 running myself, but I have forwarded the patch to the user, who had the issue and likely will test it23:50
yangooncedk: on python 2.5 no issue with the patch23:50
-!- johbo( has joined #tryton23:51
cedkyangoon: it will be great to have feedback soon to have the patch for the release23:52
yangooncedk: I know, I think he will do his best23:54
yangoonperhaps someone other runs opensuse 11.1?23:54
cedkyangoon: he must test also ssl connection23:54
CIA-48C?dric Krier <> default * 1710:3b44953dde22 trytond/trytond/ir/ Don't test write_uid when updating/importing translation for issue87223:55
CIA-48ced roundup * #872/Translation: translated items reappearing as fuzzy: I hope this is fixed with changeset 3b44953dde2223:56

Generated by 2.11.0 by Marius Gedminas - find it at!