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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010747
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajorhave not tried2009-09-24 16:372009-10-21 00:00
ReporteregoitzView Statuspublic 
Assigned Toharikrishnan 
PriorityurgentResolutionfixedFixed in Version2.50MP7
StatusclosedFix in branchpiFixed in SCM revision3d3792007d0c
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010747: The ad_clientinfo.C_AcctSchema1_ID column is not filled when executing a initial client setup

DescriptionThe ad_clientinfo.C_AcctSchema1_ID column is not filled when executing a initial client setup. This column is used by the c_base_convert fuction.

The sql used is the following
SELECT MAX(ac.C_Currency_ID)
    INTO v_CurTo_ID
    FROM AD_ClientInfo ci,
      C_AcctSchema ac
    WHERE ci.C_AcctSchema1_ID=ac.C_AcctSchema_ID
      AND ci.AD_Client_ID=p_Client_ID;

so if the column is not filled the query does not return anything.
Steps To Reproduce-Execute the initial client setup process.
-Execute the following query to see if the new client has been created filling the column

SELECT ci.ad_client_id, ci.C_AcctSchema1_ID
      FROM AD_ClientInfo ci order by created desc;

To steps the base_convert function you can do the following:
-Create a new client using the initial cliente setup process.
-Create a conversion rate from USD to EURO
-Create a pricelist with foreign key USD
-Create a product with price in the new pricelist
-Create a customer with the pricelist created.
-Create an invoice using the cusomter created. Automatically the pricelist with
foreing currency will be selected.
-Add a line with the product created with priceslist with foreing key.
-complete the invoice.
-See that the used credit of the partner has not been created.
-This is because the base_convert function does not return nothing.
Proposed SolutionC_BASE_CONVERT function [1] has to take the currency from client's base currency [2].

[1] https://code.openbravo.com/erp/devel/pi/file/846b8f66d69f/src-db/database/model/functions/C_BASE_CONVERT.xml [^]
[2] https://dev.openbravo.com/websvn/openbravo/?op=comp&compare[]=%2F@8886&compare[]=%2F@8887 [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0005564 closedrafaroda Multi currency issues in some processes and tables 
depends on backport 0010802 closedharikrishnan The ad_clientinfo.C_AcctSchema1_ID column is not filled when executing a initial client setup 
has duplicate defect 0010890 closedshuehner Invoice selector does not work for new clients 

-  Notes
(0020349)
rafaroda (developer)
2009-09-25 06:57

Please provide Target Version and steps to test C_Base_Convert function.

Thanks.
(0020806)
hgbot (developer)
2009-10-07 08:10

Repository: erp/devel/pi
Changeset: 3d3792007d0cab8ec025535dc8121d98fa3bb955
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Oct 07 11:39:39 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/3d3792007d0cab8ec025535dc8121d98fa3bb955 [^]

Fixes Issue 10747:The ad_clientinfo.C_AcctSchema1_ID column is not filled when executing a initial client setup

---
M src-db/database/model/functions/C_BASE_CONVERT.xml
---
(0021207)
arunkumar (reporter)
2009-10-20 12:30

Tested & Working fine

- Issue History
Date Modified Username Field Change
2009-09-24 16:37 networkb New Issue
2009-09-24 16:37 networkb Assigned To => rafaroda
2009-09-25 06:57 rafaroda Note Added: 0020349
2009-09-25 06:57 rafaroda Status new => feedback
2009-09-25 07:01 rafaroda Steps to Reproduce Updated
2009-09-25 07:01 rafaroda Relationship added related to 0005564
2009-09-28 10:31 egoitz Reporter networkb => egoitz
2009-09-28 10:31 egoitz Status feedback => new
2009-09-28 10:31 egoitz Proposed Solution updated
2009-09-29 06:27 rafaroda Priority immediate => urgent
2009-09-29 06:27 rafaroda Status new => scheduled
2009-09-29 06:27 rafaroda fix_in_branch => pi
2009-10-07 07:18 harikrishnan Assigned To rafaroda => harikrishnan
2009-10-07 08:10 hgbot Checkin
2009-10-07 08:10 hgbot Note Added: 0020806
2009-10-07 08:10 hgbot Status scheduled => resolved
2009-10-07 08:10 hgbot Resolution open => fixed
2009-10-07 08:10 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3d3792007d0cab8ec025535dc8121d98fa3bb955 [^]
2009-10-20 12:30 arunkumar Status resolved => closed
2009-10-20 12:30 arunkumar Note Added: 0021207
2009-10-20 12:30 arunkumar Fixed in Version => 2.50MP7
2009-10-21 00:00 anonymous sf_bug_id 0 => 2882768
2009-10-22 16:52 shuehner Relationship added has duplicate 0010890


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker