0003610: It can be changed the Organization in Processed

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0003610

Openbravo ERP

C. Security

public

2008-01-24 19:15

2008-06-12 09:44

Reporter

user71

Assigned To

user71

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

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

0003610: It can be changed the Organization in Processed

Description

Although the documents are processed, it is possible to change the
organization of these documents.

The organization can be changed in the header of the documents and in the
lines as well.

The solution is to add this code:

OR(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0'))

in the triggers

This happens in tables:

C_ORDER
C_ORDERLINE
M_INOUT
M_INOUTLINE
C_INVOICE
C_INVOICELINE
M_INVENTORY
M_MOVEMENT
GL_JOURNAL
GL_JOURNALLINE
A_AMORTIZATION
C_BANKSTATEMENT
C_BANKSTATEMENTLINE
C_CASH
C_CASHLINE
C_REMITTANCE
C_REMITTANCELINE
C_SETTLEMENT
C_DP_MANAGEMENT
C_DP_MANAGEMENTLINE

The client as well, can not be changed
(the restriction is applied in application level, but not in database
level)

The solution is to add this code in triggers:

OR(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0'))
OR(COALESCE(:old.AD_CLIENT_ID, '0') <> COALESCE(:new.AD_CLIENT_ID, '0'))

0002539

Steps To Reproduce

Proposed Solution

Additional Information