IJ47091: ORGANIZATION SETTINGS FOR DISALLOW NEGATIVE CURRENT AND NEGATIVE AVAILABLE BALANCES DO NOT GET APPLIED IN ALL SCENARIOS

APAR status

• Closed as program error.

Error description

• ABSTRACT:
  Organization Settings For Disallow Negative Current And Negative
  Available Balances Do Not Get Applied In All Scenarios
  
  DESCRIPTION:
  When the Organization settings for "Disallow Negative Balance"
  and "Disallow Negative Available Balance" are selected, it is
  still possible for the Current Balance and Quantity Available
  field values to have negative values in some scenarios.
  
  Summary: It is incorrect to allow a reconciliation to occur and
  then display a negative balance when the Org settings explicitly
  prevent this.  It is expected that there should be consistent
  enforcement of Organization settings throughout all inventory
  scnearios.  It is also expected that the error message should be
  displayed as soon as the balance is negative
  (pre-reconciliation)
  
  STEPS TO REPRODUCE:
  1.	Log in to maxdemo instance
  2.	Go To Administration | Organizations
  3.	Open the record for EAGLENA
  4.	More Actions | Inventory Options | Inventory Defaults
  5.	Click to select the radio buttons for Disallow Negative
  Balance and Disallow Negative Available Balance
  6.	Click OK
  7.	Save the record
  
  Scenario 1:
  1.	Go To Inventory | Inventory
  2.	Available Queries | All Records
  3.	In the Storeroom field, enter "central"
  4.	In the Site field, enter "bedford"
  
  5.	In the "Rotating?" field, enter "n", then press Enter
  6.	Identify an item that has a Current Balance of 2, and is
  reconciled (Reconciled checkbox selected)
  7.	More Actions | Inventory Adjustments | Physical Count
  8.	In the New Count field, enter 0, then click OK
  9.	More Actions | Issue Current Item
  10.	In the Work Order field | Detail Menu | Go To | Work Order
  Tracking
  11.	In the Status field, enter "appr", then press Enter
  12.	Click any record
  13.	Click Return With Value
  14.	Click OK
  
  15.	More Actions | Inventory Adjustments | Reconcile Balances
  16.	Click OK
  
  RESULT:
  Current Balance and Quantity Available field values display
  -1.00
  
  EXPECTED RESULT:
  Negative Current Balance and negative Quantity Available values
  should not be allowed per Organization settings
  
  Scenario 2:
  1.	Go To Inventory | Inventory
  Create the scenario where there is a quantity of 3 in one Bin,
  and a quantity of 4 in another Bin:
  2.	Open the record for "0G3582" where the Storeroom = BEDFORD
  3.	In the Inventory Balances section, click the New Row button
  4.	In the Bin field, enter "B-5-2"
  5.	In the Current Balance, enter 4
  6.	Save the record
  7.	Verify that the Current Balance and Quantity Available field
  values are both now 7.00
  8.	More Actions | Inventory Adjustments | Physical Count
  9.	In the row for Bin B-5-1, enter 0 in the New Count field,
  then click OK
  10.	Click Close at the System Message, "BMXAA1765E - Physical
  count has been adjusted.
  11.	BMXAA1805I - One or more balances records contained the same
  value as the existing physical count. The physical count will
  not be adjusted for these records."
  12.	Verify that the "Reconciled?" checkbox is unchecked for Bin
  B-5-1
  13.	More Actions | Transfer Current Item
  14.	In the Quantity field, enter 3
  15.	In the To Storeroom field, enter "central", then tab out
  16.	In the To Bin field | Select Value | click B-5-2
  17.	Click OK
  18.	More Actions | Inventory Adjustments | Reconcile Balances
  19.	Click OK
  
  RESULT: System Message, "BMXAA3496E - Trouble processing item
  0G3582. Cause: The balance in the bin will become negative as a
  result of this transaction.." and User is not able to complete
  Reconcile Balances action
  
  EXPECTED RESULT:
  User can complete Reconcile Balances action
  
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.2-IFIX20230424-1022
  Build 20200715-0100 DB Build V7612-284 HFDB Build HF7612-168
  
  LOCAL WORKAROUND:
  none
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The Disallow Negative Current Balance and Disallow Negative  *
  * Available Balance settings do not get applied in all         *
  * scenarios.                                                   *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR will be included 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