IJ45559: WPMATERIAL.QUANTITY VALIDATION DOES NOT HANDLE NEGATIVE NET ISSUE QUANTITY CORRECTLY

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 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