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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011699
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2009-11-30 10:562010-02-15 12:15
ReporternetworkbView Statuspublic 
Assigned Torafaroda 
PriorityurgentResolutionfixedFixed in Version2.40MP12
StatusclosedFix in branchpiFixed in SCM revision7d0e4f6fe554
ProjectionnoneETAnoneTarget Version2.40MP12
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP11SCM revision 
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
Summary

0011699: 347 model does not group by Tax ID

Description347 model does not group by Tax ID if two BP has the same Tax ID.
Steps To ReproduceGo 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to backport 0011959 closedrafaroda 347 does not group by Fiscal name 
blocks defect 00115472.40MP12 closedvinothbabu 347 model does not group by Tax ID 

-  Notes
(0023039)
vinothbabu (viewer)
2009-12-23 14:20

 when click on "Html Format" in the report of Generate 347 model , 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?
(0023052)
psarobe (viewer)
2009-12-24 11:23

 11699: There is no doubt on this. In 240 we don't have modularity so you have to fix in the current report that is present
(0023178)
hgbot (developer)
2009-12-31 09:41

 Repository: erp/stable/2.40
Changeset: 1b99e7068738341b38656bca249a3f67fd05d5eb
Author: Vinoth Babu <vinoth.babu <at> openbravo.com>
Date: Thu Dec 31 14:09:23 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/1b99e7068738341b38656bca249a3f67fd05d5eb [^]

Fixes the bug 11699 grouping by Tax ID

---
M src/org/openbravo/erpCommon/ad_reports/GenerateModel347_data.xsql
---
(0023179)
psarobe (viewer)
2009-12-31 10:48

 Vinoth,

It is not properly fixed. You have to substitute c_bpartner_id by taxid
(0023397)
hgbot (developer)
2010-01-13 17:58

 Repository: erp/stable/2.40
Changeset: 7d0e4f6fe554a227dfc89d440ae0f7f93ae4f20b
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Wed Jan 13 17:56:19 2010 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/7d0e4f6fe554a227dfc89d440ae0f7f93ae4f20b [^]

Fixes issue 11699 347 Report is now grouping by Tax ID

---
M src/org/openbravo/erpCommon/ad_reports/GenerateModel347_data.xsql
---
(0023398)
rafaroda (viewer)
2010-01-13 18:00

 Steps to test the fix:

From a functional side, we will create different business partners for different store locations but each of these business partners will have the same Tax ID (NIF) since they are really the same company. This is not the correct way of defining different locations for the same business partner (Tax ID should be an unique constraint) but let's assume the following scenario.

1) Create a new business partner named "My Store Bilbao" with Tax ID = 111 and Business Partner category = Standard.
1.1) Create a new location for this business partner with address "My Street - - 10000 - Bilbao - VIZCAYA - Spain"
1.2) In Customer tab select Price List = General Sales; Form of Payment = Cash; Payment Terms = Fifteen days
1.3) In Vendor/Creditor tab select Purchase Price List = Purchase; Form of Payment = Cheque; Payment Terms = Immediate
1.4) Create and complete a purchase invoice for business partner "My Store Bilbao" with quantity > 5.000
1.5) Create and complete a sales invoice for business partner "My Store Bilbao" with quantity > 5.000

2) Create a new business partner named "My Store Vitoria 1" with Tax ID = 111 and Business Partner category = Standard.
2.1) Create a new location for this business partner with address "My Street - - 20000 - Vitoria - ALAVA - Spain"
2.2) In Customer tab select Price List = General Sales; Form of Payment = Cash; Payment Terms = Fifteen days (the same as 1)
2.3) In Vendor/Creditor tab select Purchase Price List = Purchase; Form of Payment = Cheque; Payment Terms = Immediate (the same as 1)
2.4) Create and complete a purchase invoice for business partner "My Store Vitoria 1" with quantity > 5.000
2.5) Create and complete a sales invoice for business partner "My Store Vitoria 1" with quantity > 5.000

3) Create a new business partner named "My Store Vitoria 2" with Tax ID = 111 and Business Partner category = Standard.
3.1) Create a new location for this business partner with address "My Street - - 20000 - Vitoria - ALAVA - Spain"
3.2) In Customer tab select Price List = General Sales; Form of Payment = Cash; Payment Terms = Fifteen days (the same as 1)
3.3) In Vendor/Creditor tab select Purchase Price List = Purchase; Form of Payment = Cheque; Payment Terms = Immediate (the same as 1)
3.4) Create and complete a purchase invoice for business partner "My Store Vitoria 2" with quantity > 5.000
3.5) Create and complete a sales invoice for business partner "My Store Vitoria 2" with quantity > 5.000

4) Create a new business partner named "Different Store" with Tax ID = 222 (this will be a different company) and Business Partner category = Standard.
4.1) Create a new location for this business partner with address "Different Street - - 10000 - Bilbao - VIZCAYA - Spain"
4.2) In Customer tab select Price List = General Sales; Form of Payment = Cash; Payment Terms = Fifteen days
4.3) In Vendor/Creditor tab select Purchase Price List = Purchase; Form of Payment = Cheque; Payment Terms = Immediate
4.4) Create and complete a purchase invoice for business partner "Different Store"
4.5) Create and complete a sales invoice for business partner "Different Store"

5) In Financial Management || Accounting || Analysis Tools || Generate 347 Model, select:
* From Date = 01-01-2010
* To Date = 01-01-2011
* Type = RD 1065/2007
* New
Click on 'HTML Format' button and the file generated should contain only 5 rows:
A) The header
B) The sales information for 'My Store' company (with tax ID = 111)
C) The purchase information for 'My Store' company (with tax ID = 111)
D) The sales information for 'Different' company (with tax ID = 222)
E) The purchase information for 'Different' company (with tax ID = 222)


Repeat this 5th step changing the Type and selecting Complementary or Sustitutive: in all the cases only these 5 lines must to appear in the file, with different formats. Without the fix, the 2 lines of 'My Store' company were 6, 2 (sales and purchase) per each business partner/store.

Known issue: the name selected for one company if there are many business partner representing this company (with the same Tax ID) is taken as the first alphanumerical business partner name. The same happens for the region digits. Since we are not working with C_BPartner_ID, there could be a mismatch between the name displayed and the region digits displayed. In any case, the relevant information in the 347 report is the Tax ID.
(0024266)
arunkumar (viewer)
2010-02-15 12:15

 Tested & Working fine

- Issue History
Date Modified Username Field Change
2009-12-09 10:55 psarobe Type defect => backport
2009-12-09 10:55 psarobe fix_in_branch => 2.40
2009-12-10 12:21 rafaroda Assigned To rafaroda => dalsasua
2009-12-23 14:20 vinothbabu Note Added: 0023039
2009-12-24 11:23 psarobe Note Added: 0023052
2009-12-31 09:41 hgbot Checkin
2009-12-31 09:41 hgbot Note Added: 0023178
2009-12-31 09:41 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/1b99e7068738341b38656bca249a3f67fd05d5eb [^]
2009-12-31 09:49 vinothbabu Assigned To dalsasua => vinothbabu
2009-12-31 09:49 vinothbabu Status scheduled => resolved
2009-12-31 10:48 psarobe Note Added: 0023179
2009-12-31 10:48 psarobe Status resolved => new
2009-12-31 10:48 psarobe Status new => scheduled
2009-12-31 10:48 psarobe fix_in_branch 2.40 => pi
2010-01-04 11:52 rafaroda Assigned To vinothbabu => rafaroda
2010-01-13 13:37 rafaroda Relationship added related to 0011958
2010-01-13 14:18 rafaroda Relationship added related to 0011959
2010-01-13 14:19 rafaroda Relationship deleted related to 0011958
2010-01-13 17:58 hgbot Checkin
2010-01-13 17:58 hgbot Note Added: 0023397
2010-01-13 17:58 hgbot Status scheduled => resolved
2010-01-13 17:58 hgbot Resolution open => fixed
2010-01-13 17:58 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.40/rev/1b99e7068738341b38656bca249a3f67fd05d5eb [^] => http://code.openbravo.com/erp/stable/2.40/rev/7d0e4f6fe554a227dfc89d440ae0f7f93ae4f20b [^]
2010-01-13 18:00 rafaroda Note Added: 0023398
2010-02-15 12:15 arunkumar Note Added: 0024266
2010-02-15 12:15 arunkumar Status resolved => closed
2010-02-15 12:15 arunkumar Fixed in Version => 2.40MP12

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker