AEAT190/Functional Documentation
Document sign-off
Role | Name | Sign-off date |
PM | Patricia San Juan | |
QA | Patricia San Juan | |
Development | Víctor Martínez |
Document Status
Date | Author or editor | Description of change | Document status | Document version |
November 30th, 2011 | Víctor Martínez | Document creation | Draft | V1 |
December 15th, 2011 | Patricia San Juan | Document 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 “Withholding Report: Modelo 190 (Spain)” as a valid file.
Modelo 190 report includes withholdings and payments on account of income from employment and economic activities, prizes and certain capital gains and income allocations.
It must be submitted to the Tax Authorities on a yearly basis within the January month. This report includes all the previous year withholding related operations.
The report can be submitted through Internet using a valid format Modelo 190 file.
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 190 Technical Documentation
Scope
In Scope:
Modelo 190 withholding report submission as a valid txt file which can be submitted through below AEAT (Spanish Public Treasury) link:
The Modelo 190 file generated by Openbravo will include:
- monetary withholdings related to professional activities, because that's the information managed within Openbravo.
- monetary withholdings that are associated to withholding tax rates, because that's the type of withholdings officially supported in Openbravo 3.
- monetary withholding tax rates included in posted purchase invoices, because professional activities transactions must be registed in Openbravo through purchase invoices.
Modelo 190 uses the payment information stored into the system, that's why it will be available for the following scenarios:
- Openbravo 2.50 instances with the old financial flows (exclusively)
- Openbravo 2.50 instances with the new financial flows (exclusively)
- Openbravo 2.50 instances migrated from the old financial flows to the APRM
- Openbravo 3 instances with the new financial flows (exclusively)
- Openbravo 3 instances migrated from the old financial flows.
These scenarios require to create two different modules:
- Withholding Report: Modelo 190 (Spain) - NOT APRM compatible v1.0.1, to be installed in Openbravo 2.50 instances working exclusively with the old financial flows.
- Withholding Report: Modelo 190 (Spain), which will be distributed in two different major versions:
- v1.3.1, to be installed in Openbravo 2.50 instances working with the new financial flows (Advanced Payables and Receivables).
- v3.3.1, to be installed in Openbravo 3 instances.
The last two versions will be ready for working with migrated instances.
Modelo 190 module will support 190 supplementary statements. A suplementary statement is an statement which fully voids a statement already submitted which therefore is submitted once more.
Out of Scope:
The Modelo 190 file generated by Openbravo will NOT include:
- in kind withholding tax rates (in Spanish = Retenciones en Especie), as the "Spanish Tax Rates" module does not include those type of withholdings.
- withholdings and/or in kind withholdings do not related to professional activities but to employment incomes, prizes and certain capital gains and income allocations.
- withholdings which in 2.50 version can be entered in the purchase invoices header, because:
- that kind of withholding are not officialy supported in Openbravo 3.0
- and besides, that type of withholdings are not commonly used in Spain.
- professional income withholdings do not register in the system by posting a purchase invoice but by accounting a manual settelment for instance.
Modelo 190 module will NOT support 190 complentary statements. A complementary statement is an statement which must include transactions which were not included in a statement already submitted.
If the user needs to include any of the data described above as at of scope, the way to get it done will imply the manual modification of the Openbravo's generated file inside the [http://www.agenciatributaria.es/AEAT.internet/Inicio_es_ES/_Configuracion_/_Acceda_directamente/_A_un_clic_/Descarga_de_programas_de_ayuda/Declaraciones_Informativas/Declaraciones_Informativas.shtml AEAT Informativas software
Users & business process description
User goals
Modelo 190 will allow the end user to:
- Get the Spanish Withholding tax rates to be taken into account in the 190 file properly Setup by getting them linked to the corresponding 190 output parameters.
- Generate Modelo 190 file for a given year as a valid text file according to the Spanish Tax Authotities requirements.
- Review the 190 file generated importing it into the AEAT Informativas software
- Submit 190 valid file to the tax authorities via INTERNET (on-line submission), in the following link: 190 On-line 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 190 tax report setup provided by OB and adjust it if required based on her company specific needs.
She should also be able to launch 190 tax report and review it whenever needed in order to properly submit it to the tax authorities as a valid file.
Purchase staff (Alice):
Alice is an employee part of the purchase staff.
She will be the one entering purchase invoices including Withholding in the system, which therefore must be part of the Modelo 190.
Business scenario/s
F&B is an enterprise located in Spain made of several subsidiaries. F&B is the parent company while, F&B Spain is located in Spain and F&B US Inc is located in USA. Each subsidiary is modeled in OB ERP as a legal entity organization wth accounting.
Purchase transactions (November):
- On November 18th Alice enters in the system a purchase invoice from vendor Bebidas Alegres (Spanish vendor).
Purchase invoice includes a line net amount of 176.00€ related to "Prestaciones servicios nacional 0% - 15%R" tax rate.
The invoice is immediately paid.
The withholding tax associated is -26.40€ (-15% of 176.00€)
On November 19, Mary launches the 190 report, that includes a line for Bebidas Alegres business partner with a withholding of 26.40€ for the G-01 tributary key.
- On November 20th Alice enters in the system a purchase invoice from vendor Bebidas Alegres (Spanish vendor).
Purchase invoice includes a line net amount of 176.00€ related to "Prestaciones servicios nacional 18% - 15%R" tax rate.
The invoice is not paid.
The withholding tax associated is -26.40€ (-15% of 176.00€)
On November 21, Mary launches the 190 report, that includes a line for Bebidas Alegres business partner with a withholding of 26.40€ for the G-01 tributary key corresponding to the first invoice.
The second one is not included into the report because it hasn't been paid yet.
- On November 22th, our company fully pays the second invoice to Bebidas Alegres vendor.
On November 23, Mary launches the 190 report, that includes a line for Bebidas Alegres business partner with a withholding of 52.80€ for the G-01 tributary key, which corresponds to the sum of both invoices.
Functional requirements
Functional Requirement 1 - AEAT190 File Structure
The module must generated a file with the valid structure for the Modelo 190, that we can be imported into the official AEAT Informativas software,
and later on submit to the Tax Authorities.
The structure can be found at Spain AEAT Modelo 190 File structure (Spanish)
Functional Requirement 2 - Modelo 190 Input Parameters
When launching the report, the following input parameters will be displayed:
- File name.
The user can enter a file name for the generated report
- Is supplementary declaration.
Checkbox that must be selected in case of a 190 supplementary statement.
- Previous declaration no.
Text field for entering the number of the 190 statement already submitted which is being voided and submitted once more.
Functional Requirement 3 - Information to be included in the 190 file
The file generated by Openbravo includes the withholdings related to Spanish professional activities registered and posted in Openbravo as purchase invoices within the previous year of submission year, therefore:
- the 190 file corresponding to the Fiscal Year 2011 will only include the purchase invoices posted in Openbravo within 2011 which besides are fully paid within 2011.
In the case of monetary withholdings paid within the Fiscal Year (2011 for instance) but related to purchase invoices do not posted within that Fiscal Year but previous ones (2010, 2009, 2008...), the 190 file will also include information about the year when the purchase invoice/s got posted.
Monetary withholdings related to professional activies must be linked to the tributary key G, subkeys 01 and 03.
- Subkey 01 linked to Spanish Withholdings at a rate of 15%
- Subkey 03 linked to Spanish Withholdings at a rate of 7%
Functional Requirement 4 - Withholding types to be included
Only withholdings that are associated to a withholding tax rate are supported.
The reason behind is that no other type of withholdings are officially supported in Openbravo 3.
The Modelo 190 module will be backported to Openbravo 2.50 therefore it will behave same way as 3.0 version of the module.
Functional Requirement 5 - Document types to be included
The only "Document Type" to take into account is the "Purchase Invoice" document type, having into account that:
- Purchase invoices > 0 (AP Invoice >0)
- In this case the withholding tax rate and the taxable amount will be both added with a positive sign.
- Purchase invoices < 0 (AP Invoice <0)
- In this case the withholding tax rate and the taxable amount will be both taking into account with a negative sign.
- Purchase credit memo (AP Credit Memo >0), that one has the "Credit memo" flag checked into the document definition.
- In this case the sign of the withholding tax rate and the taxable amount will be the opposite to the sign of the invoice, therefor will behave same as Purchase invoices < 0 (AP Invoice <0)
- Reversal purchase invoices (Reversal Purchase Invoice <0).
- same behaviour as Purchase invoices < 0 (AP Invoice <0)
Functional Requirement 6 - Taxable Amount
We consider the taxable amount ("Base Imponible" in Spanish); which means that Modelo 190 takes into account the "Total Net Amount", total amount not including the VAT amount, because:
- Modelo 190 must not include VAT amounts in case the company must submit VAT Declarations
- as a consequence of 100% VAT deductible, otherwise a non 100% VAT Deductible would imply a higher expense amount and therefore a higher "Total Net Amount".
Functional Requirement 7 - Payments and Partial payments
The 190 file includes posted purchase invoices that have been fully or partially paid within the corresponding Fiscal Year, 2011 for instance.
In case of a partially paid invoice within the Fiscal Year, the file will include just a percentage of the withholding:
- For instance, let's imagine an invoice posted in 2011 including a withholding tax rate amount of 200.00€.
- That invoice has been paid at a 50% within 2011, therefore the withholding tax amount which will be included in the file will be 100.00€.
To manage the information about payments, the report will depend on the Advanced Payables and Receivables module.
An invoice is considered paid or part of an invoice is considered paid, if the associated payment has any of the following status:
- Withdrawn not Cleared
- Payment Cleared
- or Payment Made
In the case of old financial flows, the information to consider is to have any invoice's payment (it can be included to a settlement or not) associated with a processed bank statement line, cash journal line or remittance line. In this case the payment is considered as paid.
And in the case of old financial flows migrated to new flows (APRM), the information to take into account is exactly the same as before, i.e., for the old flows transactions we consider invoice's payments in bank statement, cash journal or remittance lines; and for the new flow transactions, the invoice's payments in status: Withdrawn not Cleared, Payment Cleared and Payment Made.
Functional Requirement 8 - Invoices paid during this year which belong to previous years
The 190 file must also include information about the purchase invoices paid within the Fiscal Year of submission which belongs and therefore were posted in previous years.
For instance, let's imagine we need to get the 190 file of 2011 Fiscal Year.
- 190 file for 2011 must take into account all the purchase invoices containing monetary withholding taxes related to professional invoices posted and paid or partially paid within 2011, and the ones paid or partially paid in 2011 which belongs or were posted in previous years (2010, 2009, 2008, etc.)
Functional Requirement 9 - Automatic configuration
The module provides automatic configuration through a dataset that the user must apply to all the legal entities with accounting.
190 dataset is based on the Spanish Tax Rates dataset, therefore 190 dataset will automatically link the following "Spanish Witholding Tax Rates" to the corresponding 190 tributary key and subkey:
- Tributary key G - subkey 01:
- Prestación servicios nacional 0% -15%R (-15%)
- Prestación servicios nacional 16% -15%R (-15%)
- Prestación servicios nacional 18% -15%R (-15%)
- Tributary key G - subkey 03:
- Prestación servicios nacional 0% -7%R (-7%)
- Prestación servicios nacional 16% -7%R (-7%)
- Prestación servicios nacional 18% -7%R (-7%)
- Tributary Key H - subkey04:
- Prestación servicios nacional 18% -1%R (-1%)
Functional Requirement 10 - 190 file currency
The amounts to include in the Modelo 190 file must be expressed just in EUROS (€).
To ensure this requirement, Modelo 190 file can only be generated for accounting schemas with EUR as base currency.
Functional Requirement 11 - Contact
A contact must be setup and therefore taken by the 190 file. Contact must be setup at Organization level, "Information" tab.
Persona based scenarios
National purchase invoice (Service) not posted
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 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 = 18-11-2011
- Accounting date = 18-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain), which should be linked to any of below listed BP Tax Category:
- Servicios Profesionales Normal
- Servicios Profesionales Reducido
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "100"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 18% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "176"
- Withholding Tax Amount = "-26,40"
- VAT amount = "31,68"
The invoice is not posted and not paid.
The Modelo 190 report does not include this transaction because it is not posted and not paid.
National purchase invoice (Service) posted but not paid
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 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 = 18-11-2011
- Accounting date = 18-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain), which should be linked to any of below listed BP Tax Category:
- Servicios Profesionales Normal
- Servicios Profesionales Reducido
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "100"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 18% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "176"
- Withholding Tax Amount = "-26,40"
- VAT amount = "31,68"
The invoice is posted and not paid.
The Modelo 190 report does not include this transaction because it is not paid.
National purchase invoice (Service) posted and fully paid
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 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 = 18-11-2011
- Accounting date = 18-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain), which should be linked to any of below listed BP Tax Category:
- Servicios Profesionales Normal
- Servicios Profesionales Reducido
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "100"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 18% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "176"
- Withholding Tax Amount = "-26,40"
- VAT amount = "31,68"
The invoice is posted and fully paid in 2011.
A withholding amount of 26,40€ linked to the G-01 tributary key will be included into the 190 report for 2011 year, in the field "Retenciones"
Besides a total net amount of "176,00" will be included in the field "Percepción Integra".
National purchase invoice (Service) posted and partially paid
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 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 = 18-11-2011
- Accounting date = 18-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain)
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "1"
- Net Unit Price = "1000"
- Tax = "Prestación servicios nacional 18% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "1000,00"
- Withholding Tax Amount = "-150,00"
- VAT amount = "180,00"
- Total Net Amount = 1000,00
- Total Gross Amount = 1030,00
The invoice is posted and 50% paid in 2011, that means a paid amount = 515,00
A withholding amount of 75,00€ linked to the G-01 tributary key will be included into the 190 report for 2011 year, in the field "Retenciones".
Besides a total net amount = 500,00 will also be included in the field "Percepciones Integras".
Several national purchase invoice (Service) posted and fully paid for the same business partner and tributary key
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 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 = 18-11-2011
- Accounting date = 18-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain)
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "100"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 0% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "176"
- Withholding Amount = "-26,40"
The invoice is posted and fully paid in 2011.
Another invoice is created:
- Transaction Document type = AP Invoice
- Invoice date = 19-11-2011
- Accounting date = 19-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain)
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "50"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 0% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "88"
- Withholding Amount = "-13,20"
The invoice is posted and fully paid in 2011.
A withholding amount of 39,60€ to Bebidas Alegres linked to the G-01 tributary key will be included into the 190 report for 2011 year.
Besides a total net amount = 264,00 will also be included in the field "Percepciones Integras".
Several national purchase invoice (Service) posted and fully paid for the same business partner and different tributary key
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 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 = 18-11-2011
- Accounting date = 18-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain)
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "100"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 0% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "176"
- Withholding Amount = "-26,40"
The invoice is posted and fully paid in 2011.
Another invoice is created:
- Transaction Document type = AP Invoice
- Invoice date = 19-11-2011
- Accounting date = 19-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain)
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service B"
- Invoiced quantity = "100"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 0% -7%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "176"
- Withholding Amount = "-12,32"
The invoice is posted and fully paid in 2011.
A withholding amount of 26,40€ to Bebidas Alegres linked to the G-01 tributary key will be included into the 190 report for 2011 year. Besides a total net amount = 176,00 will also be included in the field "Percepciones Integras" for the same record.
A withholding amount of 12,32€ to Bebidas Alegres linked to the G-03 tributary key will be included into the 190 report for 2011 year. Besides a total net amount = 176,00 will also be included in the field "Percepciones Integras" for the same record.
National purchase invoice credit memo (Service) posted and fully paid
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 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 = 18-11-2011
- Accounting date = 18-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain), which should be linked to any of below listed BP Tax Category:
- Servicios Profesionales Normal
- Servicios Profesionales Reducido
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "100"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 18% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "176"
- Withholding Tax Amount = "-26,40"
- VAT amount = "31,68"
The invoice is posted and fully paid.
Later on below credit transaction is also posted and fully paid:
- Transaction Document type = AP Credit Memo
- Invoice date = 25-11-2011
- Accounting date = 25-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain)
- Currency = EUR
In the "Lines" tab, below data is entered by Alice:
- Line 10
- Product = "Service A"
- Invoiced quantity = "50"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 18% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "88"
- Withholding Tax Amount = "13,20"
- VAT amount = "15,84"
A withholding amount of 13,20€ to Bebidas Alegres linked to the G-01 tributary key will be included into the 190 report for 2011 year.
Besides a total net amount = 88,00 will also be included in the field "Percepciones Integras" for the same record.
National negative purchase invoice (Service) posted and fully paid
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 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 = 18-11-2011
- Accounting date = 18-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain), which should be linked to any of below listed BP Tax Category:
- Servicios Profesionales Normal
- Servicios Profesionales Reducido
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "100"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 18% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "176"
- Withholding Tax Amount = "-26,40"
- VAT amount = "31,68"
The invoice is posted and fully paid.
Later on below credit transaction is also posted and fully paid:
- Transaction Document type = AP Invoice
- Invoice date = 25-11-2011
- Accounting date = 25-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain)
- Currency = EUR
In the "Lines" tab, below data is entered by Alice:
- Line 10
- Product = "Service A"
- Invoiced quantity = "-50"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 18% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "-88"
- Withholding Tax Amount = "13,20"
- VAT amount = "-15,84"
A withholding amount of 13,20€ to Bebidas Alegres linked to the G-01 tributary key will be included into the 190 report for 2011 year.
Besides a total net amount = 88,00 will also be included in the field "Percepciones Integras" for the same record.
National reversal purchase invoice (Service) posted and fully paid
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 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 = 18-11-2011
- Accounting date = 18-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain), which should be linked to any of below listed BP Tax Category:
- Servicios Profesionales Normal
- Servicios Profesionales Reducido
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "100"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 18% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "176"
- Withholding Tax Amount = "-26,40"
- VAT amount = "31,68"
The invoice is posted and fully paid.
Later on below credit transaction is also posted and fully paid:
- Transaction Document type = Reversed Purchase Invoice
- Invoice date = 25-11-2011
- Accounting date = 25-11-2011
- Business Partner = "Bebidas Alegres" (located in Spain)
- Currency = EUR
In the "Lines" tab, below data is entered by Alice:
- Line 10
- Product = "Service A"
- Invoiced quantity = "-50"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 18% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "-88"
- Withholding Tax Amount = "13,20"
- VAT amount = "-15,84"
A withholding amount of 13,20€ to Bebidas Alegres linked to the G-01 tributary key will be included into the 190 report for 2011 year.
Besides a total net amount = 88,00 will also be included in the field "Percepciones Integras" for the same record.
National purchase invoice (Service) posted belonging to a previous year and paid during next years
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 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 = 18-11-2009
- Accounting date = 18-11-2009
- Business Partner = "Bebidas Alegres" (located in Spain)
- Currency = EUR
and then go to "Lines" tab. Once there Alice must enter below data:
- Line 10
- Product = "Service A"
- Invoiced quantity = "50"
- Net Unit Price = "1,76"
- Tax = "Prestación servicios nacional 0% -15%R" (system will show up this Tax type based on setup).
- Tax Base Amount = "88"
- Tax Amount = "-13,20"
The invoice is posted and partially paid following this schema:
- In 2009 we paid 20%, that means a paid amount = 17,60
- In 2010 we paid 20%, that means a paid amount = 17,60
- In 2011 we paid 50%, that means a paid amount = 44,00
(Remaining 10% is not paid, that means a not paid amount = 8,80)
A withholding amount of 2,64€ (20% s/13.20) to Bebidas Alegres linked to the G-01 tributary key will be included into the 190 report for 2009 year (set us "Ejercicio Devengo").
A withholding amount of 2,64€ (20% s/13.20) to Bebidas Alegres linked to the G-01 tributary key will be included into the 190 report for 2010 year specifying that this transaction belongs to 2009 year (set us "Ejercicio Devengo").
A withholding amount of 6,60€ (50% s/13.20)to Bebidas Alegres linked to the G-01 tributary key will be included into the 190 report for 2011 year specifying that this transaction belongs to 2009 year (set us "Ejercicio Devengo").
Negative amount 190 transactions caused by overpaid amounts
It could happen that there are amounts which needs to be included in the 190 report as a consecuence of have being wrongly paid in previous years.
In those case:
- Alice enters a purchase invoice (AP Invoice) dated on 2010 which is posted and fully paid in 2009, for a total net amount (Tax Base Amount) = 1000,00 and a withholding amount = 150,00
- Alice enters a purchase invoice (AP Invoice) dated on 2010 which is posted and fully paid in 2010, for a total net amount (Tax Base Amount) = 2000,00 and a withholding amount = 300,00
- Dated on 2011 the vendor informs Alice that the invoices were wrongly issued and therefore needs to be reversed.
- Alice enters the corresponding credit memos or reversed purchase invoices to separatly reversed each invoice by linking them in the "Reversed Invoices" tab. The reversed documents are posted and fully settled in 2011.
Above scenario implies that the below data must be filled in the Modelo 190 tax report:
- A first negative amount transaction with a value of 1000,00 filled in the field "Percepciones Integras", with No Witholding amount filled in and 2009 year shown in the field "Ejercicio Devengo"
- A second negative amount transaction with a value of 2000,00 filled in the field "Percepciones Integras", with No Witholding amount filled in and 2010 year shown in the field "Ejercicio Devengo"
Assumptions & Dependencies
Assumptions
N/A
Dependencies
The 190 module depends on:
- Spanish tax module
- Spanish regions module (provincias de España)
- Tax Report Launcher
- Advanced Payables and Receivables
- Core 2.50 or Core 3.0MP5
Design & Technical considerations
Design considerations
190 report must be implemented as a commercial module which will be later on part of the Spanish Professional Localization Pack.
Technical constraints
None
Technical Requirements
190 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.