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 number
IJ48728
Reported component name
MAXIMO ASST MGM
Reported component ID
5724R46AM
Reported release
761
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-09-26
Closed date
2023-09-28
Last modified date
2023-09-28
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"761","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
28 September 2023