IZ60738: RECEIVING ITEM USING CONVERSION,LINECOST, LOADEDCOST,LINECOST2 AND CURRENCYLINECOST ARE CALCULATED WRONGLY

APAR status

• Closed as program error.

Error description

• Problem description:
  
  When in Maximo receiving an item that is using conversion, the
  linecost, loadedcost, linecost2 and currencylinecost are
  calculated wrongly.
  This issue seems to (re)occur in Maximo 5.2 patch 8 and Supply
  Maximo 5.2 patch 4.
  Observation:
  
  The field quantity is recalculated with conversion but unitcost
  are still the same, witch makes the prior fields calculated
  wrongly.
  I've tried to recalculate unitcost and currencyunitcost with
  conversion but the rounding will be far from exact as the format
  of unitcost is number(10,2).
  
  Environment:
  
  Maximo 5.2 patch 8
  Oracle 9.0.2
  BeaWebLogic 7
  Windows 2003 Server
  
  
  Steps to replicate issue:
  
  1)Go to ?material receipts? tab to receive the material e.g:
  PO=1000
  Vendor=XXX
  PO status=INPRG
  Ordered cost= 1650,00,
  Received cost= 1006,50
  Receipt Status= Partial
  Ordered date= 2009-09-07 9:10
  2)Say line 6, item 223264, change the order unit to one with a
  conversion =1,
  3) Receive Quantity =10 with Order unit =fat with conversion 1.5
  and unit cost 16.50. In MATRECTRANS quantity = 15
  N.B!: The quantity is recalculated according to conversion but
  unit cost remains the same. The linecost becomes quantity *
  unitcost, not the same as in purchase order.
  
  Because:
  4) You receive 10 @ PO line cost 165,00 before hand
  5) Before changing order unit, it shows Conversion 1.5 for
  orderunit "fat" (in ?receiving>Select Order/Issue Unit)
  6) After changing order unit, the PO-line cost is multiplied
  with conversion (1.5) ,but   unit cost remained 16,5.  Linecost
  should remain 165,however shows 247.50
  7) When looking in matrec trans  via select statement on the
  record it shows:
  
  Quantity=15
  Unit cost=16.50
  Actual cost= 16.50
  Conversion=1.5
  Line cost=247.50
  Loaded cost=247.50
  Qtyrequested=10
  
  Looks very similar like issue 06-18694
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Receiving users.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Problem description:                    *
  *                                                              *
  *                      When in Maximo receiving an item that   *
  *                      is using conversion, the                *
  *                                                              *
  *                      linecost, loadedcost, linecost2 and     *
  *                      currencylinecost are                    *
  *                                                              *
  *                      calculated wrongly.                     *
  *                                                              *
  *                      This issue seems to (re)occur in Maximo *
  *                      5.2 patch 8 and Supply                  *
  *                                                              *
  *                      Maximo 5.2 patch 4.                     *
  *                                                              *
  *                      Observation:                            *
  *                                                              *
  *                      The field quantity is recalculated with *
  *                      conversion but unitcost                 *
  *                                                              *
  *                      are still the same, which makes the     *
  *                      prior fields calculated                 *
  *                                                              *
  *                      wrongly.                                *
  *                                                              *
  *                      I've tried to recalculate unitcost and  *
  *                      currencyunitcost with                   *
  *                                                              *
  *                      conversion but the rounding will be far *
  *                      from exact as the format                *
  *                                                              *
  *                      of unitcost is number(10,2).            *
  *                                                              *
  *                      Environment:                            *
  *                                                              *
  *                      Maximo 5.2 patch 8                      *
  *                                                              *
  *                      Oracle 9.0.2                            *
  *                                                              *
  *                      BeaWebLogic 7                           *
  *                                                              *
  *                      Windows 2003 Server                     *
  *                                                              *
  *                      Steps to replicate issue:               *
  *                                                              *
  *                      1)Go to ?material receipts? tab to      *
  *                      receive the material e.g:               *
  *                                                              *
  *                      PO=1000                                 *
  *                                                              *
  *                      Vendor=XXX                              *
  *                                                              *
  *                      PO status=INPRG                         *
  *                                                              *
  *                      Ordered cost= 1650,00,                  *
  *                                                              *
  *                      Received cost= 1006,50                  *
  *                                                              *
  *                      Receipt Status= Partial                 *
  *                                                              *
  *                      Ordered date= 2009-09-07 9:10           *
  *                                                              *
  *                      2)Say line 6, item 223264, change the   *
  *                      order unit to one with a                *
  *                                                              *
  *                      conversion =1,                          *
  *                                                              *
  *                      3) Receive Quantity =10 with Order unit *
  *                      =fat with conversion 1.5                *
  *                                                              *
  *                      and unit cost 16.50. In MATRECTRANS     *
  *                      quantity = 15                           *
  *                                                              *
  *                      N.B!: The quantity is recalculated      *
  *                      according to conversion but             *
  *                                                              *
  *                      unit cost remains the same. The         *
  *                      linecost becomes quantity *             *
  *                                                              *
  *                      unitcost, not the same as in purchase   *
  *                      order.                                  *
  *                                                              *
  *                      Because:                                *
  *                                                              *
  *                      4) You receive 10 @ PO line cost 165,00 *
  *                      before hand                             *
  *                                                              *
  *                      5) Before changing order unit, it shows *
  *                      Conversion 1.5 for                      *
  *                                                              *
  *                      orderunit "fat" (in ?receiving>Select   *
  *                      Order/Issue Unit)                       *
  *                                                              *
  *                      6) After changing order unit, the       *
  *                      PO-line cost is multiplied              *
  *                                                              *
  *                      with conversion (1.5) ,but   unit cost  *
  *                      remained 16,5.  Linecost                *
  *                                                              *
  *                      should remain 165,however shows 247.50  *
  *                                                              *
  *                      7) When looking in matrec trans  via    *
  *                      select statement on the                 *
  *                                                              *
  *                      record it shows:                        *
  *                                                              *
  *                      Quantity=15                             *
  *                                                              *
  *                      Unit cost=16.50                         *
  *                                                              *
  *                      Actual cost= 16.50                      *
  *                                                              *
  *                      Conversion=1.5                          *
  *                                                              *
  *                      Line cost=247.50                        *
  *                                                              *
  *                      Loaded cost=247.50                      *
  *                                                              *
  *                      Qtyrequested=10                         *
  *                                                              *
  *                      Looks very similar like issue 06-18694  *
  *                                                              *
  *                      LOCAL FIX:                              *
  *                                                              *
  *                      n/a                                     *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  RECEIVING ITEM USING CONVERSION,LINECOST,  LOADEDCOST,LINECOST2
  AND CURRENCYLINECOST ARE CALCULATED WRONGLY
  

Problem conclusion

• This issue is not reproducible.  The client confirmed it must
  be due to the end their heavily customized environment and has
  confirmed we can close both the logged APAR as well as the PMR
  
  
  
  
  
  The fix for this APAR is contained in the following maintenance
  package:
  
    | release\fix pack | REL 5.2
  

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

  INVENTORY

• Fixed component ID

  5724R46IN

Applicable component levels

• R620 PSY

     UP