IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    IJ02359

  • Reported component name

    PURCHASING

  • Reported component ID

    5724R46PU

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-12-04

  • Closed date

    2018-02-18

  • Last modified date

    2018-02-18

  • 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



Document information

More support for: Maximo Asset Management
Purchase Requisitions

Software version: 750

Reference #: IJ02359

Modified date: 18 February 2018