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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010765
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-09-25 10:292009-10-16 00:00
ReportervmromanosView Statuspublic 
Assigned Torafaroda 
PriorityurgentResolutionfixedFixed in Version2.50MP7
StatusclosedFix in branchFixed in SCM revisiona9c727298086
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6
OS VersionUbuntu 8.04Database version8.3.7Ant version1.7.0
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010765: Wrong sql in C_TAX_ACCT_TRG trigger

DescriptionThe following query is wrong:

SELECT *
      FROM C_AcctSchema_Default d
      WHERE EXISTS
        (
      SELECT 1
      FROM AD_Org_AcctSchema
      WHERE AD_IsOrgIncluded(AD_Org_ID, new.AD_ORG_ID, new.AD_Client_ID)<>-1
      AND IsActive = 'Y'
      AND AD_Org_AcctSchema.C_AcctSchema_ID = d.C_AcctSchema_ID
        )

1- The queries should be filtered by AD_Client_ID
2- The use of the AD_IsOrgIncluded function should be:
AD_IsOrgIncluded(new.AD_ORG_ID, AD_Org_ID, new.AD_Client_ID) because we want to get the acct schema of the organization and its parents
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0005863 closededuardo_Argal Triggers for accounting are wrong 

-  Notes
(0020870)
hgbot (developer)
2009-10-08 11:01

Repository: erp/devel/pi
Changeset: a9c7272980861e949f096f383d76da5709bb663f
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu Oct 08 11:01:25 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a9c7272980861e949f096f383d76da5709bb663f [^]

Fixes issue 10765: Wrong sql in C_TAX_ACCT_TRG trigger

---
M src-db/database/model/triggers/C_TAX_TRG.xml
---
(0021030)
arunkumar (reporter)
2009-10-15 11:41

Tested & Working fine.

- Issue History
Date Modified Username Field Change
2009-09-25 10:29 vmromanos New Issue
2009-09-25 10:29 vmromanos Assigned To => rafaroda
2009-09-25 10:29 vmromanos Relationship added related to 0005863
2009-09-29 23:11 psarobe Priority normal => urgent
2009-09-29 23:11 psarobe Status new => scheduled
2009-10-08 11:01 hgbot Checkin
2009-10-08 11:01 hgbot Note Added: 0020870
2009-10-08 11:01 hgbot Status scheduled => resolved
2009-10-08 11:01 hgbot Resolution open => fixed
2009-10-08 11:01 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a9c7272980861e949f096f383d76da5709bb663f [^]
2009-10-15 11:41 arunkumar Status resolved => closed
2009-10-15 11:41 arunkumar Note Added: 0021030
2009-10-15 11:41 arunkumar Fixed in Version => 2.50MP7
2009-10-16 00:00 anonymous sf_bug_id 0 => 2880177


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker