Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010747 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | major | have not tried | 2009-09-24 16:37 | 2009-10-21 00:00 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | harikrishnan | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP7 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 3d3792007d0c | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP3 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0010747: The ad_clientinfo.C_AcctSchema1_ID column is not filled when executing a initial client setup | |||||||
| Description | The 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 Solution | C_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 [^] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
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 |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |