IBM Support

IV96188: ACTUAL MATERIAL COST ATTRIBUTE ON WORK ORDER TABLE IS BEING CALCULATED INCORRECTLY

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The actual material cost attribute on the
    Work Order table is being calculated incorrectly when and
    inventory item is issued to a work order where the number of
    items issued spans across cost layers with the same price.
    STEPS TO REPLICATE:
    1- Go to the Asset application. Create a new asset. Set the
    type to
    PRODUCTION.
    Set the location to a REPAIR location. Set the rotating item to
    a valid
    value.
    Set any other required values. Change the status to OPERATING
    and save
    the asset.
    2- Go to Item Master and create a new item. Activate and save
    the item.
    3- Add the item just created to a storeroom. The item will have
    a cost
    type of FIFO.
    Enter a default bin. Enter a unit cost of 1.00 and a current
    balance
    of 5. Click OK.
     4- Go to inventory and bring up the item just added to the
    storeroom.  In the More Actions section, select Inventory
    Adjustments,Current Balance.
    On the first window, Current Balance Adjustment dialog, enter a
    new balance of 10. On the second window, Specify Inventory
    Costs,   enter the price of 1.00 on the 5 items we just
    adjusted for. Now our FIFO item has 2 cost layers.
    5 items at 1.00 and another layer of 5 items at 1.00.
    5- Go to Work Order Tracking and create a new work order. Enter
    the
    asset we created in
    the first step. Please note the Charge to Store flag is checked
    properly. Save and approve the work order.
    6- Go to the actuals tab on the work order. On the Materials
    subtab,
    issue 1 of the inventory items we
    created previously. Save the work order. A transaction was
    created for the inventory
    layer it issued from properly.
    7- Complete and close the work order.
    8- In the More Actions section, select View Work Order
    Costs. The Material Cost on this is incorrect.
    We issued 1 items to the work order. With FIFO costing, those
    items were valued at 1.00. This is displaying 2.00.
    9- Go to the asset record. This also displays an Inventory cost
    value of 2.00. This is also incorrect. It should be 1.00.
    10- Now in the common actions on the asset, select Move Modify
    Assets.
    The value being moved back into the storeroom will be 2.00
    which is incorrect. We have only issued 6.00 worth of material
    to the asset. Therefore, our Global Rotating Suspense account
    will be out of balance by 1.00.
    CURRENT ERRONEOUS RESULT:
    -With FIFO costing, those items were valued at 1.00. This is
    displaying 2.00.
    -Go to the asset record. This also displays an Inventory cost
    value of 2.00.
    EXPECTED RESULT:
    This values are incorrect. It should be 1.00.
    ENVIRONMENT:
    App Server  IBM WebSphere Application Server 8.5.5.10
    Version  Tivolis process automation engine
    7.6.0.5-IFIX20161207-1834
    Build 20160611-0100 DB Build V7605-45 HFDB Build HF7605-04IBM
    TPAE
    Integration Framework 7.6.0.5 Build 20160610-2330 DB Build
    V7605-50IBM
    Maximo Enterprise Adapter for Oracle Applications
    7.6.0.0-20160713-1111
    Build 20150804-1717 DB Build V7600-05IBM Maximo Asset
    Management Work
    Centers 7.6.0.0 Build 20160610-1318 DB Build V7600-38IBM Maximo
    Asset
    Management 7.6.0.5 Build 20160611-0100 DB Build V7604-01
    Server OS  Windows Server 2012 R2 6.3
    Server DB  Microsoft SQL Server 12.0 12.00.5540
    PRODUCT VERSION: Version  Tivolis process automation engine
    7.6.0.5-IFIX20161207-1834
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * MAXIMO                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ACTUAL MATERIAL COST ATTRIBUTE ON WORK ORDER TABLE IS BEING  *
    * CALCULATED INCORRECTLY FOR FIFO ITEM                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
    package:
    		 | Release 7.6.0.9 of Base Services
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV96188

  • Reported component name

    WORK ORDERS

  • Reported component ID

    5724R46WO

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-05-12

  • Closed date

    2017-06-14

  • Last modified date

    2017-06-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    WORK ORDERS

  • Fixed component ID

    5724R46WO

Applicable component levels

  • R760 PSY

       UP



Document information

More support for: Maximo Asset Management
Work Order Tracking

Software version: 760

Reference #: IV96188

Modified date: 29 June 2017