| chat.freenode.net #tryton log beginning Wed 22 Jul 2020 12:00:01 AM CEST | ||
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 23:32 | |
| -!- thaneor(~ldlc6@r179-24-165-142.dialup.adsl.anteldata.net.uy) has joined #tryton | 01:44 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 04:58 | |
| -!- Timitos(~kpreisler@2001:a61:5ad:c901:762b:62ff:fe84:ed7e) has joined #tryton | 06:04 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 06:38 | |
| -!- rpit(~rpit@p5b22b999.dip0.t-ipconnect.de) has joined #tryton | 06:45 | |
| -!- mariomop(~quassel@190.193.24.15) has joined #tryton | 10:49 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 11:20 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 12:03 | |
| -!- SimAlbertiBeltra(sim6matrix@gateway/shell/matrix.org/x-znpyytwgeboytctd) has joined #tryton | 12:49 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 12:51 | |
| -!- lenucksi[m](lenucksieu@gateway/shell/matrix.org/x-zgnhjzmxuqdhcntz) has joined #tryton | 13:16 | |
| -!- nicoe(~nicoe@2a02:578:852a:c00:7e2a:31ff:fe5e:b25d) has joined #tryton | 13:35 | |
| -!- thaneor(~ldlc6@179.26.225.35) has joined #tryton | 13:46 | |
| -!- jcm(~jcm@78.194.214.1) has joined #tryton | 14:09 | |
| jcm | Hi, to correct my 5.0.20 install following Issue 8138, I manually updated account_tax_code_line set operator='+' | 14:15 |
|---|---|---|
| jcm | but I still don't find a vat total for 20% consistent with the VAT base | 14:15 |
| jcm | what else could I investigate ? | 14:15 |
| pokoli | did you check all the tax lines? | 14:20 |
| jcm | pokoli: I have hundreds... How should I chek ? Seems every invoice is correctly using taxes. | 14:36 |
| jcm | the strange thing is that for 5,5% and 10% taxes the base and taxes are consistent (very small error due to rounding) | 14:38 |
| cedk | jcm: hundreds of lines can already create large difference of 1-10 | 14:52 |
| jcm | I have a 248 € diff, it's 7% of the total amount of 20% rate VAT | 14:57 |
| cedk | I guess some tax lines are missing or wrongly set | 15:04 |
| jcm | I exported my base lines and computed the total vat with a spreadsheet. The total shown on Tax Codes tree view is erroneous. | 15:07 |
| jcm | I'm quite ignorant on the rules to sum up VAT. But is it normal that vat on sale and vat on intra EU purchases are added ? shoudn't the signs be opposite ? | 15:08 |
| cedk | usually they are not in the same code | 15:11 |
| semarie | jcm: the plan of tax is used for VAT declaration. and in such declaration, the amount of line 08 is "20%: Ventes Biens et Services FR, Achats Services Intracomm, Achats Biens Intracomm" | 15:11 |
| semarie | fr is so fun :) | 15:12 |
| jcm | so your partch for #Issue8138 is right (except I think 5,5% rate is missing the correction too) | 15:13 |
| cedk | maybe you do not apply correctly https://hg.tryton.org/modules/account_fr/rev/cc6d81fdf1fa | 15:13 |
| semarie | jcm: if you just need plain data, just export all your tax line and sum them in spreadsheet | 15:13 |
| jcm | cedk: since my install is with pip I didn't dare apply a patch and corrected by sql the account_tax_code_line | 15:13 |
| jcm | semarie: sure that would be the fastest solution. I wanted to undestand wether sthg is wrong in the Tax Codes report. | 15:14 |
| semarie | once applied, you need to update the database (tryton-admin -u account_fr) and next update the chart of accounts (to update tax code with template) | 15:14 |
| jcm | semarie: I dind't change the template table but the tax_code_line, are you sure I need to update ? the vat totals changed as soon as I changed this | 15:15 |
| jcm | more, your patch deals with base values, the total in the spreadsheet is now the same as in Tryton. | 15:17 |
| jcm | I find a diff in VAT value (bigger value in Tryton than expected) | 15:17 |
| semarie | ah, you directly changed value in sql of account_tax_code_line. so it is fine | 15:18 |
| jcm | I don't have the same number of lines tax lines in base and in vat: 63 lines in base and 51 in VAT. Doesn't seem right. | 15:39 |
| jcm | Though when adding the vat lines I find the same total as in Tax Codes report. So the sum that Tryton makes is right. My pb is: why is there this difference, as if base and vat weren't computed one from another. | 15:41 |
| cedk | Maybe some invoices where posted with tax line edited | 15:45 |
| cedk | or moves have been posted manually | 15:45 |
| jcm | how can I retrieve manually edited moves or invoices with vat line edited ? | 16:00 |
| cedk | you can search for move without origin | 16:07 |
| jcm | I find a move in draft state, with a reconciliation with a posted statement line. Is'nt it a source of error ? | 16:12 |
| pokoli | ACTION had been at the phone 1h 30min with a customer disussing a VAT diference case | 16:16 |
| pokoli | jcm: draft moves may produce some diferences, I think they are not excluded on tax code | 16:18 |
| jcm | pokoli: thks. I wonder why these moves are not posted :/ | 16:24 |
| jcm | how do I search for a None origin? "None" is not recognized as a value in filter | 16:24 |
| pokoli | jcm: IRC Origin: != | 16:25 |
| pokoli | jcm: normally I close the periods before submiting the tax reports to the authority | 16:26 |
| pokoli | jcm: So if there is any draft move you will get an Error when closing | 16:26 |
| pokoli | jcm: this has the benefit also that you can not modify the accounting nor the tax reports once they have submited to tax authority | 16:26 |
| jcm | pokoli: my pb is that my accountant wants to work with its own soft and imports from my FEC export. Then corrects some points. Then I will have to report back the corrections and then close and find the same numbers as his. | 16:27 |
| jcm | I found a case where the Invoice linked as origin to the tax line displays a different tax base amount as the tax line. I suppose I should then correct the tax line in accordance. | 16:44 |
| pokoli | jcm: yes, you should correct the tax line | 17:05 |
| -!- noosanon(~user@154.127.251.194) has joined #tryton | 18:22 | |
| -!- noosanon(~user@154.127.251.194) has joined #tryton | 18:37 | |
| -!- noosanon(~user@154.127.251.194) has joined #tryton | 18:48 | |
| -!- noosanon(~user@154.127.251.194) has joined #tryton | 18:53 | |
| -!- noosanon(~user@154.127.251.194) has joined #tryton | 18:57 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 21:47 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!