ADempiere ERP Business Suite / Fixed Asset / #13 Removal of unused defaults in tables

#13 Removal of unused defaults in tables

Status: open

Owner: Redhuan D. Oon

Labels: None

Priority: 5

Updated: 2011-04-28

Created: 2011-04-28

Creator: Redhuan D. Oon

Private: No

There are defaults pointing to Depreciation tables in A_AssetGroupAcct and another Asset table. Seems like was used by creator in previous test data that is now absent. Removing the defaults allow the tabs to save. If not error will be :
===========> Trx.commit: POSave_6d48560c-50fb-4877-9bac-22affffbb503 [11]
org.postgresql.util.PSQLException: ERROR: insert or update on table "a_asset_group_acct" violates foreign key constraint "adepreciation_aassetgroupacct"
Detail: Key (a_depreciation_id)=(1000003) is not present in table "a_depreciation".; State=23503; ErrorCode=0

Discussion

Redhuan D. Oon - 2011-04-28

Committed in revision - http://adempiere.svn.sourceforge.net/adempiere/?rev=15288&view=rev

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Redhuan D. Oon - 2011-05-18

DROP CREATE TABLES http://adempiere.svn.sourceforge.net/adempiere/?rev=15380&view=rev

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Removal of unused defaults in tables

A full ERP system - moved to GitHub. See full description for details.

Group

Searches

Help

#13 Removal of unused defaults in tables

Discussion