APAR status
Closed as program error.
Error description
ABSTRACT: WPMaterial.Quantity Validation Does Not Handle Negative Net Issue Quantity Correctly DESCRIPTION: The application displays the Absolute Value of a negative Net Issue Quantity scenario instead of either disallowing this condition through an error message, or by displaying the negative Net Issue Quantity value in the application. It is observed that the field validation is calculating what's issued from the Work Order, then summing the quantity of the associated matusetrans records; (where Work Order issue transactions are a negative value, and return to storeroom transactions are a positive value). The issue is that the absolute values are being used in the negative net issue calculation. STEPS TO REPRODUCE: 1. Log in to maxdemo instance 2. Go to Administration | Organizations 3. Open the record for EAGLENA 4. More Actions | Work Order Options | Edit Rules 5. In the "WP Materials?" column verify that the checkbox is selected for the row where Status = APPR 6. Click OK; save the record if it was updated 7. Go To Work Orders | Work Order Tracking 8. Common Actions | New Work Order 9. In the GL Account field | Select Value 10. Click 6000, then click 300, then click 200, then click OK 11. On the Plans tab | Materials tab, click the New Row button 12. In the Item field | Detail Menu | Go To | Inventory 13. In the Storeroom field enter "central", then press Enter 14. Identify a record where the Current Balance value is greater than 10 15. Click the record to open it, then click Return Wit Value 16. In the Quantity field update the value to 10 and tab out 17. Save the record 18. Common Actions | Approve Work Order 19. Click OK 20. On the Plans tab | Materials tab | Item field | Detail Menu | Go To | Inventory 21. More Actions | Issue Current Item 22. In the Quantity field enter 6, then tab out 23. In the Work Order field | Detail Menu | Select Value | enter the Work Order number, then press Enter 24. Click the Work Order to select it 25. Click OK 26. Click Return 27. In the Find Work Order field, enter the Work Order number and press Enter to refresh the record 28. On the Plans tab | Materials tab, update the Quantity field to 4, then tab out 29. Click the red X in the Quantity field; message displays, "You entered: 4 The quantity cannot be less than what has been already issued. (BMXAA4642)" 30. Click Edit My Value 31. Update the value to 6, then tab out 32. Observe that no error appears because 6 equals the Net Issue Quantity 33. In the Item field | Detail Menu | Go To | Inventory 34. More Actions | Issue Current Item 35. In the Quantity field enter 4 36. In the Transaction Type field | Select Value | click RETURN 37. In Work Order field | Detail Menu | Select Value 38. In the Work Order field enter the Work Order number, then press Enter 39. Click the record to select it, then click OK 40. Click Return 41. In the Find Work Order field, enter the Work Order number and press Enter to refresh the record 42. Click No at the System Message, "BMXAA2300I - Do you want to save your changes before continuing?" 43. On the Plans tab | Materials tab | Quantity field | update the value to 1, then tab out 44. Click the red X in the Quantity field; message displays, "You entered: 1. The quantity cannot be less than what has been already issued. (BMXAA4642)" 45. Click Edit My Value 46. Update the value to 2, then tab out; no error appears because 2 equals the Net Issue Quantity [6 - 4] 47. In the Item field | Detail Menu | Go To | Inventory 48. More Actions | Issue Current Item 49. In the Quantity field enter 5 50. In the Transaction Type field | Select Value | click RETURN 51. In the Work Order field | Detail Menu | Select Value 52. In the Work Order field, enter the Work Order number, then press Enter 53. Click the record to select it, then click OK 54. Click Return 55. In the Find Work Order field, enter the Work Order number and press Enter to refresh the record 56. Click No at the System Message, "BMXAA2300I - Do you want to save your changes before continuing?" 57. On the Plans tab | Materials tab | Quantity field | update the value to 1, then tab out 58. Click the red X in the Quantity field; message displays, "You entered: 1 The quantity cannot be less than what has been already issued. (BMXAA4642)" 59. Click Edit My Value 60. Update the value to 3, then tab out RESULT: No error appears in the Quantity field; the application incorrectly stores the Net Issue Quantity as 3; this is the Absolute Value of the actual Net Issue Quantity, which is -3 [ABS(6 - 4 -5)]. EXPECTED RESULT: Either an error should appear to prevent the negative Net Issue Quantity, or the negative Net Issue Quantity value should populate the Quantity field. REPORTED IN VERSION: Tivoli's process automation engine 7.6.1.2-IFIX20220726-1528 Build 20200715-0100
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * MAXIMO * **************************************************************** * PROBLEM DESCRIPTION: * * WPMATERIAL.QUANTITY VALIDATION DOES NOT HANDLE NEGATIVE NET * * ISSUE QUANTITY CORRECTLY * **************************************************************** * RECOMMENDATION: * * A property is introduced to resolve this issue, * * "mxe.app.wpmaterial.enablenetnegativeqty". * * When "mxe.app.wpmaterial.enablenetnegativeqty" is set to * * "0", * * totalIssueQty will be calculated as ABS value. This is * * default behaviour as Maximo currently works. * * When "mxe.app.wpmaterial.enablenetnegativeqty" is set to * * "1", totalIssueQty will be calculated as ABS value, then * * multiplied by -1. This is new behaviour to calculate net * * issue qty as nagetive value. * ****************************************************************
Problem conclusion
The fix for this APAR will be contained in a future release.
Temporary fix
Comments
APAR Information
APAR number
IJ45559
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-02-22
Closed date
2023-10-03
Last modified date
2023-10-03
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:
03 October 2023