IJ34703: UPDATING MATUSETRANS IN WORKORDER WILL ADD ADDITIONAL LINES WHEN THE ITEM IS LIFO/FIFO

APAR status

• Closed as program error.

Error description

• Problem description:
  Updating matusetrans in workorder will add additional lines when
  the item is LIFO/FIFO resulting in the sum being over what was
  issued.
  This works fine when doing the same steps in the UI.
  
  Steps to reproduce:
  1. Create a new item and add the item into a storeroom:
  CENTRAL Storeroom
  Issue Cost Type: LIFO
  Unit Cost: 5
  Current Balance: 3
  Issue Unit: EACH
  Order Unit: EACH
  
  Change Status to Active
  2. Create a new PO, Add vendor and a new po line for the item
  created at step 1
  Storeroom: CENTRAL
  Quantity: 3
  Unit Cost: 8
  
  Approve PO.
  
  3. Receive the PO.
  
  4. Create a new PO.
  
  5. Using REST API add the item created at step 1 in the Actuals
  tab -> Materials subtab
  Quantity: 4
  Because the item is of LIFO type it should split as follows: one
  line with a quantity of 3 and one line with a quantity of 1.
  This updates matusetrans table.
  
  REST API:
  /maximo/oslc/os/MXAPIWODETAIL/133346?lean=1&_lid=maxadmin&_lpwd
  =maxadmin
  
  x-method-override: PATCH
  patchtype: MERGE
  
  Body:
  {
  "siteid":"BEDFORD",
  "matusetrans":[
  {
  "issuetype": "ISSUE",
  "itemnum": "ADITEM9",
  "positivequantity": "4",
  "siteid": "BEDFORD",
  "sendersysid" : "MX",
  "sourcesysid" : "MX",
  "storeloc": "CENTRAL",
  "wonum":"ADWO9"
  }
  ]
  }
  
  Result:
  Adds 2 lines: one line with a quantity of 4 and one line of a
  quantity of 1.
  
  Using other object structures has the same results.
  
  Other object structures I tried:
  /maximo/oslc/os/MXAPIINVISSUE?lean=1&_lid=maxadmin&_lpwd=maxadm
  in
  
  x-method-override: SYNC
  
  Body:
  {
  "issuetype": "ISSUE",
  "itemnum": "ADITEM8",
  "positivequantity": "4",
  "siteid": "BEDFORD",
  "sendersysid" : "MX",
  "sourcesysid" : "MX",
  "storeloc": "CENTRAL",
  "wonum":"ADWO8"
  }
  
  Product version:
  Maximo 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * MIF sending FIFO/LIFO matusetrans records did not split the  *
  * quantities correctly.                                        *
  ****************************************************************
  

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.3 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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels