IJ41487: WHEN INSPECTION REQUIRED IS CHECKED FOR PO LINE, CHANGE QUANTITYAND ORDER UNIT, PO RECEIVED IN FULL INSTEAD OF PARTIAL

APAR status

• Closed as program error.

Error description

• When changing the Order Unit and the Quantity on the PO Line and
  the "Inspection Required?" has been checked in the Receiving
  application, the item is received as COMP and the Inventory
  Current Balance is incorrect. However if the "Inspection
  Required?" is not checked the calculation is correct and the PO
  is received as PARTIAL.
  
  STEPS TO REPRODUCE:
  a. Create New Item, Issue Unit = EACH, Order Unit Box. Add
  Conversion Factor 1 BOX = 12 Each.
  Item: DFTESTITEM
  Rotating: unchecked
  Order Unit: BOX
  Issue Unit: EACH
  More Actions > Unit of Measure and Conversion > Add/Modify
  Conversions
  Click New Row
  From Unit of Measure: BOX
  To Unit of Measure: EACH
  Conversion Factor: 12
  Item number: DFTESTITEM
  Click OK
  b. Change Status of Item to Active.
  c. Add Item to Storeroom CENTRAL
  Issue Cost Type: AVERAGE
  Default Bin= A-5-6
  Unit Cost: 25.00
  Current Balance: 0
  Issue Unit: EACH
  Order Unit: BOX
  Change Status: Active
  d. Go To Inventory > Reorder Details tab
  Change Reorder Point: 5
  EOQ = 2 (2 Box).
  e. Run Reorder Manually, More Actions Reorder > Reorder Items
  Created PR: 1146
  Qty: 2
  Order Unit: BOX
  Issue Unit: EACH
  Conversion Factor: 12
  Approve PR.
  Changed Status: APPR
  f. Create PO from PR
  More Actions > Create PO
  Click Autonumber > OK
  Create PO: 1236
  g. In the PO, POLINE-1, check the inspection Required Flag box.
  The Unit Cost = $375. So, total poline cost = $750 (2 box * $375
   = $750).  Total Qty Order = 2 Box (or equal to 2*12 = 24 Issue
  Unit) Go To Purchase
  Orders The Unit Cost = $375. So, total poline cost = $750 (2 box
  * $375 = $750).  Total Qty Order = 2 Box (or equal to 2*12 = 24
  Issue Unit)
  Go To Purchase Orders
  PO: 1236
  Click PO Lines tab > expand the line
  Inspection Required: check this box
  h. Approve PO.
  i. Receiving app. Perform Partial Receipt.
     In this case the the vendor will only send Qty = 8 and Unit
  of Order = EACH (vendor is only sending 8 each of qty instead of
  2 box (2 x 12 each).
  1. Select Order Item >> Check Item >> Click OK.
  2. Expand Material line
     Modify Order Unit = EACH.
     Qty = 8
     Save Receiving Transaction.
  j. More Actions > Change Inspection Status. OK
  k. Status on the PO Receipts: Complete
  PO Line > Insp. Status: COMP
  l. Go To Inventory from Item field and the Current Balance: 96
  
  Actual Result:
       POLINE is fully receipt. Qty On Hand in the storeroom = 96
  (8x12) - Incorrectly.
       PO Status is COMPLETE (Full Receipt).
  
  Expected Result:
       POLINE is receipt it partially. Qty Received = 8. Qty On
  Hand in the storeroom =         8 (increase from 0 to 8).  PO
  Status is Partially Receipt.
  
  
  *** Perform the above steps a to g but in step g DO NOT check
  the Inspection Required box
  1. Created an Item
  Item: DFTESTITEM1
  Issue Cost Type: AVERAGE
  Order Unit: BOX
  Issue Unit: EACH
  Unit Cost: 25.00
  Default Bin: A-63
  2. In Inventory app, Update Reorder Point = 5 and EOQ = 2 (2
  Box).
  Save
  3. Run Reorder Manually --> PR
  Created PR: 1147
  Qty: 2
  Order Unit: BOX
  Conversion Factor: 12
  Approve PR.
  Changed Status: APPR
  4. More Actions > Create PO
  Click Autonumber > OK
  Create PO: 1237
  5. In the PO, POLINE1 - Check the "Inspection Required" box
  Unit Cost = $375.
  6. Go To Purchase Orders - this is step 'g' from the above
  PO: 1237
  Click PO Lines tab > expand the line
  *** Inspection Required: leave this box unchecked
  7. Approve PO.
  8. Receiving app, Perform Partial Receipt
  Select Order Item >> Check >> Click OK
  9. Expand Material line
  Change Order Unit = BOX to EACH
  Qty = 8
  Save Receiving Transaction.
  
  Results and Expected Results:
  PO received status is PARTIAL and the Inventory Item's Current
  Balance is 8
  
  
  REPORTED IN VERSION:
  7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When changing the Order Unit and the Quantity on the PO Line *
  * and the "Inspection Required?" has been checked in the       *
  * Receiving application, the item is received as COMP and the  *
  * Inventory Current Balance is incorrect.                      *
  ****************************************************************
  

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