EAP: Withholding Amounts are Not Calculated Correctly Across the Ledgers in VCHR_ACCTG_LINE Table When the Invoice Lines have Multiple Withholding Rules
Last updated on SEPTEMBER 15, 2016
Applies to:PeopleSoft Enterprise FIN Payables - Version 9 to 9 [Release 9]
Information in this document applies to any platform.
Withholding Amounts are not calculated correctly across the ledgers in the VCHR_ACCTG_LINE table.
1.Select Posting Method = Detail Offset Method on Payables Installations Options page.
2.Set up 2% withholding for 194C3 Rule and 4.2% for Rule WCT4.
3.On Withholding Entity setup,select Apply Withholding to 'Withhold at Voucher Posting' and Round Option = 'Up'
4.Assign both the withholding rules to the Vendor.
5. Associate multiple ledgers to the default ledger group.
The issue can be reproduced at will with the following steps:
1.Create a Regular Voucher by copying PO that has 10 lines using Copy PO option.
2.Each invoice line has both Withholding Rules 194C3 and WCT4.
3.Associate a Receipt to each invoice line through Associate Receiver's hyperlink shown on the Invoice Page
4.Save the Voucher.
5.Run Matching, Voucher is matched successfully.
6.Run Voucher Posting.
7.The withholding amounts are not calculated correctly across the ledgers in the VCHR_ACCTG_LINE table.
Accounting entries should be created with correct withholding amounts.
What is Working
Accounting entries with correct withholding amounts are created when a single withholding rule is applicable for the invoice lines.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms