0028572: Service Contract showing incorrect currency and storing incorrect currency in the table

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0028572

Modules

Service Contract Management

public

2015-01-12 17:58

2015-02-10 10:50

Reporter

VictorVillar

Assigned To

vmromanos

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

no change required

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Sandrahuguet

Support ticket

OBNetwork customer

Regression introduced in release

Summary

0028572: Service Contract showing incorrect currency and storing incorrect currency in the table

Description

It is necessary to push the commit [1] to the regular branch.

[1] https://issues.openbravo.com/view.php?id=26427 [^]

Incorrect currency is displayed on the screen and stored in the table c_project

Steps To Reproduce

1. Make sure multiple currencies are enabled in the system.
3. Create products
2. Define a price list with USD currency and include some product in the price list version. (e.g. Price list name = SUBSCRIPTION CURRENT COMMERCIAL)
3. Create a service contract header (lets call this a subscription header) using the price list as in step2.
4. Now save the header record. You will notice that it showing currency different than what is on the price list.
5. Refresh the subscription header by clicking on the refresh button in the green toolbar. You will notice that currency is refreshed to USD.
6. Now check the data in the database (we are using Oracle), currency is still the same as what was initially shown on the screen. Below is the query to check this

select c_project_id, b.c_currency_id, b.ISO_CODE
from tad.c_project a,tad.c_currency b
where a.value= <input_value> and a.c_currency_id=b.c_currency_id
;

Screenshot is attached for your reference.

We are expecting that screen will show the currency correctly the first time as well as store the currency in table correctly.

Proposed Solution

Additional Information