| chat.freenode.net #tryton log beginning Wed Oct 15 00:00:01 CEST 2014 | ||
| 2014-10-15 00:44 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2014-10-15 01:29 -!- digitalsatori(~Thunderbi@114.92.210.36) has joined #tryton | ||
| 2014-10-15 02:52 -!- digitalsatori(~Thunderbi@114.92.210.36) has joined #tryton | ||
| 2014-10-15 03:43 -!- pokoli(~pokoli@unaffiliated/pokoli) has joined #tryton | ||
| 2014-10-15 04:07 -!- digitalsatori(~Thunderbi@114.92.210.36) has joined #tryton | ||
| 2014-10-15 04:17 -!- smarro(~sebastian@190.105.93.196) has joined #tryton | ||
| 2014-10-15 04:32 -!- digitalsatori(~Thunderbi@114.92.210.36) has joined #tryton | ||
| 2014-10-15 04:53 -!- notzippy(~sabayonus@d207-216-251-90.bchsia.telus.net) has joined #tryton | ||
| 2014-10-15 04:54 -!- smarro(~sebastian@190.105.93.196) has joined #tryton | ||
| 2014-10-15 06:40 -!- frispete_(~frispete@p54A91797.dip0.t-ipconnect.de) has joined #tryton | ||
| 2014-10-15 07:02 -!- yangoon(~mathiasb@p549F1252.dip0.t-ipconnect.de) has joined #tryton | ||
| 2014-10-15 07:23 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton | ||
| 2014-10-15 07:41 -!- pobsteta1(~Thunderbi@185.10.253.102) has joined #tryton | ||
| 2014-10-15 07:57 -!- fshahy(b903d4ab@gateway/web/freenode/ip.185.3.212.171) has joined #tryton | ||
| 2014-10-15 08:13 -!- fshahy(b903d4ab@gateway/web/freenode/ip.185.3.212.171) has left #tryton | ||
| 2014-10-15 08:13 -!- fshahy(b903d4ab@gateway/web/freenode/ip.185.3.212.171) has joined #tryton | ||
| 2014-10-15 08:14 -!- fshahy(b903d4ab@gateway/web/freenode/ip.185.3.212.171) has left #tryton | ||
| 2014-10-15 08:19 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton | ||
| 2014-10-15 08:22 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton | ||
| 2014-10-15 08:26 -!- digitalsatori(~Thunderbi@114.94.143.131) has joined #tryton | ||
| 2014-10-15 08:26 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2014-10-15 08:45 -!- fshahy(~farid@185.3.212.171) has joined #tryton | ||
| 2014-10-15 08:45 -!- fshahy(~farid@185.3.212.171) has left #tryton | ||
| 2014-10-15 09:06 -!- jeancavallo(~giovanni@bob75-9-88-181-2-176.fbx.proxad.net) has joined #tryton | ||
| 2014-10-15 09:10 -!- corro(~corro@46.22.23.85) has joined #tryton | ||
| 2014-10-15 09:14 -!- vcardon(~vcardon@bureau-sdsl.tranquil.it) has joined #tryton | ||
| 2014-10-15 10:15 -!- bechamel(~Adium@01101623.cism.ucl.ac.be) has joined #tryton | ||
| 2014-10-15 10:20 -!- prksh(~prksh@1.187.248.18) has joined #tryton | ||
| 2014-10-15 11:03 -!- fshahy(b903d4ab@gateway/web/freenode/ip.185.3.212.171) has joined #tryton | ||
| 2014-10-15 11:07 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton | ||
| 2014-10-15 11:10 -!- prksh(~prksh@106.78.122.121) has joined #tryton | ||
| 2014-10-15 11:21 -!- digitalsatori(~Thunderbi@114.94.143.131) has joined #tryton | ||
| 2014-10-15 11:24 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton | ||
| 2014-10-15 12:19 -!- nicoe(~nicoe@2001:6f8:3aa:2:ee55:f9ff:fe7b:f7ac) has joined #tryton | ||
| 2014-10-15 12:22 -!- fshahy(b903d4ab@gateway/web/freenode/ip.185.3.212.171) has left #tryton | ||
| 2014-10-15 12:46 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton | ||
| 2014-10-15 12:46 -!- mariomop(~quassel@host121.190-136-195.telecom.net.ar) has joined #tryton | ||
| 2014-10-15 12:50 -!- prksh(~prksh@198.61.199.179) has joined #tryton | ||
| 2014-10-15 12:52 -!- smarro(~sebastian@190.105.93.196) has joined #tryton | ||
| 2014-10-15 12:56 -!- kstenger(~karla@200.124.209.158) has joined #tryton | ||
| 2014-10-15 13:14 -!- prksh(~prksh@106.78.97.72) has joined #tryton | ||
| 2014-10-15 13:27 -!- kstenger(~karla@200.124.209.158) has joined #tryton | ||
| 2014-10-15 13:56 -!- prksh(~prksh@198.61.199.179) has joined #tryton | ||
| 2014-10-15 14:08 -!- prksh(~prksh@198.61.199.179) has joined #tryton | ||
| 2014-10-15 14:24 -!- newzen(~newzen@190.206.222.187) has joined #tryton | ||
| 2014-10-15 14:27 -!- swayf(~swayf@93.104.202.98) has joined #tryton | ||
| 2014-10-15 14:42 -!- vcardon(~vcardon@bureau-sdsl.tranquil.it) has left #tryton | ||
| 2014-10-15 14:58 -!- prksh(~prksh@180.188.247.165) has joined #tryton | ||
| 2014-10-15 15:32 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton | ||
| 2014-10-15 15:33 -!- prksh(~prksh@180.188.247.165) has left #tryton | ||
| 2014-10-15 15:38 -!- funnybunny(funnybunny@gateway/shell/blinkenshell.org/x-fshifdbiiuqfhyov) has joined #tryton | ||
| 2014-10-15 15:38 <funnybunny> hi there! | ||
| 2014-10-15 15:41 <pokoli> hi funnybunny | ||
| 2014-10-15 15:42 <funnybunny> hi pokoli | ||
| 2014-10-15 15:42 <funnybunny> i am looking for some advice.. | ||
| 2014-10-15 15:42 <funnybunny> i think i kinda ruined my tryton db.. | ||
| 2014-10-15 15:42 <pokoli> funnybunny: what happenend? | ||
| 2014-10-15 15:43 <funnybunny> at least from the client side.. i created an invoice which is now "paid".. | ||
| 2014-10-15 15:43 <funnybunny> and had an exchange rate set to 7500,00 when i really was 0,75 | ||
| 2014-10-15 15:43 <pokoli> funnybunny: customer or supplier invoice? | ||
| 2014-10-15 15:43 <funnybunny> i mistook , for . and didn't check twice | ||
| 2014-10-15 15:43 <funnybunny> customer | ||
| 2014-10-15 15:43 <funnybunny> now it's booked in cash and revenue.. | ||
| 2014-10-15 15:44 <pokoli> funnybunny: just create a customer credit note | ||
| 2014-10-15 15:44 <pokoli> funnybunny: there is a wizard to create the same invoice as credit note | ||
| 2014-10-15 15:44 <funnybunny> but i'd like to remove this totally wrong invoice | ||
| 2014-10-15 15:44 <pokoli> funnybunny: and then create the new invoice with the correct amount | ||
| 2014-10-15 15:44 <funnybunny> it's now 35 cents instead of 2156,- | ||
| 2014-10-15 15:45 <funnybunny> will that remove the wrong invoice? or just balance it out? | ||
| 2014-10-15 15:45 <pokoli> funnybunny: balance it out | ||
| 2014-10-15 15:46 <funnybunny> is there no way to remove the invoice without firing up some postgres admin tool? | ||
| 2014-10-15 15:47 <pokoli> funnybunny: customer invoice/credit note can not be caneceled once posted | ||
| 2014-10-15 15:47 <funnybunny> ugh, i was fearing that.. | ||
| 2014-10-15 15:48 <pokoli> funnybunny: your invoice was generated from a sale? | ||
| 2014-10-15 15:48 <funnybunny> so i'll need to read through the code to see which columns in which table to delete ?:D | ||
| 2014-10-15 15:48 <funnybunny> generated? | ||
| 2014-10-15 15:48 <funnybunny> i manually entered it | ||
| 2014-10-15 15:48 <funnybunny> as an invoice | ||
| 2014-10-15 15:49 <funnybunny> which rows in which tables* | ||
| 2014-10-15 15:49 <pokoli> funnybunny: you have to delete the accounting moves related to the invoice | ||
| 2014-10-15 15:49 <cedk> funnybunny: you could probably fix the balance by creating negative lines | ||
| 2014-10-15 15:49 <pokoli> funnybunny: and update the invoice state to draft in order to modify it | ||
| 2014-10-15 15:49 -!- yangoon(~mathiasb@p549F1252.dip0.t-ipconnect.de) has joined #tryton | ||
| 2014-10-15 15:49 <pokoli> funnybunny: but I will recommend you to create the credit note as it's easier | ||
| 2014-10-15 15:49 <funnybunny> pokoli: that'll probably be best.. | ||
| 2014-10-15 15:50 <funnybunny> negative lines will be extra work later.. | ||
| 2014-10-15 15:50 <funnybunny> i rather clean this up than increase the mess | ||
| 2014-10-15 15:50 <pokoli> funnybunny: I've never done this, so don't guaranty anything | ||
| 2014-10-15 15:50 <funnybunny> odd that not even an admin can undo an accounting line | ||
| 2014-10-15 15:51 <pokoli> funnybunny: please don't do it in production database, before testing it in a copy that you can delete if you mess it up | ||
| 2014-10-15 15:51 <funnybunny> well, guess i am lucky this is an open source project then? the inner workings can't hide from me :D | ||
| 2014-10-15 15:51 <funnybunny> this is for my own company.. and i only just setup this db | ||
| 2014-10-15 15:52 <funnybunny> actually it's the first invoice .D | ||
| 2014-10-15 15:52 <pokoli> funnybunny: why not reinstalling then? | ||
| 2014-10-15 15:52 <funnybunny> because i already input parties | ||
| 2014-10-15 15:52 <funnybunny> could i just remove the accounting related modules? will that clean their tables? | ||
| 2014-10-15 15:53 <pokoli> funnybunny: maybe truncating account_invoice and account_move may do the trick | ||
| 2014-10-15 15:53 <pokoli> funnybunny: truncating in a cascade way | ||
| 2014-10-15 15:53 <pokoli> funnybunny: but (another time) i can not guarantee anything | ||
| 2014-10-15 15:53 <funnybunny> the client can't do that though, right? | ||
| 2014-10-15 15:53 <funnybunny> sure, i need no guarantees, only suggestions :) | ||
| 2014-10-15 15:54 <pokoli> funnybunny: not from tryton client, but yes from the database client | ||
| 2014-10-15 15:54 <pokoli> funnybunny: I only want to make sure you know this is not recomended and you can loose your data if you erase the wrong table | ||
| 2014-10-15 15:55 <funnybunny> i am certain it is not recommended to hack about in the db | ||
| 2014-10-15 15:55 <funnybunny> but if it's that or start the db with 2 useless lines.. i rather.. :) | ||
| 2014-10-15 15:56 <pokoli> funnybunny: do whatever you want with your data :) | ||
| 2014-10-15 15:58 <funnybunny> okay, so deinstalling and reinstalling the invoice module didn't touch the data :o | ||
| 2014-10-15 15:59 <pokoli> funnybunny: which database are you using? | ||
| 2014-10-15 15:59 <funnybunny> should be postgres | ||
| 2014-10-15 15:59 <pokoli> funnybunny: so connect to the database and truncate account_invoice and account_move tables | ||
| 2014-10-15 16:00 <funnybunny> ^^ | ||
| 2014-10-15 16:00 <pokoli> funnybunny: that should do the trick for you | ||
| 2014-10-15 16:02 -!- leio(~leio@gentoo/developer/leio) has joined #tryton | ||
| 2014-10-15 16:12 <newzen> cedk: i have build rpm's for install trytond and tryton client. I would like to share. How? | ||
| 2014-10-15 16:13 <cedk> newzen: which distribution because we already have fedora | ||
| 2014-10-15 16:14 <funnybunny> alright | ||
| 2014-10-15 16:14 <newzen> cedk: Fedora are very old. v 2.6.1. Im build for CentOS7 | ||
| 2014-10-15 16:14 <funnybunny> i truncated account_move and account_move_line and set the invoice back to draft | ||
| 2014-10-15 16:15 <funnybunny> that seems to have worked.. i see no more bookings and the invoice is editable again | ||
| 2014-10-15 16:15 <cedk> newzen: so proposed it to CentOS | ||
| 2014-10-15 16:15 <pokoli> funnybunny: nice :) | ||
| 2014-10-15 16:15 <newzen> i builded for tryton 3.2.3 server and 3.2.4 for client | ||
| 2014-10-15 16:15 <cedk> funnybunny: what about sequence? | ||
| 2014-10-15 16:15 <funnybunny> now... how do i verify that the amount, based on the entered currency exchange rate, will be the right one? | ||
| 2014-10-15 16:16 <pokoli> funnybunny: just add a exchange rate for the currency on the invoice date | ||
| 2014-10-15 16:16 <cedk> funnybunny: it will be the right one because we have tests | ||
| 2014-10-15 16:16 <funnybunny> cedk: sequence? | ||
| 2014-10-15 16:16 <cedk> funnybunny: the sequence records which define how invoice/move are numbered | ||
| 2014-10-15 16:16 <funnybunny> so if my company's main currency is euro.. and 1 euro is .75 dollars.. | ||
| 2014-10-15 16:17 <funnybunny> i just enter an exchange rate of .75 for dollar, right? | ||
| 2014-10-15 16:17 <funnybunny> cedk: those should be based on the invoice table, no? | ||
| 2014-10-15 16:17 <cedk> funnybunny: I'm not talking about the id but the number | ||
| 2014-10-15 16:19 <funnybunny> the number_next_internal field is 1 for ir_sequence | ||
| 2014-10-15 16:19 <funnybunny> but yeah, i'll check if the invoice has the corrent sequence number.. thanks^^ | ||
| 2014-10-15 16:21 <pokoli> funnybunny: so in currency, search USD dollars and enter the exchange rate | ||
| 2014-10-15 16:21 <funnybunny> yeah.. i did that.. | ||
| 2014-10-15 16:21 <funnybunny> i did it wrong :D | ||
| 2014-10-15 16:22 <funnybunny> .75 wasn't right.. guess it was expecting 1/.75 | ||
| 2014-10-15 16:22 <funnybunny> grr | ||
| 2014-10-15 16:23 <cedk> funnybunny: it is relative: 1 € == rate $ | ||
| 2014-10-15 16:24 <cedk> funnybunny: maybe improving the doc will be good | ||
| 2014-10-15 16:24 <pokoli> funnybunny: cedk: and adding a help message on the field also will be good | ||
| 2014-10-15 16:27 <funnybunny> cedk: agreed.. now i got rounding problems, lol | ||
| 2014-10-15 16:28 <funnybunny> is there a way to have the exchange rate be automatically infered by "what was to pay" -> "what has been received"? | ||
| 2014-10-15 16:28 <funnybunny> because now i got 30 euro more than i actually got.. | ||
| 2014-10-15 16:28 <funnybunny> or should i just add that as a negative line and call it "exchange expenses"? | ||
| 2014-10-15 16:29 <cedk> funnybunny: yes you can put the write-off in a lost account | ||
| 2014-10-15 16:32 <funnybunny> the exchange rate field kind of needs more decimal places :( | ||
| 2014-10-15 16:32 <funnybunny> now my calculation is off by 8 cent.. which is ... just wrong | ||
| 2014-10-15 16:43 <cedk> funnybunny: don't understand | ||
| 2014-10-15 16:53 -!- digitalsatori(~Thunderbi@114.92.210.36) has joined #tryton | ||
| 2014-10-15 16:56 <funnybunny> cedk: i am missing 3 decimal places for my exchange rate, so the balance is off by 8 cents (rounding error).. i fixed that by just making it disappear in a journal of itself | ||
| 2014-10-15 16:56 <funnybunny> but one more thing.. is there a clean way to include my account data in the invoices? | ||
| 2014-10-15 17:00 <cedk> funnybunny: what is you rate? | ||
| 2014-10-15 17:01 <cedk> funnybunny: and the currencies? | ||
| 2014-10-15 17:02 -!- notzippy(~sabayonus@d207-216-251-90.bchsia.telus.net) has joined #tryton | ||
| 2014-10-15 17:09 <funnybunny> eurusd was .7525 | ||
| 2014-10-15 17:09 <funnybunny> but since i received usd i needed to do 1/.7525 which has some more decimal places | ||
| 2014-10-15 17:13 -!- yangoon(~mathiasb@p549F1252.dip0.t-ipconnect.de) has joined #tryton | ||
| 2014-10-15 17:13 <cedk> funnybunny: don't understand | ||
| 2014-10-15 17:14 <cedk> funnybunny: such rate can be exactly entered | ||
| 2014-10-15 17:14 <cedk> because there are 6 decimal number | ||
| 2014-10-15 18:30 -!- prksh(~prksh@180.188.248.137) has joined #tryton | ||
| 2014-10-15 18:33 -!- kstenger(~karla@200.124.209.158) has joined #tryton | ||
| 2014-10-15 18:34 -!- Telesight(~anthony@77-175-158-148.FTTH.ispfabriek.nl) has joined #tryton | ||
| 2014-10-15 18:34 <funnybunny> sure, but 1/.7525 is 1.328903654 :) | ||
| 2014-10-15 19:17 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton | ||
| 2014-10-15 20:11 -!- swayf(~swayf@ipbcc17c06.dynamic.kabel-deutschland.de) has joined #tryton | ||
| 2014-10-15 20:12 -!- swayf(~swayf@ipbcc17c06.dynamic.kabel-deutschland.de) has joined #tryton | ||
| 2014-10-15 20:15 -!- swayf_(~swayf@ipbcc17c06.dynamic.kabel-deutschland.de) has joined #tryton | ||
| 2014-10-15 20:32 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton | ||
| 2014-10-15 20:54 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton | ||
| 2014-10-15 20:58 -!- irclog(~irclog@moretus.b2ck.com) has joined #tryton | ||
| 2014-10-15 21:06 -!- TheCowboy(~TheCowboy@ip68-98-183-236.dc.dc.cox.net) has joined #tryton | ||
| 2014-10-15 21:09 <newzen> cedk: the sao code with bootstrap have something to test? | ||
| 2014-10-15 21:09 -!- vernichon(~Thunderbi@gex01-1-78-234-55-95.fbx.proxad.net) has joined #tryton | ||
| 2014-10-15 21:09 -!- uranus(~uranus@ip72-192-129-223.sd.sd.cox.net) has joined #tryton | ||
| 2014-10-15 21:20 -!- nicoe(~nicoe@2a02:a03f:3097:9e00:ee55:f9ff:fe7b:f7ac) has joined #tryton | ||
| 2014-10-15 21:22 <cedk> newzen: not really | ||
| 2014-10-15 21:23 <cedk> last time I tried: https://jquery-ui-bootstrap.github.io/jquery-ui-bootstrap/ | ||
| 2014-10-15 21:23 <cedk> it was not good enough | ||
| 2014-10-15 22:09 -!- Telesight(~anthony@77-175-158-148.FTTH.ispfabriek.nl) has joined #tryton | ||
| 2014-10-15 22:16 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!