IJ48910: PO/PR TOTAL COSTS AND TAX CALCULATION ERROR

APAR status

• Closed as program error.

Error description

• Problem with Total Cost and Tax values that do not match Pretax
  Totals.
  There is a problem with poline line type material when deleting
  the poline line qty, it clears the
  unit cost and the line cost but does not clear the tax and
  loaded cost fields leading to
  
  incorrect tax and total cost calculations.
  
  
  
  The same behaviour exists in both POLine and PRLine-with line
  type of either item or material
  
  
  Steps to Reproduce.
  1)Purchase Requisitions > create new PR=TEST12
  2)Company = BEX
  
  3)PRLINES > click new row
  4)Line type = material > description =testing
  
  Qty =1 , Unit Cost = 1000.00  > Line Cost = 1000.00
  
  Tax Code =PA > Tax = 60.00 >Loaded Cost =1000.00
  5)click Save
  6)PR Header  Pretax = 1000.00, Tax =60.00, Total Cost =1060.00
  (this is correct)
  7)PRLINES> Line 1 > remove Qty set to blank > tab out , Unit
  Cost moves to blank , Line Cost moves to 0.00
  Tax remains at 60.00  and Loaded Cost remains at 1000.00
  this is not correct  the Tax and the Loaded Cost fields should
  also
  
  be set back to 0.00  same as the Line Cost field.
  
  8)Set the Line Cost =99.00 > set the Qty = 1 , Unit Cost
  populates with 99.00 - note the Tax Field does not recalculate
  it remains as 60.00 and the Loaded Cost field does not
  recalculate it remains at 1,000.00 , Total Cost = 1060.00   This
  is not correct the tax and the loaded Cost fields should be
  re-calculating to the new  unit/line cost value and updating the
  Total Cost with the correct value.
  
  9)PR Header Pretax Total = 99.00, Tax = 60.00 , Total Cost
  =1060.00 -   The tax and the total cost are incorrect  the
  original tax and and total cost are carried over due to no
  recalculation of the tax and loaded cost fields.
  
  
  10)Purchase Orders > create new PO=TEST12
  11)Company = BEX
  
  12)POLINES > click new row
  13)Line type = material > description =testing
  
  Qty =1 , Unit Cost = 1000.00  > Line Cost = 1000.00
  
  Tax Code =PA > Tax = 60.00 >Loaded Cost =1000.00
  14)click Save
  15)PO Header  Pretax = 1000.00, Tax =60.00, Total Cost =1060.00
  (this is correct)
  16)POLINES> Line 1 > remove Qty set to blank > tab out , Unit
  Cost moves to blank , Line Cost moves to 0.00
  Tax remains at 60.00  and Loaded Cost remains at 1000.00
  this is not correct  the Tax and the Loaded Cost fields should
  also
  
  be set back to 0.00  same as the Line Cost field.
  
  17)Set the Line Cost =99.00 > set the Qty = 1 , Unit Cost
  populates with 99.00 - note the Tax Field does not recalculate
  it remains as 60.00 and the Loaded Cost field does not
  recalculate it remains at 1,000.00 , Total Cost = 1060.00   This
  is not correct the tax and the loaded Cost fields should be
  re-calculating to the new  unit/line cost value and updating the
  Total Cost with the correct value.
  
  18)PO Header Pretax Total = 99.00, Tax = 60.00 , Total Cost
  =1060.00 -   The tax and the total cost are incorrect  the
  original tax and and total cost are carried over due to no
  recalculation of the tax and loaded cost fields.
  
  
  
  Results:
  POLINES/PRLINES> when a remove Qty set to blank the tax and
  loaded cost  remain the same they do not reset /recalculate
  causing incorrect tax and total costs
  
  
  
  
  Expected Results:
  What is the expected behavior:  when the the qty  is removed
  that the unit cost and line cost are set back to 0.00.
  and the tax and loaded cost fields are reset/recalculated.
  
  
  Reported in Version
  
  IBM Maximo Asset Management  7.6.1.2  and  7.6.1.3
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * _MAXIMO_                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PO/PR TOTAL COSTS AND TAX CALCULATION ERROR                  *
  ****************************************************************
  The issue
  When the quantity in the PO/PR line is set to 0, the unit cost
  and line cost becomes 0, but the tax value, loaded cost and
  header cost values (pretaxtotal) remain the same and does not
  get updated.
  After fix
  When the quantity for the PO/PR line is set to 0, the unit cost
  and line cost become 0, so on the action of line cost being 0,
  recalculating the tax values and the pretax total values now for
  that particular line of PO/PR.
  

Problem conclusion

• The fix for this APAR will be contained in a future release.
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels