0010802: 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 ]

blocks

defect

0010747

closed

harikrishnan

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

Notes
(0020802) hgbot (developer) 2009-10-07 07:53	Repository: erp/stable/2.40 Changeset: 650568609a4f28859ec6788b74369e4deae288fe Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com> Date: Wed Oct 07 11:22:31 2009 +0530 URL: http://code.openbravo.com/erp/stable/2.40/rev/650568609a4f28859ec6788b74369e4deae288fe [^] Fixes Issue 10802: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 ---

(0020975) arunkumar (reporter) 2009-10-13 11:16	Credit used field is being updated in the customer tab after completing the sales invoice.This issue is fixed.I will close this.

Issue History
Date Modified	Username	Field	Change
2009-09-29 06:27	rafaroda	Type	defect => backport
2009-09-29 06:27	rafaroda	fix_in_branch	=> 2.40
2009-10-07 07:18	harikrishnan	Assigned To	rafaroda => harikrishnan
2009-10-07 07:53	hgbot	Checkin
2009-10-07 07:53	hgbot	Note Added: 0020802
2009-10-07 07:53	hgbot	Status	scheduled => resolved
2009-10-07 07:53	hgbot	Resolution	open => fixed
2009-10-07 07:53	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.40/rev/650568609a4f28859ec6788b74369e4deae288fe [^]
2009-10-13 11:16	arunkumar	Status	resolved => closed
2009-10-13 11:16	arunkumar	Note Added: 0020975
2009-10-13 11:16	arunkumar	Fixed in Version	=> 2.40MP10