Changing GL Account on closed WO

[NHL11]

I have just inherited Maximo 6.5.01 with sql and I would like to know how to change a GL Account once a project has been closed. The improper GL account was entered and now it needs to be corrected. I don't believe that you can change a GL account on a closed workorder. I can access the database via linked tables in access, but I'm not usre which tables contain GL account information so I can make the proper changes. Is there a way to do this on the front end? I've tried changing the status of the WO to APPR (Approved) and I still can't change the GL account.

[maurogrz]

it is not recomended to change data from the DB-side, it is quite easy to forget to change all the places...
if you need a help on the tablename/fieldname of a data you can see on maximo application, simply press ALT+F1 on the field and a popup tells you the value.

returning to your question, the gl account of the workorder is the field GLACCOUNT in the table WORKORDER...
keep in mind that the value is also stored in the WOSTATUS table on each status changes.
You have also to check the gl acccount of the labor/material/tools transactions.

at last, if you change the status (via DB) of a closed workorder, usually you have to change the HISTORYFLAG to 0 or the record will not be editable.

Mauro

[NHL11]

I agree that it's not a good practice to change data on the backend of the database, but how can you change the GL account any other way? It continues to tell me that the field is read only.

[maurogrz]

you can set editibility of GLACCOUNT, LOCATION, ASSET and other similar data in the organizations app (select action WO options)
(sorry if I'm not specific, but my installation is in Italian and so I don't know the English name of this option)
Mauro

• PM Estimated Due Date whe... by canislupus [May 21, 2012, 01:56:48 pm]
• unable to get wpmaterial ... by G Jeevan [May 21, 2012, 12:28:50 pm]
• KPIMAIN lookup not workin... by G Jeevan [May 21, 2012, 12:26:23 pm]
• add user access by Sarbjeet.Jassal [May 21, 2012, 08:04:33 am]
• Not able to access the ma... by Sarbjeet.Jassal [May 21, 2012, 07:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]