EAP: When Using Excel Upload Voucher to Create PO Voucher from the Receipt, Voucher Build Populates the Voucher Invoice Line Amount with 0.00 (Doc ID 1666998.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

When trying to create a PO Voucher using Excel Voucher Upload with minimum information and the Receiver is specified, Voucher Build is creating the Voucher in a Recycled Status due to the Invoice Line Amount being populated as 0.00.

ERROR
Merchandise Amount -- Voucher Merchandise Amount 300 <> sum of invoice line amounts 0.

STEPS
1. Enter a PO with Qty 15
2. Receipt the PO Qty of 2
3. Create a Voucher using the ExcelUploadVoucher.xls
4. Populate the following fields on the Data Sheet

1- Business Unit
2- Vendor ID
3- Invoice Date
4- Gross Amount
5- VAT Entered Amount
6- Receipt Business Unit
7- Receipt ID
8- Receipt Line

5. Click the button for Generate XML and Post on the spreadsheet
6. Run Voucher Build
7. Voucher created in Recycle Status with the above error

Cause

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