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

Last updated on JANUARY 13, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 and later
Information in this document applies to any platform.

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).  

    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 for the following:
    
    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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms