IJ44473: RECONCILE BALANCE ISSUE FOR AN ITEM WITH FIFO ISSUE COST TYPE

APAR status

• Closed as program error.

Error description

• When the Shrinkage Account is not correctly entered during
  Reconcile Balance for an item with FIFO Issue Cost Type, the
  system generates a mismatch between the inventory balance and
  the inventory cost.
  STEPS TO REPRODUCE:
  1.	Open the Item Master application and click to create a new
  item:
  a.	Item: TESTITEM, Test Item
  b.	Order Unit: EACH
  c.	Issue Unit: EACH
  d.	Save
  e.	Click on Add Items to Storeroom
  i.	Storeroom: CENTRAL
  ii.	Click OK
  iii.	Item Cost Type: FIFO
  iv.	Click OK
  f.	Click in Change Status
  i.	New Status: Active
  ii.	Roll New Status to Organizations and Inventory ? checked
  iii.	Click OK
  2.	Open the Database Configuration application
  a.	Click on GL Account Configuration
  b.	Make Required the ELEMENT component
  c.	Click OK
  3.	Open the Inventory application and the details for the item
  TESTITEM
  a.	In Inventory Balances area click to New Row:
  i.	Bin: bin1
  
  ii.	Current Balance: > 0, e.g.,5
  iii.	Unit Cost: 2.5
  b.	Click on New Row
  i.	 Bin: bin2
  
  ii.	Current Balance: 0
  c.	Save
  d.	Click on Inventory Adjustments > Physical Count and exchange
  the values of the bins
  i.	Bin1, New Count: 0
  ii.	Bin2, New Count: 5
  iii.	Click OK, then close the system message displayed
  e.	Click on Inventory Adjustments > Reconcile Balances
  f.	Click OK without changing the Shrinkage GL Account (ELEMENT
  component of the GL account is ??????)
  g.	Click OK to close the system message that is displayed:
  BMXAA1791E - Not a valid material usage transaction GL account
  6600-800-800-??????????. Either the required components are not
  filled or the component's values are not valid.
  h.	Click on Cancel
  i.	Correct the Shrinkage GL Account by entering a value
  j.	Click OK
  k.	Click OK in the Reconcile Balances screen  the Save button
  becomes active
  l.	Finish the Reconcile Balance (in OOB cancel as no other setup
  is done to accept a value for the ELEMENT component)
  m.	Save the item  The Inventory LIFO FIFO Costs has now 2
  identical rows, total quantity = 10  so double the balance
  value from the Inventory Balances area
  RESULT:
  2 identical rows are created in Inventory LIFO FIFO Costs
  generating a mismatch between inventory balance and inventory
  cost
  EXPECTED RESULT:
  The inventory cost rows should not be duplicated.
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * RECONCILE BALANCE ISSUE FOR AN ITEM WITH FIFO ISSUE COST     *
  * TYPE                                                         *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 8.X Product
  

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