Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0020568
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Localization Pack: Spain] AEAT 349majoralways2012-05-21 18:532015-11-12 12:34
ReporterdmiguelezView Statuspublic 
Assigned Tovmromanos 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision2a76b6457bf3
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0020568: Add compatibility with new Document Type Return Material Sales Invoice

DescriptionA new Document Type has been created, Return Material Sales Invoice, with a new document base type associated, ARI_RM.

This module has to be modified to be compatible with it.
Steps To ReproduceThis is the code that may be affected.

org.openbravo.module.aeat349.es/src/org/openbravo/module/aeat349/es/AEAT3492010ReportDao.java: .append(" and (fa.documentCategory = 'ARI' or (fa.documentCategory = 'ARC' and i.grandTotalAmount > 0)"
org.openbravo.module.aeat349.es/src/org/openbravo/module/aeat349/es/AEAT3492010ReportDao.java: + "or (fa.documentCategory = 'ARI' and fa.documentType.reversal = 'Y' and i.grandTotalAmount > 0)) ");
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0018825 closedjecharri 349 should properly manage Reverse Purchase/Sales invoices 

-  Notes
(0068841)
psanjuan (manager)
2014-07-23 14:09

Issue changed to design defect as this is not a bug.
(0081022)
vmromanos (manager)
2015-10-14 18:28

Test Plan:

As Openbravo Admin
 Apply the Taxes dataset to * org
 Apply the 349 dataset to FB España
 Go to sales invoice window.
 Create a new Return Material sales invoice for Alimentos y Supermercados
 Enter any line with negative amount and tax rate = Entregas intracomunitarias (%N=>0%)
 Complete and post the invoice
 
 Go to Tax Report Launcher window
 Select FB España, 349 report v2010 and the year where the previous invoice has been created
 Launch the report. Fill the necessary data and press OK.
 An error message is shown: Se han detectado devoluciones por valor superior al importe facturado para el tercero: Alimentos y Supermercados, S.A
 because the invoice is detected.
 Go back to the invoice and unpost and reactivate it
 Launch the report again.
 An error message is shown: No se han detectado en el sistema transacciones correspondientes al modelo 349 para el periodo seleccionado.
(0081023)
hgbot (developer)
2015-10-14 18:28

Repository: erp/pmods/org.openbravo.module.aeat349.es
Changeset: 2a76b6457bf306e86841471116c0e8216ba4b304
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed Oct 14 18:21:04 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat349.es/rev/2a76b6457bf306e86841471116c0e8216ba4b304 [^]

Fixed bug 20568: Add compatibility with new Document Type Return Material Sales Invoice

A Return Material Sales Invoice is like a sales invoice with negative amounts.
The fix only extends the filters for the queries to support this document type in the same places ARI is used.

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/module/aeat349/es/AEAT3492010ReportDao.java
M src/org/openbravo/module/aeat349/es/AEAT349ReportDao.java
---
(0081024)
vmromanos (manager)
2015-10-14 18:30

Fixed in Modelo 349 2.1.1 (or higher)
(0081376)
dmitry_mezentsev (developer)
2015-10-28 10:10

Not closed for 14 days!
(0081750)
psanjuan (manager)
2015-11-12 12:26
edited on: 2015-11-12 12:34

Test Plan above verified.

Besides that:

Create a sales invoice for a UE Customer for a total amount of 10.00. Complete and Post the invoice in November 2015. Check that the tax rate shown in the invoice is "Entregas Intracomunitarias....."

Launch 349 tax report for November 2015 and check that UE customer transaction for an amount of 10.00 is included.

Create a return material sales invoice for the UE Customer for a total amount of -5.00 dated also in Nov 2015. Complete and Post the return sales invoice in November 2015.

Launch 349 tax report for November 2015 and check that UE customer transaction shows now an amount of 5.00.

Go to Sales invoice window and enter a new return material sales invoice dated on Dec 2015. Add a line for an invoice quantity -1, line net amount = -1.00
Go to "Reversed Invoices" tab and select the positive invoice created in November (amount = 10.00) and check the flag "Correctiva del 349". After that enter below data:
Año = 2015
Periodo = 11-Noviembre
Base Imponible del 349 Productos = 5.00

complete and post the invoice.

Launch 349 tax report for December 2015. See file attached.
Import that file in Informativas and realize that the return material sales invoice is properly shown in "Rectificaciones" with below data:
Base declarada anteriormente = 5.00
Base imponible rectificada = 4.00


Issue closed.


- Issue History
Date Modified Username Field Change
2012-05-21 18:53 dmiguelez New Issue
2012-05-21 18:53 dmiguelez Assigned To => jonalegriaesarte
2012-05-21 19:05 jonalegriaesarte Assigned To jonalegriaesarte => vmromanos
2014-04-15 11:47 psanjuan Type feature request => defect
2014-07-23 14:09 psanjuan Note Added: 0068841
2014-07-23 14:09 psanjuan Type defect => design defect
2015-10-14 16:59 vmromanos Status new => scheduled
2015-10-14 17:38 vmromanos Relationship added related to 0018825
2015-10-14 18:28 vmromanos Note Added: 0081022
2015-10-14 18:28 hgbot Checkin
2015-10-14 18:28 hgbot Note Added: 0081023
2015-10-14 18:28 hgbot Status scheduled => resolved
2015-10-14 18:28 hgbot Resolution open => fixed
2015-10-14 18:28 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat349.es/rev/2a76b6457bf306e86841471116c0e8216ba4b304 [^]
2015-10-14 18:30 vmromanos Note Added: 0081024
2015-10-28 10:10 dmitry_mezentsev Note Added: 0081376
2015-11-12 12:26 psanjuan Note Added: 0081750
2015-11-12 12:34 psanjuan Note Edited: 0081750 View Revisions
2015-11-12 12:34 psanjuan Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker