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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027363
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2014-08-18 20:102014-08-21 11:19
ReporterjecharriView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityimmediateResolutionfixedFixed in Version3.0PR14Q4
StatusclosedFix in branchFixed in SCM revision723fbb6fcb2a
ProjectionnoneETAnoneTarget Version3.0PR14Q3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tojecharri
Web browserGoogle Chrome
ModulesCore
Regression levelProduction - QA Approved
Regression date2014-07-01
Regression introduced in release3.0PR14Q3
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/b1843f200a9092eea99d431776d029a09868615a [^]
Triggers an Emergency PackNo
Summary

0027363: It exists a case where the currency is not set to business partners and can create big problems

DescriptionIt exists a case where the currency is not set to business partners and can create big problems because it is impossible to create payment in or payment out because the JAVA is trying to get the currency.

file
modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_PaymentProcess.java
line
String toCurrency = businessPartner.getCurrency().getId();

Steps To ReproduceThe problem is the module script of the above changeset. It can happens that update return null.
It happens when the BP is checked as "bp.iscustomer='Y' " and price list is null but " bp.isvendor='Y' " and has a price list.


UPDATE C_Bpartner bp
         SET BP_Currency_ID = (
                              SELECT C_Currency_ID
                              FROM M_Pricelist
                              WHERE M_Pricelist_ID=(case when bp.iscustomer='Y' then bp.M_Pricelist_ID
                                                         when bp.isvendor='Y' then bp.PO_Pricelist_ID
                                                         end)
                              )
         WHERE bp.BP_Currency_ID IS NULL
         AND ((bp.IsCustomer = 'Y' and bp.m_pricelist_id is not null) OR
              (bp.IsVendor = 'Y' and bp.po_pricelist_id is not null));
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0069534)
hgbot (developer)
2014-08-20 07:57

 Repository: erp/devel/pi
Changeset: 723fbb6fcb2a9b08ea15e243979141008c6a0686
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Aug 19 15:28:48 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/723fbb6fcb2a9b08ea15e243979141008c6a0686 [^]

Fixes Issue 27363:Exists a case where currency is not set to business partner
and could create big problems.

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeBPCurrency.class
M src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeBPCurrencyData.class
M src-util/modulescript/src/org/openbravo/modulescript/InitializeBPCurrency.java
M src-util/modulescript/src/org/openbravo/modulescript/InitializeBPCurrency_data.xsql
A src-util/modulescript/build/javasqlc/src/org/openbravo/modulescript/InitializeBPCurrencyData.java
---
(0069552)
hudsonbot (developer)
2014-08-20 15:14

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/2b6fe7d2babe [^]
Maturity status: Test
(0069562)
daniOpenbravo (developer)
2014-08-21 11:19

 Verified.

- Issue History
Date Modified Username Field Change
2014-08-18 20:10 jecharri New Issue
2014-08-18 20:10 jecharri Assigned To => dmiguelez
2014-08-18 20:10 jecharri Web browser => Google Chrome
2014-08-18 20:10 jecharri Modules => Core
2014-08-18 20:10 jecharri Resolution time => 1408744800
2014-08-18 20:10 jecharri Regression level => Production - QA Approved
2014-08-18 20:10 jecharri Regression date => 2014-07-01
2014-08-18 20:10 jecharri Regression introduced in release => 3.0PR14Q3
2014-08-18 20:10 jecharri Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/b1843f200a9092eea99d431776d029a09868615a [^]
2014-08-18 20:10 jecharri Triggers an Emergency Pack => No
2014-08-18 20:34 heccam Issue Monitored: heccam
2014-08-18 20:41 jecharri Web browser Google Chrome => Google Chrome
2014-08-18 20:41 jecharri Summary Sometimes the currency is not set to business partners and can create big problems => It exists a case where the currency is not set to business partners and can create big problems
2014-08-18 20:41 jecharri Description Updated View Revisions
2014-08-19 08:46 AtulOpenbravo Assigned To dmiguelez => AtulOpenbravo
2014-08-19 08:50 AtulOpenbravo Status new => scheduled
2014-08-19 08:50 AtulOpenbravo fix_in_branch => pi
2014-08-20 07:55 AtulOpenbravo Review Assigned To => jecharri
2014-08-20 07:55 AtulOpenbravo Web browser Google Chrome => Google Chrome
2014-08-20 07:55 AtulOpenbravo fix_in_branch pi =>
2014-08-20 07:57 hgbot Checkin
2014-08-20 07:57 hgbot Note Added: 0069534
2014-08-20 07:57 hgbot Status scheduled => resolved
2014-08-20 07:57 hgbot Resolution open => fixed
2014-08-20 07:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/723fbb6fcb2a9b08ea15e243979141008c6a0686 [^]
2014-08-20 15:14 hudsonbot Checkin
2014-08-20 15:14 hudsonbot Note Added: 0069552
2014-08-21 11:19 daniOpenbravo Note Added: 0069562
2014-08-21 11:19 daniOpenbravo Status resolved => closed
2014-08-21 11:19 daniOpenbravo Fixed in Version => 3.0PR14Q4

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker