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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0010802

Openbravo ERP

01. General setup

public

2009-09-24 16:37

2009-10-13 11:16

Reporter

egoitz

Assigned To

harikrishnan

Priority

urgent

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.50MP3

Target Version

Fixed in Version

2.40MP10

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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 [^]

Additional Information