IV99519: UNABLE TO RETURN ITEMS WITH ISSUE COST TYPE FIFO,IF THE CURRENT BALANCE WAS ADJUSTED IN INVENTORY SUBSEQUENT TO RECEIPT.

APAR status

• Closed as program error.

Error description

• When a partial receipt is performed for an item designated in
  Inventory
  as FIFO for Issue Cost Type and the current balance is
  subsequently
  adjusted from within Inventory, the no. of items for return in
  the
  Receiving application is reduced by that amount.
  We came to realize when we received 40 items through a PO, that
  requested a quantity of 60, which was determined to be the wrong
  PO and
  we then tried to adjust the curbalanace for the item to 0 .
  We have to return the items received through the Wrong PO
  
  When we attempted to return the receipts on the worng PO from
  Receiving
  application
  using ?Select item for Return? button, the dialog box doesn?t
  show the received 40 items.
  
  Steps to Replicate the Issue:
  
  Fisrt set up the item to use:
  Go to Inventory<Item Mster and click Insert New Record
  Issue Unit=EACH, Order Unit=EACH
  Select Action<Add Item to Storeroom, Storeroom=CENTRAL
  Issue Cost Type=FIFO, Click OK
  Change Status, New Status=ACTIVE, CHECK checkbox, Roll New
  Status to
  Organizations and Inventory?
  Click OK
  
  Now the steps to demo the issue
  a)  Create a PO for an item=item created above, Company=EMI
  b)  On PO Lines tab, New Row, Quantity=60, Storeroom=CENTRAL,
  Inspection
  Required checkbox is checked
  c) Save and approve the PO
  d) Go to Receiving app and recall the PO above. Click the Select
  Ordered Items button, check the line and change the quantity to
  40,
  click OK
  e) Select Action<Change Inspection Status, check the line and
  click
  OKand then Save
  RESULTS: Receipts staus=PARTIAL
  CLick the Select Items for Return button and note the quantity
  available for return=40
  f)  Go to Inventory application and recall Item=item created
  above
  Storeroom=CENTRAL, check the Inventory currbal for the item
  g)  Select Action<Inventory Adjustments<Current Balance, click
  the line
  with Current Balance=40, under New Balance enter 32, click OK
  h)  Go to Receiving app and recall the PO above, cLick the
  Select Items
  for Return button and note the quantity
  available for return=32
  i)  Go to Inventory application and recall Item=item created
  above
  Storeroom=CENTRAL, check the Inventory currbal for the item
  j)  Select Action<Inventory Adjustments<Current Balance, click
  the line
  with Current Balance=32, under New Balance enter 8, click OK
  k)  Go to Receiving app and recall the PO above, cLick the
  Select Items
  for Return button and note the quantity
  available for return=8
  l)  Go to Inventory application and recall Item=item created
  above
  Storeroom=CENTRAL, check the Inventory currbal for the item
  m)  Select Action<Inventory Adjustments<Current Balance, click
  the line
  with Current Balance=8, under New Balance enter 0, click OK
  n)  Go to Receiving app and recall the PO above, cLick the
  Select Items
  for Return button and note the resulting dialog box HAS NO LINE
  0) Return to inventory application. Select Action<Inventory
  Adjustments<Current Balance, click
  the line
  with Current Balance=0, under New Balance enter 40, click OK
  p) Go to Receiving app and recall the PO above, cLick the
  Select Items
  for Return button and note the resulting dialog box HAS NO LINE
  
  This is incorrect.
  this is the difference in the behavior between 7506 and
   7507, in 7506 you can go back to Inventory and adjust the
  current balance from zero to 40. When this is performed and you
  go to the Receiving applicaiton and  try to return the qty 40 in
   the Select Items for Return dialog box you will be able to save
   the return after you select the
  row. The quantity for the return line is -40 and upon save the
  Receipts field goes back to NONE. So the return is effectively
  accomplished as a check of Inventory shows the available
  balance for the item as zero  .
  This is not the case in 7507 - 7.5.0.11, recall when you reduce
  the
  balance of the item to zero in Inventory and go to the Receiving
  application and   try to return the qty 40 in the Select Items
  for Return dialog box this cannot be done as there is NO line in
  said dialog box. Subsequently, unlike the behavior in 7506, when
  you adjust the available balance for the item in Inventory then
  return to the Receiving application and hit the Select Items to
  Return dialog box there is still no line entry.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users who use the LIFO/FIFO functionaltiy                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Could not return receipt for an LIFO/FIFO item when there is *
  * balance in the INVLIFOFIFOCOST records created by inventory  *
  * current balance adjustment.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• This is fixed in code.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.0.9 Product
  

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:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  INVENTORY

• Fixed component ID

  5724R46IN

Applicable component levels

• R760 PSY

     UP