IJ34901: IN THE INVOICES APPLICATION, UNABLE TO APPROVE INVOICE AFTER SETTING INVOICE TOLERANCE AND EXCHANGE RATES.

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE:
  
  1. Go to Currency Codes application.
  
  2. Add the new Currency CNY Chinese Yuan and save it.
  
  3. Go to Organizations application.
  
  4. Create and activate a new Organization ORG20 as the
  following:
  Base Currency 1: CNY - Chinese Yuan
  Base Currency 2: USD - US Dollar
  Item Set: SET1
  Company Set: COMPSET1
  
  5. Still in Organizations application, with ORG20 on the screen,
  go to Sites tab and add the new Site SITE20.
  
  6. Go to Chart of Accounts application.
  
  7. Filter the list by Organization ORG20.
  
  8. From More Actions menu, select Validation Options.
  
  9. From Validation Options dialog, select only the option
  "Deactivate GL Validations?" and click OK.
  
  10. Go to Company Master application.
  
  11. Bring up Company BWC, make sure the Currency is set to USD
  and add that Company to Organization ORG20.
  
  12. Go to Users application.
  
  13. Create a User named user20, associated to MAXADMIN Group and
  Default Insert Site SITE20.
  
  14. Go to Security Groups application.
  
  15. Bring up MAXADMIN Group and go to Limits and Tolerances tab.
  
  16. Set the following Limits and Tolerances for Organization
  ORG20:
  PR Limit: 1,000.00
  PO Limit: 1,000.00
  MR Limit: 1,000.00
  Invoice Limit: 1,000.00
  Contract Limit: 1,000.00
  
  Upper Invoice Amount: 0.50
  Lower Invoice Amount: -0.50
  Upper Invoice Percent: (clear up this field)
  Lower Invoice Percent: (clear up this field)
  
  17. Login to Maximo as user20.
  
  18. Go to Exchange Rates application.
  
  19. Add the following Exchange Rate for Organization ORG20:
  Convert from Currency: USD
  Convert to Currency: CNY
  Exchange Rate: 6.4522800
  Active Date: the system date, 1:00 AM. In this example, 9/2/21
  1:00 AM.
  Expiration Date: the system date, 11:00 PM. In this example,
  9/2/21 11:00 PM.
  
  20. Go to Purchase Orders application.
  
  21. Create a PO against BWC Vendor with just 01 PO Line as the
  following:
  Line Type: Service
  Description: Testing
  Quantity: 1.00
  Order Unit: EACH
  Unit Cost: 28.98
  Charge To > GL Debit Account: any valid GL Account.
  
  22. Save, approve PO and take note of its number.
  
  23. Go to Receiving application.
  
  24. Bring up the PO above and receive it completely.
  
  25. On the following day, login to Maximo as user20.
  
  26. Go to Exchange Rates application.
  
  27. Add the following Exchange Rate for Organization ORG20:
  Convert from Currency: USD
  Convert to Currency: CNY
  Exchange Rate: 6.5146000
  Active Date: the system date, 1:00 AM. In this example, 9/3/21
  1:00 AM.
  Expiration Date: the system date, 11:00 PM. In this example,
  9/3/21 11:00 PM.
  
  28. Go to Invoices application.
  
  29. Create an Invoice associated to the PO above and save it.
  
  30. Go to Invoice Lines tab and click on Copy PO Lines button.
  
  31. From Copy PO Lines dialog, select the PO Line and click OK.
  
  32. Save the Invoice and try to approve it.
  
  RESULTS:
  At this point, the system throws the error:
  "BMXAA2013E - Could not change invoice XXXX status to APPR.
  BMXAA1964E - Cannot approve invoice XXXX. The difference in cost
  between line 1 of the invoice and the purchase order line is
  -0.01 USD, which exceeds the tolerance of 0.077 USD."
  
  EXPECTED RESULTS:
  No error while trying to approve the Invoice.
  
  REPORTED IN VERSION:
  IBM Maximo Asset Management 7.6.1.1
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IN THE INVOICES APPLICATION, UNABLE TO APPROVE INVOICE AFTER *
  * SETTING INVOICE TOLERANCE AND EXCHANGE RATES.                *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 Product.
  

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

  PURCHASING

• Fixed component ID

  5724R46PU

Applicable component levels