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.
Hi Everyone,
I'm interested in learning about the Cost Management application in Maximo. I'd like to see if/how it can be used to track construction projects. Does anyone have experience with this? Any documentation that you can share?
We are on Maximo 7.5.03.
Thank you!
Cristina
As it happens, I'm right in the middle of an implementation of Cost
Management for a major construction project. We're in 7.5.0.5.
Basically, the way we set it up is:
1. Enter the budget breakdown into the Cost Management application -
top-level project/AFE # with budget in the top section, then tasks and
sub-tasks. For tasks that had sub-tasks, we took the "Is Chargeable?" flag
off, so users couldn't charge costs on that level.
a. There are a bunch of hidden fields that may be useful. By default,
only the Value field is showing, but the field name for that is ACTUALCOST.
That didn't make sense to me, so I un-hid the BUDGETCOST field to use
instead.
b. I added a field to allow the user to specify who the Project Manager
for that task is. The project manager specified on the top level defaults
down to the tasks, but the users can over-ride.
c. Since the company is very careful never to go over the total budget,
I added a small autoscript that enforces that - essentially the users have
to decrease the budget for one task before they can increase the budget for
another.
2. Un-hide the Project ID and Task ID fields on the work order screen -
there's a KB article on the IBM site that tells you how to do that.
a. I added a new work type called "CAP" (Capital). If this work type
is picked, the Project ID and Task ID fields become required.
b. Note: In the work order table, the Project ID and Task fields are
actually non-persistent, but when you pick them, the "real" reference
(WORKORDER.FINCNTRLID) is populated.
3. Once you have the data into the CM application and the work order
fields un-hidden, you can attach one or more work orders to each budget
task.
4. When you charge costs to these work orders, the FINCNTRLID is
automatically copied to all related transactions, i.e. PR Lines, PO Lines,
Receipts, Invoices, Labor transactions, etc.
a. I created a PR workflow that checks to see if the current PR will
take the costs over the budget for that task, and if so, stops the PR from
being approved until the budget is adjusted.
5. The last step (but not least) is to build a report that shows your
costs compared to the budget, i.e. Uncommitted (PRs and unapproved Pos),
Committed (approved Pos), Actuals (Receipts, Inventory issues, Labor, etc).
This turned out to be really tricky to build, but it's working now. I ended
up creating a view in the database to gather the costs in one place. Then I
wrote the report to draw from the view - which was still tricky since you
ideally need to join the costs to a recursive query on the FINCNTRL table to
get it right.
That's a quick breakdown of what was actually a lot of work ... we're in the
middle of the implementation, which can't say was entirely smooth, but the
Cost Management data has been entered and the work orders have been created.
My users are working setting up PRs and POs now.
If you have questions, just post them here and I'll try to answer. I think
it's a really cool application that fills a definite need!
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Tuesday, February 23, 2016 8:24 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Cost Management application
Hi Everyone,
I'm interested in learning about the Cost Management application in Maximo.
I'd like to see if/how it can be used to track construction projects. Does
anyone have experience with this? Any documentation that you can share?
We are on Maximo 7.5.03.
Thank you!
Cristina
Thank you, Shannon!! I'm sure I'll have more questions but this is excellent and detailed information to get me started with this implementation.
Cristina
> On Feb 23, 2016, at 9:51 PM, 'InComm Solutions Inc.' incomm@shaw.ca [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
> As it happens, I'm right in the middle of an implementation of Cost
> Management for a major construction project. We're in 7.5.0.5.
>
> Basically, the way we set it up is:
>
> 1. Enter the budget breakdown into the Cost Management application -
> top-level project/AFE # with budget in the top section, then tasks and
> sub-tasks. For tasks that had sub-tasks, we took the "Is Chargeable?" flag
> off, so users couldn't charge costs on that level.
>
> a. There are a bunch of hidden fields that may be useful. By default,
> only the Value field is showing, but the field name for that is ACTUALCOST.
> That didn't make sense to me, so I un-hid the BUDGETCOST field to use
> instead.
>
> b. I added a field to allow the user to specify who the Project Manager
> for that task is. The project manager specified on the top level defaults
> down to the tasks, but the users can over-ride.
>
> c. Since the company is very careful never to go over the total budget,
> I added a small autoscript that enforces that - essentially the users have
> to decrease the budget for one task before they can increase the budget for
> another.
>
> 2. Un-hide the Project ID and Task ID fields on the work order screen -
> there's a KB article on the IBM site that tells you how to do that.
>
> a. I added a new work type called "CAP" (Capital). If this work type
> is picked, the Project ID and Task ID fields become required.
>
> b. Note: In the work order table, the Project ID and Task fields are
> actually non-persistent, but when you pick them, the "real" reference
> (WORKORDER.FINCNTRLID) is populated.
>
> 3. Once you have the data into the CM application and the work order
> fields un-hidden, you can attach one or more work orders to each budget
> task.
>
> 4. When you charge costs to these work orders, the FINCNTRLID is
> automatically copied to all related transactions, i.e. PR Lines, PO Lines,
> Receipts, Invoices, Labor transactions, etc.
>
> a. I created a PR workflow that checks to see if the current PR will
> take the costs over the budget for that task, and if so, stops the PR from
> being approved until the budget is adjusted.
>
> 5. The last step (but not least) is to build a report that shows your
> costs compared to the budget, i.e. Uncommitted (PRs and unapproved Pos),
> Committed (approved Pos), Actuals (Receipts, Inventory issues, Labor, etc).
> This turned out to be really tricky to build, but it's working now. I ended
> up creating a view in the database to gather the costs in one place. Then I
> wrote the report to draw from the view - which was still tricky since you
> ideally need to join the costs to a recursive query on the FINCNTRL table to
> get it right.
>
> That's a quick breakdown of what was actually a lot of work ... we're in the
> middle of the implementation, which can't say was entirely smooth, but the
> Cost Management data has been entered and the work orders have been created.
> My users are working setting up PRs and POs now.
>
> If you have questions, just post them here and I'll try to answer. I think
> it's a really cool application that fills a definite need!
>
> Shannon Rotz
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
> Sent: Tuesday, February 23, 2016 8:24 PM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Cost Management application
>
> Hi Everyone,
> I'm interested in learning about the Cost Management application in Maximo.
> I'd like to see if/how it can be used to track construction projects. Does
> anyone have experience with this? Any documentation that you can share?
> We are on Maximo 7.5.03.
> Thank you!
> Cristina
>
>
>
>
We did something very similar, but also cloned the WorkOrder app to a Project Tracking app and made CAP worktype available only in the Project Tracking. Then we added filters to separate data by Work Type so that CAP only showed in the Project Tracking and everything else was in the WO app. That way we can secure them separately.
We then added custom code to do the reporting that Shannon describes on an extend Costs screen (brought it out of Select Action and into a tab) so that at any level of the project we could see:
1. Budget and Costs at the current level
2. Budget and Costs for this and all child levels
3. Budget and Costs for the entire Project Hierarchy
Also, the Scheduler application is very helpful as you can easily see your project structure, manage dependencies, resources, etc.
Ron Bryant
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Wednesday, February 24, 2016 12:59 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Cost Management application
Thank you, Shannon!! I'm sure I'll have more questions but this is excellent and detailed information to get me started with this implementation.
Cristina
> On Feb 23, 2016, at 9:51 PM, 'InComm Solutions Inc.' incomm@shaw.ca<mailto:incomm@shaw.ca> [MAXIMO] <MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>> wrote:
>
> As it happens, I'm right in the middle of an implementation of Cost
> Management for a major construction project. We're in 7.5.0.5.
>
> Basically, the way we set it up is:
>
> 1. Enter the budget breakdown into the Cost Management application -
> top-level project/AFE # with budget in the top section, then tasks and
> sub-tasks. For tasks that had sub-tasks, we took the "Is Chargeable?" flag
> off, so users couldn't charge costs on that level.
>
> a. There are a bunch of hidden fields that may be useful. By default,
> only the Value field is showing, but the field name for that is ACTUALCOST.
> That didn't make sense to me, so I un-hid the BUDGETCOST field to use
> instead.
>
> b. I added a field to allow the user to specify who the Project Manager
> for that task is. The project manager specified on the top level defaults
> down to the tasks, but the users can over-ride.
>
> c. Since the company is very careful never to go over the total budget,
> I added a small autoscript that enforces that - essentially the users have
> to decrease the budget for one task before they can increase the budget for
> another.
>
> 2. Un-hide the Project ID and Task ID fields on the work order screen -
> there's a KB article on the IBM site that tells you how to do that.
>
> a. I added a new work type called "CAP" (Capital). If this work type
> is picked, the Project ID and Task ID fields become required.
>
> b. Note: In the work order table, the Project ID and Task fields are
> actually non-persistent, but when you pick them, the "real" reference
> (WORKORDER.FINCNTRLID) is populated.
>
> 3. Once you have the data into the CM application and the work order
> fields un-hidden, you can attach one or more work orders to each budget
> task.
>
> 4. When you charge costs to these work orders, the FINCNTRLID is
> automatically copied to all related transactions, i.e. PR Lines, PO Lines,
> Receipts, Invoices, Labor transactions, etc.
>
> a. I created a PR workflow that checks to see if the current PR will
> take the costs over the budget for that task, and if so, stops the PR from
> being approved until the budget is adjusted.
>
> 5. The last step (but not least) is to build a report that shows your
> costs compared to the budget, i.e. Uncommitted (PRs and unapproved Pos),
> Committed (approved Pos), Actuals (Receipts, Inventory issues, Labor, etc).
> This turned out to be really tricky to build, but it's working now. I ended
> up creating a view in the database to gather the costs in one place. Then I
> wrote the report to draw from the view - which was still tricky since you
> ideally need to join the costs to a recursive query on the FINCNTRL table to
> get it right.
>
> That's a quick breakdown of what was actually a lot of work ... we're in the
> middle of the implementation, which can't say was entirely smooth, but the
> Cost Management data has been entered and the work orders have been created.
> My users are working setting up PRs and POs now.
>
> If you have questions, just post them here and I'll try to answer. I think
> it's a really cool application that fills a definite need!
>
> Shannon Rotz
>
> From: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com> [mailto:MAXIMO@yahoogroups.com]
> Sent: Tuesday, February 23, 2016 8:24 PM
> To: MAXIMO@yahoogroups.com<mailto:MAXIMO@yahoogroups.com>
> Subject: [MAXIMO List] Cost Management application
>
> Hi Everyone,
> I'm interested in learning about the Cost Management application in Maximo.
> I'd like to see if/how it can be used to track construction projects. Does
> anyone have experience with this? Any documentation that you can share?
> We are on Maximo 7.5.03.
> Thank you!
> Cristina
>
>
>
>