Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
0039382Localization Pack: SpainAEAT 349public2018-10-01 11:572022-03-11 14:47
Opentix-Test 
psanjuan 
normalmajorhave not tried
scheduledopen 
5
 
 
0039382: 349 Eliminar restricción del campo base imponible del 349 Prod/Serv y autocalcular el valor del campo "Base Imponible declarada"
Se plantea:
 - Eliminar la restricción, sobre le campo base imponible del 349 Producto y Servicio, que impide la introducción de un importe inferior al de la declaración del periodo declarado en el campo periodo.

- Autocalcular el valor del campo "Base Imponible Declarada" en función del tercero y periodo.

Relacionado con las issues/tickets: 38798/40102 *****/39907
Datos factura Original:
      - Periodo: Enero:
      - Importe: 100.000 €.

1º Crear una factura rectificativa en Febrero de la factura anterior con los siguientes datos correctivos, con un importe de factura rectificada de 10.000.-
      - Año:2018
      - Mes: Enero
      - Base Imponible del 349 Productos (ya declarada): 100.000 € (Importe Factura Original)
      - Base Imponible rectificada : 90.000

2º Crear en Marzo, otra factura rectificativa, sobre la misma factura de Enero, por importe de 20.000:
      - Año: 2018
      - Mes: Enero:
      - Base Imponible del 349 Productos (ya declarada): 90.000 €
      - Base Imponible rectificada: 70.000

Se obtiene el mensaje de error que indica que el Importe "ya existe la misma factura con importe Base imponible distinto" (base imponible declarada).
Primera corrección:

- Eliminar la restricción sobre el campo base imponible del 349 Producto y Servicio (base imponible declarada), ya que esta puede cambiar en función de que el mismo periodo pueda rectificarse en más de un periodo.

Segunda corrección:

- Autocalcular el valor del campo (base imponible declarada), en función de las facturas normales y rectificativas realizadas para el mismo tercero, en el año y periodo indicado.

En el ejemplo (Punto 2 factura rectificativa creada en Marzo):

- Base imponible declarada anteriormente = 90.000 (100.000-10.000)
- BAse Imponible rectificada = 75.000 (90.000-20.000)


No tags attached.
has duplicate defect 0039183 closed Mery Anelo 349 tax report is no correctly getting the value of "Base Imponible Rectificada" if more than one correction is done. 
Issue History
2018-10-01 11:57Opentix-TestNew Issue
2018-10-01 11:57Opentix-TestAssigned To => Triage Finance
2018-10-04 09:59psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17738#r17738
2018-10-04 09:59psanjuanProposed Solution updated
2018-10-04 10:00psanjuanStatusnew => scheduled
2018-10-04 10:10psanjuanProposed Solution updated
2018-10-05 14:04Opentix-TestSummary349 Eliminación de la restricción sobre el campo base imponible del 349 Productos y Servicios => 349 Eliminar restricción del campo base imponible del 349 Prod/Serv y autocalcular el valor del campo "Base Imponible declarada"
2018-10-05 14:04Opentix-TestDescription Updatedbug_revision_view_page.php?rev_id=17745#r17745
2018-10-05 14:04Opentix-TestProposed Solution updated
2020-03-23 18:18Mery AneloRelationship addedhas duplicate 0039183
2020-03-23 20:47Mery AneloNote Added: 0118776
2020-03-23 20:50Mery AneloNote Edited: 0118776bug_revision_view_page.php?bugnote_id=0118776#r20594
2020-09-15 01:01hgbotNote Added: 0123045
2020-09-15 01:02Mery AneloAssigned ToTriage Finance => Mery Anelo
2020-11-27 15:55Mery AneloNote Added: 0124660
2021-01-19 19:18juabaezAssigned ToMery Anelo => juabaez
2021-01-22 20:18juabaezNote Added: 0125738
2021-10-19 15:51Jorge BravoAssigned Tojuabaez => psanjuan
2022-03-11 14:47hgbotNote Added: 0135664

Notes
(0118776)
Mery Anelo   
2020-03-23 20:47   
(edited on: 2020-03-23 20:50)
Test plan:
- Log as Group Admin Role
- Create a new Invoice
- Complete the data and add lines.
- Complete the invoice and post.
- Create a Reversed Invoice and add the corresponding data to model 349 (year and period).
- The tax base of products and services must be calculated automatically. (Second part).
- If the user modifies any value in the tax bases, a warning is issued indicating that the tax base set by the user does not match the automatically calculated tax base. (First part)


Plan de test:
- Iniciar sesión administrador del grupo
- Crear una nueva factura
- Complete los datos y agregue líneas.
- Complete la factura y contabilice.
- Cree una factura rectificativa y agregue los datos correspondientes al modelo 349 (año y período).
- La base imponible de los productos y servicios debe calcularse automáticamente. (Segunda parte).
- Si el usuario modifica algún valor en las bases imponibles, se emite una advertencia que indica que el elegido no coincide con la base imponible calculada automáticamente. (Primera parte)

(0123045)
hgbot   
2020-09-15 01:01   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat349.es/-/merge_requests/1 [^]
(0124660)
Mery Anelo   
2020-11-27 15:55   
Test plan (detailed example):
- Log as Group Admin Role
- Create a new Invoice for date in January/2020
- Add a line with a service type product
- Set the amount of this invoice of 1,500€
- Complete and post the invoice
- Create a new Invoice for date in February/2020
- Add a line of services for the amount of -200€
- Create a line on the tab of the "Reversed Invoices" with the first invoice selected.
- Set the following info:

    Year: 2020
    Period: January 2020
    "Base Imponible del 349 de Servicios": it will be empty and the user will manually enter 1,500€
- Complete and post the invoice
    "Base Imponible del 349 de Servicios Actualizada": When post the invoice the value will update to 1,300€ (1,500 - 200)
    If we launched 349 at that time we would have:
       Tax base previously declared = € 1,500 (January)
       Rectified tax base = € 1,300 (updated)

- Create a new Invoice for date in February/2020
- Add a line of services for the amount of -100€
- Create a line on the tab of the "Reversed Invoices" with the first invoice selected.
- Set the following info:

    Year: 2020
    Period: January 2020
    "Base Imponible del 349 de Servicios Actualizada": will be filled in automatically with 1,300€
- Complete and post the invoice
    "Base Imponible del 349 de Servicios Actualizada": When post the invoice the value will update to 1,200€ (1,300 - 100)
    If we launched 349 at that time we would have:
       Tax base previously declared = € 1,500 (January)
       Rectified tax base = € 1,200 (updated)

- Create a new Invoice for date in March/2020
- Add a line of services for the amount of -50€
- Create a line on the tab of the "Reversed Invoices" with the first invoice selected.
- Set the following info:

    Year: 2020
    Period: January 2020
    "Base Imponible del 349 de Servicios Actualizada": will be filled in automatically with 1,200€
- Complete and post the invoice
    "Base Imponible del 349 de Servicios Actualizada": When post the invoice the value will update to 1,150€ (1,200 - 50)
    If we launched 349 at that time we would have:
       Tax base previously declared = € 1,200 (February)
       Rectified tax base = € 1,150 (updated)

Note: always use the same business partner
(0125738)
juabaez   
2021-01-22 20:18   
Test plan (detailed example):

CASE 1:
- Log as Group Admin Role
- Import the dataset in organization *
- See the that row was inserted in accounting process window
- Change rol as System Administrator
- Should be active the tab Process in general ledger configuration if not is active, activate the tab
- Change rol as Group Admin Role
- Go to General Ledger Configuration, and associate the process inserted previously in process tab
- Create a new Invoice for date in January/2021
- Add a line with a service type product
- Set the amount of this invoice of 1,500€
- Complete and post the invoice
- Create a new Invoice for date in February/2021
- Add a line of services for the amount of -200€
- Create a line on the tab of the "Reversed Invoices" with the first invoice selected.
- Set the following info:

    Year: 2021
    Period: January 2021
    "Base Imponible del 349 de Servicios": it will be empty and the user will manually enter 1,500€
- Complete and post the invoice
    "Base Imponible del 349 de Servicios Actualizada": When post the invoice the value will update to 1,300€ (1,500 - 200)
    If we launched 349 at that time we would have:
       Tax base previously declared = € 1,500 (January)
       Rectified tax base = € 1,300 (updated)

- Create a new Invoice for date in February/2021
- Add a line of services for the amount of -100€
- Create a line on the tab of the "Reversed Invoices" with the first invoice selected.
- Set the following info:

    Year: 2021
    Period: January 2021
    "Base Imponible del 349 de Servicios Actualizada": will be filled in automatically with 1,300€
- Complete and post the invoice
    "Base Imponible del 349 de Servicios Actualizada": When post the invoice the value will update to 1,200€ (1,300 - 100)
    If we launched 349 at that time we would have:
       Tax base previously declared = € 1,500 (January)
       Rectified tax base = € 1,200 (updated)

- Create a new Invoice for date in March/2021
- Add a line of services for the amount of -50€
- Create a line on the tab of the "Reversed Invoices" with the first invoice selected.
- Set the following info:

    Year: 2021
    Period: January 2021
    "Base Imponible del 349 de Servicios Actualizada": will be filled in automatically with 1,200€
- Complete and post the invoice
    "Base Imponible del 349 de Servicios Actualizada": When post the invoice the value will update to 1,150€ (1,200 - 50)
    If we launched 349 at that time we would have:
       Tax base previously declared = € 1,200 (February)
       Rectified tax base = € 1,150 (updated)


CASE 2:
- Log as Group Admin Role
- Import the dataset in organization *
- See the that row was inserted in accounting process window
- Change rol as System Administrator
- Should be active the tab Process in general ledger configuration if not is active, activate the tab
- Change rol as Group Admin Role
- Go to General Ledger Configuration, and associate the process inserted previously in process tab
- Create a new Invoice for date in January/2021
- Add a line with a service type product with price unit 800
- Add a line with a product with unit price 1500
- Set the amount of this invoice of 2,300€
- Complete and post the invoice
- Create a new Invoice for date in February/2021
- Add a line of product for the amount of -200€
- Create a line on the tab of the "Reversed Invoices" with the first invoice selected.
- Set the following info:

    Year: 2021
    Period: January 2021
    "Base Imponible del 349 de Servicios": it will be empty and the user will manually enter 800€
    "Base Imponible del 349 de Productos": it will be empty and the user will manually enter 1,500€
- Complete and post the invoice
    "Base Imponible del 349 de Productos Actualizada": When post the invoice the value will update to 1,300€ (1,500 - 200)
    "Base Imponible del 349 de Servicios Actualizada": When post the invoice the value will is 800€
    If we launched 349 at that time we would have:
       Tax base previously declared = € 1,500 (January)
       Rectified tax base = € 1,300 (updated)

- Create a new Invoice for date in February/2021
- Add a line of services for the amount of -250
- Create a line on the tab of the "Reversed Invoices" with the first invoice selected.
- Set the following info:

    Year: 2021
    Period: January 2021
    "Base Imponible del 349 de Productos Actualizada": will be filled in automatically with 1,300€
    "Base Imponible del 349 de Servicios Actualizada": will be filled in automatically with 800€
- Complete and post the invoice
    "Base Imponible del 349 de Productos Actualizada": When post the invoice the value will update to 1,050€ (1,300 - 250)
    "Base Imponible del 349 de Servicios Actualizada": When post the invoice the value will is 800€
    If we launched 349 at that time we would have:
       Tax base previously declared = € 1,500 (January)
       Rectified tax base = € 1,050 (updated)

Note: always use the same business partner
(0135664)
hgbot   
2022-03-11 14:47   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.aeat349.es/-/merge_requests/1 [^]