A new change in the API that may be of your interest:
http://wiki.openbravo.com/wiki/ERP/2.50/API_changes#PI_.28not_released_yet.29
C_ACCTSCHEMA_DEFAULT.CB_CASHTRANSFER_ACCT turns to not nullable column,
and it's field to mandatory.
This column was not nullable in 2.40, and some moment during 2.50
development, it turned to nullable. Due to the issue 10073, we realized
that this involuntary change happened, and turned it again to not
nullable.
This raises an issue, because this value corresponds to a default
account in the accounting schema. Until now, an initial client/org
setup could be done in 2.50 with a chart of accounts without this
default value. In this case, in order to perform a successful update of
core with this change, some value must be set in that column. Here
there is no way of doing an automatic functionally valid action. User
must choose the account suitable of being the default
CB_CASHTRANSFER_ACCT.
Actions taken:
* A couple of SQL snippets are provided, for users to check if
problem will affect them or not.
* When updating core, the value for CB_CASHTRANSFER_ACCT column
will be set to the same account that the one existing in CB_ASSET_ACCT
column. This will be done only if there is a null in
CB_CASHTRANSFER_ACCT column.
* To alert the user about this change, a note is added to the
release notes.
SQL snippets:
To check if some of the accounting schemes will suffer this issue:
SELECT CASE WHEN (SUM(A)>0) THEN 'DEFAULT NOT PRESENT!!'
ELSE 'EVERYTHING IS OK!!' END AS A
FROM (SELECT CASE WHEN (CB_CASHTRANSFER_ACCT IS NULL) THEN 1
ELSE 0 END AS A
FROM C_ACCTSCHEMA_DEFAULT) SQL;
To locate those accounting schemes:
SELECT S.NAME FROM C_ACCTSCHEMA S, C_ACCTSCHEMA_DEFAULT D
WHERE S.C_ACCTSCHEMA_ID = D.C_ACCTSCHEMA_ID
AND D.CB_CASHTRANSFER_ACCT IS NULL;
Action that will be done authomatically when updating, only for
accountins schemas where CB_CASHTRANSFER_ACCT column is null:
UPDATE C_ACCTSCHEMA_DEFAULT SET CB_CASHTRANSFER_ACCT=CB_ASSET_ACCT
WHERE CB_CASHTRANSFER_ACCT IS NULL;
Regards.
David Alsasua Egea
Openbravo
Localization and Accounting
e: [email protected]
m: +34.607.867.908
t: +34.948.287.507 ext: 3373
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Openbravo-development mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-development
