Bug when you tried to define a second accont schem

Description

When you define a second account schema, you first define a new account element (the COA) and then you add an accounting schema (with accounting schema dimensions, general ledger and defaults).
The necessary step to add the new schema to an existing client is going to schema account defaults and in process icon you start the add or copy accounts ant this process will copy the default accounts to BP Group, BP, Product category, product and all the required tables. But this process fails because some tables already defined some default accounts (not used yet in version 2.1) as NOT NULL in database constraint. To fix this problem you must remove the NOT NULL clause in the database definition. The tables and fields that must be modified are:
Table C_BP_GROUP
fields
v_liability_services_acct
unearnedrevenue_acct

Table C_CASHBOOK_ACCT
cb_asset_acct
cb_cashtransfer_acct
cb_differences_acct
cb_expense_acct
cb_receipt_acct

The command to do this change (for each field) is:
ALTER TABLE C_BP_GROUP
alter column v_liability_services_acct drop not null;

Environment

Ubuntu 14.04 64 bits

Activity

Show:
Carlos Ruiz
changed the StatusJuly 1, 2016 at 4:00 PM
Resolved
Closed
Carlos Ruiz
updated the LinkMay 12, 2016 at 3:54 AM
None
This issue duplicates IDEMPIERE-3087
Carlos Ruiz
changed the AssigneeMay 12, 2016 at 3:54 AM
Unassigned
Carlos Ruiz
Carlos Ruiz
changed the StatusMay 12, 2016 at 3:54 AM
Open
Resolved
Carlos Ruiz
updated the ResolutionMay 12, 2016 at 3:54 AM
None
Duplicate
Jaime Garcia
created the IssueMay 11, 2016 at 8:03 PM
Duplicate

Details

Assignee

Reporter

Tested By

Jaime Garcia

Components

Affects versions

Priority

Created May 11, 2016 at 8:03 PM
Updated July 1, 2016 at 4:00 PM
Resolved May 12, 2016 at 3:54 AM