IJ48728: BMXAA0106E-CANNOT DELETE LINE 1 BECAUSE IT IS REFERENCED IN THE INVOICE TABLE"

APAR status

• Closed as program error.

Error description

• Error on po line deletion "BMXAA0106E:Cannot delete Line 1
  because it is referenced in the Invoice table."
  When same PO number is present on multiple sites  and if the
  line 1 of one of site is invoiced , the deletion of same line on
  another is not allowed. The prompt "BMXAA0106E:Cannot delete
  Line 1 because it is referenced in the Invoice table." is
  erroneously thrown.
  
  Steps to Reproduce:
  
  ***Scenario 1 same PO number exists in same Org,
  different Sites
  1)User Wilson>default insert site Nashua(Org EagleNA)
  1)Purchase Orders>create new PO #MB1097>Vendor=ATI
  2)POLINES>add 1 line
   2a)click new row>Item=GLOVES>Storeroom=PKG
  3)Save>Change Status=APPR
  4)Receiving>select PO #MB1097>Material Receipts>click
  "select ordered items" select all items
  5)SAVE
  6)Invoices>create new Invoice  1071>PO=MB1097
  7)Invoice Lines>click Copy PO Lines>select all lines>click ok
  8)SAVE>Change status=Approved
  *** Change  User Default site
  9)User Wilson>change default insert site Bedford(Org EagleNA)
  10)Purchase Orders>create new PO #MB1097>Vendor=BEX
  11)POLINES>add 2 lines
   11a)click new row>Item=IKLEEN>Storeroom=CENTRAL>Line 1
   11b)click new row>Item=GLOVES>Storeroom=CENTRAL>Line 2
  12)Save> Change Status = APPR
  13)Receiving> select PO #MB1097>Material Receipts>click
  "select ordered items" select only line \#2
  14)SAVE
  15)Invoices>create new Invoice 1072>PO=MB1097
  16)Invoice Lines>click Copy PO Lines>select only line #2>click
  ok
  17)SAVE
  18)Purchase Order>select PO #MB1097
  19)more actions > select revise PO  receive message "BMXAA8060W
  This purchase order revision is referenced on one or more
  open invoice documents. Document 1072 currently references this
  purchase  order revision. Do you want to proceed? "
  20)Click YES
  21)Delete Line 1>click trash can> receive message
  "BMXAA0106E: Cannot delete Line 1 because it is referenced in
  the Invoice table."
  This is not correct
  
  ***Scenario 2  same PO number exists in same Org ,
  different Sites
  21)User Wilson>default insert site ChileHQ(Org EalgeSA)
  22)Purchase Orders > create new PO \#MB1107 > Vendor = ATI
  23)POLINES>add 1 line
   23a)click new row>Item=OIL15W30>Storeroom=SANTIAGO
  24)Save >Change Status=APPR
  25)Receiving>select PO #MB1107>Material Receipts>click
  "select ordered items" select all items
  26)SAVE
  27)Invoices>create new Invoice 1071>PO=MB1107
  28)Invoice Lines>click Copy PO Lines>select all lines>click ok
  29)SAVE > Change status = Approved
  ***Change  User Default site
  30)User Wilson>change default insert site Bedford(Org EagleNA)
  31)Purchase Orders>create new PO #MB1107>Vendor=BEX
  32)POLINES> add 2 lines
   32a)click new row>Item=IKLEEN > Storeroom = CENTRAL>Line 1
   33b)click new row>Item=GLOVES> Storeroom = CENTRAL >Line 2
  33)Save>Change Status=APPR
  34)Receiving>select PO #MB1107>Material Receipts>click
  "select ordered items" select only line #2
  35)SAVE
  36)Invoices>create new Invoice 1072>PO=MB1107
  37)Invoice Lines>click Copy PO Lines>select only line #2
  >click ok
  38)SAVE
  39)Purchase Order>select PO #MB1107
  40)more actions>select revise PO receive message "BMXAA8060W
  This purchase order revision is referenced on one or more
  open invoice documents. Document 1072 currently references this
  purchase  order revision. Do you want to proceed? "
  41)Click YES
  42)Delete Line 1>click trash can>receive message
  "BMXAA0106E: Cannot delete Line 1 because it is referenced in
  the Invoice table."
  This is not correct.
  
  
  RESULTS:
  receive message "BMXAA0106E Cannot delete Line 1 because it
  is referenced in the Invoice table."
  this is not correct  it appears that when
  deleting poline item from a revised  PO that has had at least
  one other poline invoiced so that it logged to the invoice
  table,and the same PO number exists on a different site in the
  same org,or same PO number exists in different org and site
  that has been already been invoiced example:
   PO #MB1097 poline 1 was already invoiced in site Nahsua
  ,and when trying to delete PO #MB1097 poline #1 in Bedford
  site the error is being generated  the search query of the
  invoice table does  not take into account the  "site"  , causing
  this problem.
  
  
  EXPECTED RESULTS:
  to be able to successfully  delete a poline from a PO  that has
  at least one other line item that has been invoiced,  and the
  same PO number  exists in a different site in same org ,
  or same PO number exists in different org and site with the
   same poline # already invoiced without generating
  "BMXAA0106E:Cannot delete Line 1 because it is referenced in
  the Invoice table."
  
  
  REPORTED IN VERSION:
  IBM Maximo Asset Management 7.6.1.3
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * BMXAA0106E-CANNOT DELETE LINE 1 BECAUSE IT IS REFERENCED IN  *
  * THE INVOICE TABLE                                            *
  ****************************************************************
  

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