EEX 9.1+: AMEX Card Transaction MONETARY_AMOUNT Recalculated When Using Receipt Split
Last updated on MARCH 16, 2016
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
The Receipt Split functionality recalculates the PS_EX_SHEET_LINE.MONETARY_AMOUNT Record Field from My Wallet defaulted American Express transactions, making a rounding difference with the original Credit Card transaction stored in PS_EX_TRANS.MONETARY_AMOUNT. This causes reconciliation issues with the Credit Card Vendor when the payment is sent for a slightly different amount than the expected.
This is a sub-scenario identified after having fixed the original problem reported in <Bug 18328105> (EX: VISA Card Transaction MONETARY_AMOUNT Recalculated When Defaulting From My Wallet Into ER).
- In an SQL Developer query tool, connect to an FSCM DEMO environment with delivered sample data, and execute the below SQL Update to have the proper data for this test:
SET TXN_AMOUNT = 16264124.000,
TXN_CURRENCY_CD = 'INR',
MONETARY_AMOUNT = 1547.680,
CURRENCY_CD = 'USD',
CUR_EXCHNG_RT = 0.00009515,
RATE_MULT = 0.00009515,
DATA_SOURCE_EX = 'AMX',
EXPEND_MTHD = 'AMX'
WHERE TRANS_NBR = '24399008153155152373915'
AND EMPLID = 'KU0005'
AND DATA_SOURCE_EX = 'VIS'
- Log into the FSCM Online Application as User ID VP1:
- Navigate to: Travel and Expenses > Manage Employee Information > Update Profile
- Open the existing Expenses Profile from Employee ID KU0005
- In the Corporate Card Information tab, make sure that the Credit Card Issuer is set to AMEX for the existing row
- Navigate to: Travel and Expenses > Manage Expenses Security > Authorize Expense Users
- Open existing Employee ID KU0005
- Make sure that User ID EXS1 is added as one of the authorized Users to enter Expense transactions on behalf of Employee ID KU0005
- Navigate to: PeopleTools > Security > User Profiles > User Profiles
- Open existing User ID EXS1
- In the ID tab, make sure to link it to Employee ID KU0005
- Log into the FSCM Online Application as User ID EXS1
- Navigate to: Employee Self-Service > Travel and Expenses > My Wallet
- Review the AMEX Credit Card transaction previously SQL updated, and confirm that the Reimbursement Amount is 1547.68 USD (PS_EX_TRANS.MONETARY_AMOUNT)
- Navigate to: Employee Self-Service > Travel and Expense Center > Expense Report > Create
- Enter Employee ID KU0005, and click on ADD button
- At the Quick Start drop down list, select the value of 'Entries From My Wallet', and click on GO
- Find the AMEX Credit Card transaction, and confirm how the Reimbursement Amount displayed is 1547.68 USD
- Default the transaction into the New Expense Report
- Enter a Line Description value, such as 'GCS Test', and click the Receipt Split icon
- Select the Expense Type of 'Breakfast', and click on the SPLIT Button
- As Transaction Amount, define a value of 200,000.00 INR
- Click on DONE Button to go back to the Expense Report Entry main page
- Confirm how the 'Employee Expenses' and 'Due Vendor' columns have been re-calculated, and are now displaying a value of 1547.53 USD
- If such changes are saved into the Expense Report, the system will store into Record Field PS_EX_TRANS.MONETARY_AMOUNT between both lines an amount of 1547.53 USD, which will differ from the PS_EX_TRANS.MONETARY_AMOUNT of 1547.68 USD
To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.
The system has automatically re-calculated the Expense Line Reimbursement Amounts, and consequently the 'Employee Expenses' and 'Due Vendor' columns, and changed their initial values to 1547.53 USD, instead of 1547.68 USD as it was uploaded. When the transaction gets saved into the new Expense Report, the system will update PS_EX_TRANS.MONETARY_AMOUNT Record Field on both Expense Lines, with an combined sum of 1547.53 USD. This will be out of sync with the Monetary Amount populated from AMEX flat file, and cause payment reconciliation issues for the Credit Card Vendor.
If the American Express flat file provided already contains and successfully uploads the Reimbursement Amounts into the Record Field PS_EX_TRANS.MONETARY_AMOUNT, the system should not recalculate the value again with any provided exchange rates. This would be for both at the time of defaulting the transaction from My Wallet into the Expense Report at the time of creation, or if the user makes use of the Receipt Split functionality to create new Lines from the original one defaulted. The provided value from AMEX should prevail at all times, as this is the one the Credit Card Vendor will be expecting in the payment from the company.
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