IJ48951: WRONG DIFFERENCE VALUE DISPLAYED AT INVOICE APPROVAL

APAR status

• Closed as program error.

Error description

• When a purchase order is created in one currency, and the
  corresponding invoice in another currency, and there are no
  Invoice Tolerances defined, the error message generated at
  invoice approval displays a wrong difference in cost.
  
  STEPS TO REPRODUCE:
  1) Go to MAXADMIN group in Security Groups.
  
  Then, go to Limits and Tolerances Tab For EAGLENA
  Organization, under Invoice Tolerance section
  
  set Upper Invoice Amount= 0
  set lower Invoice Amount=0
  Save and logout
  
  2) Login to Maximo as maxadmin and go to Exchange Rate
  application
  Create new rate conversions
  Convert from Currency: BOLIVAR
  Convert to Currency: USD
  
  Exchange Rate: 0.0022000
  Active Date: current day time
  
  Expiration Date: a later date
  Convert from Currency: USD
  
  Convert to Currency: BOLIVAR
  Exchange Rate: 449.7100000
  Active Date: same as above
  
  Expiration Date: same as above
  3) Go to PO Application.
  
  Create a PO (e.g.,1094) with any vendor.
  
  Currency USD
  
  In POLINE, add a new Line
  
  - Line type: Item
  
  - Item number: 1002
  
  - Storeroom: CENTRAL
  - Quantity: 1
  
  - Unit Cost: 2.20
  
  - Line Cost will be 2.20
  
  PO Total cost will be 2.20
  PO Base currency will be 2.20
  
  Approve the PO
  4) Go to Receiving App.
  
  Open PO (1094).
  
  Click select Ordered Items, select that line, and click OK
  Save
  
  Click Change Inspection Status, select the line and click OK.
  This will change the status to COMPLETE.
  
  5) Go to Invoice App. create a new invoice (1068)
  
  Set ponum as 1094.
  
  Currency BOLIVAR
  Click Invoice Line Tab.
  
  Click Copy PO Lines button Select that line and click Ok.
  
  Save.
  
  Click 'Change Status' to approve it.
  
  Invoice Total cost will be 989.36
  
  Invoice Base currency will be 2.18
  
  Got error, the invoice cannot be approved:
  
  BMXAA2013E - Could not change invoice XXXXX status to APPR.
  
  BMXAA1964E - Cannot approve invoice XXXXX. The difference in
  cost between line 1 of the invoice and the purchase order line
  is 987.16 BOLIVAR, which exceeds the tolerance of 0 BOLIVAR.
  
  RESULT:
  The difference in cost value is not correct (value in BOLIVAR
  value in USD)
  
  EXPECTED RESULT:
  The difference in cost value displayed should be correct.
  Inn this example the messages should be
  BMXAA2013E - Could not change invoice NNNNN status to APPR.
  BMXAA1983E - Cannot approve invoice NNNNN. The difference in
  cost between line 1 of the invoice and the purchase order line
  is -0.023 USD, which is less than tolerance of 0 USD.
  
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.3
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * _MAXIMO_                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * WRONG DIFFERENCE VALUE DISPLAYED AT INVOICE APPROVAL         *
  ****************************************************************
  When the invoice currency and the POline currency are not the
  same, the difference in the value is not displayed properly in
  the error message when approving the invoice. (For example,
  difference is calculated as 989.36 BOLIVAR - 2.20 USD = 987.16
  BOLIVAR (which is wrong)
  Fix- The difference will now be calculated in the base currency
  and the invoice difference is now calculated by converting the
  total in the base currency and multiplying the exchange rate.
  (For example ( (989.36 BOLIVAR * 0.0022200 (exchange rate)) USD
  - 2.20 USD) = -0.023 USD
  

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