IV90778: INVENTORY USAGE QUANTITY RECEIVED SHOULD CONSIDER VOIDED QUANITY

APAR status

• Closed as program error.

Error description

• PREREQUISITE DATA
  
  1. Go to Inventory -> Storerooms application -> NEW Storeroom
  
   Location: STORE901 ( Transmission Stores GWR)
   GL Control Account: 6000-100-000
   Cost Adjustment Account:6000-100-000
   Ship to Address: BEDFORDMAIN
   Bill to Address: BEDFORDMAIN
   Removed Bill to Labor: null
   Site: Bedford
   Shrinkage Account: 6000-100-000
   Use in PO/PR? - checked
  
   Location: STORE008 (Temporary Holding Storeroom)
   GL Control Account: 6000-100-000
   Cost Adjustment Account:6000-100-000
   Ship to Address: BEDFORDMAIN
   Bill to Address: BEDFORDMAIN
   Site: Bedford
   Shrinkage Account: 6000-100-000
   Use in PO/PR? - checked
  
  2. Go to Inventory -> Item Master
   Create new Item: EGITEM01
   Commodity Group: 26101500 (ENGINES)
   Lot Type: NO LOT
  3. Change Status Item to ACTIVE
  
  4.1 Select action -> Add Items to Storeroom STORE901
    EGITEM01, Average, Unit Cost: 0, Current Balance 220,
    Issue Unit: EACH, Order Unit: EACH
    OK
  4.2 Select Action -> Add Items to Storeroom STORE008
    EGITEM01, Average, Unit Cost: 0, Current Balance 0,
    Issue Unit: EACH, Order Unit: EACH
    OK
  
  4.3 Go to Inventory -> Intentory -> Search EGITEM01
  
  Should see two entries:
   EGITEM01 in STORE901 with 220 balance
   EGITEM01 in STORE008 with 0 balance
  
   Open each and set to Active
  
  REPRODUCTION STEPS
  
  5.1 Go to Inventory -> Inventory Usage -> Create an Inventory
  Usage
   Record to transfer item 14615 from storeroom ST901 to ST008.
  
   Inventory Usage: 1039 (Inventory Usage Test)
   From Storeroom: STORE901
   Usage Type: TRANSFER
   Site: Bedford
  
   Usage Line Section -> New Row
   Usage Type: Transfer
   Line type: Item
   Item: EGITEM01
   Quantity: 50
   To Storeroom: STORE008
   To Site: BEDFORD
   GL Debit Account:6000-100-100
   GL Credit Account:6000-100-000
   SAVE
  
  06. Change status other usage record to SHIPPED
   Shows Shiptment:  1005
   Note Quantity Shipped: 50
  
  07. Shipment Receiving -> display the shipment 1005
   Click on button Select Shipped Items
   Select the item and enter quantity due as 20. Click OK.
   SAVE
  
  08. Validate the change in storeroom quantity: SUCCESS
  Inventory-> Search EGITEM01
  
  Storeroom STORE901 has 170 (=220-50 transferred quantity)
  Storeroom STORE008 has 20 (received in shipment application)
  
  09. Inventory -> Shipment Receiving -> Search 1005
   Button Select Shipped Item
   Select the item and enter Qty Due 5. Click OK
   Save
  
  10. Validate the change in storeroom quantity: SUCCESS
  Inventory-> Search EGITEM01
  
  Storeroom STORE901 has 170 (=220-50 transferred quantity)
  Storeroom STORE008 has  25 (20+5 received in shipment
  application)
  
  15. Go To Inventory usage ->  1039
   Open drop down
   Validate the received quantity as 25
   INVUSELINE.RECEIVEDQTY
  
  16. Inventory -> Shipment Receiving -> 1005
   Button Select Records to Void
   Select row where number of quantity received is 5. Click OK.
   Save
   You should now see Quantity 20, 5 and -5
  
  17. Validate the change in storeroom quantity:
  Inventory-> Search EGITEM01
  
  Storeroom STORE901 has 170 (=220-50 transferred quantity)
  Storeroom STORE008 has  20 (20 received in shipment application)
  
  EGITEM01 IN STORE901 Total Quantity Shipped is 25
  INVENTORY.SHIPPEDQTY
  
  EGITEM01 IN STORE008 Quantity Available is 20
  INVENTORY.AVBLBALANCE
  
  CONCLUSION:  The scenario reproduces in the same way as the
  customer describes in the L2 lab.
  Inventory INVENTORY.CURBTOTAL is incorrect and does not take
  Void items into account.
  
  You can void a shipment receipt transaction that was created in
  error. When you void a shipment receipt, the record returns to
  its former state and storeroom balances are resolved.
  
  A voided receipt has the same effect on storeroom balances as a
  return, but a voided receipt cannot be used on a credit invoice.
  
  CURRENT ERROUNEOUS RESULT:
  The value for  INVUSELINE.RECEIVEDQTY should have been 20
  insted of 25
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * INVENTORY USAGE QUANTITY RECEIVED SHOULD CONSIDER VOIDED     *
  * QUANTITY                                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  		 | Release 7.6.0.8 of Base Services
  

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

  INVENTORY

• Fixed component ID

  5724R46IN

Applicable component levels

• R760 PSY

     UP