IJ02359: INCORRECT INVOICE CURVAR VALUE WHEN THE ITEM HAS ISSUE COST TYPE AS FIFO

APAR status

• Closed as program error.

Error description

• Incorrect Invoice CURVAR value when the item has issue cost
  type as FIFO
  Steps to reproduce:
  1. Go to -> Purchasing -> Company Master -> click on New
  Company -> Create a company: TEST
  Currency: EUR
  2. Select Action -> select 'Add Company Master to Organization'
  3. Go To -> Inventory -> Item Master -> click on New Item
  Item: TESTAD
  Issue Unit: EACH
  Order Unit: EACH
  4. Select Action -> Add Items to Storeroom
  Storeroom: CENTRAL then click OK
  Item: TESTAD
  Issue Cost Type: FIFO
  Unit Cost: 101.41
  Current Balance: 1
  Issue Unit: EACH
  Order Unit: EACH
  !! The issue is reproducible only is the Issue Cost Type is FIFO
  5. Select Action -> Change status -> Active
  Check the 'Roll New Status to Organizations and Inventory?'
  checkbox and click OK
  6. Go To -> Purchasing -> Purchase Orders -> Click on New
  Purchase Order
  PO: 1104
  Currency: EUR
  Company: the company created at step 1: TEST
  7. PO Lines tab:
  PO Lines section -> click on New Row:
  Item: the item created at step 3: TESTAD
  Quantity: 1
  Conversion Factor: 1
  Unit Cost: 101.41
  Line Cost: 101.41
  Storeroom: CENTRAL
  Save and Approve the PO.
  8.Go To -> Purchasing -> Receiving -> filter for the PO created
  at step 6: 1104
  9. Material Receipts tab -> Click on Ordered Items -> select
  the item and click OK.
  10. Go To -> Finanacial -> Exchange Rates:
  For the EAGLENA Organization filter for the active exchange
  rate:
  Convert from Currency: EUR
  Convert to Currency: USD
  11. Change the Exchange Rate: from 1.3312000 to 1.160000
  12. Go To -> Purchasing -> Invoices -> click on New Invoice
  PO: the PO created at step 6: 1104
  13. Invoice Lines tab -> click Copy PO Lines -> select the PO
  and click OK.
  14. Approve the Invoice
  15. Select Action -> View Related Records -> Invoice
  Transactions tab:
  Result: A CURVAR value that is not correct:
  CURVAR: -17.37
  TOTAL: 117.64
  If you check on the Material Receipts tab you will see that
  after the conversion the Line Cost should be 135.00
  In client's case the CURVAR + TOTAL = 135.01
  For the client the CURVAR is calculated as:
  Invoice line cost(with exchange rate) - Material Receipt line
  cost(with exchange rate).
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users who use the invoice app for FIFO/LFIFO items    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Invoice CURVAR value was calculated incorrectly due to       *
  * multiple times of rounding if exchange rate was changed      *
  * between material receipt and invoice approval.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• This is fixed in code.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.1.0 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:

Modules/Macros

• maximo
  

Fix information

• Fixed component name

  PURCHASING

• Fixed component ID

  5724R46PU

Applicable component levels

• R760 PSY

     UP