Spainaeatmodelo303/Functional Documentation
Document sign-off
Role | Name | Sign-off date |
PM | Richard Morley | |
QA | Pablo Sarobe | |
Development | Victor Martinez | |
Development | David Alsasua |
Document Status
Date | Author or editor | Description of change | Document status | Document version |
June 11th, 2010th | Patricia San Juan | Document creation | Draft | V1 |
June 12th, 2010th | Patricia San Juan | Document sent for review | Final | V1 |
Overview & Justification
Purpose
The purpose of this document is to describe the functional specifications for a new commercial module which is the “303 VAT Settlement” as a valid file.
303 VAT Settlement is aimed to allow the end-user to calculate the amount to pay or collect from the Public Treasury as the difference between the VAT -fiscal Debit (In Spanish = "IVA repercutido") and the VAT-fiscal Credit (In Spanish = "IVA soportado").
303 VAT Settlement must be sent to the Tax Authorities either monthly or quarterly within the 20 days of the next Month/Quarter, respectively.
This report must be mandatory sent through the INTERNET – on line submission of a valid 303 file in case of monthly submission, otherwise (quarterly submission) end-user can choose between on-line submission or paper submission.
On line submission implies that the Spanish companies must have a Tax ID as well as a user Certificate X.509.V3 issued by FNMT or any other valid Certificate according to tax authorities requirements.
This new feature is going to be developed and delivered as a new commercial module which will be part of the Professional Edition of the Spanish Pack which will be implemented according to the Technical Documentation which can be found here : Spain AEAT Modelo 303 Technical Documentation
Scope
In Scope:
303 VAT Settlement submission as a valid txt file which can be submitted through below AEAT (Spanish Public Treasury) link:
This functionality takes into account as Deductible VAT, the VAT included in any "Account Payable" related transaction such as a purchase invoice or a payment to a vendor, which is 100% deductible.
New in the Scope!!
Due to the fact that there are new VAT Tax Rates valid From July 1st 2010 in Spain, a new version of the module needs to be develop. "Normal" VAT Tax rate valid starting from July 1st, 2010 is 18% (instead of 16%) "Reduced" VAT Tax rate valid starting from July 1st, 2010 is 8% (instead of 7%)
This new version of the module "303 VAT declaration" will allow the end-user to get a valid file according to the Spanish Tax authorities requirements detailed below:
"303 VAT declaration, for tax periods beginning July 2010 could have taxable transactions under the new tax rates (18%, 8%) together with others under the old tax rates (16%, 7%). In such cases:
- Box 01 - File position 72 to 88- will get the the sum of the 18% and 16% related tax base amounts
- by example 1.000,00 + 2.000,00 = 3.000,00
- Box 03 - File position 94 to 110 - will get the sum of the 18% and 16% related tax amounts
- by example (18% * 1.000,00) + (16% * 2.000,00) = 180,00 + 320,00 = 500,00
- Box 02 - File position 89 to 93 - will get a tax rate (integer part + 2 decimals), calculated as sum of the 18% and 16% related the tax amounts / sum of the 18% and 16% related tax base amounts
- by example (500,00 / 3.000,00) * 100 = 16,66
- Box 04 - File position 111 to 127 - will get the the sum of the 8% and 7% related tax base amounts
- by example 4.000,00 + 5.000,00 = 9.000,00
- Box 06 - File position 133 to 149 - will get the sum of the 8% and 7% related tax amounts
- by example (8% * 4.000,00) + (7% * 5.000,00) = 320,00 + 350,00 = 670,00
- Box 05 - File position 128 to 132 - will get a tax rate (integer part + 2 decimals), calculated as sum of the 8% and 7% related tax amounts / sum of the 8% and 7% related tax base amounts
- by example (670,00 /9.000,00) * 100 = 7,44
Rest of File positions should remain the same.
Justification
303 VAT settlement is a legal requirement in Spain under "Orden EHA/3786/2008, dated on December 29th (BOE December 30th, 2008); which describes 303 VAT Settlement logical and physical design as well as the way and time for its submission to the Spanish tax authorities.
As said above 303 VAT Settlement main purpose is to calculate either the VAT to pay or the VAT to collect to/from the Spanish Tax Authorities as the difference between:
- "VAT Payable" = "IVA repercutido" (In Spanish), this VAT is the one included in any Account Receivable related transaction such as a "Sales invoices" or a "Collection/Receipt" from a customer.
- and "VAT Deductible" = "IVA soportado/deducible" (In Spanish), this VAT is the one included in any Account Payable related transaction such as a "Purchase Invoice" or a "Payment" to a vendor.
Above calculation must be mandatory done on a regular basis, either monthly or quarterly by all the VAT-payers.
New definitions and acronyms
VAT => Value-added tax
VAT Payable => Value-added tax included in any "Account Receivable" related transactions such a "sales invoice or a collection from a customer", in Spanish (IVA Devengado)
VAT Deductible => Value-added tax included in any "Account Payable" related transactions such a "purchase invoice or a payment to a vendor" which is 100% deductible, in Spanish (IVA Deducible) .
AEAT=> Acronyms for the Spanish Public Treasury = “Agencia Estatal de Administración Tributaria”
Tax Base Amount => it is the same as "Taxable Amount", which means the net amount VAT is calculated for, in Spanish "Base Imponible".
Tax Amount => VAT amount, in Spanish "Cuota"
Tax Rate => VAT %, in Spanish "Tipo %"
Total Amount => this one is the gross amount including VAT.
Users & business process description
User goals
303 VAT Settlement will allow the end user to:
- Get the VAT rates to be included in the 303 VAT Settlement properly Setup by getting them linked to the corresponding 303 output parameters.
- Generate 303 VAT Settlement for a given period, either a month or a quarter as a valid file according to Spanish Tax Authotities requirements.
- Review the 303 file generated by here "Formulario del modelo 303 para su presentación(predeclaración)"
- Submit 303 file to the tax authorities via INTERNET (on-line submission), in the following link: 303 Online Submission
User Roles and Personas
The following roles are involved:
Accounting Manager (Mary):
Mary is the accounting manager. She is the accountant responsible therefore she needs to make sure that the Company complies with the Law and the Tax requirements.
She should be able to review 303 tax report setup provided by OB and adjust it if required based on her company specific needs.
She should also be able to launch 303 tax report whenever needed in order to submit it to the tax authorities as a valid file.
Sales staff (Mike): Mike is an employee part of the sales staff. He will be the one issuing sales invoices including VAT in the system, which therefore must be part of the 303 VAT Settlement.
Purchase staff (Alice): Alice is an employee part of the purchase staff. She will be the one entering purchase invoices including VAT in the system, which therefore must be part of the 303 VAT Settlement.
Business scenario/s
Small Bazaar is an enterprise located in Spain made of several subsidiaries. Small Bazaar Holding is the parent company while, Small Bazaar Pamp and Small Bazaar Barc are two subsidiaries. Each subsidiary is modeled in OB ERP as a legal entity organization.
Sales transactions (June):
- On June 7th Mike issues a sales invoice to customer A (a National Small Bazaar Pamp customer).
Sales invoice amount is 11,600.00€ and it does include a VAT Payable = 1.600,00 €
VAT Rate = Entregas IVA 16%
Taxable Amount = 10.000,00€
Purchase transactions (June):
- On June 8th Alice enters in the system a purchase invoice from vendor Z (a National Small Bazaar Pamp vendor).
Purchase amount is 2,900.00€ and it does include a VAT Deductible = 400,00 €
VAT Rate = Adquisiciones IVA 16%>
Taxable Amount= 2.500,00€
Dated on July 20th, Mary generate 303 VAT Settlement for June 2010 and she gets that Small Bazaar company needs to pay to the Tax authorities 1.200,00€ because
VAT Payable = 1.600,00€ > VAT Deductible = 400,00.
Sales transactions (July):
- On July 7th Mike issues a sales invoice to customer B (a National Small Bazaar Pamp customer).
Sales invoice amount is 11.800.00€ and it does include a VAT Payable = 1.800,00€
New VAT Rate valid starting July 1st, 2010 = Entregas IVA 18%
Taxable Amount = 10.000,00€
- On July 30th Mike issues a sales invoice to customer UE (an Intracommunity Small Bazaar Pamp customer).
Sales invoice amount is 7.500,00€ and it does include a VAT Payable = 0€
VAT Rate = Entregas intracouminitarias (N%=>0%)
Taxable Amount = 7.500,00€
Purchase transactions (July):
- On July 8th Alice enters in the system a purchase invoice from vendor USA (an International Small Bazaar Pamp vendor).
Purchase amount is 8.398,40€ and it does include a VAT Deductible = 1.158,40 €
VAT Rate = Importaciones 16%>
Taxable Amount= 7.240,00€
- On July 30th Alice enters in the system a purchase invoice from vendor UE (an Intracomunity Small Bazaar Pamp vendor).
Purchase amount is 3.000,00€ and it does include a VAT Payable/Deductible = +/- 240,00€
VAT Rate = Adquisiciones Intracomunitarias 8%>
Taxable Amount= 3.000,00€
Other transactions (July):
- On July 30th Peter enters in the system a payment of 1.180,00€ do not related to an invoice which includes a VAT amount = 180,00€, this last one linked to a VAT Rate = "Arrendamiento 18% (pagos)"
Dated on August 20th, Mary generate 303 VAT Settlement for July 2010 and she gets that Small Bazaar company will collect from the Tax authorities 18,40 € because
VAT Payable = 1.800,00€ + 0,00 - 240,00€ = 1.560,00€ < VAT Deductible = 1.158,40 + 240,00€ + 180,00€ = 1.578,40
Functional requirements
Functional Requirement 1 - Accounting Date
Transaction/Documents Accounting date is the date to take into account while retrieving tax transactions.
Companies must take into account:
- Devengo del IVA (in Spanish) => which means Companies must take into account when the "VAT is chargeable" and therefore must be submitted to the Tax Authorities - the VAT Payable and the VAT Deductible must be submitted to the Tax Authorities in the period when the Goods/Services have either been delivered (Sales-VAT Payable) or received (Purchase-VAT Deductible); let's say June.
- Obligaciones de Facturación (In Spanish) => Besides the above, companies must invoice within the next 30 days after the delivery/receipt of the Goods/Services, but within the same settelment period, which in our case is June, therefore invoices must be issued July 16th the latest, as June VAT Settlement must be submitted to the tax authorities dated on July 20th; the latest.
In order:
- not to loose these invoices dated from 1st July to 20th July in our example,
- which could either belong to June VAT Settlement in case the operation date was June or belong to July VAT Settelemnt in case operation date was July
- and which could also do not have either a good receipt/shipment for us to easly know the operation date
- and because of the fact that Purchase invoices can have an invoice date dated on February, 2010; while are entered in the system later on, let's say June; so we could miss the period when the VAT Deductible was supposed to be submitted.
Base on all of the above, the accounting date of the invoices/transactions is the date to be taken into account because:
- Sales invoices must be issued in the same period that the operation took place and at the same time/period must be posted, most cases
- Purchase invoices can be recognized in the system when are posted, most cases.
VAT Settlements Periods, in case of monthly declaration, will go from the 1st day of the month to the last day of the month, which means:
- June period to be submitted to the tax authorities July 20th the latest, will take into account Invoices/Transactions having as "From Date" = or > June 1st and as "Date To" = or < June 30th.
- Those transactions with Invoice date "From Date" = or > July 1st and as "Date To" = or < July 20th, wll be taken into account in July VAT Settlement period, regardless could be related to June transactions.
Functional Requirement 2 - AEAT303 File Structure
303 File structure can be found in the following link:
303 File Structure - 1353 Positions
New!!
- Box 01 - File position 72 to 88- will get the the sum of the 18% and 16% related tax base amounts
- Box 02 - File position 89 to 93 - will get a tax rate (integer part + 2 decimals), calculated as sum of the 18% and 16% related the tax amounts / sum of the 18% and 16% related tax base amounts
- Box 03 - File position 94 to 110 - will get the sum of the 18% and 16% related tax amounts
- Box 04 - File position 111 to 127 - will get the the sum of the 8% and 7% related tax base amounts
- Box 05 - File position 128 to 132 - will get a tax rate (integer part + 2 decimals), calculated as sum of the 8% and 7% related tax amounts / sum of the 8% and 7% related tax base amounts
- Box 06 - File position 133 to 149 - will get the sum of the 8% and 7% related tax amounts
Functional Requirement 3- AEAT303 Constant Parameters
Based on above 303 VAT Settlement file structure there are several constant parameters which should always be enter by having same value/constant as listed below:
Position From | Lenght | Description (in spanish) | Constant |
1 | 2 | Inicio del identificador de modelo y página | "<T" |
3 | 3 | Modelo | "303" |
6 | 2 | Página | "01" |
8 | 1 | Fin de identificador de modelo | ">" |
70 | 2 | Devengo (2) - Periodo | "01", "02", "03",...,"12", "1T", "2T", "3T" or "4T" |
1343 | 9 | Identificador de Fin de Registro | "</T30301>" |
Above constant parameters should be setup by default in the Application path: Financial Management || Accounting || Setup || Tax Report || Tax Report - for a new record named "AEAT303_M" (Description = Modelo 303 Mensual) and "AEAT303_Q" (Decription = Modelo 303 Trimestral); and a Tax Report Group named "Constans".
Functional Requirement 4 - AEAT303 Input Parameters
Based on above 303 VAT Settlement file structure there are several inut parameters which should always be enter by the end-user while launching the 303 VAT Settlement:
Position From | Lenght | 303 VAT Settlement box | Description (in spanish) | Input data |
10 | 1 | n/a | Tipo Declaración | end user should select one of below values (in Spanish): "C" = "Compensación" in case [48]<0 |
65 | 1 | n/a | Inscrito en el Registro de Devolución Mensual (*) this one could also be setup as a "Constant" | "1"= "Si" or "2" = "No" |
391 | 17 | [24] | Liquidación (3) IVA deducible - operaciones interiores corrientes bienes de inversión | Numeric |
408 | 17 | [25] | Liquidación (3) IVA deducible - operaciones interiores corrientes bienes de inversión | Numeric |
459 | 17 | [28] | Liquidación (3) IVA deducible - importaciones de bienes de inversión | Numeric |
476 | 17 | [29] | Liquidación (3) IVA deducible - importaciones de bienes de inversión | Numeric |
527 | 17 | [32] | Liquidación (3) IVA deducible - adquisiciones intracomunitarias de bienes de inversión | Numeric |
544 | 17 | [33] | Liquidación (3) IVA deducible - adquisiciones intracomunitarias de bienes de inversión | Numeric |
561 | 17 | [34] | Liquidación (3) - Compensación Régimen Especial A.G y P [34] | Numeric. End user must enter here "ompensación Régimen Especial A.G y P" amount |
578 | 17 | [35] | Liquidación (3) - IVA Deducible - Regularización Inversiones [35] | Numeric. End user must enter here "Regularización de las deducciones por Bienes de Inversión" amount |
595 | 17 | [36] | Liquidación (3) - IVA Deducible - Regularización por aplicación del porcentaje def.de prorrata [36] | Numeric. End user must enter here "Regularización de las deducciones por Bienes de Inversion" amount based on the final %. |
646 | 5 | [39] | Liquidación (3) - Atribuible a la Administración del Estado % [39] (*) this one could also be setup as a "Constant" | Numeric Those VAT Payers of both Public Treasury="Administración del Estado" and "Diputaciones Forales del Pais Vasco o Navarra" must enter here the |
668 | 17 | [41] | Liquidación (3) - Cuotas a compensar de periodos anteriores [41] | Numeric. End user must enter here positive Tax Amounts to compensate coming from previous periods. |
736 | 17 | [45] | Liquidación (3) - Exclusivamente tributación conjunta [45] Resultado de la regularización anual | Numeric. End user must fill in here (for 4T or month 12) the anual regular amount. |
770 | 17 | [47] | Liquidación (3) - A deducir (D.Complementaria) [47] | Numeric. End user must fill in here the positive VAT settlement amount already submitted for the same period, just in case Complementary Declaration. |
821 | 1 | n/a | Marca sin actividad which means that there have not been any VAT Payable and VAT deductible for a given period. | "0" = "No", "1"= "Si" |
839 | 4 | n/a | Devolucion (6) - Código Cuenta Cliente - Entidad (*) this one could also be setup as a "Constant" | An - Bank Account - Bank |
843 | 4 | n/a | Devolucion (6) - Código Cuenta Cliente - Oficina (*) this one could also be setup as a "Constant" | An - Bank Account - Office |
847 | 2 | n/a | Devolucion (6) - Código Cuenta Cliente - DC (*) this one could also be setup as a "Constant" | An. Bank Account - Control Digit |
849 | 10 | n/a | Devolucion (6) - Código Cuenta Cliente - Número de cuenta (*) this one could also be setup as a "Constant" | An. Bank Account - Account number |
859 | 1 | n/a | Ingreso (7) - Forma de Pago
(*) this one could also be setup as a "Constant" | "0" = No consta "1" = Efectivo "2" = Adeudo en cuenta "3"= "Domiciliación" |
877 | 4 | n/a | Ingreso (7)- Código Cuenta Cliente - Entidad (*) this one could also be setup as a "Constant" | An. Bank Account - Bank |
881 | 4 | n/a | Ingreso (7) - Código Cuenta Cliente - Oficina (*) this one could also be setup as a "Constant" | An. Bank Account - Office |
885 | 2 | n/a | Ingreso (7) - Código Cuenta Cliente - DC (*) this one could also be setup as a "Constant" | An. Bank Account - Digit Control |
887 | 10 | n/a | Ingreso (7) - Código Cuenta Cliente - Número de cuenta (*) this one could also be setup as a "Constant" | An. Bank Account - Account number |
897 | 1 | n/a | Complementaria (8) Indicador de Autoliquidación Complementaria | "0" = "No" , "1" = Si |
898 | 13 | n/a | Complementaria (8) Nº justificante de la declaración anterior mismo periodo | Numeric |
Above input parameters should be entered by the end-user in the Application path: Financial Management || Accounting || Analysis Tools || Tax Report Launcher - "Input Parameters" process button, once AEAT303 data such as:
- Organization
- Tax Report = AEAT303_M or AEAT303_Q
- Accounting Schema
- Calendar (not editable)
- Year
- Period
have been entered by the end-user
Functional Requirement 5 - AEAT303 Ouput Parameters
Position From | Lenght | 303 VAT Settlement box | Description (in spanish) | OB Data |
11 | 9 | n/a | Identificación (1) - NIF | Organization Tax ID |
20 | 30 | n/a | Identificación (1) - Apellidos o Razón Social | Organization Name |
66 | 4 | n/a | Devengo (2) - Ejercicio | Year selected by the end-user while launching 303 tax report |
70 | 2 | n/a | Devengo (2) - Periodo | Month or Quarter selected by the end-user while launchig 303 tax report |
IVA Devengado
Position From | Lenght | 303 VAT Settlement box | Description (in spanish) | OB Data |
72 | 17 | [01] | Liquidación (3) IVA Devengado - Régimen general - Base Imponible [01] | The sum-up of all the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below: Arrendamiento 16% (cobros) |
89 | 5 | [02] | Liquidación (3) IVA Devengado - Régimen general - Tipo % [02] | A Tax Rate (integer + 2 decimals) calculated as the division between The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed below in [03] / |
94 | 17 | [03] | Liquidación (3) IVA Devengado - Régimen general - Cuota [03] | The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [01] |
111 | 17 | [04] | Liquidación (3) IVA Devengado - Régimen general - Base Imponible [04] | The sum-up of all the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below: Entregas IVA 10% |
128 | 5 | [05] | Liquidación (3) IVA Devengado - Régimen general - Tipo % [05] | A Tax Rate (integer + 2 decimals) calculated as the division between The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed below in [06] / |
133 | 17 | [06] | Liquidación (3) IVA Devengado - Régimen general - Cuota [06] | The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [04] |
150 | 17 | [07] | Liquidación (3) IVA Devengado - Régimen general - Base Imponible [07] | The sum-up of the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below: Entregas IVA 4% |
167 | 5 | [08] | Liquidación (3) IVA Devengado - Régimen general - Tipo % [08] | 04,00 |
172 | 17 | [09] | Liquidación (3) IVA Devengado - Régimen general - Cuota [09] | the sum-up of the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [07] |
189 | 17 | [10] | Liquidación (3) IVA Devengado - Recargo de Equivalencia - Base Imponible [10] | The sum-up of the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below: Entregas IVA+RE 16+4% (+4%) |
206 | 5 | [11] | Liquidación (3) IVA Devengado - Recargo de Equivalencia - Tipo % [11] | A Tax Rate (integer + 2 decimals) calculated as the division between The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed below in [12] / |
211 | 17 | [12] | Liquidación (3) IVA Devengado - Recargo de Equivalencia - Cuota [12] | The sum-up of the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [10] |
228 | 17 | [13] | Liquidación (3) IVA Devengado - Recargo de Equivalencia - Base Imponible [13] | The sum-up of the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below : Entregas IVA+Recargo 7+1% (+1%) |
245 | 5 | [14] | Liquidación (3) IVA Devengado - Recargo de Equivalencia - Tipo % [14] = 01,00 | A Tax Rate (integer + 2 decimals) calculated as the division between The sum-up of all the Tax Amounts linked to any of the VAT Payable Tax Rates listed below in [15] / |
250 | 17 | [15] | Liquidación (3) IVA Devengado - Recargo de Equivalencia - Cuota [15] | The sum-up of the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [13] |
267 | 17 | [16] | Liquidación (3) IVA Devengado - Recargo de Equivalencia - Base Imponible [16] | The sum-up of the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below: Entregas IVA+Recargo 4+0,5% (+0,5%) |
284 | 5 | [17] | Liquidación (3) IVA Devengado - Recargo de Equivalencia - Tipo % [17] = 00,50 | 0,5% |
289 | 17 | [18] | Liquidación (3) IVA Devengado - Recargo de Equivalencia - Cuota [18] | The sum-up od the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [16] |
306 | 17 | [19] | Liquidación (3) IVA Devengado - Adquisiciones Intracomunitarias - Base Imponible [19] | The sum-up of the Tax Base Amounts linked to any of the VAT Payable Tax Rates listed below: Adquisiciones intracomunitarias 16% (-16%) |
323 | 5 | [20] | Liquidación (3) IVA Devengado - Adquisiciones Intracomunitarias - Cuota [20] | The sum-up of the Tax Amounts linked to any of the VAT Payable Tax Rates listed above in [19] |
340 | 17 | [21] | Liquidación (3) IVA Devengado - Total cuota devengada [21] | Total Tax Amount for VAT Payable = [03]+[06]+[09]+[12]+[15]+[18]+[20] |
IVA Deducible
Position From | Lenght | 303 VAT Settlement box | Description (in spanish) | OB Data |
357 | 17 | [22] | Liquidación (3) IVA deducible - operaciones interiores corrientes[22] | The sum-up of the Tax Base Amounts linked to any of the VAT Deductible Tax Rates listed below: Adquisiciones B. Inmuebles 18% |
374 | 17 | [23] | Liquidación (3) IVA deducible - operaciones interiores corrientes[23] | The sum-up of the Tax Amounts linked to any of the VAT Deductible Tax Rates listed above in [22] |
425 | 17 | [26] | Liquidación (3) IVA deducible - importaciones de bienes corrientes[26] | The sum-up of the Tax Base Amounts linked to any of the VAT Deductible Tax Rates listed below: Adquisiciones a Canarias,Ceuta y Melilla 16% |
442 | 17 | [27] | Liquidación (3) IVA deducible - importaciones de bienes corrientes[27] | The sum-up of the Tax Amounts linked to any of the VAT Deductible Tax Rates listed above in [26] |
493 | 17 | [30] | Liquidación (3) IVA deducible - adquisiciones intracomunitarias de bienes corrientes[30] | the sum-up of the Tax Base Amounts linked to any of the VAT/Tax Rates below: Adquisiciones intracomunitarias 16% (+16%) |
510 | 17 | [31] | Liquidación (3) IVA deducible - adquisiciones intracomunitarias de bienes corrientes[31] | The sum-up of the Tax Amounts linked to the any of the VAT Deductible Tax Rates above in [30] |
612 | 17 | [37] | Liquidación (3) IVA deducible - total a deducir [37] | Tota Tax Amount for VAT Deductible = [23]+[25]+[27]+[29]+[31]+[33]+[34]+[35]+[36] |
Otros
Position From | Lenght | 303 VAT Settlement box | Description (in spanish) | OB Data |
629 | 17 | [38] | Liquidación (3) Diferencia [38] | Total VAT Payable - Tota VAT Deductible = [21]-[37] |
651 | 17 | [40] | Liquidación (3) - Atribuible a la Administración del Estado [40] | This one will be same as [38] in case [39] box is = 100,00%, otherwise [40]= [38] x [39] |
685 | 17 | [42] | Liquidación (3) Entregas Intracomunitarias [42] | The sum-up of the Tax Base Amounts linked to any of the VAT Payable listed below: Entregas intracomunitarias (%N=>0%) |
702 | 17 | [43] | Liquidación (3) Exportaciones y Operaciones asimiladas [43] | The sum-up of the Tax Base Amounts linked to any of the VAT Payable listed below: Entregas a Canarias,Ceuta y Melilla (%N=>0%) |
719 | 17 | [44] | Liquidación (3) Operaciones no sujetas o con Inversión de sujeto pasivo [44] | The sum-up of the Tax Base Amounts linked to any of the VAT Payable listed below: Servicios a Canarias, Ceuta y Melilla (%N=>0%) |
753 | 17 | [46] | Liquidación (3) Resultado [46] | Result = [40]-[41]+[45] |
787 | 17 | [48] | Liquidación (3) Resultado de la liquidación[48] | VAT Settlement Result = [46]-[47] |
804 | 17 | [49] | Compensación (4)-Importe a compesar | [48], in case [48] is <0 - Declaration Type = "C" |
822 | 17 | [50] | Devolución (6) - Importe a devolver | [48], in case [48] is <0 - Declaration Type = "D" because "Inscrito en el Registro de Devolución mensual = "1" = Yes |
860 | 17 | Ingreso (7) - Importe a ingresar | [48], in case [48] is >0 - Declaration Type = "I" because "Inscrito en el Registro de Devolución mensual = "1" = Yes |
Functional Requirement 6 - Transactions or Document types to take into account
303 VAT Settlement must take into account below transactions/document types for each type of VAT:
VAT Payable - Account Receivable related transactions:
- Sales invoices (>0) -> Application path = Sales Management || Transactions || Sales Invoice - Document type = AR Invoice(>0).
- For for this type 303 VAT Settlement must get:
- Tax Base Amount (>0)
- Tax Amount (>0)
- Total Amount (>0)
- For for this type 303 VAT Settlement must get:
- Sales invoices (<0) -> Application path = Sales Management || Transactions || Sales Invoice - Document type = AR Invoice(<0).
- For for this type 303 VAT Settlement must get:
- Taxable Amount (<0)
- Tax Amount (<0)
- Total Amount (<0)
- For for this type 303 VAT Settlement must get:
- Sales credit memos (>0) -> Application path = Sales Management || Transactions || Sales Invoice - Document type = AR Credit Memo(>0).
- For for this type 303 VAT Settlement must get:
- Tax Base Amount (<0)
- Tax Amount (<0)
- Total Amount (<0)
- it is important to highlight that AR Invoice (<0) & AR Credit Memo (>0) should behave exactly same way.
- For for this type 303 VAT Settlement must get:
Sales Invoices above described applies to both type of Invoices detailed below:
- Product/Services related Sales Invoices
- Financial Sales Invoices by using a GL item setup as "Enable in Financial Invoices".
VAT Deductible - Account Payable related transactions:
- Purchase invoices -> Application path = Purchase Management || Transactions || Purchase Invoice - Document type = AP Invoice(>0).
- For for this type 303 VAT Settlement must get:
- Taxable Amount (>0)
- Tax Amount (>0)
- Total Amount (>0)
- For for this type 303 VAT Settlement must get:
- Purchase invoices (<0) -> Application path = Purchase Management || Transactions || Purchase Invoice - Document type = AP Invoice(<0).
- For for this type 303 VAT Settlement must get:
- Tax Base Amount (<0)
- Tax Amount (<0)
- Total Amount (<0)
- For for this type 303 VAT Settlement must get:
- Purchase credit memos (>0) -> Application path = Purchase Management || Transactions || Sales Invoice - Document type = AP Credit Memo(>0).
- For for this type 303 VAT Settlement must get:
- Tax Base Amount (<0)
- Tax Amount (<0)
- Total Amount (<0)
- it is important to highlight that AP Invoice (<0) & AP Credit Memo (>0) should behave exactly same way.
- For for this type 303 VAT Settlement must get:
Purchase Invoices above described applies to both type of Invoices detailed below:
- Product/Services related Purchase Invoices
- Financial Purchase Invoices by using a GL item setup as "Enable in Financial Invoices".
Functional Requirement 7 - 303 VAT Settlement setup & 303 tax parameters
In order to check 303 VAT Settlment and 303 parameters setup he should navigate to Financial Management / Accounting / Setup / Tax Report and check that there is a Tax Report with a Search key => AEAT303_M or AEAT303_Q with below setup:
- Tax Report (Header):
- Client=> OB Client for which 303 is setup.
- Organization => OB organization or legal entity for which 303 is setup.
- Name=> 303 VAT Settlment name (AEAT303_M : Liquidación de IVA Mensual and AEAT303_Q : Liquidación de IVA Trimestral)
- Description=> 303 VAT Settlment description (AEAT303_M : Liquidación de IVA Mensual and AEAT303_Q : Liquidación de IVA Trimestral)
- Period=> it should be Monthly or Quarterly
- Java Class name=> Java class for this declaration should be here
- Active=> YES
- Tax Report Group. There should as many Tax Report groups as needed babed on the parameters type (constant, input and output) defined in Functional Requirements sectios above.
Persona based scenarios = Sales/Purchase Invoices
Sales Invoices
New!!! National Sales Invoice (Goods and Services) - different VAT rates
Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.
Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.
In case of a National Sales Invoice, below data must be entered:
- Transaction Document type = AR Invoice
- Invoice date = 01-07-2010
- Accounting date = 02-07-2010
- Business Partner = "National Customer A" (located in Spain)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Entregas IVA 18%" (system will show up this Tax type based on setup)
- but as this transaction took place dated on 28th June (operation date) the end-user manually select "Entregas IVA 16%" as applicable tax rate.
- Tax Base Amount = 1.000,00
- Tax Amount = 160,00
- Tax Rate = 16,00
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:
1.160,00 Customer (Debit)
1.000,00 Income (Credit)
160,00 VAT Payable (Credit)
Besides, Mike enters in the system a new sales invoice, as explained below:
- Transaction Document type = AR Invoice
- Invoice date = 01-07-2010
- Accounting date = 02-07-2010
- Business Partner = "National Customer B" (located in Spain)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product B" (which belongs to Tax Category "IVA Reducido")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Entregas IVA 8%" (system will show up this Tax type based on setup)
- but as this transaction took place dated on 28th June (operation date) the end-user manually select "Entregas IVA 7%" as applicable tax rate.
- Tax Base Amount = 1.000,00
- Tax Amount = 70,00
- Tax Rate = 07,00
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:
1.070,00 Customer (Debit)
1.000,00 Income (Credit)
70,00 VAT Payable (Credit)
After that, Mike enters in the system a new sales invoice, as explained below:
- Transaction Document type = AR Invoice
- Invoice date = 17-07-2010
- Accounting date = 20-07-2010
- Business Partner = "National Customer A" (located in Spain)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Entregas IVA 18%" (system will show up this Tax type based on setup)
- Tax Base Amount = 1.000,00
- Tax Amount = 180,00
- Tax Rate = 18,00
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:
1.180,00 Customer (Debit)
1.000,00 Income (Credit)
180,00 VAT Payable (Credit)
And finally, Mike enters in the system a new sales invoice, as explained below:
- Transaction Document type = AR Invoice
- Invoice date = 18-07-2010
- Accounting date = 25-07-2010
- Business Partner = "National Customer B" (located in Spain)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product B" (which belongs to Tax Category "IVA Reducido")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Entregas IVA 8%" (system will show up this Tax type based on setup)
- Tax Base Amount = 1.000,00
- Tax Amount = 80,00
- Tax Rate = 08,00
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:
1.080,00 Customer (Debit)
1.000,00 Income (Credit)
80,00 VAT Payable (Credit)
Above VAT Payable must be captured in the VAT Settlement for July period - VAT Payable section as shown below:
- Tax Base Amount = 1.000,00 + 1.000,00 = 2.000,00 [01]
- Tax Rate % = (490,00 / 2.000,00)*100 = 17,00[02]
- Tax Amount = 160,00 + 180,00 = 340,00 [03]
- Tax Base Amount = 1.000,00 + 1.000,00 = 2.000,00 [04]
- Tax Rate % = (150,00 / 2.000,00)*100 = 07,50 [05]
- Tax Amount = 70,00 + 80,00 = 150,00 [06]
New!!! National Sales Invoice (Goods and Services) - different VAT rates Invoice and Void Invoice
Same as explained in the scenario below would happen in case Mike needs to : - issue a sales invoice dated on July 25th at a 18% VAT Rate, tax base amount 1.000,00 and tax amount 180,00 - and void a June sales invoice dated on July 27th at a 16% VAT Rate, tax base amount 500,00 and tax amount 80,00
In this scenario the result must look like:
- Tax Base Amount = 1.000,00 - 500,00 = 500,00 [01]
- Tax Rate % = (100,00 / 500,00)*100 = 20,00[02]
- Tax Amount = 180,00 - 80,00 = 100,00 [03]
National Sales Invoice (Goods and Services) - 2 VAT rates in the same invoice
Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.
Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.
In case of a National Sales Invoice, below data must be entered:
- Transaction Document type = AR Invoice
- Invoice date = 17-06-2010
- Accounting date = 20-06-2010
- Business Partner = "National Customer A" (located in Spain)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Entregas IVA 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = 1.000,00
- Tax Amount = 160,00
- Line 20
- Product = "Product B"(which belongs to Tax Category "IVA Reducido")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Entregas IVA 7%" (system will show up this Tax type base on setup).
- Tax Base Amount = 1.000,00
- Tax Amount = 70,00
- Line 30
- Product = "Service A" (which belongs to Tax Category "IVA Normal Servicios")
- Invoice quantity = "1"
- Net Unit Price = "1.800,00"
- Tax = "Servicios prestados nacional 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = 1.800,00
- Tax Amount = 288,00
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:
4.318,00 Customer (Debit)
3.800,00 Income (Credit)
518,00 VAT Payable (Credit)
Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:
- Tax Base Amount = 2.800,00 [01]
- Tax Rate % = 16,00 [02]
- Tax Amount = 448,00 [03]
- Tax Base Amount = 1.000,00 [04]
- Tax Rate % = 7,00 [05]
- Tax Amount = 70,00 [06]
National Sales Invoice (Goods) - under "Recargo Equivalencia" Regimen
Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.
Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.
In case of a National Sales Invoice to a customer under "Recargo de Equivalencia", below data must be entered:
- Transaction Document type = AR Invoice
- Invoice date = 18-06-2010
- Accounting date = 20-06-2010
- Business Partner = "National Customer M" (located in Spain)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Entregas IVA 16 % + 4 %" (system will show up this Tax type based on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "160,00" + "40,00"
- Line 20
- Product = "Product B"(which belongs to Tax Category "IVA Reducido")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Entregas IVA 7% + 1%" (system will show up this Tax type base on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "70,00"+ "10,00"
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:
2.280,00 Customer (Debit)
2.000,00 Income (Credit)
280,00 VAT Payable (Credit)
Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:
- Tax Base Amount = 1.000,00 [01]
- Tax Rate % = 16,00 [02]
- Tax Amount = 160,00 [03]
- Tax Base Amount = 1.000,00 [04]
- Tax Rate % = 7,00 [05]
- Tax Amount = 70,00 [06]
- Tax Base Amount = 1.000,00 [10]
- Tax Rate % = 4,00 [11]
- Tax Amount = 40,00 [12]
- Tax Base Amount = 1.000,00 [13]
- Tax Rate % = 1,00 [14]
- Tax Amount = 10,00 [15]
National Sales Invoice (Goods or Servies) - (negative Sales Invoice)
(same should apply in case Mike uses either a negative AR Invoice or a positive AR Credit Memo)
Mike must issued the negative Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.
Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.
In case of a National negative Sales Invoice, below data must be entered:
- Transaction Document type = AR Invoice
- Invoice date = 25-06-2010
- Accounting date = 25-06-2010
- Business Partner = "National Customer A" (located in Spain)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "-10"
- Net Unit Price = "100,00"
- Tax = "Entregas IVA 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "-1.000,00"
- Tax Amount = "-160.00"
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:
1.160,00 Customer (Credit)
1.000,00 Income (Debit)
160,00 VAT Payable (Debit)
Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:
- Tax Base Amount = -1.000,00 [01]
- Tax Rate % = 16,00 [02]
- Tax Amount = -160,00 [03]
In case there is no other positive Invoice for that period, otherwise it would look like:
- Tax Base Amount = 5.000,00 - 1.000,00 = 4.000,00[01]
- Tax Rate % = 16,00 [02]
- Tax Amount = 800,00 -160,00 = 640,00 [03]
Same applies in the case of Services in relation to 303 data to be retrieved, in that case the VAT rates will the ones linked to the Tax Categories "IVA Normal Servicios", "IVA Reducido Servicios" or "IVA Super Reducido Servicios" at the same % rates as VAT Categories for Goods "IVA Normal", "IVA Reducido" and "IVA Super Reducido".
National Sales Invoice (Goods or Services) - Reversed Invoice of a previous period
Dated on July 25th, Mike needs to issue a corrective invoice because part of the goods send and invoiced to Customer A have been returned.
For doing the above Mike must navigate to : Sales Management || Transactions || Sales Invoice || Header and enter a new sales invoice by entering below data:
- Transaction Document type = AR Invoice
- Invoice date = 25-07-2010
- Accounting date = 27-07-2010
- Business Partner = "National Customer A" (located in Spain)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "-5"
- Net Unit Price = "100,00"
- Tax = "Entregas IVA 16%" (the system will not show up this Tax type because dated on = or > July 1st, 2010; system will show up "Entregas IVA 18%" unless the original invoice is fully voided, therefore Mike must select the Tax Rate used in the original invoice being corrected).
- Tax Base Amount = "-500,00"
- Tax Amount = "-80,00"
Under the tab "Reversed Invoices", Mike will be able to select the original invoice being reversed.
Once the negative sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:
580,00 Customer (Credit)
500,00 Income (Debit)
80,00 VAT Payable (Debit)
Above VAT Payable must be captured in the VAT Settlement for July period - VAT Payable section but having a 16% VAT instead of 18%:
- Tax Base Amount = -500,00 [01]
- Tax Rate % = 16,00 [02]
- Tax Amount = -80,00 [03]
In case there is no other positive Invoice for that period at 16% and another one at 18%, otherwise it would look like:
- Tax Base Amount = 5.000,00 - 500,00 = 4.500,00[01]
- Tax Rate % = 16,00 [02]
- Tax Amount = 800,00 -80,00 = 720,00 [03]
- Tax Base Amount = 1.000,00 [04]
- Tax Rate % = 18,00 [05]
- Tax Amount = 180,00 [06]
Same applies in the case of Services in relation to 303 data to be retrieved, in that case the VAT rates will the ones linked to the Tax Categories "IVA Normal Servicios", "IVA Reducido Servicios" or "IVA Super Reducido Servicios" at the same % rates as VAT Categories for Goods "IVA Normal", "IVA Reducido" and "IVA Super Reducido".
EU Sales Invoices (Goods)
Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.
Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.
In case of an EU Sales Invoice, below data must be entered:
- Transaction Document type = AR Invoice
- Invoice date = 17-06-2010
- Accounting date = 20-06-2010
- Business Partner = "EU Customer A" (located in France)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Entregas intracomunitarias (%N=>0%)" (system will show up this Tax type based on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "0,00"
- Line 20
- Product = "Product B"(which belongs to Tax Category "IVA Reducido")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Entregas intracomunitarias (%R=>0%)" (system will show up this Tax type base on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "0,00"
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below, there will not be any VAT posting:
2.000,00 Income (Credit)
2.000,00 Customer (Debit)
Above VAT Payable must be captured in the VAT Settlement for June period - Settlement Section:
- Tax Base Amount = 2.000,00 [42]
EU Sales Invoices (Goods) negative
(same should apply in case Mike uses either a negative AR Invoice or a positive AR Credit Memo)
Mike must issued the negative Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.
Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.
In case of a National negative Sales Invoice, below data must be entered:
- Transaction Document type = AR Invoice
- Invoice date = 25-06-2010
- Accounting date = 25-06-2010
- Business Partner = "EU Customer C" (located in Belgium)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "-10"
- Net Unit Price = "100,00"
- Tax = "Entregas intracomunitarias (%N=>0%)" (system will show up this Tax type based on setup).
- Tax Base Amount = "-1.000,00"
- Tax Amount = "0.00"
Under the tab "Reversed Invoices", Mike will be able to select the original invoice being reversed.
Once the negative sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:
1.000,00 Customer (Credit)
1.000,00 Income (Debit)
Above VAT Payable must be captured in the VAT Settlement for June period - VAT Settelement section:
- Tax Base Amount = -1.000,00 [42]
In case there is no other positive Invoice for that period, otherwise it would look like:
- Tax Base Amount = 5.000,00 - 1.000,00 = 4.000,00 [42]
Same applies in the case of Services in relation to 303 data to be retrieved, in that case the VAT rates will the ones linked to the Tax Categories "IVA Normal Servicios", "IVA Reducido Servicios" or "IVA Super Reducido Servicios" at the same % rates as VAT Categories for Goods "IVA Normal", "IVA Reducido" and "IVA Super Reducido".
EU Sales Invoices (Services)
Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.
Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.
In case of an EU Sales Invoice, below data must be entered:
- Transaction Document type = AR Invoice
- Invoice date = 17-06-2010
- Accounting date = 20-06-2010
- Business Partner = "EU Customer A" (located in France)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Service A" (which belongs to Tax Category "IVA Normal Servicios")
- Invoiced quantity = "1"
- Net Unit Price = "3.750,00"
- Tax = "Servicios prestados UE (%N=>0%)" (system will show up this Tax type based on setup).
- Tax Base Amount = "3.750,00"
- Tax Amunt = "0,00"
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below, there will not be any VAT posting:
3.750,00 Income (Credit)
3.750,00 Customer (Debit)
Above VAT Payable must be captured in the VAT Settlement for June period - Settlement Section:
- Tax Base Amount = 3.750,00 [44]
EU Sales Invoices (Services) Negative
(same should apply in case Mike uses either a negative AR Invoice or a positive AR Credit Memo)
Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.
Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.
In case of an EU Sales Invoice, below data must be entered:
- Transaction Document type = AR Invoice
- Invoice date = 17-06-2010
- Accounting date = 20-06-2010
- Business Partner = "EU Customer A" (located in France)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Service A" (which belongs to Tax Category "IVA Normal Servicios")
- Invoiced quantity = "-1"
- Net Unit Price = "3.750,00"
- Tax = "Servicios prestados UE (%N=>0%)" (system will show up this Tax type based on setup).
- Tax Base Amount = "-3.750,00"
- Tax Amunt = "0,00"
Under the tab "Reversed Invoices", Mike will be able to select the original invoice being reversed.
Once the negative sales invoice is processed and posted, the corresponding accounting entries are posted as shown below:
3.750,00 Income (Debit)
3.750,00 Customer (Credit)
Above VAT Payable must be captured in the VAT Settlement for June period - Settlement Section:
- Tax Base Amount = -3.750,00 [44]
In case there is no other positive Invoice for that period, otherwise it would look like:
- Tax Base Amount = 5.000,00 - 3.750,00 = 1250,00 [44]
Exports (Goods)
Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.
Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.
In case of an "Export" Sales Invoice, below data must be entered:
- Transaction Document type = AR Invoice
- Invoice date = 17-06-2010
- Accounting date = 20-06-2010
- Business Partner = "Customer USA" (located in United States)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "100"
- Net Unit Price = "100,00"
- Tax = "Exportaciones (%N=>0%)" (system will show up this Tax type based on setup).
- Tax Base Amount = "10.000,00"
- Tax Amount = "0,00"
- Line 20
- Product = "Product B"(which belongs to Tax Category "IVA Reducido")
- Invoiced quantity = "100"
- Net Unit Price = "100,00"
- Tax = "Exportaciones (%R=>0%)" (system will show up this Tax type base on setup).
- Tax Base Amount = "10.000,00"
- Tax Amount = "0,00"
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below, there will not be any VAT posting:
20.000,00 Income (Credit)
20.000,00 Customer (Debit)
Above VAT Payable must be captured in the VAT Settlement for June period - Settlement Section:
- Tax Base Amount = 20.000,00 [43]
Same applies in case of a negative Sales Invoice for an Export (Goods) of an amount = 5.000,00 by example. The VAT payable must be captured in the VAT Settlement for June period - Settelment Section as shown below:
- Tax Base Amount = 20.000,00 - 5.000,00 = 15.000,00 [43]
Exports (Services)
Mike must issued the Sales Invoices in the application path: Sales Management || Transactions || Sales Invoice || Header.
Mike can enter in the system diferent sales invoices types depending on the BP (Customer) and the Products/Services for which a sales invoice is issued to.
In case of an "Export" Sales Invoice, below data must be entered:
- Transaction Document type = AR Invoice
- Invoice date = 17-06-2010
- Accounting date = 20-06-2010
- Business Partner = "Customer USA" (located in United States)
and then go to "Lines" tab. Once there Mike must enter below data:
- Line 10
- Product = "Service A" (which belongs to Tax Category "IVA Normal Servicios")
- Invoiced quantity = "100"
- Net Unit Price = "100,00"
- Tax = "Servicios prestados internacional (%N=>0%)" (system will show up this Tax type based on setup).
- Tax Base Amount = "10.000,00"
- Tax Amount = "0,00"
- Line 20
- Product = "Service B"(which belongs to Tax Category "IVA Reducido Servicios")
- Invoiced quantity = "100"
- Net Unit Price = "100,00"
- Tax = "Servicios prestados internacional (%R=>0%)" (system will show up this Tax type base on setup).
- Tax Base Amount = "10.000,00"
- Tax Amount = "0,00"
Once the sales invoice is processed and posted, the corresponding accounting entries are posted as shown below, there will not be any VAT posting:
20.000,00 Income (Credit)
20.000,00 Customer (Debit)
Above VAT Payable must be captured in the VAT Settlement for June period - Settlement Section:
- Tax Base Amount = 20.000,00 [44]
Same applies in case of a negative Sales Invoice for an Export (Services) of an amount of -3.500,00. VAT payable must be captured for June period - Settlement Section as shown below:
- Tax Base Amount = 20.000,00 - 3.500,00 [44]
Purchase Invoices
New!!! National Purchase Invoices (Financial Invoices)
Alice must enter the Purchase Invoices in the application path: Produrement Management || Transactions || Purchase Invoice || Header.
Alice can enter in the system diferent purchase invoices types depending on the BP (vendor) and the Products/Services for which a purchase invoice has been sent to Alice's company by a vendor.
In case of a National Purchase Invoice, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 17-06-2010
- Accounting date = 20-06-2010
- Business Partner = "National Vendor A" (located in Spain)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Financial Invoice Line flag = Yes (see screen below)
- Account = "Item A" (GL item named "Item A" previously created at the application path = Financial Management || Accounting || Setup || G/L Item || G/L Item, set up as "Enable in Financial Invoices"=Yes and linked to "Iva Normal" Tax Category, see screen below)
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Adquisiciones IVA 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "160,00"
Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
1.000,00 Expense (Debit)
160,00 VAT deductible (Debit)
1.160,00 Vendor (Credit)
Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:
- Tax Base Amount = 1.000,00 [22]
- Tax Amount = 160,00 [23]
Note = Same applies to Sales Financial Invoices
National Purchase Invoices (Goods and Services)
Alice must enter the Purchase Invoices in the application path: Produrement Management || Transactions || Purchase Invoice || Header.
Alice can enter in the system diferent purchase invoices types depending on the BP (vendor) and the Products/Services for which a purchase invoice has been sent to Alice's company by a vendor.
In case of a National Purchase Invoice, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 17-06-2010
- Accounting date = 20-06-2010
- Business Partner = "National Vendor A" (located in Spain)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Adquisiciones IVA 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "160,00"
- Line 20
- Product = "Product B"(which belongs to Tax Category "IVA Reducido")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Adquisiciones IVA 7%" (system will show up this Tax type base on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "70,00"
- Line 30
- Product = "Service C"(which belongs to Tax Category "IVA Reducido Servicios")
- Invoiced quantity = "8"
- Net Unit Price = "250,00"
- Tax = "Adquisiciones IVA 7%" (system will show up this Tax type base on setup).
- Tax Base Amount = "2.000,00"
- Tax Amount = "140,00"
Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
4.000,00 Expense (Debit)
370,00 VAT deductible (Debit)
4.370,00 Vendor (Credit)
Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:
- Tax Base Amount = 4.000,00 [22]
- Tax Amount = 370,00 [23]
National Purchase Invoices (Goods and Services) - Reversed Invoices
Alice must enter the Purchase Invoices in the application path: Produrement Management || Transactions || Purchase Invoice || Header.
Alice can enter in the system diferent purchase invoices types depending on the BP (vendor) and the Products/Services for which a purchase invoice has been sent to Alice's company by a vendor.
In case of a National Purchase Invoice, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 24-06-2010
- Accounting date = 24-06-2010
- Business Partner = "National Vendor A" (located in Spain)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "-5
- Net Unit Price = "100,00"
- Tax = "Adquisiciones IVA 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "-500,00"
- Tax Amount = "-80,00"
- Line 20
- Product = "Service C"(which belongs to Tax Category "IVA Reducido Servicios")
- Invoiced quantity = "-1"
- Net Unit Price = "250,00"
- Tax = "Adquisiciones IVA 7%" (system will show up this Tax type base on setup).
- Tax Base Amount = "-250,00"
- Tax Amount = "-17,50"
Under the tab "Reversed Invoices", Alice will be able to select the original invoice being reversed.
Once the negative purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
847,50 Vendor (Debit)
750,00 Expense (Credit)
97,50 VAT deductible (Credit)
Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:
- Tax Base Amount = 4.000,00 - 750 = 3.250,00 [22]
- Tax Amount = 370,00 - 97,50 = 272,50 [23]
National Purchase Invoices/Imports/Intracommunity Acquisitions of Capital Goods
In case of Capital Good purchase such as a car, a building or whatever, the VAT Deductible is not be 100% deductable within the same period that good was purchased. That type of VAT can be deducted in a period of time well defined by the Tax Authorities.
Therefore and for a give period (month or quarter) Alice must manually filled in below data as input if any:
National Purchase of Capital Goods:
[24] Por cuotas soportadas en operaciones interiores con bienes de inversión.
Base Imponible
[25] Por cuotas soportadas en operaciones interiores con bienes de inversión.
Cuota.
Imports of Capital Goods:
[28] Por cuotas soportadas en importaciones de bienes de inversión.
Base Imponible
[29] Por cuotas soportadas en importaciones de bienes de inversión.
Cuota.
Intracommunity Acquisitions of Capital Goods:
[32] Por cuotas soportadas en adquisiciones intracomunitarias de bienes de inversión.
Base Imponible
[33] Por cuotas soportadas en adquisiciones intracomunitarias de bienes de inversión.
Cuota.
Imports (Goods)
Alice must enter the Purchase Invoices in the application path: Produrement Management || Transactions || Purchase Invoice || Header.
Alice can enter in the system diferent purchase invoices types depending on the BP (vendor) and the Products/Services for which a purchase invoice has been sent to Alice's company by a vendor.
In case of a Import, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 29-06-2010
- Accounting date = 30-06-2010
- Business Partner = "Vendor USA Z" (located in USA)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "10"
- Net Unit Price = "300,00"
- Tax = "Importaciones 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "3.000,00"
- Tax Amount = "480,00"
- Line 20
- Product = "Product B"(which belongs to Tax Category "IVA Reducido")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Importaciones 7%" (system will show up this Tax type base on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "70,00"
- Line 30
Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
4.000,00 Expense (Debit)
370,00 VAT deductible (Debit)
4.370,00 Vendor (Credit)
Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:
- Tax Base Amount = 4.000,00 [26]
- Tax Amount = 370,00 [27]
Imports (Goods) - Reversed Invoices
Alice must enter the Purchase Invoices in the application path: Produrement Management || Transactions || Purchase Invoice || Header.
Alice can enter in the system diferent purchase invoices types depending on the BP (vendor) and the Products/Services for which a purchase invoice has been sent to Alice's company by a vendor.
In case of a Import, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 29-06-2010
- Accounting date = 30-06-2010
- Business Partner = "Vendor USA Z" (located in USA)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Product A" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "-1"
- Net Unit Price = "300,00"
- Tax = "Importaciones 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "-300,00"
- Tax Amount = "-48,00"
Under the tab "Reversed Invoices", Alice will be able to select the original invoice being reversed.
Once the negative purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
348,00 Vendor (Debit) 300,00 Expense (Credit) 48,00 VAT Deductible (Credit)
Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:
- Tax Base Amount = 4.000,00 - 300,00 = 3.700,00 [26]
- Tax Amount = 370,00 - 48,00 = 322,00 [27]
EU Purchase Invoices (Goods)
Alice must enter in the system the Purchase Invoices in the application path: Procurement Management || Transactions || Purchase Invoice || Header.
Alice can enter in the system diferent purchase invoices types depending on the BP (Vendor) and the Products/Services for which a purchase invoice has been received.
In case of an EU Purchase Invoice, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 17-06-2010
- Accounting date = 20-06-2010
- Business Partner = "EU Vendor A" (located in Italy)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Product X" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Adquisiciones intracomunitarias 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "+/-160,00"
Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
1.000,00 Expense (Debit)
160,00 VAT Deductible (Debit)
160,00 VAT Payable (Credit)
1.000,00 Vendor (Credit)
Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:
- Tax Base Amount = 1.000,00 [19]
- Tax Amount = 160,00 [20]
And Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:
- Tax Base Amount = 1.000,00 [30]
- Tax Amount = 160,00 [31]
EU Purchase Invoices (Goods) - Reversed Invoices
Alice must enter in the system the Purchase Invoices in the application path: Procurement Management || Transactions || Purchase Invoice || Header.
Alice can enter in the system diferent purchase invoices types depending on the BP (Vendor) and the Products/Services for which a purchase invoice has been received.
In case of an EU Purchase Invoice, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 25-06-2010
- Accounting date = 25-06-2010
- Business Partner = "EU Vendor A" (located in Italy)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Product X" (which belongs to Tax Category "IVA Normal")
- Invoiced quantity = "-1"
- Net Unit Price = "100,00"
- Tax = "Adquisiciones intracomunitarias 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "-100,00"
- Tax Amount = "+/-16,00"
Under the tab "Reversed Invoices", Alice will be able to select the original invoice being reversed.
Once the negative purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
100,00 Expense (Credit)
16,00 VAT Deductible (Credit)
16,00 VAT Payable (Debit)
100,00 Vendor (Debit)
Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:
- Tax Base Amount = 1.000,00 - 100,00 = 900,00 [19]
- Tax Amount = 160,00 - 16,00 = 144,00 [20]
And Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:
- Tax Base Amount = 1.000,00 - 100,00 = 900,00 [30]
- Tax Amount = 160,00 - 16,00 = 144,00 [31]
EU Purchase Invoices / Imports (Services)
Alice must enter in the system the Purchase Invoices in the application path: Procurement Management || Transactions || Purchase Invoice || Header.
Alice can enter in the system diferent purchase invoices types depending on the BP (Vendor) and the Products/Services for which a purchase invoice has been received.
In case of an EU Purchase Invoice of Services, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 01-06-2010
- Accounting date = 05-06-2010
- Business Partner = "EU Vendor P" (located in France)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service C" (which belongs to Tax Category "IVA Normal Servicios")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Inversión Sujeto Pasivo 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "+/-160,00"
- Line 20
- Product = "Service D" (which belongs to Tax Category "IVA Reducido Servicios")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Inversión Sujeto Pasivo 7%" (system will show up this Tax type based on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "+/-70,00"
Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
2.000,00 Expense (Debit)
230,00 VAT Deductible (Debit)
230,00 VAT Payable (Credit)
2.000,00 Vendor (Credit)
In case of an Import of Services, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 11-06-2010
- Accounting date = 11-06-2010
- Business Partner = "Vendor USA RR" (located in USA)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service E" (which belongs to Tax Category "IVA Normal Servicios")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Inversión Sujeto Pasivo 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "+/-160,00"
- Line 20
- Product = "Service F" (which belongs to Tax Category "IVA Reducido Servicios")
- Invoiced quantity = "10"
- Net Unit Price = "100,00"
- Tax = "Inversión Sujeto Pasivo 7%" (system will show up this Tax type based on setup).
- Tax Base Amount = "1.000,00"
- Tax Amount = "+/-70,00"
Once the purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
2.000,00 Expense (Debit)
230,00 VAT Deductible (Debit)
230,00 VAT Payable (Credit)
2.000,00 Vendor (Credit)
Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:
- Tax Base Amount = 2.000,00 [01]
- Tax Rate = 16.00 [02]
- Tax Amount = 320,00 [03]
- Tax Base Amount = 2.000,00 [04]
- Tax Rate = 7.00 [05]
- Tax Amount = 140,00 [06]
And Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:
- Tax Base Amount = 4.000,00 [22]
- Tax Amount = 460,00 [23]
EU Purchase Invoices / Imports (Services) - Reversed Invoices
Alice must enter in the system the Purchase Invoices in the application path: Procurement Management || Transactions || Purchase Invoice || Header.
Alice can enter in the system diferent purchase invoices types depending on the BP (Vendor) and the Products/Services for which a purchase invoice has been received.
In case of an EU Purchase Invoice of Services, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 20-06-2010
- Accounting date = 22-06-2010
- Business Partner = "EU Vendor P" (located in France)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service C" (which belongs to Tax Category "IVA Normal Servicios")
- Invoiced quantity = "-1"
- Net Unit Price = "100,00"
- Tax = "Inversión Sujeto Pasivo 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "-100,00"
- Tax Amount = "+/-16,00"
- Line 20
- Product = "Service D" (which belongs to Tax Category "IVA Reducido Servicios")
- Invoiced quantity = "-1"
- Net Unit Price = "100,00"
- Tax = "Inversión Sujeto Pasivo 7%" (system will show up this Tax type based on setup).
- Tax Base Amount = "-1000,00"
- Tax Amount = "+/-7,00"
Under the tab "Reversed Invoices", Alice will be able to select the original invoice being reversed.
Once the negative purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
200,00 Vendor (Debit)
23,00 VAT Payable (Debit)
200,00 Expense (Credit)
23,00 VAT Deductible (Credit)
In case of an Import of Services, below data must be entered:
- Transaction Document type = AP Invoice
- Invoice date = 20-06-2010
- Accounting date = 22-06-2010
- Business Partner = "Vendor USA RR" (located in USA)
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service E" (which belongs to Tax Category "IVA Normal Servicios")
- Invoiced quantity = "-1"
- Net Unit Price = "100,00"
- Tax = "Inversión Sujeto Pasivo 16%" (system will show up this Tax type based on setup).
- Tax Base Amount = "-100,00"
- Tax Amount = "+/-16,00"
- Line 20
- Product = "Service F" (which belongs to Tax Category "IVA Reducido Servicios")
- Invoiced quantity = "-1"
- Net Unit Price = "100,00"
- Tax = "Inversión Sujeto Pasivo 7%" (system will show up this Tax type based on setup).
- Tax Base Amount = "-100,00"
- Tax Amount = "+/-7,00"
Under the tab "Reversed Invoices", Alice will be able to select the original invoice being reversed.
Once the negative purchase invoice is processed and posted, the corresponding accounting entries are posted as shown below:
200,00 Vendor (Debit)
23,00 VAT Payable (Debit)
200,00 Expense (Credit)
23,00 VAT Deductible (Credit)
Above VAT Payable must be captured in the VAT Settlement for June period - VAT Payable section:
- Tax Base Amount = 2.000,00 - 200,00 = 1.800,00 [01]
- Tax Rate = 16.00 [02]
- Tax Amount = 320,00 - 32,00 = 288,00 [03]
- Tax Base Amount = 2.000,00 - 200,00 = 1.800,00 [04]
- Tax Rate = 7.00 [05]
- Tax Amount = 140,00 - 14,00 = 126,00 [06]
And Above VAT Deductible must be captured in the VAT Settlement for June period - VAT Deductible section:
- Tax Base Amount = 4.000,00 - 400,00 = 3.600,00 [22]
- Tax Amount = 460,00 - 46,00 = 414,00 [23]
“303 VAT Settlement” generation
Mary can launch the 303 VAT Settlement in the application path: Financial Management / Accounting / Analysis Tools / Tax Report Launcher and once there enter below information:
- Organization
- Report
- Accounting schema
- Calendar (not editable)
- Year - to be selected by the end-user
- Period
- in case of monthly declaration, reference list containing each month of the year
- in case of quarterly declaration, reference list containing each quarter of the year
After the above, the end-user should press "Input Parameters" and a new window showing "input parameters" will pop-up.
Once the end-user has entered the required of needed input parameters, he/she should press the button "Generate Electronic File" and the file will be generated.
“303 VAT Settlement” validation
Once the 303 file is generated from OB, it can be pre-verified and submit here:
- pre-verified option "Formulario de modelo 303 para su presentación (predeclaración)
- submit option "Presentación del Modelo"
Assumptions & Dependencies
Assumptions
N/A
Dependencies
N/A
Design & Technical considerations
Design considerations
303 VAT Settlement must be implemented as a commercial module which will be later on part of the Spanish Professional Localization Pack.
Technical constraints
None
Technical Requirements
303 file generation must be based on an existing feature named “Tax Report Launcher” so there is no need for new fields/tables/parameters creation.
User interface
New User Interface
N/A
User interface changes
License
License code description
The Spanish Professional Pack is released under the "Openbravo Commercial License" (OBCL) as opposite as the Openbravo Public License (OPL) for open source modules
The OBCL needs to be accompanied by a "term sheet" that describes the specific licensing terms per module.
It is likely that a number of enhancements to modularity will be needed in order to store the term sheet as attributes of the module and to display them when the user acknowledges the license.
Product Strategy is responsible for publishing the license on the Openbravo web site. Developers are responsible for putting a reference to that license in the file header and to declare it in the module definition.
Functionality enabled by the license code
The functionality enable by the license code will be “303 VAT Declaration as a valid file”