IV61447: MAXIMO 7.5 - UNINVOICED TOTAL IS NOT REFLECTING THE SPENDING ACTIVITY.

APAR status

• Closed as program error.

Error description

• Problem: When a new invoice is created against a PO with
  previous
  
  spending activity, the uninvoiced total is not reflecting the
  spending
  activity. This issue is seen only when the site ID of PO and new
  Invoice are different. When the site ID of PO and new invoice
  are same,
  then the uninvoiced total is reflecting the spending activity.
  
  
  App Server: IBM WebSphere Application Server 7.0.0.21
  Version: IBM Maximo Asset Management 7.5.0.5 Build 20130903-1504
  DB
  Build V7505-00
  IBM Maximo for Transportation 7.5.1.0 Build 20130902-1500 DB
  Build
  V7510-10
  Tivoli's process automation engine 7.5.0.5-IFIX20131125-1226
  Build
  20130903-1504 DB Build V7505-43 HFDB Build HF7505-01
  IBM Maximo for Service Providers 7.5.1.2-20131119-0852 Build
  20130520-1027 DB Build V7512-13 HFDB Build HF7512-02
  IBM Maximo for Utilities 7.5.0.1-20131212-0652 Build
  20120710-0136 DB
  Build V7501-14 HFDB Build HF7501-04
  IBM Maximo for Nuclear Power 7.5.1.0-20131009-1046 Build
  20121004-0300
  DB Build V7510-17 HFDB Build HF7510-12
  IBM Maximo Calibration 7.5.0.0 Build $build$ DB Build V7501-01
  IBM TPAE Integration Framework 7.5.1.0-IFIX7510MIF-01 Build
  20130916-0400 DB Build V7510-28
  Server OS: Linux 2.6.32-279.14.1.el6.x86_64
  Server DB: Oracle 11.2 (Oracle Database 11g Enterprise Edition
  Release
  11.2.0.3.0 - 64bit
  
  ACTION TAKEN:
  tested and replicated with steps below core 7505:
  
  
  1. Go to Purchasing > Purchase Orders
  2. Create a new PO against any valid Company -  #1096 - GCE (max
  7504) -
  1096 (max 7505) - Bedford as the site
  3. Click on PO Lines Tab > then New Row Button
  4. Add a PO Line with the following info
    Item = any valid Item - 0-0031
    Quantity = 200
    and Cost = 50
    Save, approve and take note of this PO number - can not save
  without
  storeroom - I entered Central for this test.
  
  Create a new (1st partial) Invoice for the above PO
  5. Go to Purchasing > Invoice
  6. Create a new Invoice with below details against the above PO
  number.
  In this the PO number 657290
   Vendor Invoice = TEST UNINVOICED TOTAL (give any text)
    Invoice Date = enter appropriately. In this case current date
  was
  keyed in.
    Invoice Receipts Date = enter appropriately. In this case
  current date
  was keyed in.
  Go to Invoice Lines Tab > click copy PO lines > choose PO 657290
  then,
  Quantity = 30
  Save, and take note of this Invoice number. In this case invoice
  number
  is 2508809
  Mine INV # is 1068 (max 7504) - Max 7505 (INV 1068)
  
  In this case, Invoice is created for a quantity 30 out 200 with
  unit
  cast 50. The total line cost for this invoice is 1500. Here,
  un-invoiced
  total is 8500 as 1st invoice for 1500 only is created. This is
  good and
  working as expected.
  
  
  Create a new (2nd partial) Invoice for the above PO
  7. Go to Purchasing > Invoice
  8. Create a new Invoice with below details against the above PO
  number.
  In this the PO number 657290
  Mine inv # is 1070 (max 7504) - inv 1069 on max 7505
    Vendor Invoice = TEST 2ND UNINVOICED TOTAL (give any text)
    Invoice Date = enter appropriately. In this case current date
  was
  keyed in.
    Invoice Receipts Date = enter appropriately. In this case
  current date
  was keyed in.
  Go to Invoice Lines Tab > click copy PO lines > choose PO 657290
  then,
  give
  Quantity = 70
  Save, and take note of this Invoice number. In this case invoice
  number
  is 2508811
  
  First 30 items out of 200 are taken care by the 1st invoice. In
  this
  case, there are only 170 items and Invoice is created for a
  quantity 70
  out 170 with unit cast 50. The total line cost for this invoice
  is 3500.
  Here, un-invoiced total is 5000 as 1st invoice for 1500 and 2nd
  invoice
  is for 3500. This is good and working as expected
  
  
  To see the issue, change the default site for the user
  9. Go to Profile > Default Information
  10. Change the Default Insert Site to any site that is not the
  same as
  that of both PO and Invoice.
  
  I used Denver
  
  Create a new (3nd partial) Invoice for the above PO
  12. Go to Purchasing > Invoice
  13. Create a new Invoice with below details against the above PO
  number.
  In this the PO number 657290
  Mine INV # 1071 on Max 7504 - on max 7505 ( inv # 1070)
    Vendor Invoice = TEST 3RD UNINVOICED TOTAL (give any text)
    Invoice Date = enter appropriately. In this case current date
  was
  keyed in.
    Invoice Receipts Date = enter appropriately. In this case
  current date
  was keyed in.
  Go to Invoice Lines Tab > click copy PO lines > choose PO 657290
  then,
  give
  Quantity = 70
  Save, and take note of this Invoice number. In this case invoice
  number
  is 2508812
  
  
  On Max 7505 - this is replicated - total cost on Inv 1070 is
  10,000 and
  Uninvoiced Total is 10,000 on site Denver
  
  Conclusion: When the site ID of PO and invoice are same, then
  the
  uninvoiced total reflects the previous spending activity. If
  site ID of
  PO and new invoice are different, the invoiced total was reset
  to the PO
  total cost even though there are valid invoices against the PO.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Maximo Invoice users.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * UNINVOICED TOTAL IS NOT REFLECTING THE SPENDING ACTIVITY.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply release 7.5.0.7 of base services or request an interim *
  * fix                                                          *
  ****************************************************************
  

Problem conclusion

• Fixed the calculation of Uninvoiced PO Total Cost for cross site
  invoices.
  

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

• R750 PSY

     UP