Prerequisites

Before you can enter and import spreadsheet vouchers, you must:

• Copy the voucher workbook file (ExcelUploadforVoucher.xls) to a folder on your workstation.

  The Microsoft Excel file is located in the core\build\excel folder of the shipped PeopleSoft software.

• Install MicroSoft delivered XML library file MSXML.DLL on your workstation.

• Set up your Microsoft Excel to accept macros.

• Configure Integration Broker for the Voucher EIP.

  The web server and the application server should be configured for setting up the Integration Gateway. Also, the application server should be configured to have the Pub/Sub servers established before bringing up the application server.

  Determine your default local node for the Integration Broker to receive the data and run the application message. PeopleSoft defines the default local node as PSFT_EP, but you can change it to your default local node.

  Configure your browser to automatically detect LAN settings. From your browser, navigate to Tools > Internet Options. Select the Connections tab and click the LAN Settings button. Select Automatically detect settings in the Automatic configuration group box.

• Create a Voucher Build process run control and request a run of the Voucher Build process.