0005162: Is not possible to change the alias in Account Combination window

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0005162

Openbravo ERP

09. Financial management

public

2008-09-22 18:01

2009-05-21 16:37

Reporter

networkb

Assigned To

vmromanos

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.35MP5

Target Version

Fixed in Version

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

0005162: Is not possible to change the alias in Account Combination window

Description

It is currently not possible to modify the alias in window: Account Combination, as the alias in Valid Combination is overwritten by the value of the Element Value via a trigger.

Steps To Reproduce

Financial Management>Accounting>Setup>Account Combination

Change the Alias and save

Proposed Solution

Modify the C_VALIDCOMBINATION_TRG so that whenever the alias in Account
Combination is empty, the value from Element Value is used. Whenever the alias is filled, it will not update from elementvalue anymore.

Modify

IF (Cur_AC%NOTFOUND) THEN -- mandatory
v_IsFullyQualified := 'N';
ELSE
:new.Alias := v_TempValue; --Alias is the account no
END IF;

to:

IF (Cur_AC%NOTFOUND) THEN -- mandatory
v_IsFullyQualified := 'N';
ELSE
IF (:old.Alias is null) THEN
:new.Alias := v_TempValue; --Alias is the account no
END IF;
END IF;

Attached you fill find the modified C_VALIDCOMBINATION_TRG

Additional Information