IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    IJ00514

  • Reported component name

    INVENTORY

  • Reported component ID

    5724R46IN

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-10-09

  • Closed date

    2017-12-06

  • Last modified date

    2017-12-06

  • 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



Document information

More support for: Maximo Asset Management
Inventory

Software version: 760

Reference #: IJ00514

Modified date: 06 December 2017