0026991: It should not be possible to select invoices from different periods as "corrective 349" invoices in the tab "Reversed Invoices"

Openbravo Issue Tracking System - Localization Pack: Spain

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0026991

Localization Pack: Spain

AEAT 349

public

2014-07-01 18:59

2014-09-16 14:22

Reporter

maite

Assigned To

rafaroda

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Support ticket

OBNetwork customer

Regression introduced in release

Summary

0026991: It should not be possible to select invoices from different periods as "corrective 349" invoices in the tab "Reversed Invoices"

Description

It should not be possible to select invoices from different periods as "corrective 349" invoices in the tab "Reversed Invoices"

Steps To Reproduce

1. Register a sales invoice for an amount of 100 € for a customer located in France. Tax rate to be used: Entregas intracomunitarias (%N=>0%). Invoice dated on August 2014. Complete and Post the invoice.
Launch the 349 tax form from the Tax Report Launcher for August period and realize that the Tax Base Amount for that customer is = 100

2. Register a new sales invoice for an amount of 200 € for the same customer as in 1. Once more the tax rate to be used: Entregas intracomunitarias (%N=>0%). Invoice dated on September 2014. Complete and Post the invoice.
Launch the 349 tax form from the Tax Report Launcher for September period and realize that the Tax Base Amount for that customer is = 200

3. Register a Reverse Sales Invoice for the same customer and for an amount of -200 €. Invoice dated on October 2014
Access "Reverse Invoice" tab, select August invoice (see point 1 above) and set it as "corrective 349". Enter below data:
Year = 2014
Period = August
Base Imponible del 349 Productos = 100

In this tab add a new record referencing the invoice dated in February (see point 2 above) and set it as "corrective 349". Enter below data:
Year = 2014
Period = September
Base Imponible del 349 Productos = 200

Realize that no error is obtained.

Launch the 349 tax form from the Tax Report Launcher for October and realize that it is not possible to validate the txt file obtained because it is not possible to import it in AEAT software "Informativas". Below error is shown (In Spanish):
Código: 31401A
Descripción: Base Imponible rectificada NO NUMÉRICA

The reason is:
Openbravo is making this calculation:
(1) to get new August tax base is doing 100-200 = -100
(2) to get new September tax base is doing 200-200= 0
but above calculations are not correct because it is not possible to indicate which amount (among reverse invoice amount of 200 €) should correct August invoice and which amount (among reverse invoice amount of 200 €) should correct September invoice.

Therefore it should not be possible to reference invoices from different periods (months or quarters) in the same reverse invoice as "Corrective 349", as there is no way to know the new tax base amount of each period (month or quarter).
At the end of the day end-user needs to register two Reversed Sales Invoice, first one reversing August invoice and second one reversing September invoice.

Same applies to purchase invoice.

Same applies for Quarterly submission of 349 tax form.

Proposed Solution

It should not be possible to reference invoices from different periods (months or quarters) in the same reverse invoice as "Corrective 349", as there is no way to know the new tax base amount of each period (month or quarter).

Additional Information