IJ05918: SERVRECTRANS.LINECOST SHOWS INCORRECT CALCUATION WHEN YOU PARTIALLY RECEIVE A DISTRIBUTED PO

APAR status

• Closed as program error.

Error description

• Environment :
  
  TPAE 7609
  
  Reproduction Steps:
  
  1. Login to Maximo
  
  2. Go to Purchasing --> PO --> Create a new PO 1097
  - Type - STD
  - Company - ATI-R
  - Currency - EUR (Make sure you have a valid USD <--> EUR
  exchange
  rate; In this case the rate is 1: 1.3312)
  
  3. Save the record
  
  4. Go to POLines --> New Row
  Line 1
  - Line Type - Service (Test Description)
  - Quantity - 10
  - Order Unit - each
  - Conversion Factor - 1
  - Unit Cost - 1000
  - Tax Code - empty
  - GL Debit Account - 6000-200-000
  
  5. Save the record
  
  6. Click on Distribute Costs
  - Distribute the PO Cost into 60% and 40%
  - GL Debit Account for both should be 6000-200-000
  
  7. Save the record.
  
  8. POLines --> New Row
  Line 2
  - Line Type - Service (Test Description 2)
  - Quantity - 10
  - Order Unit - each
  - Conversion Factor - 1
  - Unit Cost - 1500
  - Tax Code - empty
  - GL Debit Account - 6000-200-000
  
  9. Save the record
  
  10. Click on Distribute Costs
  - Distribute the PO Cost into 60% and 40%
  - GL Debit Account for both should be 6000-200-000
  
  11. Save the record
  
  12. POLines --> New Row
  Line 3
  - Line Type - Service (Test Description 3)
  - Quantity - 10
  - Order Unit - each
  - Conversion Factor - 1
  - Unit Cost - 2000
  - Tax Code - empty
  - GL Debit Account - 6000-200-000
  
  13. Do not distribute the cost on this PO.
  
  14. Save and approve this PO.
  
  15. Go to Receiving --> 1097 --> Service Reciepts tab --> Select
  ordered Services
  - Line 1 --> Do a partial receipt of 5
  - Line 2 --> Do a full receipt of 10
  - Line 3 --> Do a full receipt of 10
  
  16. Save the record
  - The Receipts status is PARTIAL
  
  17. Now open an sql editor to access the database and enter the
  following query;
  SELECT
  POLINENUM,ISSUETYPE,QUANTITY,CURRENCYUNITCOST,CURRENCYLINECOST,E
  XCHANGER
  ATE,LINECOST,LOADEDCOST,UNITCOST FROM SERVRECTRANS WHERE
  PONUM='1097'
  AND ISSUETYPE='POCOST'
  
  18. The results will contain the values of the 2 distributed
  lines
  (Line 1 and Line 2)
  A - If you look at the POLINENUM 1 --> LINECOST value it shows;
  3544.19
  --> THIS IS INCORRECT
  --> The correct cost should be UNITCOST (1331.20) * Quantity
  (2) =
  2662.4
  --> This cost of 2662.4 is being again multipled by the
  EXCHANGERATE
  (1.3312) to arrive at a cost of 3544.10 which should not be the
  case.
  
  B - If you look at the POLINENUM 1 --> LINECOST value it shows;
  5316.2
  --> THIS IS INCORRECT
  --> The correct cost should be UNITCOST (1331.20) * Quantity
  (3) =
  3993.6
  --> This cost of 3993.6 is being again multipled by the
  EXCHANGERATE
  (1.3312) to arrive at a cost of 5316.28 which should not be the
  case.
  
  C - If you look at the POLINENUM 2 --> LINECOST value it shows;
  7987.2
  --> THIS IS CORRECT
  
  D - If you look at the POLINENUM 2 --> LINECOST value it shows;
  11980.8
  --> THIS IS CORRECT
  
  19. The above indicates that
  
  CURRENT RESULTS :
  - The LINECOST mentioned in 18A and 18B above are incorrect
  (3544.19
  and 5316.2 respectively)
  
  EXPECTED RESULTS :
  - The LINECOST mentioned in 18A and 18B above should be 2662.4
  and
  3993.6 respectively
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * SERVRECTRANS LINECOST SHOWS INCORRECT CALCULATION WHEN YOU   *
  * PARTIALLY RECEIVE A DISTRIBUTED PO IN DIFFERENT CURRENCY     *
  * THAN BASE CURRENCY                                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  		 | Release 7.6.1.0 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:

Fix information

• Fixed component name

  PURCHASING

• Fixed component ID

  5724R46PU

Applicable component levels

• R760 PSY

     UP