Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002415Openbravo ERP03. Procurement managementpublic2007-12-27 11:502008-07-04 18:49
Reporterrafaroda 
Assigned Torafaroda 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40beta 
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
Summary0002415: AT235MP1: Amount issues in Purchase Dimensional Report
Description*Environment
OS: Unbuntu 7.04
DB: Oracle XE 10g
OB: R2.35 MP1
Web browser: Firefox 2

*Steps
1. Procurement Management > Analysis Tools > Purchase Dimensional Report.
2. Fill required dates.
3. Fill 'Amount greater than' and 'Less than' text fields.
4. Click on 'HTML format' or on 'PDF format' button.
5. 'ORA-00904: "AMOUNT": identificador no válido' error displays in pop-up window.

'Amount' fields seem not to be taken into account in report creation.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003589 closed rafaroda AT235MP1: Amount issues in Purchase Dimensional  
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-04 18:49plujanStatusresolved => closed
2008-07-04 18:49plujanFixed in Version2.40alpha-r2 => 2.40beta

Notes
(0006004)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1858870 [^]
(0002867)
rafaroda   
2008-01-09 09:20   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1892190
Originator: YES

Orthographic mistakes: 'Busines' instead of 'Business'.
(0002868)
rafaroda   
2008-01-11 15:08   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1892190
Originator: YES

Typo 'Busines' reported in a new bug: https://sourceforge.net/tracker/index.php?func=detail&aid=1869328&group_id=162271&atid=823129 [^]
(0002869)
rafaroda   
2008-01-11 15:10   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1892190
Originator: YES

Changed 'HAVING SUM(AMOUNT)' by 'HAVING SUM(LINENETAMT)' in 'ReportPurchaseDimensionalAnalysesJR.java' file.