IBM Support

Update Database Option In Chart Of Accounts

Question & Answer


Question

Are there different options available for updating the GL accounts in Chart of Accounts?

Answer

In previous Maximo system administration guides this information was available but in the 71 system administration guide it seems to have been removed.

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.

There are 3 available options to chose from :




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.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Chart of Accounts","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"Edition Independent","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21610919