When the VAT listing was discussed for inclusion on Tryton, the Spanish chart of account was not part of the supported modules so it VAT listing was not included. As we now have it available it will be great to include it’s VAT listing.
On Spain we have to include the following reports:
Modelo 347: Which includes the list of National parties and it’s amount operation which operations are above the limit of 3005.06€. It’s required to include the list of both purchases and sales operations and they are differentiated by a code: A for purchases and B for Sales. This should be reported once per fiscalyear.
Modelo 349: Which includes the list of intracomunitary operations. This is very similar to the EC Sales List which currently exist in Tryton, but we include purchases also. There is also a operation code which is used to differentiate if there is a services or goods related operation.
Proposal
account_es:
Add EC Operation List model, which includes sale list code and purchase invoices.
Add EC purchase list codes for purchase taxes.
Add a new view for national taxes operation. This should be a table query very similar to the one of the account_be module but including more details:
Operation Code: Purchase/Sale identifier
Party Information including: Tax Identifier, Name and Province Code.
Sum of invoices total amount broken down by quarter
I do not think EC Sales List should be changed, this is the official report for all EU. Indeed this is the Spanish requirements that extend it. So I think account_es should create a new listing but probably doing an union with ECSalesList query.
I did not see that in the description of the report.
I do not think it is a good idea to hard code such value. There is the same kind of value for Belgium and we did not put it because it is subject to change. So it will be more annoying to the user if he can not customize it himself.
This is yearly report that must be presented each January no mather how the fiscalyear of the company is defined. So the periods are based on the month:
So this is not similar to account_be report because this report is based on fiscal year.
But I still have some doubts because the form use 1T, 2T, 3T and 4T instead of dates. Such format is usually used when the period are not static.
What are we talking about here is about the requirement to report the National parties operation (Modelo 347) broken by Quarter, which is independent on how the company has created his fiscalyear:
This implies that we should add a new field to indicate the purchase code list as we can not reuse the ec_sales_list_code. Should this field specific to Spain?
Indeed in Spanish the Party name is required, do you think it’s good to add this field to the account_eu sales list (which will allow to extend it) or generate a new (similar) query which adds the new field?
For me, localization should never modify standard behavior globally. It can only for the case of the company being in the country. The activation of the module should not modify the standard behavior.
You can when you have the reference to the table (so you can select the columsn of the same table) but it gets harder when you only have the q variable, as my code looks like:
I see your point and agree to it. I think I did not explain myself properly.
My idea is to add the party field on the account_eu module so it’s also shown when the account_es module is not activated. Is there any reason to not include it?