IJ51216: IN THE RECEIVING APPLICATION, RECEIVED COST CALCULATED INCORRECTLY WHEN INVOICE TRANSACTION IS RECORDED IN SERVICE RECEIPTS.

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE:
  
  Dataset:
  . Organization with base currency 1 USD and base currency 2
  Chilean PESO.
  . TAX1, Tax Rate: 19%
  . Company COMP1, Currency: USD.
  
  Steps:
  
  1. Increase both Cost and Quantity fields' Length to 19 and
  Scale to 4 following the technotes below:
  https://www.ibm.com/support/pages/increasing-cost-fields-length
  -unit-cost-or-line-cost
  https://www.ibm.com/support/pages/node/534621
  
  2. Increase the EXCHANGE.EXCHANGERATE field Length to 17 and
  Scale to 10.
  
  3. Go to Exchange Rates and set below value for current date:
  USD to PESO: 811.9800000000
  PESO to USD: 0.0012315574
  
  4. Create a PO against Company COMP1 with currency code as USD.
  4.1. Add a service to poline with Quantity as 1, Unit cost
  350,000.0000.
  4.2. Charge the service poline against any location.
  
  5. Approve the PO.
  
  6. Go to Receiving > Receive quantity of 0.0486 in service.
  
  7. In the next day, set the Exchange Rate as below:
  USD to PESO: 895.7700751703374
  PESO to USD: 0.0011163579
  
  8. Create Invoice in PESO for the received quantity and approve
  it.
  
  9. Receive another quantity of 0.3651.
  
  10. In the next day, set Exchange Rate as below:
  USD to PESO: 863.2300098805
  PESO to USD: 0.0011584398
  
  11. Create Invoice in PESO for the received quantity.
  
  12. Give the unit cost and tax values as below (remove the
  values in decimal place), save and approve the Invoice:
  Unit Cost: 302,130,503.0000
  Tax: 20,958,490.0000
  
  13. Go to Receiving > INVOICE type transaction has been added.
  
  14. Run the SQL query below:
  select exchangerate,exchangerate2,itemnum,linecost,loadedcost,c
  urrencylinecost,currencycode,quantity,transdate,issuetype
  from servrectrans where ponum='XXXX' and siteid='YYYY' order by
  transdate desc;
  
  RESULTS:
  The system is adding the value in CLP (issue type INVOICE) and
  USD (issue type RECEIPT) as Received Total cost.
  Received Total Cost: 127785 + 17010 - 0.1726 = 144794.8274
  
  EXPECTED RESULTS:
  System should not be including a value in CLP (issue type
  INVOICE) with received total cost.
  It should either exclude or convert the value in USD to add with
  other RECEIPT issue types.
  Received Total Cost: 127785 + 17010 = 144795
  
  REPORTED IN VERSION:
  IBM Maximo Asset Management 7.6.1.3
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IN THE RECEIVING APPLICATION, RECEIVED COST CALCULATED       *
  * INCORRECTLY WHEN INVOICE TRANSACTION IS RECORDED IN SERVICE  *
  * RECEIPTS                                                     *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 9.x Product
  

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