Procurement Card Reconcile VAT Recovery Percent is Not Matching to CC_TRANS_DS_VAT.VAT_RECOVERY_PCT and Causing Issue in Voucher Creation
(Doc ID 2939065.1)
Last updated on SEPTEMBER 23, 2024
Applies to:
PeopleSoft Enterprise SCM Purchasing - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
Reconcile VAT recovery percent is not matching to CC_TRANS_DS_VAT.VAT_RECOVERY_PCT and causing issue in Voucher creation.
The issue can be reproduced at will with the following steps:
1. Run Load PCard Stage. Navigation: Menu > Purchasing > Procurement Cards > Process Statements > Load Pcard Stage
2. Error listed. Navigation: Menu > Purchasing > Procurement Cards > Process Statements > Correct PCard Statement Errors
3. Cardholder Profile. Add the card number. Navigation: Menu > Purchasing > Procurement Cards > Definitions > Cardholder Profile
4. Go Back to Correct Statement Errors. No error listed
5. Run Load Pcard Statement. Navigation: Menu > Purchasing > Procurement Cards > Process Statements > Load Pcard Statement
6. Reconcile page. Navigation: Menu > Purchasing > Procurement Cards > Reconcile > Reconcile PCard Statement
7. Go to distribution icon and go to Distribution VAT
8. Recovery Percent is 100.00. Change it to 40 and recalculate. Return to Distribution page. Ok and save
9. Query: SELECT A.VAT_RECOVERY_PCT, A.* FROM PS_CC_TRANS_DS_VAT A; It is showing VAT_RECOVERY_PCT = 40
10. Go back to Reconcile Statement page and click on distribution icon again and go to Distribution VAT icon
11. It is showing the original Recovery Percent. The information is not matching to backend information
12. Approve the transaction at Reconcile page and save.
13. Run Load Voucher Stage. Navigation: Menu > Purchasing > Procurement Cards > Process Statements > Load Voucher Stage
14. Run Voucher Build. Navigation: Menu > Accounts Payables > Batch Process > Vouchers > Voucher Build
15. Voucher created. Navigation: Menu > Accounts Payables > Vouchers > Add/Update > Regular Entry
16. Go to Distribution Lines VAT link. It is exactly the same information from Pcard Reconcile page. It is showing Recovery Percent 100.
17. Go to Voucher VAT summary page link. It is also showing VAT Recovery 100.
18. Check Voucher VAT Details. Navigation: Menu > Account Payables > Review Account Payables Info > vouchers > VAT Details. VAT recovery is not matching to Voucher page summary
Cause
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
Symptoms |
Cause |
Solution |
References |