Maximo Open Forum

 View Only
  • 1.  Asset TOTALCOST vs MATUSETRANS total cost - not equal

    Posted 10-01-2024 18:33

    Hello MORE Maximo Community,

    When something was issued there was a typo and the line cost was negative.

    We have fixed the issue on the MATUSETRANS table, but the Asset Table (ASSET.TOTALCOST) still shows negative.

    How can I update this table as well? Or are we missing a step?  Not sure why they are not lining up.

    Thank you


    #Administration
    #Analytics
    #Assets
    #EverythingMaximo
    #Inventory

    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------


  • 2.  RE: Asset TOTALCOST vs MATUSETRANS total cost - not equal

    Posted 10-02-2024 08:55

    This would be the Maintenance Cost Rollup report (on Maximo 76) or use the attached Automation script: Rolling up maintenance costs by using an automation script - IBM Documentation to find and fix only the particular asset. Make sure the resulting value is correct before running.



    ------------------------------
    Niv Geo
    BPD Zenith
    ------------------------------



Newest Episode
Ep. 4 | System Properties in IBM Maximo

Watch Steven Shull walk through practical IBM Maximo system properties that can improve usability, query behavior, attachment handling, and the overall Maximo user experience.

MORE by Naviam Episode 4 cover
Watch Episode 4
Also available: Ep. 3 | Work Order Role-Based Application