EAP: Is There a Way to Mass Update the VAT Code Account Distribution Setting?
(Doc ID 2849777.1)
Last updated on FEBRUARY 21, 2023
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Goal
Requirement changed the way VAT is booked to a specific account. With that user need to more than 100 VAT Codes to point the Input Non Recoverable VAT (VAT_DST_ACCT_TYPE = 'VIN' in PS_VAT_DST_TBL) to a new account. However doing an update on this table to the account value only doesn't do the trick. It seems that the details are also stored in PS_VAT_ACCT_TBL.
Are there any additional records/fields that impacted if an SQL update is done, or preferably if there is a delivered way of doing a mass update to the VAT account distribution setup?
Solution
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
Goal |
Solution |