Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011547Openbravo ERP09. Financial managementpublic2009-11-30 10:562010-01-19 01:41
networkb 
vinothbabu 
urgentmajoralways
closedfixed 
5
2.40MP11 
2.40MP122.50MP10 
OBPS
Core
No
0011547: 347 model does not group by Tax ID
347 model does not group by Tax ID if two BP has the same Tax ID.
Go to Master Data Management > Business Partner. Search two BP (IE mafalda and jonh) and fill the same Tax ID for both (IE 12345678).
Go to Sales Management > Transacctions > Sales Invoice. Create its header using one of the BP.
Create its line, with an Unit price of 50000.
Create other Sales invoice, with the other BP. Also, its price of 50000.
Go to Financial Management > Accounting > Analysis tools > Generate 347 model.
Fill From date and to date.
Press HTML and see its results.
No tags attached.
depends on backport 00116992.40MP12 closed rafaroda 347 model does not group by Tax ID 
related to defect 0011958 closed rafaroda 347 does not group by Fiscal name 
Issue History
2009-11-30 10:56networkbNew Issue
2009-11-30 10:56networkbAssigned To => rafaroda
2009-11-30 10:56networkbOBNetwork customer => Yes
2009-12-07 20:09psarobeNote Added: 0022506
2009-12-07 20:09psarobeStatusnew => feedback
2009-12-09 10:29networkbNote Added: 0022566
2009-12-09 10:29networkbStatusfeedback => new
2009-12-09 10:54psarobePriorityimmediate => urgent
2009-12-09 10:55psarobeStatusnew => scheduled
2009-12-09 10:55psarobeAssigned Torafaroda => dalsasua
2009-12-09 10:55psarobefix_in_branch => pi
2009-12-23 14:03vinothbabuAssigned Todalsasua => vinothbabu
2009-12-23 14:18vinothbabuNote Added: 0023038
2009-12-24 11:22psarobeNote Added: 0023051
2009-12-30 16:14hgbotCheckin
2009-12-30 16:14hgbotNote Added: 0023156
2009-12-30 16:14hgbotStatusscheduled => resolved
2009-12-30 16:14hgbotResolutionopen => fixed
2009-12-30 16:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d64c2db08d870e01b18b8cafbce3248c1018965a [^]
2009-12-31 08:22arunkumarNote Added: 0023175
2009-12-31 08:22arunkumarStatusresolved => closed
2009-12-31 08:22arunkumarFixed in Version => 2.50MP10
2010-01-01 00:00anonymoussf_bug_id0 => 2924330
2010-01-13 14:19rafarodaRelationship addedrelated to 0011958
2010-01-13 18:16rafarodaNote Added: 0023401
2010-01-19 01:41hudsonbotCheckin
2010-01-19 01:41hudsonbotNote Added: 0023522

Notes
(0022506)
psarobe   
2009-12-07 20:09   
Can you please provide the proposed solution? Two different bpartner with the same tax Id????
(0022566)
networkb   
2009-12-09 10:29   
Instead to group by c_bpartner_id, by taxid.
(0023038)
vinothbabu   
2009-12-23 14:18   
In PI we have the button called "Create file" in the report of Generate 347 model. But there is no "Html Format" button which is mentioned in the reproducible steps. anyhow when click on "create file button" , It is asking to download the file for DAT. In that file , I can't see the taxID values. Can you provide the screen shot to identify the results does not group by Tax id?
(0023051)
psarobe   
2009-12-24 11:22   
11547: You should deactivate the report that is currently in PI and in 240. And fix it in the module itself
(0023156)
hgbot   
2009-12-30 16:14   
Repository: erp/devel/pi
Changeset: d64c2db08d870e01b18b8cafbce3248c1018965a
Author: Vinoth Babu <vinoth.babu <at> openbravo.com>
Date: Wed Dec 30 20:41:14 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/d64c2db08d870e01b18b8cafbce3248c1018965a [^]

Fixes bug 11547 Deactivated the Generate 347 model report

---
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_PROCESS.xml
M src-db/database/sourcedata/AD_TREENODE.xml
---
(0023175)
arunkumar   
2009-12-31 08:22   
Generate 347 model report has been deactivated. Tested & working fine.
(0023401)
rafaroda   
2010-01-13 18:16   
347 report is now coded as a module http://forge.openbravo.com/projects/spainaeatmodelo347 [^]
(0023522)
hudsonbot   
2010-01-19 01:41   
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/d64c2db08d87 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7f3a35240cf9 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15846.obx [^]