IJ40245: INVOICETRANS RECORD NOT CREATED WHEN APPROVING MATERIAL INVOICES

APAR status

• Closed as program error.

Error description

• When creating a PO (payment on receipt) and a material is
  immediately received and then canceled, invoices are created for
  each transaction and the lines in the INVOICETRANS table.
  When the PO is revised, the cost of the material changes and it
  is received, the invoice is created, but the rows in the
  INVOICETRANS table are not.
  
  STEPS TO REPRODUCE:
  
  1) Go to PO application and create a new PO: 1097
  Company: WES
  Pay on Receipt?: checked
  
  Under Po Lines tab add new row
  Line Type: MATERIAL
  Description: Material for test
  Quantity: 1
  Order Unit: EACH
  Unit Cost: 100.00
  GL Debit Account: 6100-200-200
  
  Save and Approve it
  
  2) Go to Receiving application and bring up the PO 1097
  
  Under Material Receipts tab click on Select Ordered Items
  Select the line created above
  OK
  
  Save
  
  An invoice will be created for this PO 1071
  
  3) From SQL tool run the following query:
  SELECT * FROM MAXIMO.INVOICETRANS WHERE invoicenum = '1071';
  
  Here is the entry created in INVOICETRANS for invoice 1071 on
  invoice approval
  
  4) Go bac to Receiving application and bring up PO 1097
  
  Under Material Receipts tab click on Select Items to Return
  Select the line
  OK
  
  Save
  
  An invoice will be created for this PO 1072
  
  5) From SQL tool run the following query:
  SELECT * FROM MAXIMO.INVOICETRANS WHERE invoicenum = '1072';
  
  Here is the entry created in INVOICETRANS for invoice 1072 on
  invoice approval
  
  6) Go back to PO application and bring up PO 1097
  
  Under More Actions > Revise PO
  
  Under Po Lines tab > change the Unit Cost for this material to
  110.00
  
  Save and Approve
  
  7) Go back to Receiving application and bring up PO 1097
  
  Under Material Receipts tab click on Select Ordered Items
  Select the line with the new cost
  OK
  
  Save
  
  An invoice will be created for this PO 1073
  
  3) From SQL tool run the following query:
  SELECT * FROM MAXIMO.INVOICETRANS WHERE invoicenum = '1073';
  
  Result: No rows are returned for invoice 1073.
  
  Expected Results: The rows should be returned as was done
  previously with invoices 1071 and 1072.
  
  
  
  Reported in Version: 7612
  Application within Maximo: Invoices
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Invoice                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * INVOICETRANS RECORD NOT CREATED WHEN APPROVING MATERIAL      *
  * INVOICES                                                     *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR will be contained in a future release.
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels