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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0016161
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Localization Pack: Spain] AEAT 347majorhave not tried2011-03-07 17:022011-03-09 18:34
ReporterpsanjuanView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version1.2.3
StatusclosedFix in branchFixed in SCM revisione9e67e6050a1
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0016161: 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
TagsNo tags attached.
Attached Files? file icon 16161 [^] (7,516 bytes) 2011-03-07 18:38 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0034708)
hgbot (developer)
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 (manager)
2011-03-09 18:34

fixed and working

- Issue History
Date Modified Username Field Change
2011-03-07 17:02 psanjuan New Issue
2011-03-07 17:02 psanjuan Assigned To => dalsasua
2011-03-07 18:28 psanjuan Proposed Solution updated
2011-03-07 18:38 psanjuan Steps to Reproduce Updated View Revisions
2011-03-07 18:38 psanjuan Proposed Solution updated
2011-03-07 18:38 psanjuan File Added: 16161
2011-03-08 19:09 psanjuan Steps to Reproduce Updated View Revisions
2011-03-08 19:09 psanjuan Proposed Solution updated
2011-03-08 19:21 psanjuan Steps to Reproduce Updated View Revisions
2011-03-08 19:21 psanjuan Proposed Solution updated
2011-03-09 10:19 vmromanos Status new => scheduled
2011-03-09 10:19 vmromanos Assigned To dalsasua => vmromanos
2011-03-09 10:19 vmromanos fix_in_branch => pi
2011-03-09 17:50 hgbot Checkin
2011-03-09 17:50 hgbot Note Added: 0034708
2011-03-09 17:50 hgbot Status scheduled => resolved
2011-03-09 17:50 hgbot Resolution open => fixed
2011-03-09 17:50 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat347.es/rev/e9e67e6050a1c2cb821bab5af5a769a96debe3a5 [^]
2011-03-09 18:34 psanjuan Note Added: 0034710
2011-03-09 18:34 psanjuan Status resolved => closed
2011-03-09 18:34 psanjuan Fixed in Version => 1.2.3
2011-03-09 18:34 psanjuan fix_in_branch pi =>


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker