IZ80064: RECEIVING APPLICATION INCORRECTLY UPDATES RECEIVEDTOTALCOST FIELD OF INVENTORY PO LINE OF PO IN FOREIGN CURRENCY.

APAR status

• Closed as program error.

Error description

• Environment:
  - Maximo 7.1.1.5 (data upgraded from Maximo 4.1.1)
  also tested on Base Services 7.1.1.6-LA20100419
  - WebSphere 6.1 64bit (v 6.1.0.19; cluster environment)
  - Oracle 10
  - Windows 2003 64bit
  Receiving application incorrectly updates RECEIVEDTOTALCOST
  field of
  inventory PO line of PO in foreign currency.
  Service lines are calculated correctly.
  Steps to reproduce:
  1. create PO in foreign currency (USD, exchange rate with base
  currency
  AUD is 1.3048)
  2. add a PO Line #1: inventory item, quantity=1, unit cost=100
  3. add a PO line #2: service, quantity=1, unit cost=100
  4. approve PO, go to receiving application
  5. completely receive service line
  Expected result:
  - RECEIVEDTOTALCOST field of service PO line #2 is 100 - CORRECT
  Back-end script (most important fields):
  1) insert into servrectrans (currencycode, ,linecost) values
  (?...,?)
  LINETYPE = SERVICE
  CURRENCYCODE = USD
  CURRENCYUNITCOST = 100.0
  EXCHANGERATE = 1.3048
  UNITCOST = 130.48
  TAX1 = 13.05
  TAX1CODE = GST STD
  QUANTITY = 1.0
  CURRENCYLINECOST = 100.0
  LOADEDCOST = 130.48
  LINECOST = 130.48
  2) update poline set
  receivedqty=?,receiptreqd=?,isdistributed=?,
  rejectedqty=?,receivedtotalcost=?,receivedunitcost=?,receiptscom
  plete=?
  where polineid=? and rowstamp=?
  RECEIVEDQTY = 1.0
  RECEIPTREQD = 1
  ISDISTRIBUTED = 0
  REJECTEDQTY = 0.0
  RECEIVEDTOTALCOST = 100.
  RECEIVEDUNITCOST = 100.0
  6. completely receive Inventory Item line
  Expected result:
  - RECEIVEDTOTALCOST field of service PO line #1 is 130.48
  INCORRECT
  Back-end script (most important fields):
  1) insert into matrectrans (currencycode, ,issue) values (?, ,?)
  LINETYPE = ITEM
  ITEMNUM = 440-22540
  CURRENCYCODE = USD
  CURRENCYUNITCOST = 100.0
  UNITCOST = 130.48
  EXCHANGERATE = 1.3048
  TAX1 = 13.05
  CONVERSION = 1.0
  TAX1CODE = GST STD
  ACTUALCOST = 130.48
  QUANTITY = 1.0
  LINECOST2 = 100.0
  CURRENCYLINECOST = 100.0
  LOADEDCOST = 130.48
  TOSTORELOC = MAIN
  POLINENUM = 1
  LINECOST = 130.48
  2) update poline set
  receivedqty=?,isdistributed=?,rejectedqty=?,
  receivedtotalcost=?,receivedunitcost=?,receiptscomplete=? where
  polineid=? and rowstamp=?
  RECEIVEDQTY = 1.0
  ISDISTRIBUTED = 0
  REJECTEDQTY = 0.0
  RECEIVEDTOTALCOST = 130.48
  RECEIVEDUNITCOST = 130.48
  More logs are in the attached log file: SystemOut - incorrect
  Received
  Total calculation.log
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: maximo users                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: RECEIVING APPLICATION SHOULD UPDATE     *
  *                      RECEIVEDTOTALCOST  FIELD OF PO LINE OF  *
  *                      PO IN FOREIGN CURRENCY.                 *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  RECEIVING APPLICATION SHOULD UPDATE RECEIVEDTOTALCOST  FIELD OF
  PO LINE OF PO IN FOREIGN CURRENCY.
  

Problem conclusion

• <Per product designer, vendor currency line cost should be used
  to update poline.receivedtotalcost.  This is fixed in code.>
  
  
  
  
  
  The fix for this APAR is contained in the following maintenance
  package:
  
    | release\fix pack | REL 7.1.1.8 - BS
  

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

• R711 PSY

     UP