IBM Support

IV90745: WHEN A DISTRIBUTED LINE IS REVISED, IN MATRECTRANS TABLE THE POCOST RECORDS POINT TO WRONG PO REVISION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Steps to replicate the issue in Maxdemo database:
    
    1) Go to Item Master application
    
    2) Create a new Item as the following and save:
    Item = any valid Item number
    Order Unit = EACH
    Issue Unit = EACH
    
    3) Change Item Status to ACTIVE, selecting the option "Roll New
    Status to Organizations and Inventory?"
    
    4) Select Action > Add Items to Storeroom
    
    5) From Add Items to Storeroom dialog, enter:
    BEDFORD Site
    CENTRAL Storeroom
    Unit Cost = 100.00
    Current Balance = zero
    
    6) Click OK, save Item and take note of its number
    
    7) Go to Purchase Orders application
    
    8) Create a new PO against any valid Vendor with just 01 PO Line
    as the following:
    Line Type = ITEM
    Item = the Item created above
    Quantity = 5.00
    Unit Cost = 100.00
    No Tax Code
    Charge To > GL Debit Account = 6000-200-000
    
    9) Save PO
    
    10) Click on Distribute Costs button
    
    11) From Distribute Costs dialog, distribute the costs as the
    following and click OK:
    (in this scenario, we can use the same GL Account while
    distributing the costs)
    
    Line Cost = 200.00
    GL Debit Account = 6000-200-000
    
    Line Cost = 300.00
    GL Debit Account = 6000-200-000
    
    12) Approve PO and take note of its number
    
    13) Go to Receiving application
    
    14) Receive the PO
    
    15) Go to Purchase Orders application
    
    16) Bring up the PO and revise it (in this scenario, while
    revising the PO just change the PO Description)
    
    17) Approve the revised PO
    
    18) Go to Receiving application
    
    19) Bring up that PO, click on Select Items for Return button
    and return the total quantity
    
    20) Using a SQL tool, run the query below considering the PONUM
    in question:
    
    select ponum, itemnum, polinenum, porevisionnum, issuetype,
    quantity, gldebitacct, linecost, loadedcost from matrectrans
    where ponum = 'XXXX' order by
    to_char(transdate,'DD-MON-YYYHH24:MM:SS');
    
    From the query results, note that the issue is:
    
    When a Distributed Line is Revised, the Returns in MATRECTRANS
    records inherit the correct PO Revision being Returned only for
    the RECEIPT record and not for the POCOST records. For the
    POCOST records, always refer to the current PO Revision and not
    to the PO Revision of the Return transaction.
    

Local fix

  • No workaround has been found.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users who return a receipt with distributed (POCOST)         *
    * records.                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * "POREVISIONNUM" on the MATRECTRANS with POCOST type are      *
    * incorrect when user returned a receipt with distributed      *
    * records.  This happened after user revised the purchase      *
    * order before using the Select Items for Returns              *
    * functionality in the Receiving app.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * none                                                         *
    ****************************************************************
    

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.8 Product
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV90745

  • Reported component name

    PURCHASING

  • Reported component ID

    5724R46PU

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-11-15

  • Closed date

    2017-01-22

  • Last modified date

    2017-01-22

  • 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

    PURCHASING

  • Fixed component ID

    5724R46PU

Applicable component levels

  • R760 PSY

       UP



Document information

More support for: Maximo Asset Management
Purchase Requisitions

Software version: 760

Reference #: IV90745

Modified date: 22 January 2017