IV96610: BMXAA1964E WHEN USING LARGE CURRENCY EXCHANGES EVEN WITH DB ATTRIBUTES INCREASED

APAR status

• Closed as program error.

Error description

• PRE-SETTINGS
  Based on the following tech note to increase db attributes
  https://www-304.ibm.com/support/docview.wss?uid=swg21443939
  
  change field Length to 17. Amount type to Length 17.
  
  To test this PMR, at least change PO related module,
  ServRecTrans module
  and Invoice related module to Length 17.
  Amount type to Length 17.
  
  1. Go to Security Groups, find MAXADMIN group. Click Limits and
  Tolerances tab.
  Find EAGLENA. Under Limits section, remove PR, PO, Invoice,
  Contract and
  MR Limit. Make all fields null value.
  
  Upper Invoice Amount:  100.00
  
  Logout to make sure the setting works.
  
  2. Go to Currency Codes. Create a new Currency IQD. Make sure
  it's Active.
  
  ======================================================
  
  REPRODUCTION STEPS
  
  1. Exchange Rate > New
     Convert From Currency = IQD
     Convert To Currency = USD
     Exchange Rate = 0.000857
     Active Date today's date, current time is ok (For example,
  05 Apr 2017 10:00 AM)
     Expiration Date today's date, set time to 11:45 pm (For
  example, 05
  Apr 2017 11:45 PM)
  
  2. Purchase Orders - > New
     PO: POEGC, Currency:  IQD, Company:  VOLVO (no tax involved)
  
  3. PO Line Tab -> New Row button
     Line 1, Line Type:  Service, Qty: null, Order Unit: NULL,
  Line Cost:
  261,501,600.00
     GL Debit Acc:  6000-200-000
     Save
     Approve PO
     Now shows Total Cost: 261,501,600.00. (PO.TOTALCOST)
  
  4. Purchasing ->  Invoices -> New
  
  Invoice:INEGC, PO: POEGC
  Inoice Lines -> Copy PO Lines
  Invoice Line1 -> Line 1, Service, Qty null, change Line Cost:
  174,334,400.00
  Approve Invoice
  
  Invoice got approved.
  
  5. Exchange Rate > Find IQD to USD. Very important step.
     Exchange Rate = 0.000846
  
  6. Purchasing ->  Invoices -> New
  
  Invoice: INEG2C PO: POEGC
  Inoice Lines -> Copy PO Lines
  Invoice Line1 -> Line 1, Service, Qty: null, Unit Cost:
  87,167,200.00
  Approve Invoice
  
  Error Message dispalyed:
  BMXAA2013E - Could not change invoice INEG2C status to APPR.
  BMXAA1964E - Cannot approve invoice INEG2C. The difference in
  cost between line 1 of the invoice and the purchase order line
  is 2,266,065.248 IQD, which exceeds the tolerance of 118,203.31
  IQD.
  
  (the number in error message could be little different when you
  testing... )
  

Local fix

• The removal of the Upper Invoice Amount allows the invoice to
  be approved, however then this check is not performed which
  could be of interest to customers.
  
  Because of the large values, we found that some invoices got
  approved but a few would not.  Could be considered a short term
  workaround in business critical invoicing.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When invoice line cost has large decimal (Length is 17)      *
  * setting, PO and invoice are not using base currency and with *
  * Invoice Approve Limit set, users may get cannot approve      *
  * invoice error message.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  		 | Release 7.6.0.9 of Base Services
  

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

  INVENTORY

• Fixed component ID

  5724R46IN

Applicable component levels

• R760 PSY

     UP