Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010163Openbravo ERP09. Financial managementpublic2009-08-03 13:432009-08-29 00:00
Reporternetworkb 
Assigned Todalsasua 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP3 
Target Version2.50MP4Fixed in Version 
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
Summary0010163: Dat file for Remittance Cuaderno 34 is not correct
DescriptionWhen remittance file (.dat) is generated is not properly configured:

*Some lines contain '.' where is not neede (see fifth line of attached file).
*If Organization contains a short Address, address does not appear (third and fourth line)
*The third line must has 72 characters (mandatory).
*The last line must show total recipient (one for each line), not total sender.
Steps To ReproduceGenerate Remittance type Cuaderno 34 as:
Create a new register in Financial management > Receivables and payables > Setup > Remittance type. Its name will be Cuaderno 34.
Go to its line and create: Cuaderno (name), 34 (content).
Contract(name), 000 (content).
Create a new Remittance (Financial management > Receivables and payables > Transactions). Select Cuaderno 34.
Use Create from process to enter at least, two lines.
Process it.
Create file
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00101742.40MP12 closed dalsasua Dat file for Remittance Cuaderno 34 is not correct 
Attached Files? BANK-3.DAT (1,188) 2009-08-03 13:43
https://issues.openbravo.com/file_download.php?file_id=1615&type=bug
? BANK.DAT (1,260) 2009-08-04 08:30
https://issues.openbravo.com/file_download.php?file_id=1620&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-08-03 13:43networkbNew Issue
2009-08-03 13:43networkbAssigned To => rafaroda
2009-08-03 13:43networkbFile Added: BANK-3.DAT
2009-08-03 13:49azabaletaIssue Monitored: azabaleta
2009-08-03 14:07rafarodaNote Added: 0018797
2009-08-03 14:07rafarodaAssigned Torafaroda => dalsasua
2009-08-03 14:07rafarodaPriorityimmediate => high
2009-08-03 14:07rafarodaNote Edited: 0018797
2009-08-03 19:26dalsasuaNote Added: 0018800
2009-08-03 19:26dalsasuaStatusnew => feedback
2009-08-04 08:19networkbNote Added: 0018805
2009-08-04 08:19networkbStatusfeedback => new
2009-08-04 08:27dalsasuaNote Added: 0018806
2009-08-04 08:27dalsasuaStatusnew => feedback
2009-08-04 08:30dalsasuaFile Added: BANK.DAT
2009-08-04 09:53rafarodaNote Added: 0018810
2009-08-04 10:29dalsasuaStatusfeedback => scheduled
2009-08-04 10:29dalsasuaNote Added: 0018814
2009-08-04 10:29dalsasuafix_in_branch => pi
2009-08-12 10:26networkbTarget Version => 2.50MP4
2009-08-12 10:26networkbfix_in_branchpi =>
2009-08-12 12:30networkbSeverityminor => major
2009-08-18 09:36dalsasuaNote Edited: 0018814
2009-08-20 13:01dalsasuaNote Edited: 0018814
2009-08-20 18:09hgbotCheckin
2009-08-20 18:09hgbotNote Added: 0019137
2009-08-20 18:09hgbotStatusscheduled => resolved
2009-08-20 18:09hgbotResolutionopen => fixed
2009-08-20 18:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6eaf0aea2ddf8d79d5f1799996522400d4779b29 [^]
2009-08-20 18:22hgbotCheckin
2009-08-20 18:22hgbotNote Added: 0019138
2009-08-20 18:22hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6eaf0aea2ddf8d79d5f1799996522400d4779b29 [^] => http://code.openbravo.com/erp/devel/pi/rev/1ee7c2cc0f7226a364e8bdc5840f583947887e08 [^]
2009-08-28 09:22azabaletaIssue End Monitor: azabaleta
2009-08-28 09:31plujanStatusresolved => closed
2009-08-28 09:31plujanNote Added: 0019244
2009-08-29 00:00anonymoussf_bug_id0 => 2846543

Notes
(0018797)
rafaroda   
2009-08-03 14:07   
David,

Could you please take action on this issue?

Thanks.
(0018800)
dalsasua   
2009-08-03 19:26   
I cannot reproduce the issue. The file I obtain has all lines with length 72, hasn't got any dot in the 39th column.
Actions to be taken by now are:
Add first line of the address to the file
I don't understand the sentence "The last line must show total recipient (one for each line), not total sender."

Regards,
David
(0018805)
networkb   
2009-08-04 08:19   
Please, have a look at attached file. Second line has no data (it does not show any address).

Related to last line, it shows in the middle of lots of '0', one '1'. This number must show the total of bussiness partners in lines, but it only counts the number of business partners that sends the file (only one, the organization)
(0018806)
dalsasua   
2009-08-04 08:27   
attached file is useless, if I don't know which payments where included. I have obtained a file that do not present the problems related here about the line wide and dot character, and the bug reproducibility says always.

btw, is it a ops bug? is the priority correctly set?

Regards.
(0018810)
rafaroda   
2009-08-04 09:53   
David, it is a OBPS issue and both the severity and priority are correct. Let's wait for the feedback.
(0018814)
dalsasua   
2009-08-04 10:29   
(edited on: 2009-08-20 13:01)
After doing a research with the consultant we found out the problem, and the issue was completely defined.

This are the problems must be researched:

1. Sometimes the line width is 73 instead of 72
2. Last line must show total number of recipients, and always show number of senders (that always is one).
3. Sometimes, and only in postgresql, some lines show a dot in the middle of a number. File only allows to include numbers and letters.
4. Charset of the file must UTF-8
(0019137)
hgbot   
2009-08-20 18:09   
Repository: erp/devel/pi
Changeset: 6eaf0aea2ddf8d79d5f1799996522400d4779b29
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu Aug 20 18:09:13 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6eaf0aea2ddf8d79d5f1799996522400d4779b29 [^]

Fixes issue 10163: Dat file for Remittance Cuaderno 34 is not correct

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFile.java
M src/org/openbravo/erpCommon/ad_actionButton/CreateFile34_data.xsql
---
(0019138)
hgbot   
2009-08-20 18:22   
Repository: erp/devel/pi
Changeset: 1ee7c2cc0f7226a364e8bdc5840f583947887e08
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu Aug 20 18:21:50 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1ee7c2cc0f7226a364e8bdc5840f583947887e08 [^]

Fixes issue 10163: Dat file for Remittance Cuaderno 34 is not correct

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFile.java
---
(0019244)
plujan   
2009-08-28 09:31   
The fix was applied in a customer's site and it seems to work.