0010747: 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

0010747

Openbravo ERP

01. General setup

public

2009-09-24 16:37

2009-10-21 00:00

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.50MP7

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

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

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0005564	closed	rafaroda	Multi currency issues in some processes and tables
depends on	backport	0010802	closed	harikrishnan	The ad_clientinfo.C_AcctSchema1_ID column is not filled when executing a initial client setup
has duplicate	defect	0010890	closed	shuehner	Invoice selector does not work for new clients