My Oracle Support Banner

E1: 43: Quantity Open to Receive Incorrect After Partial Receipt w/ Tolerance Checking Followed by P4310 Simulated Quantity Change To J LNTY PO w/ Account Distribution and Warning MA30 - Values Redistributed to Multiple Account (Doc ID 2872089.1)

Last updated on MAY 24, 2022

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

For partially received J line type purchase orders with Account Distribution and Tolerance Checking, after simulating a change to the quantity in P4310 that results in Warning MA30 - Values Redistributed to Multiple Account, but then saving the order with the original quantity value (so no actual change is made to the PO), the Quantity Open to Receive is updated to the original order quantity which is not the remaining to receive quantity after the partial receipt.  In P4310 after receiving the MA30 warning and setting the PO quantity back to the original value, you take the Row Exit to Account Distribution, the quantity open to receive is NOT incorrectly changed, it remains with the correct partial quantity open to receive.


The issue can be reproduced at will with the following steps:

  1. Create a 10% Quantity Checking Tolerance Rule (P4322) for the company and Function Type 2 (Receipt).
  2. P4310 - Create 2 J line type orders for an account and add Account Distribution to the order.  (No need to split the line to a different or multiple accounts, just use the same account for the entire order quantity.)  Both orders are for the same account and quantity 30.
  3. Row Exit to Account Distribution, distribute the entire quantity to the same account on the detail line.  PO now shows "Account Distribution" in the Account Number field.
  4. P4310 - Enter a 2nd order identical to the first order.
  5. P4310 – Open Orders & P4312 Receive by PO both show quantity 30 available to receive for both orders.
  6. Set P4312 - Receipt by PO Tolerance processing option #1 = 1.
  7. P4312 - Receive a partial quantity of 10 of each order.
  8. P4310 – Open Orders & P4312 Receive by PO correctly show quantity 20 open to receive of both orders.
  9. Next use P4310 to clear and change the order quantity of the first order, but then return the quantity value back to the original quantity and save the order.
    1. Inquire on the order and go to detail.  Original quantity 30 is shown.  
    2. Blank out the quantity and then click off of the line.
    3. Next enter a new and different quantity in the quantity field, then click off of the line.
    4. Warning MA30 is generated.
    5. Now change the quantity back to the original quantity (30) and save the order.
  10. P4312 now shows the full quantity of 30 available to receive while the Amount open to receive remains correct at $20.00.
  11. Next perform the same ‘change’ steps as done for the first PO, but this time add the step where you row exit to Account Distribution after warning MA30 is generated.
  12. Warning MA30 is generated, Row exit to Account Distribution.
  13. Cancel out of Account Distribution, save the order.  Order quantity has the original value (30) again.
  14. P4310 – Open Orders shows the order details with the correct quantity 20 / $20.00 open to receive.
  15. P4312 – Receive by PO shows the correct quantity 20 / $20.00 open to receive.

When following these steps to 'simulate' a change to a PO line without actually making a change, (original quantity remains on the order), warning MA30 is generated due to the existence of Account Distribution.  If after receiving the warning you then row exit to Account Distribution, the open to receive quantity is not incorrectly changed.  However, if you do not use the row exit after the warning, the quantity open to receive will be updated to the value last set on the PO detail line (even if it is the original quantity) which will allow over receipt of the PO.  The amount open to receive is not updated when simulating the change and so the quantity and amount are then out of sync.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.