Maximo List Archive

From: Brian Swanson (2019-04-03 11:42)

Yes,
With help from a friend, I created an automation script that rolls up the cost to two added fields on the workorder. From there I added a database view that will display all the costs, including those not on workorders. We needed the view as that is how we are getting data into the Qlik analytics program we are using. The only catch with the view is I’m only going 3 levels deep with the workorder parent-child, but so far that is enough for us.

If I had the Maximo java source code, I could most likely create a custom class file to duplicate what the Maximo application is doing, but I don’t.

Thanks..

Brian Swanson
IT Senior Analyst - Maximo
Information Technology

hermanmiller.com
616 654 7687 Office
616 836 8491 Mobile

HermanMiller

From: MAXIMO@yahoogroups.com <MAXIMO@yahoogroups.com>
Sent: Saturday, February 23, 2019 10:20 AM
To: MAXIMO@yahoogroups.com
Subject: [Newsletter] Re: [MAXIMO List] Displaying PO Costs on the workorder



Did you ever solve this?

On Fri, Nov 9, 2018 at 3:01 PM Brian Swanson brian_swanson@hermanmiller.com<mailto:brian_swanson@hermanmiller.com>
[MAXIMO] <MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>> wrote:

>
>
> I would like to add a field to the workorder for PO Costs, so the costs
> from any PO is displayed there. I know it is there by doing a view costs,
> but I want to do something else with the costs so I need them in a database
> field on the workorder itself. I'm not sure what the best option would be,
> Automation Script, Procedure, trigger? It gets complicated as you can have
> a workorder on several different PO's and POLINES can also have several
> different workorders and I need to rollup all the costs received and not
> received and update a field on the workorder so I can see costs received
> and costs not received, but on active PO's
>
> Thanks
>
> Brian Swanson
> IT Senior Analyst - Maximo
> Information Technology
>
> HermanMiller
>
>
>
>
>