IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    IV96610

  • Reported component name

    INVENTORY

  • Reported component ID

    5724R46IN

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-05-25

  • Closed date

    2017-06-12

  • Last modified date

    2017-06-12

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"}, "Product":{"code":"SSCHPMA","label":"Inventory"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":""}]

Document Information

Modified date:
12 June 2017