IBM Support

IV90667: RETURNING A MATERIAL-TYPE POLINE WITH DISTRIBUTED LINECOST DOES NOT CREATE POCOST-TYPE RETURN RECORDS IN THE MATRECTRANS TABLE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Steps to reproduce:
    
    Go to Purchase Order
    Create new PO=1108, description=testing, Vendor=Franklin supply
    corp
    Go to POline tab, Click New row
    Create new material line-type, description=testing
    Qty=10, Unit cost=10, Line cost=100
    GL debit acct=6000-238-300
    Be sure to check  Receipt returned, Inspection required and
    Issue on receipt
    Save
    
    Click Distribute Cost button
    Create 2 distribute line costs with 50% line each
    Percentage=50.00, Line cost=50.00
    Click OK
    Notice that Distributed check box will automatically be checked
    Click Save
    
    Create another POline
    This time,a Service-line type, description=testing2
    Vendor=Franklin supply corp
    Go to POline tab, Click New row
    Create new material line-type, description=testing
    Qty=100, Unit cost=1, Line cost=100
    GL debit acct=6110-450-200
    Be sure to check  Receipt returned, Inspection required and
    Issue on receipt
    Click Save
    
    Click Distribute Cost button
    Create 2 distribute line costs with 50% line each
    Percentage=50.00, Line cost=50.00
    Click OK
    Notice that Distributed check box will automatically be checked
    Click Save
    Approve PO
    
    Go to Receiving | Material receipts tab
    Search for PO#1108
    Select Ordered items
    Filter Poline #1 with qty of 10
    Click OK
    
    Go to Service receipts tab
    Search for PO#1108
    Select Ordered items
    Filter Poline #1 with qty of 10
    Click OK
    
    Now go back to material receipts tab
    Select Action | Change to Inspection status
    Change qty accepted from 10 to 5
    Change qty rejected from 0 to 5
    Click OK
    
    Navigate to Service receipts tab
    Select Action | Change to Inspection status
    Change qty accepted from 100 to 50
    Change qty rejected from 0 to 50
    Click OK
    
    Try to run below sql queries:
    1)
    select
    ponum,polinenum,matrectransid,issuetype,quantity,receivedunit,un
    itcost,l
    inecost,transdate from maximo.matrectrans where ponum='1108'
    order by
    polinenum,matrectransid;
    
    Results will be:
    1,1108,1,1,336,104,402,RECEIPT,10,[NULL],10,100,2016-10-06-10.58
    .34.0001
    43
    2,1108,1,1,336,104,403,POCOST,5,[NULL],10,50,2016-10-06-10.58.34
    .000174
    3,1108,1,1,336,104,404,POCOST,5,[NULL],10,50,2016-10-06-10.58.34
    .000283
    4,1108,1,1,336,104,405,TRANSFER,5,[NULL],10,50,2016-10-06-10.59.
    04.00006
    5
    5,1108,1,1,336,104,406,RETURN,-5,[NULL],10,-50,2016-10-06-10.59.
    04.00014
    3
    
    Note:
    When the inspection was completed the accepted quantity was
    broken into its distributed POCOST records/quantities, but the
    return was not also broken into its distributed POCOST
    records/quantities.  Data is missing.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Maximo users who use the distributed PO costs functionality. *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The POCOST type of MATRECTRANS were not created for the      *
    * RETURN record created due to the fact that there are         *
    * rejected quantities in the Change Inspection Status dialog   *
    * in the Receiving application.                                *
    ****************************************************************
    * 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

    IV90667

  • Reported component name

    PURCHASING

  • Reported component ID

    5724R46PU

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-11-11

  • Closed date

    2017-01-25

  • Last modified date

    2017-01-25

  • 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: 750

Reference #: IV90667

Modified date: 25 January 2017