Change to Rolled PO gets Double Encumbrance on Closed Distribution when Sales Tax is Recalculated (Doc ID 1641113.1)

Last updated on AUGUST 21, 2023

Applies to:

Symptoms

Change to Rolled PO gets Double Encumbrance on Closed Distribution when Sales Tax is Recalculated

Replication Steps:

1. Create a PO one line (amount only).  Navigation: Purchasing > Purchase Orders > Add/Update POs

    Merch Amt = 1754.90
    Sales Tax =  140.39 (8%)
    Total Amt = 1895.29

2. Budget check the PO.  Encumbrance is 1895.29.

3. Dispatch the PO.

4. Invoice is received. Navigation: Accounts Payables > Vouchers > Add/Update > Regular Entry
    
    Merch Amt = 1754.09
    Sales Tax =  140.32
    Total Amt = 1894.41

    Sales Tax should be calculated:
    1754.09 X 8% = 140.3272 = 140.33

    However, vendor’s invoice has sales tax of 140.32 so that is what is entered on the voucher (one penny less).

5. Budget check the voucher.

    At this point, encumbrance is as follows:

    PO Distrib 1 (open)   - $0.88

6. Rollover the PO form 2014 to 2015. 

    At this point, encumbrance is as follows:

    PO Distrib 1 (closed) -  zero
    PO Distrib 2 (open)   - $0.88  (Merch Amt .81 plus Sales Tax .07)

7. Change the PO by adding $5.00 to the amount.  See that budget status of both distribs changed to Not Checked.  This is incorrect.  Distrib 1 should have remained Valid since it is Closed and was not changed.  


8. Budget check the PO.  Encumbrance Balance on PO shows as $6.27, which is correct at this point ($5.81 + 8% = $6.27)

9. PO Accounting Entries page shows that the amount for Distrib 1 has been added back TWICE, resulting in double encumbrance in 2014 when it should be zero.

    PO Distrib 1 (closed) - $3788.84 (1894.42 + 1894.42) - THIS SHOULD BE ZERO
    PO Distrib 2 (open)   - $   6.27
    Total Encumbrance     - $3795.11

Changes

Cause

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