IJ00514: WRONG LIFO/FIFO COSTS AND COST DATES WHEN RETUNRING ITEMS THAT CONTAIN LIFO/FIFO RECORDS THRU CURRENT BALANCE ADJUSTMENTS

APAR status

• Closed as program error.

Error description

• Note:
  There is a slight difference between the current issue and APAR
  IV85176.
  The current scenario uses the demo Item 28149 which contains
  FIFO records thru current balance adjustments.
  In the case of APAR IV85176, the FIFO records were created via
  receiving.
  Maximo has connections between matrectransid and LIFO/FIFO
  records but does not have the same connection between invtransid
  and LIFO/FIFO.
  
  Steps to replicate the issue in Maxdemo database:
  
  1) Go to Organizations application
  
  2) Bring up EAGLENA Organization
  
  3) Select Action > Inventory Options > Inventory Costs
  
  4) From Inventory Costs dialog, select FIFO Cost for BEDFORD
  Site and click OK
  
  5) Go to Inventory application
  
  6) Bring up Item 28149
  
  7) Note that in CENTRAL Storeroom, BEDFORD Site, the Current
  Balance is 30.00 and Issue Cost Type is FIFO
  
  8) Also note there are 5 Inventory LIFO/FIFO Cost lines.
  8.00 units with Unit Cost = 10.00 and Cost Date = 3/1/00.
  
  9) Go to Work Order Tracking application
  
  10) Create a new WO against any valid GL Account, approve WO and
  take note of its number
  
  11) Go to Inventory Usage application
  
  12) Create Inventory Usage record to issue 1.00 unit of Item
  28149 from Bin LR1 against the WO created above
  
  13) Change Inventory Usage record Status to COMPLETE
  
  14) Go to Inventory application
  
  15) Bring up Item 28149
  
  16) Note that the Current Balance is now 29.00 and the Inventory
  LIFO/FIFO Cost line for 3/1/00 now displays Quantity = 7.00.
  That's correct. Expected result.
  
  17) Go back to Inventory Usage application
  
  18) Create a return transaction for Item 28149 against the WO in
  question:
  
  18.1) Click on Select Item for Return button
  
  18.2) Filter by the Item 28149
  
  18.3) From Select Items for Return dialog, select the line
  and click OK
  
  19) Change the Inventory Usage record Status to COMPLETE
  
  20) Go back to Inventory application
  
  21) Bring up Item 28149
  
  The issue is (copying Client words):
  
  "There are now 6 rows in the LIFO/FIFO Cost table. The line that
  I returned is showing today's date, not the date at which it was
  issued.
  
  This item is now the newest item in this table, so therefore,
  the next time this item is issued out, it will select the oldest
  before this new one.
  
  This is not the way we would expect this to work. It should come
  back into the storeroom at the cost date in which it was
  issued."
  

Local fix

• No workaround has been found.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users who use the LIFO/FIFO functionality             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Cost Date is system date in the new INVLIFOFIFOCOST record   *
  * when returning an Issue for an old INVLIFOFIFOCOST records   *
  * created not thru the Receiving application.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Create the LIFO/FIFO records thru the Receiving application. *
  * The "matrectransid" is in many tables which holds the        *
  * connection for issue and returns.                            *
  ****************************************************************
  For the INVTRANS type of INVLIFOFIFOCOST records, this apar
  does:
  1. Finds the closest INVLIFOFIFOCOST that matches the cost of
  the material issue.  If found, use its cost date.
  2. If none is found, it uses the date of the material issue.
  

Problem conclusion

• This is fixed in code.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.0.10 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:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  INVENTORY

• Fixed component ID

  5724R46IN

Applicable component levels

• R760 PSY

     UP