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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010163
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-08-03 13:432009-08-29 00:00
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision1ee7c2cc0f72
ProjectionnoneETAnoneTarget Version2.50MP4
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010163: 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
TagsNo tags attached.
Attached Files? file icon BANK-3.DAT [^] (1,188 bytes) 2009-08-03 13:43
? file icon BANK.DAT [^] (1,260 bytes) 2009-08-04 08:30

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00101742.40MP12 closeddalsasua Dat file for Remittance Cuaderno 34 is not correct 

-  Notes
(0018797)
rafaroda (developer)
2009-08-03 14:07
edited on: 2009-08-03 14:07

David,

Could you please take action on this issue?

Thanks.

(0018800)
dalsasua (reporter)
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 (developer)
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 (reporter)
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 (developer)
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 (reporter)
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 (developer)
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 (developer)
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 (manager)
2009-08-28 09:31

The fix was applied in a customer's site and it seems to work.

- Issue History
Date Modified Username Field Change
2009-08-03 13:43 networkb New Issue
2009-08-03 13:43 networkb Assigned To => rafaroda
2009-08-03 13:43 networkb File Added: BANK-3.DAT
2009-08-03 13:49 azabaleta Issue Monitored: azabaleta
2009-08-03 14:07 rafaroda Note Added: 0018797
2009-08-03 14:07 rafaroda Assigned To rafaroda => dalsasua
2009-08-03 14:07 rafaroda Priority immediate => high
2009-08-03 14:07 rafaroda Note Edited: 0018797
2009-08-03 19:26 dalsasua Note Added: 0018800
2009-08-03 19:26 dalsasua Status new => feedback
2009-08-04 08:19 networkb Note Added: 0018805
2009-08-04 08:19 networkb Status feedback => new
2009-08-04 08:27 dalsasua Note Added: 0018806
2009-08-04 08:27 dalsasua Status new => feedback
2009-08-04 08:30 dalsasua File Added: BANK.DAT
2009-08-04 09:53 rafaroda Note Added: 0018810
2009-08-04 10:29 dalsasua Status feedback => scheduled
2009-08-04 10:29 dalsasua Note Added: 0018814
2009-08-04 10:29 dalsasua fix_in_branch => pi
2009-08-12 10:26 networkb Target Version => 2.50MP4
2009-08-12 10:26 networkb fix_in_branch pi =>
2009-08-12 12:30 networkb Severity minor => major
2009-08-18 09:36 dalsasua Note Edited: 0018814
2009-08-20 13:01 dalsasua Note Edited: 0018814
2009-08-20 18:09 hgbot Checkin
2009-08-20 18:09 hgbot Note Added: 0019137
2009-08-20 18:09 hgbot Status scheduled => resolved
2009-08-20 18:09 hgbot Resolution open => fixed
2009-08-20 18:09 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6eaf0aea2ddf8d79d5f1799996522400d4779b29 [^]
2009-08-20 18:22 hgbot Checkin
2009-08-20 18:22 hgbot Note Added: 0019138
2009-08-20 18:22 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/6eaf0aea2ddf8d79d5f1799996522400d4779b29 [^] => http://code.openbravo.com/erp/devel/pi/rev/1ee7c2cc0f7226a364e8bdc5840f583947887e08 [^]
2009-08-28 09:22 azabaleta Issue End Monitor: azabaleta
2009-08-28 09:31 plujan Status resolved => closed
2009-08-28 09:31 plujan Note Added: 0019244
2009-08-29 00:00 anonymous sf_bug_id 0 => 2846543


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker