Procurement Card Reconcile Account Distribution is Not Adjusting Percent/Amount (Doc ID 1601443.1)

Last updated on NOVEMBER 22, 2013

Applies to:

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

Symptoms

Pcard Reconcile Account Distribution Is Not Adjust Percent/Amount When Add New Line.
Reconcile Statement page, when splitting the Accounting Distribution line, the initial line is not adjusting percent and amount.

STEPS
The issue can be reproduced with the following steps:

Test 1 – Foreign transaction where currency for Billing Amount and Transaction are different.

1 - Credit Card Transaction for Transaction amount 883,64 SGD
2 - Billing Amount of 705.52 AUD’s needs to be split across 3 different chartfields
3 - Add 1 distribution line
4 - Automatically line 2 showing:
     Percent 20,1575 and Amount 142,22.
     At this point the SUM are:
     Amount = 847,74
     Percent = 120,1575
5 - Change line 2 amount to 16.34
6 - Line 1 (percent and amount) should be adjust after insert line 2. Still showing the initial values.
7 - Add line 3 distribution.
     Automatically line 3 inserted with values:
     Percent = 18,3084 and amount = 129,17
     Total amount = 851,03
     Percent = 120,6244.
8 - Received the message 'You have allocated over 100% of the original value'


Test 2: The same currency

1 - Open a transaction where currency for Billing Amount and Transaction are the same.
2 - Add a line at Account Distribution line
3 - Insert 20 % for line 2.
The system calculated the amount correctly, but line 1 still showing initial percent and amount.


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