EAP: How does Voucher Build create Sales Tax on a PO Voucher Uploaded from ExcelVoucherforUpload/EDI (Doc ID 1983011.1)

Last updated on MARCH 14, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

A multi-line PO is created with no Sales Tax.  Excel Voucher Upload spreadsheet is used to create a 2 line PO Voucher where the Sales Tax, Sales Tax Code and Sales Tax Applicability fields are specified on the spreadsheet.
 
When Voucher Build is run, the PO Voucher is created in a Recycle Status with the following error:

"At least one line item must have been selected over which to prorate the voucher sales tax amount."

On the Voucher > Invoice Information page, the Sales Tax field is populated but on the Invoice Line Tax Information page, the Sales/Use Tax Applicability = Item is Exempt and the Tax Code SUT field is blank.

Expected that the PO Voucher be created in a Postable Status with the Sales Tax, Sales Tax Code and Sales Tax Applicability fields be populated correctly, as provided in the Excel file.

Solution

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