Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016161Localization Pack: SpainAEAT 347public2011-03-07 17:022011-03-09 18:34
Reporterpsanjuan 
Assigned Tovmromanos 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04.1
Product Version 
Target VersionFixed in Version1.2.3 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0016161: 347 tax report - does not properly show "collections" over 6000,00 €
Description347 tax report - does not properly show "collections" over 6000,00 €
Steps To ReproduceCreate and post a sales invoice for customer "Arrendatario A" for a total amount of 4.130,00€. Invoice date and Due Date 20-09-2010. Product "Local de negocio" tax = Entregas IVA 18%

Create and post another sales invoice for customer "Arrendatario A" for a total amount of 4.130,00€. Invoice date and Due Date 20-10-2010. Product "Local de negocio" tax = Entregas IVA 18%

Go to Financial Management || Receivables & Payables || Setup || Cashbook || Cashbook and make sure there is a cash journal

Go to Financial Management || Receivables & Payables || Transactions || Cash Journal || Header and create a new cash journal just for 1 invoice, amount 4.130,00
Transaction and Accounting date = 20-09-2010
Go to lines and enter a new one.
Select Debt-Payment and select the payment of 4130 with due date 20-09-2010
Process and Post

Run the 347 tax report

23472010B3124567802889768W ARRENDATARIO A D28 B000000000826000 X0000000008260000000000000000002010

and you will realize that the file is showing an amount of 8.260,00 as collection (positions 100-114) as well as 2010 year (positions 130-1133) but only 4.130,00 has been actually collected.

Besides In this case the collection should not be shown unless it is over 6000,00€

Another scenario:

Create a new customer named (Cash Customer); form of payment = Cash
Enter and post a sales invoice for a total amount of 4060.00
Navigate to Financial Management || Receivables & Payables || Transactions || Cash Journal || Header and process and post the cash journal for 4060

Launch the 347 tax report

file is showing below record which is not right as it is showing a collection of 4060*2

23472010B31245678A89876765 CASH CUSTOMER D00 B000000000406000 0000000008120000000000000000002010

Another scenario:
Create a new customer named "Cash Customer 2", form of payment "Cash"
Enter a sales invoice for an amount of 12083.20 dated on 2009
complete and post
Navigate to Financial Management || Receivables & Payables || Transactions || Cash Journal || Header and process and post the cash journal for 12083.20
by changing the accounting date to 2010 and selecting the 2009 as the 347 year.

Run the 347 tax report
file is showing below record which is not right as it is showing 12083.20*2

23472010B31245678B67898767 CASH CUSTOMER 2 D00 B000000000000000 0000000024166400000000000000002009


Proposed SolutionThe file should not shown any collection until it is over 6.000,00€

23472010B3124567802889768W ARRENDATARIO A D28 B000000000826000 X0000000000000000000000000000000

Example 2
The file should not shown any collection until it is over 6.000,00€
23472010B31245678A89876765 CASH CUSTOMER D00 B000000000406000 000000000000000000000000000000

Example 3
The file should show below information:
23472010B31245678B67898767 CASH CUSTOMER 2 D00 B000000000000000 0000000012083200000000000000002009
Additional Information
TagsNo tags attached.
Relationships
Attached Files? 16161 (7,516) 2011-03-07 18:38
https://issues.openbravo.com/file_download.php?file_id=3632&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-03-07 17:02psanjuanNew Issue
2011-03-07 17:02psanjuanAssigned To => dalsasua
2011-03-07 18:28psanjuanProposed Solution updated
2011-03-07 18:38psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=1568#r1568
2011-03-07 18:38psanjuanProposed Solution updated
2011-03-07 18:38psanjuanFile Added: 16161
2011-03-08 19:09psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=1573#r1573
2011-03-08 19:09psanjuanProposed Solution updated
2011-03-08 19:21psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=1574#r1574
2011-03-08 19:21psanjuanProposed Solution updated
2011-03-09 10:19vmromanosStatusnew => scheduled
2011-03-09 10:19vmromanosAssigned Todalsasua => vmromanos
2011-03-09 10:19vmromanosfix_in_branch => pi
2011-03-09 17:50hgbotCheckin
2011-03-09 17:50hgbotNote Added: 0034708
2011-03-09 17:50hgbotStatusscheduled => resolved
2011-03-09 17:50hgbotResolutionopen => fixed
2011-03-09 17:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat347.es/rev/e9e67e6050a1c2cb821bab5af5a769a96debe3a5 [^]
2011-03-09 18:34psanjuanNote Added: 0034710
2011-03-09 18:34psanjuanStatusresolved => closed
2011-03-09 18:34psanjuanFixed in Version => 1.2.3
2011-03-09 18:34psanjuanfix_in_branchpi =>

Notes
(0034708)
hgbot   
2011-03-09 17:50   
Repository: erp/pmods/org.openbravo.module.aeat347.es
Changeset: e9e67e6050a1c2cb821bab5af5a769a96debe3a5
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed Mar 09 17:44:44 2011 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat347.es/rev/e9e67e6050a1c2cb821bab5af5a769a96debe3a5 [^]

Fixed bug 16161 in module version 1.2.3
347 tax report - does not properly show collections over 6000,00 €
Avoid Contenido no numérico en Ejercicio error while importing file into the Informativas software

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/module/aeat347/es/AEAT347Report.java
M src/org/openbravo/module/aeat347/es/AEAT347ReportDao.java
---
(0034710)
psanjuan   
2011-03-09 18:34   
fixed and working