IJ24807: MAXIMO ALLOWS USER TO CHANGE AN ITEM FROM ROTATING TO NON-ROTATING WHEN THERE ARE RECEIPTS IN WASSET STATUS.

APAR status

• Closed as program error.

Error description

• When a rotating item has been partially received i.e.
  the status in the receiving applicaiton is WASSET MAximo
  allows the item's designation to be changed from
  Rotating to Non-rotating. Invoice match is matching
  to an incomplete matrectransid row in invoicematch table.
  
  Login to a Maximo environment as WILSON
  Access the Item Master application.
  Create a new record Item: CHTST_3
  Check the Rotating? flag; set the issue unit to ?EACH?; save the
  record:
  Change the status to "ACTIVE" for the EAGLENA org, be sure to
  check the Roll Status checkbox
  
  Go to the Purchase Order application
  Create a new PO
  Set Vendor=DATACHIP
  Go to the PO Line tab and insert a new row, set Item: CHTST_3
  Set the conversion to factor to 1; unit cost to 100; GL Debit
  Acct to 6100-200-000
  Save the record
  Change the status on the PO to approved
  
  Go to the Receiving application and query the PO created above:
  Click on Select Ordered Items, an place a check on the po line
  Click OK
  The status of the receipt is now WASSET
  Save the receipt:
  
  Go to the Invoice application.
  Insert a new invoice, reference the PO created above
  Go to the Invoice Lines tab and click on the Copy the PO Line,
  place checkmark next to po
  line and Click OK in dailog box
  Save the Invoice
  Approve the Invoice
  
  RESULT
  Error received not allowing the invoice to be approved
  BMXAA2013E - Could not change invoice XXXX status to APPR.
  BMXAA1981E - The sum of all invoice quantities for invoice
  XXXX for line 1 of purchase order XXXX exceeds the
  quantity that has been received.
  
  Click on OK
  Click on Cancel
  
  Go to the Item Master application and access the item created
  above
  Uncheck the Rotating option
  Save the record
  
  RESULT: the record is saved
  EXPECTED RESULT: the item should not be allowed to have its
  Rotating deisgnation changed to Non-Rotating
  
  Currently, allowing this then results in the record in the
  INVOICEMATCH table to reference the wrong row (MATRECTRANSID) in
  the MATRECTRANS table
  
  Continued steps to demonstrate the result of allowing the item's
  rotating desgination to be changed:
  
  Go to the Receiving application and access the PO created above
  Click on Add new row button, set PO Line to 1; select item
  created above; set Quantity to 1:
  Save the record
  Status of record with new receipt is COMP
  
  GO to the Invoice application and access the invoice created
  above
  Approve the invoice:
  
  
  Invoice successfully is approved
  
  From a data access tool, select the associated records from
  MATRECTRANS:
  
  Select itemnum, issuetype, status, matrectransid, GLDEBITACCT,
  GLCREDITACCT from maxwam.MATRECTRANS where PONUM = 'XXXX';
  
  Note the MATRECTANSID value for row with Status=WASSET
  
  Select the associated record(s) from INVOICEMATCH:
  Select invoicenum, invoicelinenum, ponum, polinenum,
  matrectransid from maxwam.invoicematch where invoicenum =
  'XXXX';
  
  Note the MATRECTRANSID for the row returned in INVOICEMATCH
  matches back to the row in MATRECTRANS with Status=WASSET
  
  The row in INVOICEMATCH should match back to
  row with Status=COMP in MATRECTRANS
  
  i.e. Invoice matches to an incomplete receipt transaction.
  when the Invoice should match to the complete receipt
  transaction only.
  
  EXPECTED RESULT: The application should not allow the change of
  item from Rotating to Non-rotating when there exists receipts
  for the item in WASSET status
  
  
  
  
  Version
  Tivoli's process automation engine 7.6.0.9
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * MAXIMO ALLOWS USER TO CHANGE AN ITEM FROM ROTATING TO        *
  * NON-ROTATING WHEN THERE ARE RECEIPTS IN WASSET STATUS.       *
  ****************************************************************
  

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:

Fix information

• Fixed component name

  INVENTORY

• Fixed component ID

  5724R46IN

Applicable component levels