EEX 9.2: Expense Report Containing Prepaid Expenses Displays Incorrect Total Amount Values When Save For Later Or Submitting For Approval
(Doc ID 2613443.1)
Last updated on NOVEMBER 21, 2019
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When adding prepaid expense lines to an Expense Report, at the time of saving the transaction, submitting it for approval, and reviewing it during approvals, several Total Amount fields are incorrectly being calculated:
- Expense Report Total (At the Expense Report creation page)
- Employee Expenses
- Amount Due to Company
- Total Amount (At the Approve Transactions page)
These incorrect calculations of amounts seem to resolve themselves once the transaction is closed, and re-opened. It only takes place when the transaction is being created, and submitted.
1.- Log into the FSCM Online Application as an Expenses User
2.- Create a brand new Expense Report, with two Expense Line using Payment Type Prepaid
3.- Save For Later the newly created Expense Report, and see how the Total field is calculated at 0.00 USD
4.- Click on Summary & Submit link
5.- Click on Submit for approval
6.- Log into the FSCM Online Application as an Expenses Approver User
7.- Open the routed Expense Report, add a comment, and Send Back For Revision
8.- Log into the FSCM Online Application as an Expenses User
9.- Open the returned Expense Report, and add a new Expense Line, again using Payment Type Prepaid, and Save For Later
10.- Confirm that the Total field is again wrongly calculated, completely disregarding the new line's amount
11.- Click on the Summary & Submit link
12.- Note that at this stage, from the Totals section, two fields are wrongly calculated:
a) Employee Expenses is listing all existing lines (3), but the amount is only counting the original 2
b) Amount Due to Company shows the amount of the latest 3 prepaid line, while it should be: Amount Due to Employee = 0.00 USD
13.- Submit the Expense Report once again for Approval
14.- Log into the FSCM Online Application as an Expenses Approver User
15.- At the Approve Transactions Overall page, the routed Expense Report is displayed, but the Total column shows an amount equal to the sum of the first 2 prepaid lines, not including the 3rd line's amount
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.
Due to this problem, Expense Employees get very confused when creating the Expense Report containing prepaid expense lines, as the amounts do not reflect the expected values. The same happens for the Expense Approver Users, who get displayed incorrect amounts when reviewing the routed transactions. This makes it complicated to streamline Expense Report approvals, as Users keep having doubts on the transaction's displayed/calculated amounts.
Whenever prepaid Expense Lines are included within an Expense Report, the system should be able to calculate at all times the Total fields, with the correct amounts.
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