Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011918Openbravo ERP09. Financial managementpublic2010-01-08 13:162010-03-10 18:28
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP9 
Target Version2.50MP11Fixed in Version2.50MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011918: Bank.dat is not correct in "Cuaderno 34"
DescriptionWhen bank.dat is generated in Remittance window, using "Cuaderno 34" as Remittance type, is not well formated.

There are two empty lines at the buttom of .dat, that must be deleted.

See attached file.

Note: Here you are the rules of "Cuaderno 34"

http://empresa.lacaixa.es/transferenciaficheros/queesunfichero_es.html [^]
Steps To ReproduceGo to Financial Management > Receivables and Payables > Setup > Remittance.
Generate a new one called "Cuaderno 34". Set as "Consolidated" and select two status for return and receive.
Go to Parameters tab. Enter this list (Name - Content):
Cuaderno - 34
Contract - 000
Gastos - 1
Concepto - S
Detalle - 1
Go to Financial Management > Receivables and Payables >Transactions > Remittance.
Create a new record and select the previous remittance type.
Open "Create lines from"
Select one payment and press OK.
Process it.
Press "Create file" button.
See two last lines.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? BANK (1).DAT (816) 2010-01-08 13:17
https://issues.openbravo.com/file_download.php?file_id=2109&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-01-08 13:16networkbNew Issue
2010-01-08 13:16networkbAssigned To => rafaroda
2010-01-08 13:17networkbFile Added: BANK (1).DAT
2010-01-12 10:54rafarodaNote Added: 0023342
2010-01-12 10:54rafarodaAssigned Torafaroda => dalsasua
2010-01-12 10:54rafarodaStatusnew => feedback
2010-01-12 11:02networkbNote Added: 0023343
2010-01-12 11:03networkbStatusfeedback => new
2010-01-12 11:03networkbversion => 2.50MP9
2010-01-15 13:12dalsasuaStatusnew => scheduled
2010-01-15 13:12dalsasuaNote Added: 0023470
2010-01-15 13:12dalsasuafix_in_branch => pi
2010-01-15 14:25hgbotCheckin
2010-01-15 14:25hgbotNote Added: 0023474
2010-01-15 14:25hgbotStatusscheduled => resolved
2010-01-15 14:25hgbotResolutionopen => fixed
2010-01-15 14:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5f693dc325c65e89e70f11312f7f6af6089bb3ef [^]
2010-01-20 23:26hudsonbotCheckin
2010-01-20 23:26hudsonbotNote Added: 0023658
2010-01-22 10:20sureshbabuNote Added: 0023733
2010-01-22 11:37dalsasuaNote Added: 0023739
2010-02-18 13:39sureshbabuNote Added: 0024595
2010-02-18 13:39sureshbabuStatusresolved => closed
2010-02-18 13:39sureshbabuFixed in Version => 2.50MP12
2010-02-19 00:00anonymoussf_bug_id0 =>
2010-03-10 18:28anonymoussf_bug_id => 2967973

Notes
(0023342)
rafaroda   
2010-01-12 10:54   
@dalsasua: can you please comment on this issue? Is reproducible?

@networkb: can you please set a product version?

Thanks.
(0023343)
networkb   
2010-01-12 11:02   
There is attached a file from this remittance. It was created in an standard application.
(0023470)
dalsasua   
2010-01-15 13:12   
I verified that ONE extra line break is inserted.
(0023474)
hgbot   
2010-01-15 14:25   
Repository: erp/devel/pi
Changeset: 5f693dc325c65e89e70f11312f7f6af6089bb3ef
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Jan 15 14:25:36 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5f693dc325c65e89e70f11312f7f6af6089bb3ef [^]

Fixes issue 11918: Bank.dat is not correct

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFile.java
---
(0023658)
hudsonbot   
2010-01-20 23:26   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/5f693dc325c6 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/fa6621f85351 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15942.obx [^]
(0023733)
sureshbabu   
2010-01-22 10:20   
@ David, when i click create file button, i am getting error as "Tax Identification number" needed.
(0023739)
dalsasua   
2010-01-22 11:37   
Hi Suresh:

Please check that every business partner involved in the remittance has got a VALID tax id. To ensure that, execute this query in your database:

update ad_orginfo set taxid='B31098765';
update c_bpartner set taxid='B31098765';

If executing this it continues to through same error, please let me know.

Thanks.
(0024595)
sureshbabu   
2010-02-18 13:39   
Tested working fine