Tryton - Issues

 

Issue8701

Title Allow to export book of issued and received Invoices
Priority feature Status chatting
Superseder Nosy List ced, pokoli, reviewbot
Type feature request Components account_es
Assigned To pokoli Keywords review
Reviews 250051002
View: 250051002

Created on 2019-10-02.15:44:41 by pokoli, last changed by pokoli.

Messages
msg53809 (view) Author: [hidden] (pokoli) (Tryton committer) (Tryton translator) Date: 2019-12-03.18:27:07
I had one extra doubt with I resolved with our accountant. This was when the invoice has VAT but is in a different curreny. The accountant told me that in case of diferent currencies in the VAT book we should use the amount in the copmany currency (EURO).
msg53757 (view) Author: [hidden] (pokoli) (Tryton committer) (Tryton translator) Date: 2019-11-30.18:07:33
Indeed the norma has been updated and there are some changes starting on January 1st 2020. Here is the normative (only in spanish sorry):

https://www.agenciatributaria.es/static_files/AEAT/Contenidos_Comunes/La_Agencia_Tributaria/Informacion_institucional/Campanias/IVA/Informacion_tecnica/Formato_Electronico_Libros_Registro_IVA.pdf

Indeed with the new legislation on the supplier invoices the supplier number (reference) should be used. 

I'm wondering if we should allow to make this field required for all supplier invoices probably using the same desing as we did on issue8445, so we can activate this feature on the spanish companies.
msg52259 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2019-10-02.22:40:12
When I look at this module [1], it seems that it is more than a simple CSV export:

* only the VAT part should be shown not other taxes
* A summary of taxes
* the invoice and refund seems to be separated


Another point not from the module is that I find it strange to not use the reference for supplier invoice instead of the internal number.


So for me, it looks like account.be.vat_customer but with full details.I would see a dedicated query model with contextual filter fiscal year and/or period. With finally a CSV export.

[1] https://github.com/OCA/l10n-spain/tree/11.0/l10n_es_vat_book
msg52258 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2019-10-02.22:04:39
Sorry but I do not understand what is this export. It is not clear at all how it works. When is it generated? Which data should be included? For which purpose?
msg52257 (view) Author: [hidden] (pokoli) (Tryton committer) (Tryton translator) Date: 2019-10-02.20:50:49
> Is not there any constraint on the domain to use? 
Yes, only invoices with number should be used.
> Should not it be all the invoice for a period or a fiscal year?
This are not constraints but normally you generate the report for a fiscalyear, for a period
msg52256 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2019-10-02.18:10:11
Is not there any constraint on the domain to use? Should not it be all the invoice for a period or a fiscal year?
msg52255 (view) Author: [hidden] (pokoli) (Tryton committer) (Tryton translator) Date: 2019-10-02.18:01:39
El 2/10/19 a les 17:59, Cédric Krier ha escrit:
> On 2019-10-02 17:45, Sergi Almacellas Abellana wrote:
>> El 2/10/19 a les 17:05, Cédric Krier ha escrit:
>>> And our CSV format when there are multiple different taxes is supported? I would find this strange because it is very custom.
>> Yes, I've used this format for sending the 2018 books without any issues.
> Did you have different taxes?
>

Yes we have several invoices which had two taxes (IVA and IRPF)
msg52254 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2019-10-02.17:59:05
On 2019-10-02 17:45, Sergi Almacellas Abellana wrote:
> El 2/10/19 a les 17:05, Cédric Krier ha escrit:
> > And our CSV format when there are multiple different taxes is supported? I would find this strange because it is very custom.
> 
> Yes, I've used this format for sending the 2018 books without any issues.

Did you have different taxes?

> BTW I think the format we are using for exporting multiple formats is quite easy to understand.

We inherited from Odoo and it was the first time I ever seen it.
msg52253 (view) Author: [hidden] (pokoli) (Tryton committer) (Tryton translator) Date: 2019-10-02.17:45:59
El 2/10/19 a les 17:05, Cédric Krier ha escrit:
> And our CSV format when there are multiple different taxes is supported? I would find this strange because it is very custom.

Yes, I've used this format for sending the 2018 books without any issues.

BTW I think the format we are using for exporting multiple formats is quite easy to understand.
msg52252 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2019-10-02.17:05:04
And our CSV format when there are multiple different taxes is supported? I would find this strange because it is very custom.
msg52250 (view) Author: [hidden] (pokoli) (Tryton committer) (Tryton translator) Date: 2019-10-02.16:38:29
> If there is no format how do you know which data to put?

Because on the links I posted it details the fields that should be included:ç

"The register book of issued invoices shall include the following information:the number and, if applicable, the series, the date of issue, the date of performance if different from the latter, the first name and surnames, the recipients trade name or complete denomination and Tax Identification Number (NIF), the taxable base of the operations, the tax rate and the tax amount."
msg52249 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2019-10-02.16:31:26
If there is no format how do you know which data to put?
msg52248 (view) Author: [hidden] (pokoli) (Tryton committer) (Tryton translator) Date: 2019-10-02.16:14:06
> I do not see where it defines the CSV format (nor that the CSV format must be used). Also neither that it should be a file for this.

Indeed there is any requirement about the format but they require you to send this information in a readable format so the CSV export is accepted.
msg52247 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2019-10-02.16:09:17
I do not see where it defines the CSV format (nor that the CSV format must be used). Also neither that it should be a file for this.
review250051002 updated at https://codereview.tryton.org/250051002/#ps264331003
msg52244 (view) Author: [hidden] (pokoli) (Tryton committer) (Tryton translator) Date: 2019-10-02.15:44:41
The Spanish tax authority requires to be able to have a book of issued and received invoices: 

https://www.agenciatributaria.es/AEAT.internet/en_gb/Inicio/_Segmentos_/Empresas_y_profesionales/Empresas/IVA/Obligaciones_contables_y_registrales_en_el_IVA/Libro_registro_de_facturas_expedidas_.shtml

https://www.agenciatributaria.es/AEAT.internet/en_gb/Inicio/_Segmentos_/Empresas_y_profesionales/Empresas/IVA/Obligaciones_contables_y_registrales_en_el_IVA/Libro_registro_de_facturas_recibidas_.shtml

Thanks to issue8695 this can easly achieved as a CSV Export.
History
Date User Action Args
2019-12-03 18:27:07pokolisetmessages: + msg53809
2019-11-30 18:07:34pokolisetstatus: testing -> chatting
messages: + msg53757
2019-10-02 22:40:13cedsetmessages: + msg52259
2019-10-02 22:04:40cedsetmessages: + msg52258
2019-10-02 20:50:49pokolisetmessages: + msg52257
2019-10-02 18:10:12cedsetmessages: + msg52256
2019-10-02 18:01:40pokolisetmessages: + msg52255
2019-10-02 17:59:06cedsetmessages: + msg52254
2019-10-02 17:45:59pokolisetmessages: + msg52253
2019-10-02 17:05:04cedsetmessages: + msg52252

Showing 10 items. Show all history (warning: this could be VERY long)