This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Try creating a view and then use a relationship.
On Friday, November 9, 2018, 2:01:12 PM CST, Brian Swanson brian_swanson@hermanmiller.com [MAXIMO] <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
Do you want that data updated without having to open the Work Order? If so, you might need to tie something to an escalation or something like that.
From: MAXIMO@yahoogroups.com <MAXIMO@yahoogroups.com>
Sent: Monday, January 7, 2019 5:37 PM
To: Brian Swanson brian_swanson@hermanmiller.com [MAXIMO] <MAXIMO@yahoogroups.com>
Subject: Re: [MAXIMO List] Displaying PO Costs on the workorder
Try creating a view and then use a relationship.
On Friday, November 9, 2018, 2:01:12 PM CST, 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
Do you want it "on the work order" in so much as it is persistent in a
database field or "available from the WO"? This may sound simple but it
will drive your direction, the "standard" way would be to create a
non-persistent field that is calculated on initialization, it
would/should/could show up like any other field, always be up to date,
available through interfaces etc. But... if you query via SQL it will not
exist.. or persist...
A view... is a sort of hybrid, it is "sort of persistent" in that you can
query it from the database and it is calculated.
Calculating it and storing (persisting) it is more "traditional" but you
then have to decide if it is maintained "real time" or in "batch". Batch
(escalation) is easier but brings in a lag and can also be costly if you
are recalculating for every WO as you don't know what has changed, a "pull"
if you like. Making it more dynamic - a "push" is more elegant but you then
need to understand anything and everything that would initiate an update,
it is however more efficient as you only reevaluate when necessary.
The best and the worst of Maximo... there are many ways to do it, picking
the right one for you is what matters. This, in my opinion, is the true
definition of configuration vs. customization and all hinges on a detailed
definition of what it is that you really need/want.
Chris.
On Tue, Jan 8, 2019 at 10:40 AM Ron Bryant ron_bryant@cargill.com [MAXIMO] <
MAXIMO@yahoogroups.com> wrote:
>
>
> Do you want that data updated without having to open the Work Order? If
> so, you might need to tie something to an escalation or something like
> that.
>
>
> From: MAXIMO@yahoogroups.com <MAXIMO@yahoogroups.com>
> Sent: Monday, January 7, 2019 5:37 PM
> To: Brian Swanson brian_swanson@hermanmiller.com [MAXIMO] <
> MAXIMO@yahoogroups.com>
> Subject: Re: [MAXIMO List] Displaying PO Costs on the workorder
>
>
>
> Try creating a view and then use a relationship.
> On Friday, November 9, 2018, 2:01:12 PM CST, 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
>
>
>
>
>
>
>
>
>
>