IJ24917: DISCREPANCY IN COSTS AND TAX CONVERSIONS BETWEEN BASE CURRENCIES

APAR status

• Closed as program error.

Error description

• PROBLEM: Work Center Service Request Details and Comments
  screen is getting cut off on the right.
  When there is a second
  base currency, with exchange rates created correctly and
  validated, costs, taxes and premium pay rate are calculated
  incorrectly in labor transactions and in the Invoice
  application.
  STEPS TO REPRODUCE:
  1) Go to the Currency Codes
  application and create a new currency EGP (Egyptian) . This is
  also reproducible using any other currency.
  2) Go to the Organizations application and in the
  EAGLENA organization add EGP as Base Currency 2.
  3) Go to the Exchange Rates
  application and add 2 new rows for the EAGLENA:
  From Currency:
  EGP
  To Currency: USD
  Exchange Rate: 0.0633935
  Active Date:
  4/1/2020 12AM
  Expiration Date: 4/30/2020 12AM
  From Currency:
  USD
  To Currency: EGP
  Exchange Rate: 15.7744879
  Active Date:
  4/1/2020 12AM
  Expiration Date: 4/30/2020 12AM
  4) Go to the
  Companies application and bring up the CMC company.
  Change its currency to EGP.
  5) Go to the Labor Rate Contracts application and create a new
  Contract.
  Company: CMC
  Total Cost: 1,000,000.00
  6) Go to the Crafts application and bring up ELECT.
  7) Under More Actions > Premium Pay Codes > New row
  Premium Pay Code: OT5
  Default Rate:
  373.00
  Default Rate Type: HOURLY
  OK.
  8) Under Outside Rates click New Row
  Skill Level: FIRSTCLASS
  Vendor: CMC
  Contract:
  1042 (Contract created on the step 5)
  Standard Rate:
  272.00
  Under Premium Pay table click New Row
  Premium Code:
  OT5
  Save.
  9) Go back to Labor Rate Contracts and bring up the
  contract created on step 5.
  Approve it.
  Under Associated Labor
  click new row
  Labor: ADAMS
  Craft ELECT
  Save.
  10) Go to the Labor Reporting application and click on New Row.
  Labor: ADAMS
  Craft
  ELECT
  Vendor: CMC
  Regular Hours: 2
  Work Order: any approved
  Work Order.
  Note: Rate field is not equal 272.00 as documented
  in the Crafts application (see step 8). It was converted to
  USD, them Rate field = 17.24 and Line Cost = 34.48
  272.00 X
  0.0633935 - This is correct.
  11) Under the Premium Pay
  section:
  Premium Pay Code: OT5
  Premium Pay Hours: 1
  Expected result:
  The Premium Pay Rate should be converted to USD as just like
  the Rate field was. The correct value should be 23.65
  Actual result:
  The Premium Pay Rate was not converted to USD. The value
  remained with the EGP value = 373.00.
  12) Save and approve labor.
  13) Mark the line created above and under More Actions
  menu > Create Invoice
  OK.
  14) Go to Invoice application (or
  just hyperlink there through the invoice field)
  The field is filled in correctly except for the Pretax total,
  Invoice total and Total
  Base Cost.
  EXPECTED RESULTS: Pretax Total should be converted to EGP
  currency, since the invoice was created with EGP
  currency.
  ACTUAL RESULTS:
  Labor Reporting Application
  Premium Pay Hours should
  be 23.65 instead 373.00
  Line cost should be 58.13 instead of
  407.48
  Invoice Application
  Pretax total should be 916.97
  (58.13 X 15.7744879) instead 407.48
  Invoice Total should be
  916.97 + 27.51 = 944.48
  Total Base Cost should be 59.87 instead of
  26.61
  REPORTED IN VERSION:
  Version of Maximo:
  7610
  Application within Maximo: Invoice & Labor Reporting
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users with multi-curency                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DISCREPANCY IN COSTS AND TAX CONVERSIONS BETWEEN BASE        *
  * CURRENCIES                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  	  Release 7.6.1.3 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

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels