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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0002539

closed

user71

It can be changed the Organization in Processed Documents

Notes
(0004071) user71 2008-05-06 15:02 edited on: 2008-06-12 09:27	Logged In: YES user_id=1964080 Originator: YES Fixed since revision 2273 in branch r2.3x

(0007199) user71 2005-06-01 00:00 edited on: 2008-06-12 09:44	This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1879065 [^]

Issue History
Date Modified	Username	Field	Change