Re: [tryton] third-party and self-billing

2018-07-20 Thread Richard PALO
Le 20/07/2018 à 19:26, Richard PALO a écrit : What I see as really different here, at least in France, is that the invoice sequencing probably should be clearly distinct (http://bofip.impots.gouv.fr/bofip/140-PGP.html paragraph 100) oups... and paragraphs 120-130 -- Richard PALO -- You

Re: [tryton] third-party and self-billing

2018-07-20 Thread Richard PALO
Le 20/07/2018 à 18:13, Cédric Krier a écrit : On 2018-07-20 16:48, Richard PALO wrote: I'm curious if somebody has already come up with a third-party and self-billing (autofacturation) module for tryton. This should be relatively trivial, but it would be nice to save some cycles if al

[tryton] third-party and self-billing

2018-07-20 Thread Richard PALO
I'm curious if somebody has already come up with a third-party and self-billing (autofacturation) module for tryton. This should be relatively trivial, but it would be nice to save some cycles if already done. cheers, -- Richard PALO -- You received this message because you are subsc

Re: [tryton] sao and comma decimal separator

2018-06-22 Thread Richard PALO
Le 22/06/2018 à 09:35, Cédric Krier a écrit : On 2018-06-22 08:42, Richard PALO wrote: Le 22/06/2018 à 08:31, Richard PALO a écrit : How to get SAO client data entry to accept numeric keypad decimal as comma which seems to be required for debit/credit entries? I'm using French locale

Re: [tryton] sao and comma decimal separator

2018-06-21 Thread Richard PALO
Le 22/06/2018 à 08:31, Richard PALO a écrit : How to get SAO client data entry to accept numeric keypad decimal as comma which seems to be required for debit/credit entries? I'm using French locale. No problem in standard client. Thought I would double check with chromium and surpris

[tryton] sao and comma decimal separator

2018-06-21 Thread Richard PALO
How to get SAO client data entry to accept numeric keypad decimal as comma which seems to be required for debit/credit entries? I'm using French locale. No problem in standard client. -- Richard PALO -- You received this message because you are subscribed to the Google Groups "try

Re: [tryton] Re: [tryton-fr] Handling of returns/cancelations

2018-06-01 Thread Richard PALO
Le 08/04/2018 à 09:41, Richard PALO a écrit : For info, https://bugs.tryton.org/issue5180 has been updated with an initial patchset proposal supporting an 'allow_negative_moves' configuration parameter. Perhaps this should be alternately named 'allow red storno moves' as

Re: [tryton] Using different credit and debit accounts on statement journal

2018-06-01 Thread Richard PALO
Le 01/06/2018 à 18:39, Richard PALO a écrit : As far as our usage goes (using account_fr), the only journal having differing accounts for debit/credit is the closing journal which is a [special] situation, not a statement, journal. Should probably mention that since the debit/credit

Re: [tryton] Using different credit and debit accounts on statement journal

2018-06-01 Thread Richard PALO
for debit/credit is the closing journal which is a [special] situation, not a statement, journal. cheers, -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/ms

[tryton] Re: [tryton-fr] Handling of returns/cancelations

2018-04-08 Thread Richard PALO
de.google.com/p/tryton/wiki/CreditNotevsCancelation May be we can find together the most common denominator of this business case. Le mardi 24 mars 2015, Richard PALO a écrit : En effet, avec le Nouveau Plan comptable (1999), une obligation de traçabilité des modifications d'écritur

Re: [tryton] journal sequences by fiscal year

2018-04-03 Thread Richard PALO
Le 03/04/2018 à 18:54, Dominique Chabord a écrit : 2018-04-03 18:44 GMT+02:00 Richard PALO : Dans chaque journal, les écritures doivent être identifiées par un numéro séquentiel formant, le cas échéant par période comptable ou par exercice, une série continue. Which quickly translated says

Re: [tryton] journal sequences by fiscal year

2018-04-03 Thread Richard PALO
Le 03/04/2018 à 18:54, Cédric Krier a écrit : On 2018-04-03 18:44, Richard PALO wrote: Interestingly, article III.C.4 Avis CNC 174-1 - Les principes d'une comptabilité régulière found in the site of the Belgian CNC http://www.cnc-cbn.be/files/advice/link/FR_174-01.htm is quite simil

Re: [tryton] journal sequences by fiscal year

2018-04-03 Thread Richard PALO
Le 02/04/2018 à 21:58, Cédric Krier a écrit : On 2018-04-02 18:43, Richard PALO wrote: How to set sequences created for general journals to reset every fiscal year? It is not possible. 'not possible' is probably missing the adverb 'currently' It is true that the post

[tryton] journal sequences by fiscal year

2018-04-02 Thread Richard PALO
How to set sequences created for general journals to reset every fiscal year? It appears even the Default Account Journal sequence is shared... It is true that the posted move sequence and invoicing sequences are reset, but any journal that touches the GL should be as well. -- Richard PALO

Re: [tryton] merge invoices

2017-12-25 Thread Richard PALO
Le 19/12/2017 à 14:15, Sergi Almacellas Abellana a écrit : El 19/12/17 a les 06:55, Richard PALO ha escrit: Does it exist documentation to map, for migration purposes, openerp purchase workflows to tryton workflows?  This is somewhat the critical path. No that I'm aware of. But it wi

Re: [tryton] merge invoices

2017-12-18 Thread Richard PALO
Le 18/12/2017 à 20:11, Cédric Krier a écrit : On 2017-12-18 20:06, Richard PALO wrote: Having a number of suppliers which group multiple deliveries in one invoice, with OpenERP (aka Odoo) we've been using account_invoice_merge extensively. Maybe missing something but haven't seem to

[tryton] merge invoices

2017-12-18 Thread Richard PALO
Having a number of suppliers which group multiple deliveries in one invoice, with OpenERP (aka Odoo) we've been using account_invoice_merge extensively. Maybe missing something but haven't seem to have found the equivalent in tryton. Any hints? cheers, -- Richard PALO -- You rec

Re: [tryton] Discount per family and per amount of products in a month

2017-10-28 Thread Richard PALO
Le 28/10/2017 à 11:27, Cédric Krier a écrit : On 2017-10-28 06:48, Richard PALO wrote: Le 28/10/2017 à 01:12, Cédric Krier a écrit : On 2017-10-27 22:27, Richard PALO wrote: So do not fill it. You do not need to have the supplier price, it is there for information. ?? I thought that stock

Re: [tryton] Discount per family and per amount of products in a month

2017-10-27 Thread Richard PALO
Le 28/10/2017 à 01:12, Cédric Krier a écrit : On 2017-10-27 22:27, Richard PALO wrote: So do not fill it. You do not need to have the supplier price, it is there for information. ?? I thought that stock receptions used the order prices (not the invoiced price) for stock valuation on the

Re: [tryton] Discount per family and per amount of products in a month

2017-10-27 Thread Richard PALO
Le 26/10/2017 à 10:09, Cédric Krier a écrit : On 2017-10-26 07:19, Richard PALO wrote: Le 25/10/2017 à 13:57, Cédric Krier a écrit : On 2017-10-25 13:47, Richard PALO wrote: I believe there should be some additional things to consider, typically for suppliers where instead of communicating

Re: [tryton] Discount per family and per amount of products in a month

2017-10-25 Thread Richard PALO
I believe as well that supplier purchase categories could or should probably relate to purchase.product_supplier as opposed to being dumped on product.template cheers -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To

Re: [tryton] Discount per family and per amount of products in a month

2017-10-25 Thread Richard PALO
Le 25/10/2017 à 13:57, Cédric Krier a écrit : On 2017-10-25 13:47, Richard PALO wrote: I believe there should be some additional things to consider, typically for suppliers where instead of communicating net prices to their [professional] clients, there are: We don't try to compute in

Re: [tryton] Discount per family and per amount of products in a month

2017-10-25 Thread Richard PALO
a broker may have this on both supplier and client price lists. It seems that currently the pricing and price list schemas don't deal with these common practices. cheers, -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group.

[tryton] Re: Handling of returns/cancelations

2017-10-10 Thread Richard PALO
de.google.com/p/tryton/wiki/CreditNotevsCancelation May be we can find together the most common denominator of this business case. Le mardi 24 mars 2015, Richard PALO a écrit : En effet, avec le Nouveau Plan comptable (1999), une obligation de traçabilité des modifications d'écritur

Re: [tryton] Re: openerp2tryton : painfully long in migrate_account_balance

2017-10-06 Thread Richard PALO
Le 06/10/2017 à 11:32, Albert Cervera i Areny a écrit : 2017-09-20 19:25 GMT+02:00 Richard PALO mailto:richard.p...@free.fr>>: Thought I would mention that I'm seeing roughly a 2,5x speedup using pgbouncer over vanilla postgresql socket connections (via tryton.conf) w

Re: [tryton] proteus: is it possible to dynamically add/remove simple field to existing model

2017-09-25 Thread Richard PALO
psql. cheers, -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/cb9858f6-82ff-025c-c7d6-f3db0055369f%40free.fr.

Re: [tryton] proteus: is it possible to dynamically add/remove simple field to existing model

2017-09-23 Thread Richard PALO
Le 23/09/2017 à 18:43, Cédric Krier a écrit : On 2017-09-23 18:16, Richard PALO wrote: As the title indicates, I'm interested to know if one can add/remove a persistent field (simple, non relational... like an integer) to an existing model with proteus. Tryton enforce data integrity

[tryton] proteus: is it possible to dynamically add/remove simple field to existing model

2017-09-23 Thread Richard PALO
As the title indicates, I'm interested to know if one can add/remove a persistent field (simple, non relational... like an integer) to an existing model with proteus. Or is the only way by adding a custom module which then can be removed when done. Any pointers are welcome. -- Richard

Re: [tryton] setting sequence.number_next[_internal] via proteus

2017-09-21 Thread Richard PALO
Le 21/09/2017 à 00:11, Cédric Krier a écrit : On 2017-09-20 19:26, Richard PALO wrote: I'm curious how to currectly set the next_number_internal for an ir.sequence, namely for reconciliations using proteus. Setting, for example, seq.prefix='A' works just fine but seq.number_n

[tryton] setting sequence.number_next[_internal] via proteus

2017-09-20 Thread Richard PALO
nually from the sequences form, is that the only way to do it? Hints on doing so? I tried Sequence.write([seq.id], {'number_next_internal': 10,}) but I get: TypeError: write() missing 1 required positional argument: 'values' cheers -- Richard PALO -- You received this me

[tryton] Re: openerp2tryton : painfully long in migrate_account_balance

2017-09-20 Thread Richard PALO
roughly 30 minutes per fiscalyear with a rough average of 21-22K lines/year) cheers, -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/3bf

Re: [tryton] openerp2tryton : painfully long in migrate_account_balance

2017-07-23 Thread Richard PALO
a nice tip, and it allowed me to get much much further. Thanks. In the end, once I created a tryton move per opererp move, it seemed I could live without modifying the cache and get 5 1/2 years in under a couple of hours (fiscal year by fiscal year). -- Richard PALO "Ne croyez rien, peu im

Re: [tryton] openerp2tryton : painfully long in migrate_account_balance

2017-07-21 Thread Richard PALO
tively fast, but a thousand was slowing down fast, and many hours later only a total of roughly 2500 move lines were saved so extrapolating 15K is probably close to infinity,timewise. *I presume* multiple moves would help already greatly (but I haven't had a chance yet to try it). cheers -

Re: [tryton] openerp2tryton : painfully long in migrate_account_balance

2017-07-20 Thread Richard PALO
ese accounts. Can't directly explain why it takes so long before throwing this error, but oh well, it may be because there are between 15K and 25K move lines per fiscal year. So far I split by year, but might as well go for year/period/journal/move why I'm at it (for a full, deep migra

Re: [tryton] openerp2tryton : painfully long in migrate_account_balance

2017-07-18 Thread Richard PALO
Le 18/07/2017 à 13:27, Cédric Krier a écrit : On 2017-07-18 13:01, Richard PALO wrote: I'm looking for hints as to how to prod move.save() to complete or at least to give some info as to why it isn't. It appears to be cpu bound (indeed, the openerp base is quite large). move.save

[tryton] openerp2tryton : painfully long in migrate_account_balance

2017-07-18 Thread Richard PALO
sep", "a"."n_cs_precedes" AS "n_cs_precedes", "a"."n_sep_by_space" AS "n_sep_by_space", "a"."n_sign_posn" AS "n_sign_posn", "a"."negative_sign" AS "negative_sign", "a&q

[tryton] import_data for accounts

2017-07-16 Thread Richard PALO
re (that is, losing the valid ids)? Other ideas on how to import these VAT accounts? -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/2454336e-8553-0a0e-0dda-a1a680e083f5%40free.fr.

Re: [tryton] updating party_sequence with proteus

2017-06-20 Thread Richard PALO
Le 20/06/2017 à 17:09, Richard PALO a écrit : The following code, for example, works as expected if I manually install party and select the party sequence with the tryton client. # Reset the sequence Sequence = Model.get('ir.sequence') configuration = Configuration(

Re: [tryton] updating party_sequence with proteus

2017-06-20 Thread Richard PALO
Le 20/06/2017 à 15:19, Cédric Krier a écrit : On 2017-06-20 15:10, Richard PALO wrote: Le 20/06/2017 à 14:27, Cédric Krier a écrit : On 2017-06-20 09:08, Richard PALO wrote: Not very fluent in proteus nor the recent ir.sequence usage changes, I'm having difficulty getting a critical po

Re: [tryton] updating party_sequence with proteus

2017-06-20 Thread Richard PALO
Le 20/06/2017 à 14:27, Cédric Krier a écrit : On 2017-06-20 09:08, Richard PALO wrote: Not very fluent in proteus nor the recent ir.sequence usage changes, I'm having difficulty getting a critical portion of the openerp2tryton to work on 4.4... In migrate_party, there is the following

[tryton] updating party_sequence with proteus

2017-06-20 Thread Richard PALO
cannot 'save()' the record as the method isn't available. Using update_sql_sequence() doesn't seem to work in this context either. So I presume this is probably a false route. Any hints on how to actualise the reference party_sequence under Configuration? Where does Configura

[tryton] Re: printing moves and journals

2017-03-24 Thread Richard PALO
Le 24/03/2017 à 12:23, Cédric Krier a écrit : On 2017-03-22 15:42, Richard PALO wrote: I was just stupefied to notice that there seems to be no default way to print a standard account move nor a period journal report. I guess most of our users embraced the dematerialized movement :-) ja

Re: [tryton] Re: account_invoice reports

2017-03-24 Thread Richard PALO
ton stored the path and not the bytes of the report when modified in Administration->UI->Actions->Reports->Facture If I update upon every change of the model it seems okay. Sorry for the noise. -- Richard PALO -- You received this message because you are subscribed to the Google Grou

[tryton] Re: account_invoice reports

2017-03-24 Thread Richard PALO
"invoice.reference" and some other combinations to no avail. Is there some special magic needed to add a guard here? I doubled checked to see that it wasn't using a cached file, and that Reference was indeed empty, so there seems to be something with the logic. -- Richard PALO -- Yo

[tryton] printing moves and journals

2017-03-22 Thread Richard PALO
functionality already added something? If so, let's see to get it mainlined as soon as possible! cheers, -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com

[tryton] Re: account_invoice reports

2017-03-20 Thread Richard PALO
Le 20/03/2017 à 14:03, Richard PALO a écrit : Le 20/03/2017 à 00:19, Cédric Krier a écrit : On 2017-03-19 18:28, Richard PALO wrote: I have some question concerning account_invoice reports: 1. How do I get rid of the last page, which only has a header/footer? As far as I have seen it is a

[tryton] Re: account_invoice reports

2017-03-20 Thread Richard PALO
Le 20/03/2017 à 00:19, Cédric Krier a écrit : On 2017-03-19 18:28, Richard PALO wrote: I have some question concerning account_invoice reports: 1. How do I get rid of the last page, which only has a header/footer? As far as I have seen it is a bug in open/libre—office. Reference please to

[tryton] account_invoice reports

2017-03-19 Thread Richard PALO
ick up price_decimal for calculations, but I don't believe it should be the resulting display precision for unit prices, how can I set this to a different value on the report? 4. In the file store, final format should probably be pdf, is there a way to get pdf stored, eventually a hybrid pdf

[tryton] some questions about account_invoice / attachments

2017-03-19 Thread Richard PALO
4. Trying with the [attachment] section, I noticed setting store_prefix is parallel to the default, which is the database name. Is there a mechanism to get the prefix to work as a subdirectory of the database name? cheers, -- Richard PALO -- You received this message because you are subscribed to

Re: [tryton] Re: version 4 GL & balance reports

2016-12-05 Thread Richard PALO
Le 04/12/2016 à 12:30, Cédric Krier a écrit : On 2016-12-04 07:59, Richard PALO wrote: As a side note, seems a bit heavy if tryton needs to read all previous years to get starting balance (I most certinaly hope not). It is not heaving and indeed it is even a speedup. I see

[tryton] Re: version 4 GL & balance reports

2016-12-03 Thread Richard PALO
Le 04/12/2016 à 04:06, Cédric Krier a écrit : On 2016-12-03 13:37, Richard PALO wrote: Anybody get further into prototype mode in order to propose a blueprint supporting, in addition to 'all' as is currently: 1. with 'start balance <> 0' and/or 2. with 'end

[tryton] Re: version 4 GL & balance reports

2016-12-03 Thread Richard PALO
Le 27/05/2016 à 09:42, Richard PALO a écrit : As indicated https://bugs.tryton.org/issue5168 I'm trying to see how to approach (as suggested) under 4.0 a function field 'searcher' that operates on 'sum' fields as the patch which worked on 3.8 no longer does. The is

[tryton] Re: Adding validity dates for product supplier price

2016-07-22 Thread Richard PALO
Le 22/07/16 09:17, Cédric Krier a écrit : On 2016-07-22 07:21, Richard PALO wrote: Le 22/07/16 07:08, Cédric Krier a écrit : That highly depends on the industry. In some of them, suppliers update prices yearly and the company want the new prices to take effect on the right date. It is also

Re: [tryton] Adding validity dates for product supplier price

2016-07-21 Thread Richard PALO
One common example is any installation service company (electricity, plumbing, HVAC, etc...) -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/5791AD52.6080104%40netbsd.org.

[tryton] version 4 GL & balance reports

2016-05-27 Thread Richard PALO
t other experiences/observations/suggestions from the community. cheers -- Richard PALO -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/5747FA62.6050401%40netbsd.org.

[tryton] Re: migration from 3.8 -> 4.0 with webdav

2016-05-06 Thread Richard PALO
re-installed instead of 4.0. Updated now via tryton-admin and am trying to get accustomed to the new interface to GL and balance. cheers -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web

[tryton] migration from 3.8 -> 4.0 with webdav

2016-05-06 Thread Richard PALO
tError: No module named webdav I have built trytond_webdav (4.0.1) and installed it, all the other modules used have been updated to 4.0.0 cheers -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/572CAF39.6080409%40netbsd.org.

Re: [tryton] asset amortisation and 'yearly' frequency

2016-04-22 Thread Richard PALO
. > Well, I'd like to get 'degressive' polished first, I think linear can be 'fixed' and both methods optimised in a future pass. Walk before run? Teething can be painful:-P Nicolas has a copy of the work in progress. Once I get the GUI part reacting better, to me

Re: [tryton] asset amortisation and 'yearly' frequency

2016-04-21 Thread Richard PALO
Le 20/04/16 10:56, Nicolas Évrard a écrit : > * Richard PALO [2016-04-20 12:28 +0700]: >> I've been tinkering getting a fully working 'degressive' amortisation >> method in account_assets. >> >> Although initially it was rather quite simple (at it i

Re: [tryton] dependency on liberation fonts?

2016-04-19 Thread Richard PALO
. (the problem is with 'n's being printed as 'o's) I can reproduce with db's converted from earlier versions of tryton but not with a fresh install. -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To

[tryton] asset amortisation and 'yearly' frequency

2016-04-19 Thread Richard PALO
tion. 'Yearly' effects could still be done, for example, leaving it to the 'movement', that is, either split by period or grouping all and collapsing into a single movement at the end of the period... leaving the amortisation 'future' schedule monthly. What are

Re: [tryton] dependency on liberation fonts?

2016-04-08 Thread Richard PALO
Le 08/04/16 13:36, Cédric Krier a écrit : > On 2016-04-08 13:09, Richard PALO wrote: >> During the discussion of pagesize/language problems in report templates from >> issue5464 >> I noticed: >>> doc/topics/reports/index.rst:5115:* Use Liberation fonts

[tryton] dependency on liberation fonts?

2016-04-08 Thread Richard PALO
if being > officially included in I find no other documentation of this dependency. Is it supposed to be in trytond or in one of the modules so I can add fonts/liberation-ttf to it's dependency list... -- Richard PALO -- You received this message because you are subscribed to the Googl

[tryton] Re: Do we need to create new Post Move, Invoice and Credit Note Sequences for every Fiscal Year?

2015-12-10 Thread Richard PALO
t only garantee that two invoices emitted in *the same year* cannot have the same sequence number. It is therefore advised to use a *distinct* prefix for each sequence number in order to avoid any confusion. Using the year as a prefix is, and I believe always has been, perfectly fine. cheers,

[tryton] downloads directory not updated?

2015-03-22 Thread Richard PALO
; Release of trytond_account_fr-3.4.1 ... But these are missing from http://downloads.tryton.org/3.4/ Please update the download directory for each release. - -- Richard PALO -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.