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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010174
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementminoralways2009-08-03 13:432009-11-12 12:02
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision96eff736e731
ProjectionnoneETAnoneTarget Version2.40MP12
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010174: 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 needed (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
Tagsmain
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 00101632.50MP4 closeddalsasua Dat file for Remittance Cuaderno 34 is not correct 

-  Notes
(0019092)
rafaroda (developer)
2009-08-20 11:39

Removed OBPS information since it was reported by OBPS customer in 2.50 version. Nevertheless backport remains open since it is desirable to have this fixed in 2.40 version also.
(0020811)
rafaroda (developer)
2009-10-07 08:59

Made OBPS requested by MAL.
(0021055)
hgbot (developer)
2009-10-15 13:26

Repository: erp/stable/2.40
Changeset: 96eff736e731b4613ad5962faf13210aca0a267f
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Oct 13 11:33:12 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/96eff736e731b4613ad5962faf13210aca0a267f [^]

Fixes issue 10174: 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
---
(0021716)
sureshbabu (reporter)
2009-11-11 12:27

I am getting an error “Tax identification number needed” while creating the File..Please find the steps below which i followed to retest the Fix.

Precondition: Created two sales invoices for BP: Red Bunny

 
Generate Remittance type "Cuaderno 34" (Financial management > Receivables and payables > Setup > Remittance type)

Name: Cuaderno 34. (Note: I left blank for the fields Consolidate, Final status, Returned status) and clicked save button

Then I moved to Parameter tab and created two lines:

Cuaderno (name), 34 (content)
Contract (name), 000 (content)

Create a new Remittance (Financial management > Receivables and payables > Transactions). Select Cuaderno 34.
Using “Create lines from” process to enter the above created invoice lines created in precondition and then moved back to header and clicked the “Process” button to process it.

I got an error as “Error: NotNullError: C_DP_MANAGEMENTLINE - STATUS_TO”

 

Then I moved to Financial Management || Receivables & Payables || Setup || Remittance Type || Remittance Type and selected the above created Remittance type Cuaderno 34 and changed the Final status field value to “In Remittance”

Move to Financial Management || Receivables & Payables || Transactions || Remittance || Header and clicked the process button.
“Process completed successfully” message appears.

Then I clicked the Create File button,
I got an error as “Tax identification number needed”
(0021719)
sureshbabu (reporter)
2009-11-11 13:05

0356 987654321 0011111091111090000000000000000000 00
0356 987654321 002BIGBAZAAR
0356 987654321 003POL. IND. LANDABEN CALLE J EDIF. SLA
0356 987654321 004PAMPLONA
0656 987654321 12345678A01000000001345612345678123456789011 90
0656 987654321 12345678A011RED BUNNY
0656 987654321 12345678A012CARROT STREET
0656 987654321 12345678A01444578CARROT
0656 987654321 12345678A015HUELVA
0656 987654321 12345678A016* 100043 * ( )
0656 987654321 12345678A01000000020706012345678123456789011 90
0656 987654321 12345678A011RED BUNNY
0656 987654321 12345678A012CARROT STREET
0656 987654321 12345678A01444578CARROT
0656 987654321 12345678A015HUELVA
0656 987654321 12345678A016* 100044 * ( )
0856 987654321 000000220516000000020000000017

****************
I have attached the details of the remittance file above and my findings are

Third line not showing Organization complete address (Address given in the application as Pol. Ind. Landaben calle J - Edif. Slan 1ªplanta - 31012 - Pamplona - NAVARRA - Spain but in the file the address is truncated) and in the defect description it is mentioned as The third line must has 72 characters (mandatory).)

As per the defect description, *The last line must show total recipient (one for each line), not total sender. -- but i am not finding the mentioned details
(0021769)
plujan (manager)
2009-11-12 12:02

Raised an extra issue about the wrong message

- Issue History
Date Modified Username Field Change
2009-08-04 10:29 dalsasua Type defect => backport
2009-08-04 10:29 dalsasua fix_in_branch => 2.40
2009-08-20 11:39 rafaroda Note Added: 0019092
2009-08-20 11:39 rafaroda Reporter networkb => dalsasua
2009-08-20 11:39 rafaroda Description Updated
2009-10-07 08:59 rafaroda Note Added: 0020811
2009-10-07 08:59 rafaroda Reporter dalsasua => networkb
2009-10-07 08:59 rafaroda version 2.50MP3 => 2.40
2009-10-07 08:59 rafaroda Target Version => 2.40MP12
2009-10-09 11:34 networkb Priority high => immediate
2009-10-15 13:26 hgbot Checkin
2009-10-15 13:26 hgbot Note Added: 0021055
2009-10-15 13:26 hgbot Status scheduled => resolved
2009-10-15 13:26 hgbot Resolution open => fixed
2009-10-15 13:26 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/96eff736e731b4613ad5962faf13210aca0a267f [^]
2009-10-22 19:26 psarobe Tag Attached: main
2009-11-11 12:27 sureshbabu Note Added: 0021716
2009-11-11 13:05 sureshbabu Note Added: 0021719
2009-11-12 12:02 plujan Note Added: 0021769
2009-11-12 12:02 plujan Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker