Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011959Openbravo ERP09. Financial managementpublic2010-01-13 13:242019-10-02 14:36
Reporternetworkb 
Assigned Torafaroda 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP11 
Target VersionFixed in Version2.40MP12 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011959: 347 does not group by Fiscal name
Description347 model group by commercial name instead of Fiscal name.

It must be the other way
Steps To ReproduceGo to Financial Management > Accounting > Anaylisys tools > Generate 347 model.
Enter two dates process it.
See the name used in the report
Proposed SolutionGroup by name2 instead of name
Additional Information
TagsNo tags attached.
Relationships
related to backport 00116992.40MP12 closed rafaroda 347 model does not group by Tax ID 
blocks defect 0011958 closed rafaroda 347 does not group by Fiscal name 
Attached Filesdiff patch-issue-11959.diff (2,358) 2010-01-13 18:14
https://issues.openbravo.com/file_download.php?file_id=2122&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-01-13 14:18rafarodaTypedefect => backport
2010-01-13 14:18rafarodafix_in_branch => 2.40
2010-01-13 14:18rafarodaRelationship addedrelated to 0011699
2010-01-13 18:14rafarodaFile Added: patch-issue-11959.diff
2010-01-13 18:15rafarodaNote Added: 0023399
2010-01-13 18:15rafarodaStatusscheduled => closed
2010-01-13 18:15rafarodaResolutionopen => no change required
2010-01-19 10:16hgbotCheckin
2010-01-19 10:16hgbotNote Added: 0023554
2010-01-19 10:16hgbotStatusclosed => resolved
2010-01-19 10:16hgbotResolutionno change required => fixed
2010-01-19 10:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/dcaa885db0d946ad03e73f0164e95562b258e8c7 [^]
2010-02-15 11:14arunkumarNote Added: 0024254
2010-02-15 11:14arunkumarStatusresolved => closed
2010-02-15 11:14arunkumarFixed in Version => 2.40MP12
2019-10-02 14:35LeyreIssue Monitored: Leyre
2019-10-02 14:36LeyreIssue End Monitor: Leyre

Notes
(0023399)
rafaroda   
2010-01-13 18:15   
"Name 2" field inside Business Partner window may or may not be used as the "Fiscal Name". If you want this "Name 2" field to display in the 347 report as the "Fiscal Name" just apply the patch attached.

The action performed in the code has been swapping BP.NAME and BP.NAME2 in the lines 170 (method selectNavarraType2) [1] and 435 (method selectAEATType2) [2] of file src/org/openbravo/erpCommon/ad_reports/GenerateModel347_data.xsql [3]

[1] https://code.openbravo.com/erp/stable/2.40/file/7d0e4f6fe554/src/org/openbravo/erpCommon/ad_reports/GenerateModel347_data.xsql#l170 [^]
[2] https://code.openbravo.com/erp/stable/2.40/file/7d0e4f6fe554/src/org/openbravo/erpCommon/ad_reports/GenerateModel347_data.xsql#l435 [^]
[3] https://code.openbravo.com/erp/stable/2.40/file/7d0e4f6fe554/src/org/openbravo/erpCommon/ad_reports/GenerateModel347_data.xsql [^]
(0023554)
hgbot   
2010-01-19 10:16   
Repository: erp/stable/2.40
Changeset: dcaa885db0d946ad03e73f0164e95562b258e8c7
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Sun Jan 17 21:39:34 2010 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/dcaa885db0d946ad03e73f0164e95562b258e8c7 [^]

Fixes issue 11959 347 report is now grouped by Fiscal Name (Name 2).

---
M src/org/openbravo/erpCommon/ad_reports/GenerateModel347_data.xsql
---
(0024254)
arunkumar   
2010-02-15 11:14   
Based on the proposed solution the fix is made.BP.NAME is replaced by BP.NAME2.