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.
Tried the sql and update using autoscript once to rollup hours from task workorders to the master workorder, started causing database locks.
I was thinking procedure and run it once a night with a cron task. Just looking to see if anyone ever did something like this and what their solution was. I’ll look elsewhere. 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: Friday, November 09, 2018 8:20 PM
To: MAXIMO@yahoogroups.com
Subject: [Newsletter] Re: [MAXIMO List] Displaying PO Costs on the workorder
You want PO costs for... active POs? Approved POs? You can write the SQL
for this and have it summarized into a single number. Call that SQL from
an auto script, write a method... your choice. There's no free lunch here,
unless maybe you're thinking you can derive this from receipts?
-C
On Fri, Nov 9, 2018 at 2:56 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
>
>
>
>
>