EAR 9.2: Record PS_VAT_SUMM_AR_WS Keeps Sometimes Leftover Data That Should Be Cleaned Up After Pending Group On VAT BU Is Saved
Last updated on JUNE 14, 2017
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When testing the entry of Pending Item Groups for a VAT enabled Business Unit, never the first Item in the Group gets populated in this Record, and even the second Items only get populated when a specific series of steps are taken in a precise order. Items with similar conditions created later on this Group are also not populated automatically.
This leads to suspect that maybe the data on Record PS_VAT_SUMM_AR_WS is only supposed to be temporary for some calculations, and that upon saving the Pending Item Group, the data should be deleted.
1.- Log into the FSCM Online Application as a Payables User
2.- Navigate to: Accounts Receivable > Pending Items > Online Items > Group Entry
3.- Enter a brand new Pending Item Group for a VAT enabled Business Unit, such as GBR01
4.- At the Group Control tab, set a Count of 2, a Control Amount of 2,225.00 GBP
5.- At the Pending Item 1 tab, create one first Item for Customer ID GBR01, and Amount of 1,175.00 GBP
6.- At the VAT Control Totals section, set VAT Transaction Amount to 1,000.00, and VAT Amount at 175.00
7.- Save the changes
8.- Query Record PS_VAT_SUMM_AR_WS, and confirm that it is empty
9.- Click on the + sign, to add a second Item, again for Customer ID GBR01, and Amount of 1,050.00 GBP
10.- At the VAT Control Totals section, set VAT Transaction Amount to 1,000.00, and VAT Amount at 50.00
11.- Click on the VAT Summary link on this second Item
12.- Continue by clicking on the VAT Lines icon available
13.- Expand all sections, an in the VAT Details one, modify the VAT Code to UK2
14.- Click on the Adjust Affected VAT Defaults button
15.- Click on the Group Entry available link
16.- At the VAT Summary Information page, click on the Group Entry available link
17.- Save the changes
18.- Query Record PS_VAT_SUMM_AR_WS once again, and confirm that this time the Table contains one row for the Group's second Item, but not the first one
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.
Record PS_VAT_SUMM_AR_WS contains left over transaction data that should not be there, as this table is being used as a work/derived record to be used when performing VAT calculations when the User is accessing the VAT Summary page, but once gone from this page, this should be emptied.
Record PS_VAT_SUMM_AR_WS should only contain transaction data while the User is at the VAT Summary page (GROUP_ENTRY_VATS).
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