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":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
12 June 2017