IV75765: CONSIGNMENT INVOICE NOT USING MATRECTRANS

APAR status

• Closed as program error.

Error description

• During Current Balance Adjustment and Reconcilation adjustment
  Consignment Invoice is using item's loaded cost for unit cost
  when when it should be using the unit cost from MATRECTRANS
  
  Reproduced Maximo Asset Management 7.5.0.8, 7.5.0.6, 7.5.0.7
  
  Steps to Replicate:
  
  1.Go Organizations select Eaglena
  2.Go to Select Action / Purchasing Options / Tax Options
  3.Open the details for TAX1 and check the For All Items.  You
  can do the same for TAX2-TAX3.  Click OK
  4.Inventory > Item Master> create new Item # Test9A
  5.Select Action> "Add Item to Storeroom", Storeroom = Central
  click ok
  6.Storeroom Information window opens,
  7.Expand item row, check Consignment, Issue Cost Type =
  FIFO(auto populates when Consignment checked),
  Unit Cost= 10.00, Issue Unit=Each ,Order Unit =Each, Consignment
  Vendor = WB, Invoice Generation Type = MANUAL, click ok
  8.Save record
  9.Change status = Active , select "Roll New Status to
  Orgnaizations and Inventory", click ok
  10.Purchase Orders App, create new PO # TestAA, Vendor = WB(must
  be the Conginment Vendor used in Step#7)
  11.POLines tab, click new row , Line type=Item, Item #=
  Test9A(item created in Step #4), Storeroom = Central,quantity =
  1,conversion factor =1, unit cost =10.00,
  11a.Take note of loaded cost = 10.68 (unit cost + tax)
  12.Save and Approve PO
  13.Receiving App, Select PO# TestAA(created in Step #10)
  14.Materials tab , click "Select Order Items", select poline
  item, click ok
  15.Save record
  16.Inventory,select consignment item #Test9A(created in step
  #4), note: Inventory LIFO/FIFO Costs > Unit Cost = 10.68 POLINE
  loaded cost from PO # TestAA (created step #10)
  17.Select Action >"Inventory Adjustments"> "Current Balance" >
  New Balance = 0, click ok , Save record
  18.Invoices, create new #Testcon , type =consignment, company =
  WB (item consignment Vendor from Step #7)
  19.Invoice lines, click "Select Consignment Transactions",
  select consignment item #Test9A,
  20.Expand Inovice Lines> note: the Unit cost = the loaded cost
  from the POLines Step #11 this is not correct, the loaded cost
  is now the loaded cost plus tax added again not correct
  Expected behaviour Unit Cost should = Unit cost from POLines
  Step#11 , Loaded Cost should = Loaded Cost from POLines Step
  #11.
  Do not save Invoice, will now do consignment item inventory
  reconciliation and then create consignment invoice again
  21.Inventory , select consignment item # Test9A > Select Action
  >"Inventory Adjustments"> "Reconcile Balances" > click ok
  22.Invoices, create new #Testcon , type =consignment, company =
  WB (item consignment Vendor from Step #7)
  23.Invoice lines, click "Select Consignment Transactions",
  select consignment item #Test9A,
  24.Expand Inovice Lines> note: the Unit cost = the loaded cost
  from the POLines Step #11 this is not correct, the loaded cost
  is now the loaded cost plus tax added again not correct
  Expected behaviour:
  Unit Cost should = Unit cost from POLines Step #11
  Loaded Cost should = Loaded Cost from POLines Step #11
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Consignment Invoice is not using Matrectrans loaded cost.    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * During Current Balance Adjustment and Reconcilation          *
  * adjustment Consignment Invoice is using item's loaded cost   *
  * for unit cost when when it should be using the unit cost     *
  * from MATRECTRANS.                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixpack Release 7.5.0.9 of Base Services or request an *
  * interim fix.                                                 *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contined in the follwing maintenance
  package:
     | release\fixpack\interim fix for 7.5.0.9
  

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

• R750 PSY

     UP