Thursday, 11 October 2012

What is use of Update Database Option in Chart of Accounts?


In the Chart Of Accounts under the Select Action menu there is an Update Database option. This option is meant to be used after a modification has been made to a default GL Account or resource code.

 As an example say the Control Account of a storeroom was changed since this GL defaults into place as the credit or debit account one would have to use the Update Database options to push the changes through so the new GL can be used.
Here is an explanation of how the above 3 options work:

Overwrite Blank Accounts only?

Suppose you created an account code for the GL Account field of an existing item type. The GL Account field of the item is overwritten only where it is blank, but not where a GL account was entered.


Overwrite Accounts With Old Defaults?

Overwrites blank fields and GL account fields that have the previous GL account. Suppose an item type had a GL account code associated with it in Chart of Accounts. This code was inserted on item records that used the item type. On some records, the account code was changed.


Overwrite All Accounts:

Overwrites all relevant GL Account fields in Maximo records. Suppose an item type has a GL account code associated with it in Chart of Accounts. All blank GL Account fields for that item type and all existing GL Account fields for items of that type, including ones that were subsequently changed, are overwritten.

No comments:

Post a Comment