IJ17764: UPDATE BUDGET LINES ACTION RESULTS IN INCORRECT CALCULATION

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE :
  
  1. GoTo --> Financial --> Budget Monitoring
  Click New Budget
  
  Enter details:
  Budget: 1022
  Description: PO Revision Test - IBM
  Site: 100
  Year: 2019
  Supervisor: PAUL.LOFTHOUSE
  
  2. Add Focal Point: CHARTOFACCOUNTS
  Condition: glaccount = '43721-RMB'
  NB: Chart of Accounts are already setup - SEG0 = 5 ALN, SEG1 =
  3 ALN
  
  3. Click Save
  
  4. Click Generate Budget Lines
  
  5. Enter an amount in the Direct Material Amount field = 14070.
  
  6. Click Save
  
  7. Approve the Budget Record.
  
  8. GoTo --> Purchasing --> Purchase Orders
  
  9. Click New Purchase Order
  Add necessary details - Description, Company
  
  10. Add a PO Line
  Line Type: Material
  Description: Some Material
  Quantity: 10
  Unit Cost : 100
  GL Debit Account: 43721-RMB
  The Line Cost is 1000 in DKK (Currency comes from Company), the
  Base Currency is USD so Total Base Cost is 1514.12
  
  11. Save the Purchase Order
  
  12. Return to the Budget Record
  
  13. Click Update Budget Lines
  
  14. Observe that an Estimated Total Cost of 1514.12 is entered
  on the Budget Line.
  
  15. Return to the Purchase Order
  
  16. Approve the Purchase Order
  
  17. Return to the Budget Record
  
  18. Click Update Budget Lines
  Observe that both Estimated Total Cost and Committed Total Cost
  now have a value of 1514.12
  
  19. Return to the Purchase Order
  
  20. Revise the Purchase Order
  Change the Unit Cost to 75.
  
  21. Save the PO
  
  22. The Line Cost is now 750 and the Total Base Cost is now
  1135.89
  
  23. Return to the Budget Record
  
  24. Click Update Budget Lines
  
  25. Observe that both Estimated Total Cost and Committed Total
  CostS are now set to 2649.71 while PO is in PNDREV
  
  26. Return to the Purchase Order
  
  27. Approve the Revised Purchase Order
  
  28. Return to the Budget Record
  
  29. Click Update Budget Lines
  
  Observe that both Estimated Total Cost is still 2649.71 while
  Committed Total Cost is now set to 0.00.
  So now Estimated Total Cost appears to = Original PO Base Cost
  + Revised PO Base Cost (not exact probably because of Exchange
  Rate)
  Committed Total Cost is apparently lost.
  
  30. Refresh the application, reopen the Budget and Update
  Budget Lines - no change.
  
  31. Click Duplicate Budget
  Budget Line retains the budgeted value of 14070
  
  32. Click Save.
  
  33. Approve the Budget
  
  34. Click Update Budget Lines
  No Change.
  
  35. Revise the PO again
  
  36. Add an additional material line, Quantity = 5, Unit Cost =
  25 against the same GL Debit Account.
  
  37. Total Base Cost is now 1324.86
  
  38. Approve the PO again.
  
  39. Update the Budget Line again. 2ndRev
  
  40. Receipt the entire PO.
  
  RESULT :
  The final Budget Position is now:
  Estimated Total Cost = 3974.57 (each revision summed)
  Committed Total Cost = 0.00 (reasons unknown)
  Actual Costs = 1324.86 (Total Base Cost of the PO)
  
  EXPECTED RESULT:
  At this point all of theses values are expected to be the same
  - 1324.86.
  
  PRODUCT :
  
  TPAE 7610
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Budget application users in Maximo 7.6.1.0                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * UPDATE BUDGET LINES ACTION RESULTS IN INCORRECT CALCULATION  *
  ****************************************************************
  

Problem conclusion

• Updated scripts to accurately use the most recent revision
  

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