IV90668: RETURNING ANY POLINE WITH DISTRIBUTED LINECOST RESULTS IN UNITCOST BEING CALCULATED INCORRECTLY FOR THOSE POCOST-TYP

APAR status

• Closed as program error.

Error description

• Returning any POLine with distributed linecost results in
  unitcost being calculated incorrectly for those POCOST-type
  return records in matrectrans or servrectrans
  
  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
  
  Run this sql query :
  select
  ponum,polinenum,servrectransid,issuetype,quantity,,unitcos
  t,line cost,transdate from maximo.servrectrans where
  ponum='1108' order by
  polinenum,servrectransid;
  
  Results will be:
  1,1108,2,100,074,RECEIPT,100,1,100,2016-10-06-10.59.16.000925
  2,1108,2,100,075,POCOST,50,1,50,2016-10-06-10.59.16.000940
  3,1108,2,100,076,POCOST,50,1,50,2016-10-06-10.59.17.000018
  4,1108,2,100,077,RETURN,-50,1,-50,2016-10-06-10.59.41.000487
  5,1108,2,100,078,POCOST,-25,-0.5,-25,2016-10-06-10.59.41.000519
  6,1108,2,100,079,POCOST,-25,-0.5,-25,2016-10-06-10.59.41.000581
  
  Note:
  The return for the service receipt rejection did generate the
  appropriate POCOST records for the distributed quantities, but
  the assigned unitcost value is incorrect.  The unitcost should
  = 1.00.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users who use the PO distribution functionality.      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * POCOST type of MATRECTRANS and SERVRECTRANS have incorrect   *
  * unitcost when a RETURN type was created due to Rejected      *
  * quantity in Inspecting.                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * none                                                         *
  ****************************************************************
  

Problem conclusion

• This is fixed in code.
  
  The fix for this APAR is contained in the following maintenance
  package:
  		 | Release 7.6.0.8 of Base Services
  

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

  PURCHASING

• Fixed component ID

  5724R46PU

Applicable component levels

• R760 PSY

     UP