IJ38131: WORK ORDER ACTUALS MATERIAL UNIT/ACTUAL COST FIELDS ARE INCORRECT

APAR status

• Closed as program error.

Error description

• Unit/Actual Cost fields are incorrect when information is being
  changed before the record is Saved for Actuals/material on a
  work order.
  
  STEPS TO REPRODUCE:
  Prerequisite: In Organizations, Inventory Options, Inventory
  Defaults: "Allow Negative Balance" checkbox checked
  
  Inventory Usage application:
  
  On a Chrome session
  Login: wilson
  1) Go To Item Master.
  2) Create a new Item
  Item: TESTDF
  Order Unit: EACH
  Issue Unit: EACH
  3) Add Item to CENTRAL Storeroom in Bedford Site with Average
  Cost of 30 and Current Balance of 20 for a Total Value of
  $600.00.
  Add Items to Storeroom
  Item: TESTDF
  Issue Cost Type: AVERAGE
  Unit Cost: 30.00
  Current Balance: 20
  Click OK
  4) Add Item to GARAGE Storeroom in Bedford Site with Average
  Cost of 60 and Current Balance of 40 for a Total Value of
  $2400.00.
  Add Item to Storeroom
  Item: TESTDF
  Issue Cost Type: AVERAGE
  Unit Cost: 60.00
  Current Balance: 40
  Click OK
  5) Change Item Status to ACTIVE and checking the ?Roll New
  Status?? checkbox.
  6) Go To Work Order Tracking.
  7) Find (or create) an Approved WO.
  Created WO: 1288
  Location: BR240
  Status: APPR
  8) Click on Actual tab. then on Materials sub-tab, and click on
  New Row.
  9) Issue a Quantity of 25 (of the Item created in Step 2) to the
  work order from Step 7 (complete GL Debit Account if necessary),
  to the Central Storeroom but DO NOT SAVE yet.
  Item: TESTDF
  Storeroom: CENTRAL
  Quantity: 25
  Unit Cost: 30.00
  GL Debit Account: 6210-350-000
  Transaction Type: ISSUE
  ** DO NOT SAVE
  10) Open another browser tab and launch Maximo.
  Open a session on Firefox
  Login: maxadmin
  11) Go To Inventory / Inventory Usage
  12) So created Usage: 1013
  Usage Type: TRANSFER
  From Storeroom: GARAGE
  New Row
  Quantity: 25
  Transfer Details section
  To Storeroom: CENTRAL
  Save
  Change Status to COMP
  13) Go back to Work Order Tracking on Chrome
  WO: 1288
  14) Click SAVE.
  15) Go To Inventory from the chrome session.
  16) Call up the test Item at CENTRAL Storeroom.
  Filter for Item: TESTDF
  Click on the one for Central storeroom
  Current Balance: 20
  17) Look at the Average Cost for Central
  Inventory Costs section
  Standard Cost: 30.00
  Average Cost: 46.67
  Last Receipt Cost: 60.00
  a) View Inventory Transactions
  Click Issues & Returns tab
  Unit Cost: 30.00
  Actual Cost: 30.00
  b) Look at the Average Cost for Garage
  Inventory Costs section
  Standard Cost: 60.00
  Average Cost: 60.00
  Last Receipt Cost: 60.00
  
  
  On Inventory application
  
  On a Chrome session
  1) Go To Item Master.
  2) Create a new Item
  Item: TESTINV
  Order Unit: EACH
  Issue Unit: EACH
  3) Add Item to CENTRAL Storeroom in Bedford Site with Average
  Cost of 30 and Current Balance of 20 for a Total Value of
  $600.00.
  Add Items to Storeroom
  Item: TESTINV
  Issue Cost Type: AVERAGE
  Unit Cost: 30.00
  Current Balance: 20
  4) Add Item to GARAGE Storeroom in Bedford Site with Average
  Cost of 60 and Current Balance of 40 for a Total Value of
  $2400.00.
  Add Item to Storeroom
  Item: TESTINV
  Issue Cost Type: AVERAGE
  Unit Cost: 60.00
  Current Balance: 40
  5) Change Item Status to ACTIVE and checking the ?Roll New
  Status?? checkbox.
  6) Go To Work Order Tracking.
  7) Find (or create) an Approved WO.
  Created WO: 1289
  Location: BR240
  Status: APPR
  8) Click on Actual tab. then on Materials sub-tab, and click on
  New Row.
  9) Issue a Quantity of 25 (of the Item created in Step 2) to the
  work order from Step 7 (complete GL Debit Account if necessary),
  to the Central Storeroom but DO NOT SAVE yet.
  Item: TESTINV
  Storeroom: CENTRAL
  Quantity: 25
  GL Debit Account: 6210-350-000
  Transaction Type: ISSUE
  ** DO NOT SAVE
  10) Open another browser tab and launch Maximo.
  Open a session on Firefox
  11) Go To Inventory / Transfer Current Item
  Filter for Item: TESTINV
  12) Select Storeroom: GARAGE
  More Actions > Transfer Current Item
  Transfer Current Item dialog box
  Quantity: 25
  From Storeroom: GARAGE
  To Storeroom: CENTRAL
  From Issue Unit: EACH
  To Issue Unit: EACH
  Conversation Factor: 1
  Click OK
  13) Go back to Work Order Tracking on Chrome.
  14) Click SAVE.
  15) Go To Inventory from the chrome session.
  16) Call up the test Item at CENTRAL Storeroom.
  Filter for Item: TESTINV
  Click on the one for Central storeroom
  Current Balance: 20
  17) Look at the Average Cost.
  Inventory Costs section
  Standard Cost: 30.00
  Average Cost: 46.67
  Last Receipt Cost: 60.00
  
  In the Inventory application
  More Actions > View Inventory Transactions dialog box > Issues &
  Returns tab
  Unit Cost: 30.00
  Actual Cost: 30.00
  
  View Inventory Transactions dialog box > Receipts & Transfers
  tab
  Unit Cost: 60.00
  Actual Cost: 60.00
  
  RESULTS: Unit/Actual Cost fields show incorrect
  
  EXPECTED RESULTS: The issue is in Step 17a.  The Unit/Actual
  Cost fields should be $46.67 since that was the Average Cost at
  the time the transaction posted.
  
  
  REPORTED IN VERSION: TPAE 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * NO ERROR HANDLING WHEN ONE USERS ADDS MATERIAL ACTUALS TO WO *
  * AND DOESNT SAVE, ANOTHER USER TRANSFERS THE ITEM USED IN WO, *
  * FIRST USER THEN SAVES LEADING TO INCORRECT AVGCOST IN ISSUES *
  * AND RETURNS TAB                                              *
  ****************************************************************
  

Problem conclusion

• ADDED ERROR HANDLING WARNING THE USER TO RE_ADD MATERIAL ACTUAL
  INFO
  

Temporary fix

Comments

APAR Information

• 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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels