Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008240Openbravo ERP07. Sales managementpublic2009-03-18 11:272009-03-26 11:02
Reporterthirumalai 
Assigned Toshuehner 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionFedora 9
Product Version2.40 
Target VersionFixed in Version2.40MP4 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008240: Cannot able to view grid in Commission payment
Description
Sales Management || Transactions || Commission Payment || Header >> Amounts >> Details

Grid view says -->ORA-00918: column ambiguously defined

Note:No change was done by us.
Steps To Reproduce1.Sales management >> Setup >> Sales commission
2.Create a header and process Generate commission.
3.It shows commission payment document no.
4.Retrieve that document no in Sales Management >> Transactions >> Commission Payment
5.Go to Header >> Amounts >> Details

Grid view says -->ORA-00918: column ambiguously defined
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0008191 closed shuehner Cannot able to view grid in Commission payment 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-03-23 18:35shuehnerTypedefect => backport
2009-03-23 18:35shuehnerfix_in_branch => 2.40
2009-03-23 19:22hgbotCheckin
2009-03-23 19:22hgbotNote Added: 0014874
2009-03-23 19:22hgbotStatusscheduled => resolved
2009-03-23 19:22hgbotResolutionopen => fixed
2009-03-23 19:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/87f53a41d2aeb130a5d90f9d11be199d833db61c [^]
2009-03-24 11:01psarobeFixed in Version => 2.40MP4
2009-03-26 11:02sureshbabuRegression testing => No
2009-03-26 11:02sureshbabuStatusresolved => closed
2009-03-26 11:02sureshbabuNote Added: 0014985

Notes
(0014874)
hgbot   
2009-03-23 19:22   
Repository: erp/stable/2.40
Changeset: 87f53a41d2aeb130a5d90f9d11be199d833db61c
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon Mar 23 19:18:37 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/87f53a41d2aeb130a5d90f9d11be199d833db61c [^]

Fixed 8240. Fix SQL generation for grid view with TableDir and target table pk.isidentifier='Y'

---
M src/org/openbravo/erpCommon/utility/TableSQLData.java
---
(0014985)
sureshbabu   
2009-03-26 11:02   
Tested working fine