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.
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
[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
>
>
>
>
>